Differences

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

--- 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 ======