LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (http://www.linuxquestions.org/questions/linux-server-73/)
-   -   Mysql Backup & Restore scripts (http://www.linuxquestions.org/questions/linux-server-73/mysql-backup-and-restore-scripts-874242/)

ramecare 04-11-2011 01:09 AM

Mysql Backup & Restore scripts
 
Good day to all,

Iam new to mysql & writting shell scripts,i searched in google but could not get the exact,pls can anyone help how to take mysql backup & restore using shell scripts.

EricTRA 04-11-2011 01:31 AM

Hello,

Apparently you didn't use the 'right' keywords because Google comes up with this in a blink of an eye: AutoMySQL Backup.
Quote:

A script to take daily, weekly and monthly backups of your MySQL databases using mysqldump. Features - Backup mutiple databases - Single backup file or to a seperate file for each DB - Compress backup files - Backup remote servers - E-mail logs - More..
This will give you plenty of information and how to proceed. Lots you can learn from that script.

Kind regards,

Eric

ramecare 04-11-2011 05:26 AM

Thank u very much

EricTRA 04-11-2011 05:29 AM

Hi,

You're welcome. If this solves your question please mark your thread as SOLVED using the Thread Tools. If not, let us know where you're stuck.

Kind regards,

Eric


All times are GMT -5. The time now is 05:09 AM.