Sql

Search

mysql repair a table

REPAIR TABLE mytablename

Comment

mysql check if table need repair

#check the whole database for tables that need repair
mysqlcheck -c mydatabase -u root -p

#check just one table to see if it needs repair
mysqlcheck -c mydatabase mytable -u root -p

#NOTE:careful running this on production its costly command

Comment

PREVIOUS	NEXT

Code Example
Sql :: check mysql port
Sql :: sql select except null
Sql :: firebase bigquery cloud message
Sql :: sort by last three charecter in sql
Sql :: postgresql CREATE EXTENSION pgcrypto
Sql :: oracle sequence last_number
Sql :: tsql replace value in json
Sql :: sql server drop table if exists
Sql :: sql fillna
Sql :: get table column names sql laravel
Sql :: ilike for date postgres
Sql :: how to get slow query log in mysql
Sql :: Database "mem:testdb" not found, either pre-create it or allow remote database creation (not recommended in secure environments) [90149-200] 90149/90149 (Help)
Sql :: how to check current user in mysql
Sql :: oracle ora-00054 causes
Sql :: update row in mysql
Sql :: installing postgresql ubuntu
Sql :: convert to hexadecimal sql
Sql :: mysql pretty date format
Sql :: add unique constraint sql server multiple columns
Sql :: sql random integer
Sql :: calculate age in sql
Sql :: create in sql
Sql :: ORA-00903
Sql :: sql server arabic collation
Sql :: sql where keyword contains
Sql :: get top 10 records in oracle
Sql :: sql server substring
Sql :: find duplicates mysql
Sql :: sql get last id

Search

SQL

mysql repair a table

mysql check if table need repair

ADD CONTENT