Hi All
I have My SQL running on my remote webserver.
What is the best way to back this up every night to my windows home server?
Thanks
+1
A:
Create a mysql SQL script with the backup process most likely having
mysqldumpor 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.sqlSet up Windows jobs to execute the bat file daily.
Yada
2010-02-20 15:13:38
i doubt that his remote mysql server is accessible via `mysql` from his windows box.
ax
2010-02-20 15:15:48
Not sure what you mean. mysql command is used to access remote/local servers. Just need to specify the -host option. The default is to access the localhost.
Yada
2010-02-20 15:24:15
@Yada in many hosting environments, access to mySQL from the outside is blocked, partly because of horrible security problems with the mySQL logins in the past. In that case, you need a "proxy" (e.g. a PHP script) to access the database. From an earlier question, though, we know that the OP has 2003 server fully under his control, so this solution is probably going to work.
Pekka
2010-02-20 15:37:34
Thanks, so I install MYSQL on my home server and it will communicate with my remote MY SQL server?
Roaders
2010-02-20 15:37:45
@Roaders yes, that's the idea. The mySQL client binaries would be enough (no need to install the server locally) but I don't think there's a client only installation.
Pekka
2010-02-20 15:39:40