Archives for October 2020

2020-10-12 15:12:52 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.

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 that 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.