All geek questions in one place

How to backup my sql from a remote server

I have my SQL running on my remote web server.

What is the best way to maintain this every night on my home windows server?

thank

+3
source share
1 answer

  • Create a mysql SQL script with a backup process that most likely has commands mysqldumpor SELECT .. INTO OUTIFLE.

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

  • Set up Windows jobs to run the bat file daily.

+2
source

Source: https://habr.com/ru/post/1733672/

More articles:


All Articles