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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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 AnifantakisProgramming InstructorCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.