Repair operations performed through phpMyAdmin or the control panel on large MySQL database files may not complete or may cause issues. Therefore, it is more reliable to repair large MySQL databases via SSH on Linux servers.
Connect via SSH and make sure you are the superuser (root). Enter the following command in the command line:
mysqlcheck -r [database name]mysqlcheck is the command used to check databases. The -r parameter performs a Repair operation.
If the above command does not work, you can perform the operation directly by specifying the MySQL files directory from the Linux command line:
myisamchk -r /var/lib/mysql/[database name]/*Note: Before performing a MySQL repair, make sure the server has sufficient disk space.
Leave a Comment
* Your comment will be published after approval.
Comments
0No comments yet. Be the first to comment!