MySQL Forums :: Newbie :: mysqldump and import to de-fragment tables


Advanced Search

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?!

Thanks
Kev

Options: ReplyQuote


Subject Written By Posted
mysqldump and import to de-fragment tables Kevin Walsh 01/12/2011 09:28AM
Re: mysqldump and import to de-fragment tables Rick James 01/13/2011 10:07PM
Re: mysqldump and import to de-fragment tables Kevin Walsh 01/17/2011 12:22PM
Re: mysqldump and import to de-fragment tables Rick James 01/17/2011 02:48PM
Re: mysqldump and import to de-fragment tables Kevin Walsh 02/17/2011 08:23AM


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.