MySQL Forums
Forum List  »  Data Recovery

Recover Tables from database
Posted by: Frank F
Date: June 16, 2020 05:18AM

Hi Everyone,

I'm using XAMPP and am having trouble starting the MYSQL server. The system work for years and a couple of months back the server would not start. I've searched the Internet for solutions and nothing has worked so far.

I've reinstalled a clean version of XAMPP and put the old MYSQL data folder into it figuring something went bad with the XAMPP files. That didn't help.

I deleted the INNODB files as was suggested by several posts, hoping that MYSQL would recreate them. It did recreated the files, but the server failed to start.

I made a copy of the the XAMPP directory and moved it to several different computers, thinking that the machine the database got corrupted in may be blocking MYSQL from running. I get the same error in all different machines.

I tried moving the PORT that MYSQL runs on from 3306 to 3307. That didn't help either.

The database is small and at this point all I'd like to do is extract the tables and insert them into a backup I have of the database from a few months earlier.

Is there someway to do that? Any help with this would be greatly appreciated.

Below are the error message & log file entries I get, every time I try and start MYSQL.

Attempting to start MySQL app...
6:40:25 AM [mysql] Status change detected: running
6:40:38 AM [mysql] Status change detected: stopped
6:40:38 AM [mysql] Error: MySQL shutdown unexpectedly.
6:40:38 AM [mysql] This may be due to a blocked port, missing dependencies,
6:40:38 AM [mysql] improper privileges, a crash, or a shutdown by another method.
6:40:38 AM [mysql] Press the Logs button to view error logs and check
6:40:38 AM [mysql] the Windows Event Viewer for more clues
6:40:38 AM [mysql] If you need more help, copy and post this
6:40:38 AM [mysql] entire log window on the forums


EVENT LOG
2020-06-16 6:40:25 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-16 6:40:25 0 [Note] InnoDB: Uses event mutexes
2020-06-16 6:40:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-16 6:40:25 0 [Note] InnoDB: Number of pools: 1
2020-06-16 6:40:25 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-16 6:40:25 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-16 6:40:25 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-16 6:40:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-16 6:40:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-16 6:40:25 0 [Note] InnoDB: Setting file 'C:\Users\xampp\mysql\data\ib_buffer_pool' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-16 6:40:25 0 [Note] InnoDB: File 'C:\Users\xampp\mysql\data\ib_buffer_pool' size is now 12 MB.
2020-06-16 6:40:25 0 [Note] InnoDB: Waiting for purge to start
2020-06-16 6:40:25 0 [Note] InnoDB: 10.3.16 started; log sequence number 1604234; transaction id 9
2020-06-16 6:40:25 0 [Note] InnoDB: Loading buffer pool(s) from C:\Users\xampp\mysql\data\ib_buffer_pool
2020-06-16 6:40:25 0 [Note] InnoDB: Buffer pool(s) load completed at 200616 6:40:25
2020-06-16 6:40:25 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-16 6:40:25 0 [Note] Server socket created on IP: '::'.

Options: ReplyQuote


Subject
Views
Written By
Posted
Recover Tables from database
178
June 16, 2020 05:18AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.