Re: MySQL setup cloning?

[Wayne Topa <linuxone@intergate.com>]

Carl Fink(carl@fink.to) is reported to have said:
> 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.

mysqldump -A > backup-file.sql   (on main server)

mysql  database < backup-file.sql (on backup server)

man mysqldunp

Wayne
-- 
All wiyht. Rho sritched mg kegtops awound?
_______________________________________________________