How to REORG a table in MySQL MySQL Add comments Feb 122008 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 Leave a Reply Cancel reply Name (required) E-mail (required) URI Your Comment You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
