How to repair MySQL database in Linux SSH Commands?
You can easily repair a MySQL database in SSH. To do so, please follow the steps given below:
1. Log into your server via SSH.
2. If you have MySQL within your server (localhost), then you can easily repair the database, so, run below commands to repair a database:
sudo mysqlchek -r databasename
If you wish to repair only a particular table, then use the command as:
sudo mysqlchek -r databasename databasetablename
Also, if you do not have SSH service, you can manually log into your cPanle/phpMyAdmin/controlpanel to repair MySQL database. For more information, click here.
repair-mysqldb-tables
Link to this post!
One Comment
@Slava: That is a very good question. In fact you can use those migrations as a 1:1 match with the product release cycles. So when the weekly (or whatever) version of the project is to be released next friday, every dev enters their deltas into that script. In rare cases a project lead will have to reshufle or do tiny bits of editing into the migration script.
[Translate]