Re: moving mysql database
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?
Subject
Written By
Posted
Re: moving mysql database
May 09, 2013 10:41PM
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.