Carl Fink([EMAIL PROTECTED]) 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? _______________________________________________________ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
