Re: DB Compress
If the tables are InnoDB ...
1. Backup all InnoDB tables with mysqldump
2. DROP all InnoDB tables
3. Stop the server, delete the ibdata1 file
4. Restart MySQL Server, which will create a new ibdata1
5. Restore from the dump
A lot of risky folderall to save a bit of space. It would be far more efficient, in most circumstances, to simply install a bigger drive.
Edited 1 time(s). Last edit at 04/28/2013 02:59PM by Peter Brawley.
Subject
Written By
Posted
Re: DB Compress
April 28, 2013 02:59PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.