Repairing all MySQL tables
mysqlcheck --repair --extended --all-databases
————-
Dumping the content of all databases in SQL format. (can be used for backup/migration purposes)
mysqldump -p --user=root --add-drop-table --all-databases > all_my_databases.sql
Import all databases from above saved file
mysql -u root -p < all_my_databases.sql
-------------
Dumping the content of a single database in SQL format.(can be used for backup/migration purposes)
mysqldump -p --user=root --add-drop-table databasename > my_database.sql
Import a database from above saved files
mysql -u root -p databasename < my_database.sql
-------------
Checking the integrity of mysql databases
mysqlcheck -A -p