This guide will show you how to run the Repair Database utility to repair your Virtualizor Database in the event of a MySQL crash.
- Take a backup of your Virtualizor Database located at /usr/local/emps/var/mysql
- There can be data loss. So please verify that the data is intact after the repair.
- Keep a copy of the output for your reference.
- In-case master database has issues, then restoring the crashed table from newest database backup is recommended.
Using repair script for master server’s database can cause issues with other working tables as well.
You can even reach us on chat for faster communication : https://virtualizor.com/
Just run the following command :
root# /usr/local/emps/bin/php /usr/local/virtualizor/scripts/repair_db.php
The utility will ask you for a confirmation .