I can't totally relying on remote db connection so I have a primary server (remote), and if that fails my secondary is localhost. To sync the primary to the secondary server I use the following line:
mysqldump --add-drop-table -u root auth | mysql -h servername -u nssroot --password=foobar auth
Hopefully that's helpfully to somebody.
Keith
You do realize that MySQL can replicate, right? Granted, it's a little more complex to setup and maintain ... :-)
Thanks for the post tip tho! I'm sure those who don't want to replicate will make use of it ...
Log in to post a comment.
I can't totally relying on remote db connection so I have a primary server (remote), and if that fails my secondary is localhost. To sync the primary to the secondary server I use the following line:
mysqldump --add-drop-table -u root auth | mysql -h servername -u nssroot --password=foobar auth
Hopefully that's helpfully to somebody.
Keith
You do realize that MySQL can replicate, right? Granted, it's a little more complex to setup and maintain ... :-)
Thanks for the post tip tho! I'm sure those who don't want to replicate will make use of it ...