CODEWITHSUNDEEP
mysqlwindowsbackup
DataGeek
DataGeek

Reputation: 25

Application for backup a MYSQL

I'm trying to backup MYSQL automatically on specified time every day, i searched for a free tool but i didn't find any thing ! Is there any free tool or application for backup a MYSQL database from my domain?

Upvotes: 0

Views: 193

Answers (1)

sreenivas
sreenivas

Reputation: 395

Solution 1: If you are searching free tool for auto backup mysql then you should check this Auto MY SQL Backup

Features:

  1. Email notification of backups
  2. Backup Compression and Encryption
  3. Configurable backup rotation
  4. Incremental database backups

Solution 2: Another Solution will be Cron Jobs 

5 0 * * * /path/to/mysqldump ... > /path/to/backup/mydata_$( date +"%Y_%m_%d" ).sql

Read man date

How to (Cron)

Introduction to cron,covers the basics of what cron does, and how to use it.

Solution 3: For windows machines go for this link windows auto backup

solution 4: In windows i would prefer Task Scheduler, it looks some thing like this

schtasks /create /sc daily /st 08:20 /ru SYSTEM /tn MySQL_backup /tr "\"C:\My Project\MySQL\MySQL Server 5.1\bin\dump.exe\" -B <DataBase_NAME> -u <USER_NAME> -p<PASSWORD> -r C:\MySQL_backup\<DataBase_NAME>_%date:~0,2%.sql

I would prefer Cron Jobs. Hope this helps you.

Upvotes: 2

Related Questions