With the long-term use of MySQL, you can fix the table to optimize and reduce disk footprint when optimizing. Easy backup.REPAIR table is used to repair corrupted tables.OPTIMIZE table is used to reclaim unused database space, and when the data rows
CopyCodeThe Code is as follows: repair table 'table _ name' to repair the table
Optimize table 'table _ name' optimize table
Repair table is used to repair damaged tables.Optimize table is used to recycle idle database space. When the data rows in
Copy Code code as follows:
REPAIR table ' table_name ' repair form
OPTIMIZE table ' table_name ' optimization tables
The REPAIR table is used to repair damaged tables.
The OPTIMIZE table is used to reclaim unused database space, and when
With the long-term use of MySQL, there will certainly be some problems, in general, the MySQL table can not be accessed, it is possible to repair the table, optimized to reduce disk space, convenient backup. Table table_name // table table_name /
REPAIR table Syntax
REPAIR table ' table_name ' repair form
REPAIR table is used to repair damaged tables
Using in Linux
REPAIR TABLE ' table_name ' pre_forum_thread
Tips
Xt.pre_forum_thread Repair Error 1 when fixing table
REPAIRTABLE and OPTIMIZETABLE optimize TABLE and REPAIR table repair table 'Table _ name' REPAIR table
Optimize table 'Table _ name' OPTIMIZE table
Repair table is used to REPAIR damaged tables.
Optimize table is used to reclaim idle database
On the local test machine the day before yesterday, data loss occurs when MySQL 5.1.43 and MyISAM engines run repair table. We hereby record that the same problem has been encountered in MySQL 5.0.32, therefore, you must back up the data before
database table xxx is marked as crashed and should be repaired error resolution server Power off and other reasons may cause data table corruption, resulting in access to prompt: Table xxx is marked as crashed and should be repaired where xxx is the
With the long-term use of mysql, some problems may occur. In general, mysql tables cannot be accessed, and the tables can be repaired. During optimization, the disk space is reduced. Convenient backup.
With the long-term use of mysql, some problems
ALTER DATABASE Dcdata set Single_user with rollback immediateSet to Single user modeAnd then perform the repair.DBCC checktable (Zlbzsgph,repair_allow_data_loss)DBCC checktable (Zlbzsgpb,repair_allow_data_loss)DBCC checktable (Zlyggpmxh,repair_allow_
Copy codeThe Code is as follows:Repair table 'table _ name' REPAIR tableOptimize table 'table _ name' OPTIMIZE tableRepair table is used to REPAIR damaged tables.Optimize table is used to recycle idle database space. When the data rows in the TABLE
REPAIRTABLE syntax in MySQL database introduction bitsCN.com
REPAIRTABLE syntax in MySQL database
[Pre] REPAIR [LOCAL | NO_WRITE_TO_BINLOG] TABLE [/pre] [pre] tbl_name [, tbl_name]… [QUICK] [EXTENDED] [USE_FRM] [/pre] repair table is used to
Symptom of table corruption
A typical symptom of a damaged table is as follows:1. When selecting data from a table, you get the following error:Incorrect key file for table: ' ... '. Try to repair it2. The query cannot find rows in the table or
Maybe many people have encountered the class Can 'topenfile: '[Table] mytable. the myi' error message does not know how to solve it. Next we will introduce that, in most cases, database corruption only means that the index file is damaged, the real
In most cases, the database is damaged only when the index file is damaged, and the real data is damaged rarely. Most forms of database corruption can be easily repaired.
As with the previous verification, there are three methods to fix the
mysql tutorial cant open file: Table name modification method
1.can ' t Open file: ' [table]mytable.myi '2.table ' picture ' are marked as crashed and should be repaired
The following methods are valid only for tables in MyISAM format. Other types
Maybe many people have encountered an error message like Can 'topenfile: '[Table] mytable. myi', but they don't know how to solve it. Let's introduce it as follows,
Many people may have encountered an error message like Can't open file: '[Table]
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.