开发者

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


  1. Create a mysql SQL script with the backup process most likely having mysqldump or SELECT .. INTO OUTIFLE commands.

  2. Create a .bat file to run the mysql script in step1 with command line. mysql -uuser -ppassword -host remoteserver.com database < script.sql

  3. Set up Windows jobs to execute the bat file daily.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜