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 :: 2020 new year
Sql :: drop column from table if exist on live server mysql
Sql :: triggers in mysql
Sql :: How to Search in all Columns for all tables in a database for Date Value in SQL Server - SQL Server
Sql :: mysql get nested records
Sql :: Raw query must include the primary key
Sql :: php mysql set db collation
Sql :: mysql a from on this page has
Sql :: azure sql server check foreign key
Sql :: postgresql select fast check no rows
Sql :: how to read the potentail error messages in ssis package
Sql :: openquery update linked server
Sql :: oracle query archive mode
Sql :: sql set devault value with existing column
Sql :: how to take recent row without limit in mysql
Sql :: flask sqlalchemy decimal
Sql :: dump only data
Sql :: odata expand and $select only column values
Sql :: execute stored procedure without db set
Sql :: SQL ORDER BY With Multiple Columns
Sql :: replace sqlalchemy
Sql :: Insert and initialize a SQL column with value dependent on another column data
Sql :: pl sql trigger update sysdate
Sql :: power query case when
Sql :: oracle optional field procedure
Sql :: MQL4 mql4 run ea on all symbols by adding to just one chart
Sql :: reading from right to left from string find first special characters in sql
Sql :: sql server union if table exist
Sql :: postgresql get tables where column is foreign key
Sql :: how to install sql server

Search

SQL

mysql repair a table

mysql check if table need repair

ADD CONTENT