Just restore your backup. Should be fine. You do have a backup… right?
Thread Starter
empil
(@empil)
I did not back it up. The mysql did not start and because of that I couldn’t back it up. But I was able to copy the Database folder. What can I do please to get back my website??
Please check the MySQL error log to see what might have happened. Usually it can be found in the database folder with the name mysql.err. It might also be available from within MAMP. The log messages should tell you what the problem is.
If I had to guess, you have a corrupted ibdata file; if so, your old databases are gone forever. It would be a hard lesson to learn, but you now know how important it is to create routine backups of the localhost databases.
Thread Starter
empil
(@empil)
The files are not corrupt. Is there a way I can send someone the database files so that the person can check it and then try to correct the errors and export the database files for me please… Am so so pained right now. Anyone that can help and wants me to send the database folder, please send me a message through my email: empilgiwa@gmail.com
Thread Starter
empil
(@empil)
This is one of the error messages i found in the log folder:
2018-09-26T08:05:09.014977Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-09-26T08:05:09.045128Z 0 [ERROR] InnoDB: Upgrade after a crash is not supported. This redo log was created before MySQL 5.7.9. Please follow the instructions at http://dev.mysql.com/doc/refman/5.7/en/upgrading.html
2018-09-26T08:05:09.045203Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2018-09-26T08:05:09.351410Z 0 [ERROR] Plugin ‘InnoDB’ init function returned error.
2018-09-26T08:05:09.351460Z 0 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2018-09-26T08:05:09.351480Z 0 [ERROR] Failed to initialize builtin plugins.
2018-09-26T08:05:09.351489Z 0 [ERROR] Aborting
Please go back a bit further in your MySQL error log to before you re-installed MAMP. Note the version of MySQL that is displayed after a successful restart.
What you must do is install that same version of MySQL, and hope that InnoDB can read the ibdata file.
Hmm. Since you have a backup of the folder, here’s another suggestion. Edit the MySQL configuration file (my.cnf on Linux systems, my.ini on Windows) and add the following line:
innodb_force_recovery = 2
Now restart MAMP. If you’re really lucky, MySQL will start. If it does, verify the database is working, and then IMMEDIATELY make a backup of your database. You should now re-install MAMP again, but this time start with the fresh database folder. THen create a database and import the backup into it.
Thread Starter
empil
(@empil)
Thank you so much for your assistance Dion Designs. I have tried but not working. Am not too good with database. Can you send me your email please so I can send you the database folder to help me rectify the issue to enable me back up my database please. Thank you very much. AM grateful. Mine is empilgiwa@gmail.com
The only two straightforward ways you can possibly recover your data are to try innodb_force_recovery (which apparently failed), or to install MAMP with the same version of MySQL you were using before the problems occurred.
I suggest you do the second option and hope for the best. If it doesn’t work, you’ll probably need to hire someone to restore your database.
Good luck!
Hi,
The link you give corresponds to a functional site. Is your local site a duplicate of this site?
