backup question: INSERT statements

2004-09-28 Thread Neil Zanella
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 and would like to rebuild the database

Re: backup question: INSERT statements

2004-09-28 Thread Paul DuBois
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.

2003-11-18 Thread Paco Martinez
] 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 --host=source.IP.addr.spec -uuser -ppassword databasename | mysql -uuser -ppassword I've found

RE: Backup question.

2003-11-18 Thread Simon Green
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 any problem

Re: Backup question.

2003-11-18 Thread Paco Martinez
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 snapshot in MySQL and use this to back up

Re: Backup question.

2003-11-18 Thread Bernard Clement
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 therefore having same file in obth machines?? Is it unsafe this method

Re: Backup question.

2003-11-18 Thread Bernard Clement
] 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 --host=source.IP.addr.spec -uuser -ppassword databasename | mysql -uuser -ppassword

Re: Backup question.

2003-11-18 Thread Joseph Bueno
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 rsync /var/lib/mysql/data/ from one

Re: Backup question.

2003-11-13 Thread David T-G
-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

Backup question.

2003-11-12 Thread Richard Reina
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 there any way to do this besides using ftp. Any help would be appreicated. Richard -- MySQL General

RE: Backup question.

2003-11-12 Thread Victor Pendleton
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

RE: Backup question.

2003-11-12 Thread Christensen, Dave
-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 linux MySQL server to another linux machine on the same private network but I don' see

Database Backup Question

2003-02-17 Thread Loren McDonald
This is actually more a PHP question but since it refers to a MySQL database I thought I would ask here. I may not be looking in the right places but, I can't seem to find a way to do a database backup through PHP (other than BACKUP TABLE, which I don't want to use if possible) What I mean is

Re: Database Backup Question

2003-02-17 Thread KH Chiu
Sorry I am in a bit hurry and just post some hints on your question. It is more than one way to do your job. One of the trival way is to use php function 'exec'. This function can execute shell programs. It means that you can execute mysqldump etc. and create dump file. From my experience, you

RE: Database Backup Question

2003-02-17 Thread Loren McDonald
/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com -Original Message- From: KH Chiu [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 9:19 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Database Backup Question Sorry I am in a bit hurry and just post some hints on your

Backup Question.

2001-12-31 Thread Richard Reina
I am running mysql on a linux box RH 6.2. I backup all the filesytems with: /sbin/dump 0ubf 800 /dev/npt0 to a COLORADO 8gig. travan tape drive. Is this sort of backup regimen a good one -- compatible with MySQL -- or should I instead be backing up with FLUSH and (or) mysqldump? Any

Re: Backup Question.

2001-12-31 Thread David J Jackson
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

Backup question

2001-09-10 Thread Kraa de Simon
Hi, I'm running MySQL on a NT box and do a nightly backup of the complete file system to tape. I know I should use mysqldump and probably stop MySQL but will a file system copy do as well? The system is inactive at the time. Met vriendelijke groet / With kind regards, ICL Nederland B.V.

RE: Backup question

2001-09-10 Thread SidY
Database Administrator -Original Message- From: Kraa de Simon [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 5:47 PM To: '[EMAIL PROTECTED]' Subject: Backup question Hi, I'm running MySQL on a NT box and do a nightly backup of the complete file system to tape. I

Newbie Backup Question

2001-06-12 Thread Philip Mak
I'm trying to write a cron job to back up my databases. The manual says: Do a full backup of your databases: shell mysqldump --tab=/path/to/some/dir --opt --full You can also simply copy all table files (`*.frm', `*.MYD' and`*.MYI' files), as long as the server isn't updating anything.The

backup question

2001-01-15 Thread sanaa
hi I want to know how to backup and restore databases in mysql. thanks for help - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

backup question

2001-01-15 Thread sanaa
hi i have a problem and i hope somebody can help me. I use mysql-2.23.25 ( for windows). I have my database in (c:) and i want to backup it in (d:) . thanks and regards - Before posting, please check: