Re: MYSQL DB BACKUP

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 > > > http://www.howtoforge.com/shell-script-to-back-up-all-mysql

Re: MYSQL DB BACKUP

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 ab

Re: MYSQL DB BACKUP

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

Re: MYSQL DB BACKUP

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 s

Re: MYSQL DB BACKUP

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, >

Re: MYSQL DB BACKUP

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 i

Re: restoring mysql db backup..

Helza wrote: > > Hi, > > I've made an backup of my MySQL db using: > > mysqldump -uoperatio_operati -p* operatio_forum >> database.sql > > and with: > mysqldump -uoperatio_operati -p* --quick --add-drop-table --add-locks >--extended-insert --lock-tables operatio_forum > database.sql >

restoring mysql db backup..

Hi, I've made an backup of my MySQL db using: mysqldump -uoperatio_operati -p* operatio_forum >> database.sql and with: mysqldump -uoperatio_operati -p* --quick --add-drop-table --add-locks --extended-insert --lock-tables operatio_forum > database.sql both produce a mysql back of aro