Category Archives: MySql

Remote mysql backups on windows

In our day to day job needs to backup remote mysql database and sometimes may needs to synchronize with another one. It can be done by using following code snippet, no matter the remote server is windows or Linux. Save the following code snippet as a batch(.bat) file and setup a task scheduler. set DATET=%date:~-4%_%date:~7,2%”your…

Read More

Mysql backup on linux using ssh and cron

Sometimes, we may need to backup and synchronize mysql on linux as a background process. Linux has a great program for this called cron. It allows tasks to be automatically run in the background at regular intervals. Create a script file(.sh) using following code snippet to backup and restore database in to another database: ssh…

Read More