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

Mysqldump: Seeding the db backup file.

t not getting good example) -- Manivannan Palanichamy http://mani.gw.googlepages.com/index.html -- View this message in context: http://www.nabble.com/Mysqldump%3A-Seeding-the-db-backup-file.-tf4287584.html#a12205477 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL Ge

Re: Problem with DB backup

They are not SQL statements. They are both command line tools. You don't run them from inside the mysql client. hlam wrote: >I'm trying to do a backup of my DB using "mysqldump" >and "mysqlhotcopy" but both functions are sending me an error on SQL >syntax. >Could someone tell me what's the cor

Re: DB backup

hi, you should be using the c: prompt to run command and not the mysql prompt. Hasan - Original Message - From: "Horacio Lam" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 7:30 PM Subject: DB backup > I'm trying to do a backu

Problem with DB backup

I'm trying to do a backup of my DB using "mysqldump" and "mysqlhotcopy" but both functions are sending me an error on SQL syntax. Could someone tell me what's the correct syntax for this functions. HL - Net-M@sters S.A. Plaza Credicorp Bank Calle 50, Oficina 703 tel. (5

DB backup

I'm trying to do a backup of my DB using mysqldump and mysqlhotcopy but both fuctions are sending me an error in SQL syntax. Could anyone tell me the correct syntax for this functions? thanks HL _ Supercharge your e-mail with a 25MB Inbox, P

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