Re: MYSQL DB BACKUP

2008-10-25 Thread Moon's Father
There are some of backup scripts written by me.You can find it at: http://blog.chinaunix.net/u/29134/article_71953.html On Wed, Oct 22, 2008 at 4:52 PM, Mad Unix [EMAIL PROTECTED] wrote: Any one tried the script from HowToForge

Re: MYSQL DB BACKUP

2008-10-22 Thread Mad Unix
Any one tried the script from HowToForge http://www.howtoforge.com/shell-script-to-back-up-all-mysql-databases-each-table-in-an-individual-file-and-upload-to-remote-ftp #!/bin/sh # System + MySQL backup script # Copyright (c) 2008 Marchost # This script is licensed under GNU GPL version 2.0 or

Re: MYSQL DB BACKUP

2008-09-16 Thread Ananda Kumar
Hi Krishna, When u say remote server, do u mean the file system storing the backup is on a different machine. regards anandkl On 9/16/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi, Currently, i am taking production server backup on hourly basis on the slave server. Is it

Re: MYSQL DB BACKUP

2008-09-16 Thread Krishna Chandra Prajapati
Yes On Tue, Sep 16, 2008 at 6:39 PM, Ananda Kumar [EMAIL PROTECTED] wrote: Hi Krishna, When u say remote server, do u mean the file system storing the backup is on a different machine. regards anandkl On 9/16/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi, Currently, i am

Re: MYSQL DB BACKUP

2008-09-16 Thread Ananda Kumar
Can u mount that file system on the slave db and take the backup so that u can avoid Network latency. regards anandkl On 9/16/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Yes On Tue, Sep 16, 2008 at 6:39 PM, Ananda Kumar [EMAIL PROTECTED] wrote: Hi Krishna, When u say remote

Re: MYSQL DB BACKUP

2008-09-16 Thread Krishna Chandra Prajapati
Thanks a lot. I am writing script which will take backup and copy it to another box. On Wed, Sep 17, 2008 at 11:14 AM, Ananda Kumar [EMAIL PROTECTED] wrote: Can u mount that file system on the slave db and take the backup so that u can avoid Network latency. regards anandkl On 9/16/08,