开发者

how to backup my sql from a remote server

开发者 https://www.devze.com 2022-12-20 15:22 出处:网络
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?

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

精彩评论

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