Re: MySQL setup cloning?

[Robert Vangel <vangelr@rfgt.net>]

Carl Fink wrote:
> Is there some simple way to duplicate a MySQL setup from one server to
> another, with all tables, queries, and accounts/passwords?  Perhaps just
> copying certain files?
>
> I'm not a MySQL expert (obviously), just trying to have a warm backup server
> ready if the main one goes down.  I don't need two-way replication at all,
> just the ability to manually copy everything over once a day or so.
>
> Thanks.
> --      
> Carl Fink             carl@fink.to
> Jabootu's Minister of Proofreading
> http://www.jabootu.com

This was just a quick search on google, you might want to have a look at 
 http://dev.mysql.com/doc/mysql/en/replication-faq.html

Dirtier, maybe copying the /var/lib/mysql/ directory would also do the 
trick and restarting the service once the copy is finished.

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature