How to REORG a table in MySQL
Answer:
In MySQL, the only way to REORG a table is to export the data, e.g. using mysqldump, then import the data into MySQL again.
While other database such as Oracle provides a more handy way to do it.
Related posts:
- Dump the table schema of a MySQL database
- Drop all tables in MySQL database
- Optimize table in MySQL
- Repair table in MySQL
- Copy existing table schema to a new table
