auto matic backup mysql table

please suggest the method to back up my sql automatic ly to flash drive or another server
teeraAsked:
Who is Participating?
 
KysolCommented:
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

If you are in a *nix environment, write a cronjob to run at the times you want, get it to mysqldump the databases you need, tar them up (optional) then either scp them to another server or cp them to the flash drive.
0
 
theGhost_k8Database ConsultantCommented:
You may also use MySQL Gui Tools eg. administrator / workbench to schedule the autobackup.
0
 
k_murli_krishnaCommented:
Take backups using freeware tool SQLYog for MySQL. You can restore the backup as well.

How To Backup a MySQL Database With SQLyog
http://blog.sobbayi.com/2010/03/how-to-backup-a-mysql-database-with-sqlyog/
Introducing SQLyog, a MySQL Front End - Backing Up/Restoring Data
http://www.databasejournal.com/features/mysql/article.php/10897_1558731_5/Introducing-SQLyog-a-MySQL-Front-End.htm
Synchronize MySQL Data Using SQLyog Job Agent
http://articles.sitepoint.com/article/mysql-data-sqlyog-job-agent

If backup files fall in folder in:

1) Windows: Write a .bat batch file to copy from here to flash drive/another server and schedule in Windows Scheduler or using AT command or even anti-virus scheduler OR using third party windows job scheduling tools

How To Schedule Tasks in Windows XP
http://support.microsoft.com/kb/308569
How to use the Windows Task Scheduler
http://www.iopus.com/guides/winscheduler.htm
How To Use the AT Command to Schedule Tasks
http://support.microsoft.com/kb/313565

2) UNIX/LINUX: Write a CRON job to schedule the copy of backups OR use third party tools

What is a cronjob, and how do I use it?
http://www.aota.net/Script_Installation_Tips/cronhelp.php3
Crontab – Quick Reference
http://adminschoice.com/crontab-quick-reference
0
 
Ioannis AnifantakisSoftware EngineerCommented:
Download the MySQL Admin, from mysql site (think its merged now in MySQL Workbench).
You can create a backup project on your desired schema from there and select whether or not you will simply want this project to backup immediately your DB, or you want it to perform scheduled backups.

On scheduled backups you can provide what days and what times you want your backups to be planed for, and the only thing you will be asked, is to provide your "windows username/password" for the automatic backup to take place.

Thats both easy and official from MySQL.
0
 
rajkumar_pbCommented:
I think you need to take automatic backup. Right?. Ok then, follow the link

http://www.dagondesign.com/articles/automatic-mysql-backup-script/

All you need to do is, write a PHP file that backup the DB. Configure it with cron job(if you're in *nix environment) and set the interval of its execution.It'll automatically take backup and store it under a user-specified directory. Thats it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.