MySQL Forums
Forum List  »  Newbie

mysqldump and import to de-fragment tables
Posted by: Kevin Walsh
Date: January 12, 2011 09:28AM

Hi there,
I am pretty new to sql but not sys admining. We recently took on a service that has large innodb tables within its DB. ie. 250G tables which store files, jpegs, videos etc. (I imagine this is already bad practice).
My query to the knowledgable out there is this:

1. There is a master and a slave set up
2. I would like to mysqldump and re-import the whole DB to free up any available space.

What is the best way to go about this?
Should i start with the slave and then make that the master after the re-import?
Once I have done the mysqldump do i need to drop the full DB and re-import?
Am I way off?!


Options: ReplyQuote

Written By
mysqldump and import to de-fragment tables
January 12, 2011 09:28AM

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.