Close
Our websites services are provided as software as a service.

07/05/2017

How to restore mysql database from .frm and ibd files

1. COPY THE .FRM FILES OF WP22 TO C:\WP22
2. RUN THIS BATCH FILE A.BAT. TWO FILES ARE CREATED NAMELY tables_structure AND tablespan.
3. OPEN THE TABLE STRUCTURE FILE AND ADD THIS PHRASE AT THE END OF EACH CREATE TABLE STATEMENT
row_format=compact; REMOVE EXTRA ; IF ANY.
4. ADD THIS LINE AT THE TOP OF FILE IE. SET sql_mode = ”;
5. OPEN PHPMYADMIN CREATE NEW DATABASE WP22.. CLICK THE SQL TAB. COPY PASTE THE COMPLETE SQL STRUCTURE OF LINE 3 ABOVE HERE. THEN CLICK OK TO RUN THE SQL COMMANDS.
6. ON SUCCESSFULL EXECUTION. COPY THE IBD FILES FROM ORIGINALOLD FOLDER ie
F:\wamp\bin\mysql-old\mysql5.6.17\data\wp22 TO NEW DATABASE STRUCTURE DIRECTORY F:\wamp64\bin\mysql\mysql5.7.14\data\wp22
7. RUN THE SECOND FILE COMMANDS IEĀ  tablespan IN SQL AREA OF PHPMYADMIN .
ON SUCCESSFULL RUNNING OF ALL COMMANDS. EXPORT THE DATBASE WP22 SQL FILE.
8. COPY THE WP22 APPLICATION FROM OLD WWW FOLDER TO WWW NEW APPLICATION FOLDER. LOAD THE APPLICATION IN BROWSER IE LOCALHOST/WP22
Note I WAS USING MYISAM ENGINEE AND MY NEW WAMP HAS NEW ENGINE=InnoDB. SO THE LINE row_format=compact.