Chapter 29. Statements for Table Maintenance
29.1 Introduction
MySQL supports several SQL statements that relate to the maintenance and management of databases. For example, with one we can repair a damaged table, and with another one we can check whether a table with indexes is still correct. Generally, database managers, not developers, use these statements. Still, we discuss them here to be complete.
This chapter discusses the following statements:
• ANALYZE TABLE
• CHECKSUM TABLE
• OPTIMIZE TABLE
• CHECK TABLE
• REPAIR TABLE
• BACKUP TABLE
• RESTORE TABLE
These statements belong to the group called table maintenance statements.
Note that MySQL also supports special utilities with which comparable actions can be performed. Because this book ...
Get SQL for MySQL Developers: A Comprehensive Tutorial and Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
