Restart of MySQL service

/etc/init.d/mysqld restart

Recovery of database password

cat /data/support/ispadmin/config/config.php | grep DBPASS

Database table correction

Some files with system database tables may be damaged after “hard restart” of server.
When you restart MySQL database an error message is displaying a damaged table. Thus if you encounter the notifications while working in the system, login to the command line environment and enter the following command for repairing the table:

First stop the database

/etc/init.d/mysql stop

Database table correction

myisamchk -o -f /var/lib/mysql/ispadmin/CRASHED_TABLE.MYI

/etc/init.d/mysql start

Or you can repair tables when MySQL is running with

mysqlcheck -u ispadmin -p ispadmin

You will be asked for database password, then a complete database check will be performed, including all tables and their reparation in case of minor errors.

Repair a certain database with

mysqlcheck -r -u ispadmin -p ispadmin table_name