MySQL Database backup automatically on a windows server

mysql database backup
Coderwannabe picture Coderwannabe · Feb 2, 2013 · Viewed 72.4k times · Source

Is there a way to back up MySQL database automatically at certain times of the day for designated servers or send an email with an attachment.. Which ever do you think is the best and safest way to achieve this?

Answer

Tarun Gupta picture Tarun Gupta · Jul 7, 2014

Best way to do this would be 

mysqldump.exe --user=YourUserName --password=YourPassword --host=localhost --port=3306 --result-file="Path\dump.sql" --databases "DatabaseName1" "Database2"


mysqldump.exe --user=root --password=root  --host=localhost --port=3306 --result-file="c:\www\db\backup.%date:~10,4%%date:~7,2%%date:~4,2%.sql" --default-character-set=utf8 --single-transaction=TRUE --databases "dbtest1" "dbtest2"

The pattern backup.%date:~10,4%%date:~7,2%%date:~4,2%.sql will create a unique name (backup20131010.sql) each time it will run

Now you just need to call this command in your task scheduler. That's it. :)

Related questions

mysqldump with create database line

I'm in the process of moving my files onto another computer, and one thing I would like to do is to transfer the data in my MySQL database. I want to dump the databases into .sql files, but also have …

Read More
How to backup MySQL database on a remote server?

I have a MySQL database existing on a remote server. I only have sql connection privilege. I don't have FTP access to the server, and I need to do a complete dump of the database. I have tried mysqldump, but …

Read More
Simple Backup and Restore for mysql Database from Java

How to backup a mysql database from a java code such that: It's saving path is dynamically allocated. Spaces in Path do not create problems. Path is generated using the executing jar file. DBname,DBusername or DBpass are dynamically allotted. …

Read More