Re: backup question: INSERT statements

At 19:47 -0230 9/28/04, Neil Zanella wrote: Hello, I need to backup a mysql database in such a way that the output is simply a bunch of insert statements. I do not want the database schema as output as well: just the insert statements. This is because I already have a script with CREATE statements

Re: Backup question.

take a snapshot in MySQL and use this to back up data? Simon -Original Message- From: Paco Martinez [mailto:[EMAIL PROTECTED] Sent: 18 November 2003 10:00 To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED] Subject: Re: Backup question. Is there any problem executing "rs

Re: Backup question.

Message - > From: "Christensen, Dave" <[EMAIL PROTECTED]> > To: "'Richard Reina'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, November 12, 2003 10:20 PM > Subject: RE: Backup question. > > > Yes, you can do

Re: Backup question.

Paco Martinez [mailto:[EMAIL PROTECTED] > Sent: 18 November 2003 10:00 > To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED] > Subject: Re: Backup question. > > > Is there any problem executing "rsync /var/lib/mysql/data/" from one host > to another host and

Re: Backup question.

Just me has access to that machine... And there's no LVM. - Original Message - From: "Simon Green" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 18, 2003 11:12 AM Subject: RE: Backup question. > Has any one use LVM to take a sna

RE: Backup question.

Has any one use LVM to take a snapshot in MySQL and use this to back up data? Simon -Original Message- From: Paco Martinez [mailto:[EMAIL PROTECTED] Sent: 18 November 2003 10:00 To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED] Subject: Re: Backup question. Is there a

Re: Backup question.

, Dave" <[EMAIL PROTECTED]> To: "'Richard Reina'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, November 12, 2003 10:20 PM Subject: RE: Backup question. > Yes, you can do it like this: > > > Prompt> mysqldump --add-drop-table -

Re: Backup question.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Richard -- ...and then Richard Reina said... % % I would like to backup databases from a linux MySQL server to another % linux machine on the same private network but I don' see in the docs how % I can do this with mysqlhotcopy or mysqldump. Is th

RE: Backup question.

Yes, you can do it like this: Prompt> mysqldump --add-drop-table --host=source.IP.addr.spec -uuser -ppassword databasename | mysql -uuser -ppassword I've found that it helps things if you add --no-data to the source side on the first pass, then remove that clause and run it again. Dave -

RE: Backup question.

mysqldump -uname -ppassword -BDatabase | mysql -uname -ppasswrod -Ddatabase -hremotehost -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:54 PM To: [EMAIL PROTECTED] Subject: Backup question. I would like to backup databases from a li

Re: Backup Question.

Richard -- You could do both, I would be a lot quicker to import data than restore from tape. Say do an incremental dump back to your last level 0. Which would be helpfull to developers as well as youself. You could also use a seperate partition for the data directory and back that up. The subj

RE: Backup question

Howdy, I tend to do both a dump to disk and then stop the DB and do a tape backup. I don't believe there is an "Online" backup capability as user transactions would need to be stored and played back against the DB after the backup as in most production ready DB's. Sid Young QML Pathology Datab

Re: backup question

Look in the MySQL manual for mysqldump you should find the correct syntax On Mon, 15 Jan 2001, sanaa wrote: > hi > I want to know how to backup and restore databases in mysql. > > > thanks for help > > - > Before posting, pl