CODEWITHSUNDEEP
mysqlxampp
Sk Md Nurujjaman
Sk Md Nurujjaman

Reputation: 371

MySql stops unexpectedly

MySql stops unexpectedly

Here is a copy of Error log:

2019-07-03 13:27:50 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

2019-07-03 13:27:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2019-07-03 13:27:50 0 [ERROR] InnoDB: Page [page id: space=0, page number=305] log sequence number 2834539 is in the future! Current system log sequence number 1604011.

2019-07-03 13:27:50 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

2019-07-03 13:27:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2019-07-03 13:27:50 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-03 13:27:50 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

2019-07-03 13:27:50 0 [Note] InnoDB: Waiting for purge to start

2019-07-03 13:27:50 0 [Note] InnoDB: 10.3.16 started; log sequence number 1604002; transaction id 1432

2019-07-03 13:27:50 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2019-07-03 13:27:50 0 [ERROR] InnoDB: Page [page id: space=0, page number=9] log sequence number 2841120 is in the future! Current system log sequence number 1604011. 2019-07-03 13:27:50 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

2019-07-03 13:27:50 0 [ERROR] InnoDB: Page [page id: space=0, page number=243] log sequence number 2082633 is in the future! Current system log sequence number 1604011. 2019-07-03 13:27:50 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

2019-07-03 13:27:50 0 [ERROR] InnoDB: Page [page id: space=1, page number=0] log sequence number 1608629 is in the future! Current system log sequence number 1604011. 2019-07-03 13:27:50 0 [Note] Plugin 'FEEDBACK' is disabled.

2019-07-03 13:27:50 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

2019-07-03 13:27:50 0 [ERROR] InnoDB: Page [page id: space=1, page number=1] log sequence number 1604111 is in the future! Current system log sequence number 1604011. 2019-07-03 13:27:50 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

2019-07-03 13:27:50 0 [Note] Server socket created on IP: '::'.

2019-07-03 13:27:50 0 [ERROR] InnoDB: Page [page

Upvotes: 36

Views: 72897

Answers (9)

Umut Çakmak
Umut Çakmak

Reputation: 29

For me the Google Drive was corrupting my mysql/data files while running or syncing. I couldn't find a solution but not running Google Drive while using XAMPP seems to help.

Upvotes: 0

Bang T
Bang T

Reputation: 41

Step 1: rename mysql\data to mysql\data.backup Step 2: duplicate mysql\backup folder to mysql\data ( still keep mysql\backup) Step 3: Start mysql -> It is working Step 4: Stop mysql copy database in mysql\data.backup to mysql\data Step 5: Start Mysql. It is done

Upvotes: 0

Swapnil Ghone
Swapnil Ghone

Reputation: 748

Ok seems like if Mysql has a large database that consumes too much processing power then Windows Defender stops the MySql process.

https://answers.microsoft.com/en-us/windows/forum/all/windows-defender-in-windows-10-scans-and-blocks/e79012c0-216a-484d-9058-ba741d91bcd5

All you need to do is add mysqld and mysqld.exe to the process exclusion list.

Also, allow MySql on both your private and public firewall under Windows Defender.

Upvotes: 0

Martian.titan
Martian.titan

Reputation: 466

Here is what I did to solve this issue because I had databases that I couldn't just lose it.

Step 1: I installed a fresh Xampp. make sure you stop apache/mysql after it started then follow the next steps.

Step 2: Made a backup from the "mysql\data" folder: Copy/past "data-org".

step 3: From my old Xampp mysql/data directory, I copied the database folders only. Note: each database will have a folder and I paste the folders inside my new Xampp mysql/data folder.

step 4: Copied the "ibdata1" file from my old Xampp mysql/data directory and paste it in the new Xampp mysql/data directory.

Step 5: started the new Apache/MySql and made a backup from my databases using phpMyAdmin and stopped Apache/MySql.

Step 6: Deleted all the files and folder from my new Xampp mysql/data folder and copied all the files/folders from the data-ORG folder(refer to step 2) and paste them in the new Xampp mysql/data folder.

Step 7: Started the new Xampp Apache/MySql and created my databases using phpMyAdmin and imported the sql backups files for each database.

Step 8: Tested my applications and they all were working fine.

Upvotes: 0

Senthilnadhan Ramasamy
Senthilnadhan Ramasamy

Reputation: 1213

I have faced the same problem. I just followed the below steps

Step 1: Moved(cut/paste) all the files in C:\xampp\mysql\data to desired backup location.

Step 2: After that copied all the files from C:\xampp\mysql\backup to C:\xampp\mysql\data

Step 3: Restarted mysql and checked the phpmyadmin url, it worked.

Step 4: After that stopped mysql and copied ibdata1 file from backup location to C:\xampp\mysql\data

Step 5: Restarted mysql

Step 6: After that copied all database folders and checked all the tables, It worked.

Upvotes: 88

divix
divix

Reputation: 1364

If your backup folder doesn't include your latest DB changes and you are stuck with collation of in use, then do this instead:

  1. Install another XAMPP instance in new folder;
  2. Copy the single folder of: [old_xampp]/mysql/data/[table_name]/ into [new_xampp]/mysql/data/;
  3. Copy a file from: [old_xampp]/mysql/data/ibdata1 to: [new_xampp]/mysql/data/ibdata1 and replace it;
  4. Stop old XAMPP;
  5. Run new XAMPP.
  6. DONE!

All your new table entries should be brought back.

Upvotes: 2

Sarwar Ali
Sarwar Ali

Reputation: 19

Just Unintall XAMPP and the reinstall it , it will resolve all the issue , but make sure to have the backup of your MYSQL database.

Upvotes: 0

Afraz Ahmad
Afraz Ahmad

Reputation: 5386

I also faced this issue and searched a lot only one solution worked for me.

Just copy all files from C:\xampp\mysql\backup to C:\xampp\mysql\data

Make sure to take backup of your data folder to avoid any further problems.

If you see any error related to table engine then you can copy file ibdata1 from your backup data folder to current data folder

Upvotes: 22

Zeid Al-Rashwani
Zeid Al-Rashwani

Reputation: 565

Seems that there is corruption in MySQL log and/or data files, one way to workaround this problem is to start MySQL in recovery mode. From my.ini in windows (or my.cnf in Linux) add the following line: innodb_force_recovery=1 under [mysqld] section then re-start MySQL service.

If the problem persisted, mysqlcheck can help, move to the folder where MySQL binaries exist in your machine, and in Command Line execute ./mysqlcheck.exe --all-databases this will list tables that are corrupted

Reference: https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html

Upvotes: 2

Related Questions