Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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 
ADD CONTENT
Topic
Content
Source link
Name
6+1 =