![]() Can you suggest how can I make the ibdata1 size return to its actual size of 100MB?Ī. As suggested in method 4 above, I changed the line in my.cnf to 80MB that helped restore the InnoDB tables. The repaired database and all the restored tables will be saved in the selected location. Select the location to save the database and click Save once again.Choose to save the repaired database to a new MySQL database or other file formats like CSV, HTML, or XLS.Select all or specific items you want to restore and click Save on the File menu.A preview of all the repaired tables and their recoverable data is displayed.Click OK when presented with a ‘Repair Complete’ message box.Select the database that has the corrupt table and click Repair. ![]()
0 Comments
Leave a Reply. |