repair a MySQL table.

repair a MySQL table.

How can we repair a MySQL table?

View Answers

December 27, 2010 at 1:10 PM

Hi friends,

The syntex for repairing a mysql table is:

REPAIR TABLE tablename
REPAIR TABLE tablename QUICK
REPAIR TABLE tablename EXTENDED

This command will repair the table specified. If QUICK is given, MySQL will do a repair of only the index tree.
If EXTENDED is given, it will create index row by row.

Thanks.









Related Tutorials/Questions & Answers:
repair a MySQL table.
repair a MySQL table.  How can we repair a MySQL table?   Hi friends, The syntex for repairing a mysql table is: REPAIR TABLE tablename... will repair the table specified. If QUICK is given, MySQL will do a repair of only
How can we repair a MySQL table?
How can we repair a MySQL table?  How can we repair a MySQL table
Advertisements
Getting mysql table in textbox
Getting mysql table in textbox  how to get mysql table values into textbox in java using ajax and servlets
How alter table in MySQL?
How alter table in MySQL?  Hi, I have a table and I want to alter an int field into text field. How to alter the table in MySQL? Thanks   ... examples of alter table statements in MySQL. Thanks
MYSQL - mysql copy table to another table example by creating new table
MYSQL - mysql copy table to another table example by creating new table  Hi, I have a table with many fields and hue data is in it. I want to create a new table with all the data from this table. How to create a new table
mysql table extract
mysql table extract  Hello friends!! I am a trainee. I am learning connectivity of java with MYSQL. I want to extract table from mysql so that I can access it on another computer. I want to attach mysql table to my java NETBEANS
mysql table construction - SQL
mysql table construction  In MySql there is no pivot function. using a function or Stored Procedure, I want to loop through a column of data and create a another table that uses the row value as Column labels from the row
Mysql Table
Mysql Table       MySQL Create Table Here, you will read the brief description about the MySQL create table.    Mysql Add
mysql select into table from another table example
mysql select into table from another table example  Can you suggest the correct example of select into table from another table example in MySQL... from one table into another table. Check the example at MySQLselect into new
Mysql Alter Table Syntax
Mysql Alter Table Syntax       Mysql Alter Table is used to redefine the existing table... 'Mysql Alter Table'. To grasp this example we create a table 'employees
mysql alter table add column
mysql alter table add column  Hi, What is the syntax of mysql alter table add column? Thanks   Hi, Here is mysql alter table add column example: ALTER TABLE employee ADD address VARCHAR(50); Read more at MySQL Add
Table Maintenance Statements
TABLE, BACKUP TABLE, CHECK TABLE, CHECKSUM TABLE, OPTIMIZE TABLE, REPAIR TABLE... or not with the current MySQL version. Server checks each table for determining... tables : If the table has deleted or split rows, repair the table
Mysql Alter Table
Mysql Alter Table       Mysql Alter Table is used to redefine the existing table. Understand with ExampleADS_TO_REPLACE_1 The Tutorial illustrate an example from 'Mysql Alter Table
insert excel sheet into mysql as a table
insert excel sheet into mysql as a table  sir, i want to import an excel sheet into mysql5.0 database as in the table format using tomcat 6.0 by jsp
Mysql Alter Rename Table
Mysql Alter Rename Table       Mysql Alter Rename Table is used to redefine and rename the existing... from 'Mysql Alter Rename Table'. To understand this example we create a table
Mysql Alter Rename Table
Mysql Alter Rename Table       Mysql Alter Rename Table is used to modify and change the name... an example from 'Mysql Alter Rename Table'. To grasp this example , we create a table
How to rename MySQL table?
How to rename MySQL table? The designing and development of any software system is a continuous process and you might give a wrong name to a table. After a review you many have to change the name of database. The MySQL database
Mysql From Table
Mysql From Table       Mysql From Table is used to specify the table from which the records... from 'Mysql From Table'. To grasp this example we create  a table 'Stu
MySQL Create Table
MySQL Create Table       Here, you will read the brief description about the MySQL create table...; There are following way to create MySQL table:ADS_TO_REPLACE_1      ADS
Mysql Table Describe
Mysql Table Describe       Mysql Table Describe is used to describe the Fieldtype, Datatype, Null... illustrate an example from 'Mysql Table Describe'. To understand the example we
How to insert data into MySQL Table?
How to insert data into MySQL Table?  Hi, How to insert the data into MySQL Database? Please explain me with the examples and videos thanks. Thanks   Hi, The insert into query is used to insert the data into MySQL
alter table create index mysql
alter table create index mysql  Hi, What is the query for altering table and adding index on a table field? Thanks
Mysql Alter Table Identity
Mysql Alter Table Identity       Mysql Alter Table Identity is used to change the existing structure... illustrate an example from 'Mysql Alter Table Identity'. To understand
alter table create index mysql
alter table create index mysql  Hi, What is the query for altering table and adding index on a table field? Thanks   Hi, Query is: ALTER TABLE account ADD INDEX (accounttype); Thanks
mysql alter table add unique constraint
mysql alter table add unique constraint  How to add mysql alter table add unique constraint in mysql table. Thanks   Hi Following query query can be used: ALTER TABLE mytable ADD CONSTRAINT uc_key1 UNIQUE
Mysql Alter Table
Mysql Alter Table       Mysql Alter Table is used to redefine the existing table. Understand with ExampleADS_TO_REPLACE_1 The Tutorial illustrate an example from 'Mysql
how to take input table name in jsp to create table in mysql?
how to take input table name in jsp to create table in mysql?  how to take input table name in jsp to create table in mysql?   Hello Friend...; <form method="post"> Enter Table Name:<input type="text" name="table
Copy Table in a MySQL Database
Copy Table in a MySQL Database       In this section, you will learn to copy one table to another... you in copying one table to another in a same MySQL database. To copy any table
alter table add foreign key mysql
alter table add foreign key mysql  Hi, How to add foreign key in mysql using the query 'alter table add foreign key mysql' Thanks   Hi, We can use the following query: ALTER TABLE emp_address ADD FOREIGN KEY (emp_id
mysql alter table add multiple columns
mysql alter table add multiple columns  Hi, I have a table in database. I want to add multiple columns into existing table. What is the code for mysql alter table add multiple columns? Thanks   Hi, You can use
MySQL take backup of a table - example code needed
MySQL take backup of a table - example code needed  How to take backup of a table in MySQL? I have a database which contains many tables. What is the command to take the backup of one table with data from database? Thanks
WANNA IMPORT RAINBOW TABLE IN MYSQL DATABASE
WANNA IMPORT RAINBOW TABLE IN MYSQL DATABASE  hello, i have... table in one and then i want to import the values of rainbow table in mysql... to import rainbow table in mysql database thanks
create table in mysql of split file created in java
create table in mysql of split file created in java  i have created splite file in java. now i want to create table from splited data how to do
update a particular of mysql table using servlet
update a particular of mysql table using servlet  how to update a particular column for the entire table by taking requests from html form and update the particular column with out affecting other attribute values in the tuple
browse and submit the excel sheet into mysql as a table
browse and submit the excel sheet into mysql as a table  sir, i want to browse and after clicking a submit button, the data in the excel sheet should be stored in the mysql5.0 as a table
deleting all records from a table in mysql
deleting all records from a table in mysql  Hi, I am finding code for deleting all records from a table in mysql. How to delete all rows in mysql table? Thanks   Hi, If you have a table called EMPLOYEE then you can
deleting all records from a table in mysql
deleting all records from a table in mysql  Hi, I am finding code for deleting all records from a table in mysql. How to delete all rows in mysql table? Thanks   Hi, If you have a table called EMPLOYEE then you can
Unable to Insert Arabic words in mysql table
("UTF-8"); In mysql Change Setting Alter table and Set charset=utf8...Unable to Insert Arabic words in mysql table  I have I java program that I want to insert arabic letters in mysql. Do you have any idea about
php csv file uploding into mysql database table.
php csv file uploding into mysql database table.  hai friends, i... fields. i have one mysql database table with two files fields, when ever i am uploding csv file, i want to fetch the datas in corresponding fields in table. can
problem on jsp, inserting data into table(mysql).
problem on jsp, inserting data into table(mysql).  hello friends, I have a problem in jsp.I want to insert data, which is given by user through a html page into a table.And the table name also is given by the user.My database
fetch record from MYsql table query
fetch record from MYsql table query  Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table
Mysql Alter Table Primary Key
Mysql Alter Table Primary Key       Mysql Alter Table Primary Key is used to remove... an example from 'Mysql Alter Table Primary Key'. To understand this example, we create
MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist
MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist  MySQL issue: Table 'datadictionary.CHARACTERSETS' doesn't exist
HTML & MYSQL - retrieve record from table
HTML & MYSQL - retrieve record from table  Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai... table. Actually they are separated by comma. I want to take the values as single
MYSQL retrieve record from Data table
MYSQL retrieve record from Data table  Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy... table. Actually they are separated by comma. I want to take the values as single
how to import excel sheet into mysql database and save it as a table in database
how to import excel sheet into mysql database and save it as a table in database  sir, i want to import an excel sheet into a MySQL database and after importing it i want to store the excel sheet as a table in database
i want to protect mysql database table which user can not view to table and can not copy my table till then us
i want to protect mysql database table which user can not view to table and can not copy my table till then us  i want to protect mysql database table which user can not view to table and can not copy my table till then user do
Inserting values in MySQL database table
Inserting values in MySQL database table   ... insert values in the MySQL database table. We know that tables store data in rows... the facility for inserting the values in MySQL database table. Description
i want to protect mysql database table which user can not view to table and can not copy my table till then us
i want to protect mysql database table which user can not view to table and can not copy my table till then us  i want to protect mysql database table which user can not view to table and can not copy my table till then user do
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields

Ads