Differences

This shows you the differences between two versions of the page.

Link to this comparison view

systems:sql_commands [2018/12/27 15:58]
eServices Greece created
systems:sql_commands [2020/04/29 15:23] (current)
eServices Greece
Line 1: Line 1:
 +====== Maintenance ======
 +
 +==== Check Table Integrity ====
 +<sxh bash>myisamchk -s /var/lib/mysql/*/*.MYI</sxh>
 +
 +==== Repair Table ====
 +<sxh bash>myisamchk -r /var/lib/mysql/dbname/table_name.MYI</sxh>
 +
 +=== If it fails ===
 +<sxh bash>systemctl stop mariadb 
 +myisamchk -r --update-state /var/lib/mysql/dbname/table_name.MYI
 +systemctl start mariadb</sxh>
 +
 ====== Basic SQL Commands ====== ====== Basic SQL Commands ======