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?
4
-
Do you have server access? What are your possibilities?AgeDeO– AgeDeO2015-02-10 11:32:01 +00:00Commented Feb 10, 2015 at 11:32
-
I have a domain just, and i bought it from a company.DataGeek– DataGeek2015-02-10 11:36:10 +00:00Commented Feb 10, 2015 at 11:36
-
have the ability to schedule cron jobs? if so: stackoverflow.com/questions/6645818/…n34_panda– n34_panda2015-02-10 11:36:27 +00:00Commented Feb 10, 2015 at 11:36
-
I'm asking for Windows application :)DataGeek– DataGeek2015-02-10 11:43:48 +00:00Commented Feb 10, 2015 at 11:43
Add a comment
|
1 Answer
Solution 1: If you are searching free tool for auto backup mysql then you should check this Auto MY SQL Backup
Features:
- Email notification of backups
- Backup Compression and Encryption
- Configurable backup rotation
- 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
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.
