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 [EMAIL PROTECTED]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.
smime.p7s
Description: S/MIME Cryptographic Signature
