How can we repair a MySQL table?
Answers were Sorted based on User's Feedback
Answer / malkiet
using myisamchk at prompt
or "repair table TBLNAME" command at mysql prompt.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / opensky
using myisamchk at prompt
or "repair table TBLNAME" command at mysql prompt.
| Is This Answer Correct ? | 2 Yes | 3 No |
Can you tell few best practices to be followed for optimization in sql?
How do I zip a file in mysql?
What are the advantages/disadvantages of mysql and php?
How do I know if mysql is running on windows?
How do I change directories in mysql?
Give the syntax of GRANT commands?
How to create a new table by selecting rows from another table in mysql?
What are the advantages of myisam over innodb?
What is the return type of mysqli_query?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
What happens if you no create privilege in a database?
Why to use char instead of varchar in the database?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)