MySQL Forums
Forum List  »  General

Re: moving mysql database
Posted by: Varun Nidadavolu
Date: May 09, 2013 10:41PM

Peter Brawley Wrote:
-------------------------------------------------------
> Install & configure MySQL on the local server.
>
> Take a complete mysqldump or equivalent from the
> remote server
>
> Run that dump file on the local server
>
> Completely regression-test all apps & procedures
> on the local server
>
> Switch users to the local server
>
> When you're satisfied that no more move-induced
> bugs are to be found, lose the remote server.





Thank you for your response Peter, we have configured MYsql at local server, I googled and found few steps on mysqldump. My doubt is does mysql dump file contains all data pertaining to target database? or we need to manually copy datafiles to local server using scp?

Options: ReplyQuote


Subject
Written By
Posted
Re: moving mysql database
May 09, 2013 10:41PM
May 10, 2013 06:02AM
June 08, 2013 05:46AM


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.