If you can post the log of your server starting, that might help. There is a good chance that one of your databases got corrupted when the power went out. It happens alot on Linux servers for sure.
If that is the case, you should download Navicat Lite (search for it in google) and get the free (lite) version, NOT the 30 day free trial one. Then configure it to work with your database, which is easy to setup. Then, get to the view that shows all of your tables in it. Next, hold CTRL and click and drag to select all of the tables. Then, you right click on the selected tables and go to "Maintenance" and then do the Extended Check/Repair or whatever it is called. That will report if there were any tables that needed to be corrected. Then try starting your server up again and see what happens. You might also want to do a full backup of your database, which you can do by right clicking on the name of your database in the left column of Navicat and selecting "Dump Mysql" or whatever it is called (NOT delete). That will prompt you to name the file you want to save it as and then you click ok and it will backup your entire database. This way, if you ever have problems in the future, you can just source that file and it will recover your entire database from the point you created that file.
I would recommend doing a backup at least 1 time per week, if not more. Also, you should store the backup files in 2 separate drives incase one of them fails for any reason. You do NOT want to lose those files.
|