how to backup my sql from a remote server
I have My SQL running on my remote webse开发者_开发知识库rver.
What is the best way to back this up every night to my windows home server?
Thanks
Create a mysql SQL script with the backup process most likely having
mysqldump
or SELECT .. INTO OUTIFLE commands.Create a .bat file to run the mysql script in step1 with command line.
mysql -uuser -ppassword -host remoteserver.com database < script.sql
Set up Windows jobs to execute the bat file daily.
精彩评论