Have you been doing backups of your instance before the crash of the database?
If you didn't I would recommend you to do one of the files of the database. To do this, just follow these steps:
tar cfz mysql_backup_DATE.tar.gz mysql/
Note: It would be nice to change the DATE placeholder for the data when you performed this backup of the entire mysql directory.
After that, make sure you keep that tarball in a safe place as it contains the data files of your database.
If after following some instructions I will give you now the database is completely crashed you can always restore that tarball in
/opt/bitnami and you will have again the mysql folder with all the data inside.
Now, I would recommend you to run this tool:
And use the mysqlcheck tool to check/repair the database. The binary of the tool is under
/opt/bitnami/mysql/bin. You can use it with this command:
opt/bitnami/mysql/bin/mysqlcheck DATABASE_NAME -u root -p
In this case, the password is the one I configured when I installed Wordpress. If you deployed Wordpress using Google Cloud, the password of the database is the random password Google shows you in the Google Cloud webpage.
Also, do not forget to change the
DATABASE_NAME placeholder for the database of wordpress, if you didn't modify anything, the name should be
It would be awesome if you share here the output of the tool. Just to check if this fixes something. After running the tool, you can try restarting the mysql service and check the log with
sudo /opt/bitnami/ctlscript.sh restart.
If the above workaround doesn't work you could try this tool:
This tool works with the raw data files and re-build all the mysql tables from that.
You can follow this guide in order to use the Percona tool. They also have a community forum, which I think to be quite interesting to post your issue there too.
If none of that works, you could also use this:
This is quite risky as it can crash the database and you can lose some data. However, you should not be worried about this if you have performed a backup before going into this. There are a few tutorials on internet about how to use that parameter of mysql.
Hope this helps.