RE: A question about mysql database backup.

2004-02-27 Thread Li, Lenny Yong Bo (Lenny)
database backup. Li, Lenny Yong Bo (Lenny) wrote: Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure whether the following procedures are correct for database backup. 1. mysqldump -F --opt database_name database_name.backup In my

Re: A question about mysql database backup.

2004-02-27 Thread Scott Haneda
on 02/27/2004 12:11 AM, Li, Lenny Yong Bo (Lenny) at [EMAIL PROTECTED] wrote: 1. database backup. This is done on the standby one with the following command. mysqldump --opt --quote-names --flush-logs database_name database.backup How does this operations handle binary fields, password

Re: A question about mysql database backup.

2004-02-27 Thread Adam Hardy
On 02/25/2004 09:13 AM Frederic Wenzel wrote: Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure whether the following procedures are correct for database backup. 1. mysqldump -F --opt database_name database_name.backup In my opinion, you

Re: A question about mysql database backup.

2004-02-25 Thread Frederic Wenzel
Li, Lenny Yong Bo (Lenny) wrote: Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure whether the following procedures are correct for database backup. 1. mysqldump -F --opt database_name database_name.backup In my opinion, you should

RE: A question about mysql database backup.

2004-02-25 Thread Li, Lenny Yong Bo (Lenny)
] Sent: Wednesday, February 25, 2004 4:13 PM To: Li, Lenny Yong Bo (Lenny) Cc: [EMAIL PROTECTED] Subject: Re: A question about mysql database backup. Li, Lenny Yong Bo (Lenny) wrote: Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure

A question about mysql database backup.

2004-02-24 Thread Li, Lenny Yong Bo (Lenny)
Ms./Sir, Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure whether the following procedures are correct for database backup. 1. mysqldump -F --opt database_name database_name.backup 2. stop mysqld if is running. Then start it with --log-bin

RE: MYSQL DATABASE BACKUP

2002-03-20 Thread Simon Green
but would mean a second copy of MySQL but you would only need a low spec system.. I hope this helps... Simon -Original Message- From: Kathy Reyes [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 21:37 To: mysql Subject: MYSQL DATABASE BACKUP I am trying to backup a table in mysql without

MYSQL DATABASE BACKUP

2002-03-19 Thread Kathy Reyes
I am trying to backup a table in mysql without locking my tables it this posible - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

RE: MYSQL DATABASE BACKUP

2002-03-19 Thread Barry L. Jeung
PROTECTED]] Sent: Tuesday, March 19, 2002 1:37 PM To: mysql Subject: MYSQL DATABASE BACKUP I am trying to backup a table in mysql without locking my tables it this posible - Before posting, please check: http://www.mysql.com

Re: MYSQL DATABASE BACKUP

2002-03-19 Thread Lars Heidieker
not quite sure what you mean by locking. each table will be locked during readout for the dump automaticly for the time the select runs and delivers data to the dumping program. it is not needed to lock the tables (more than one) in advance for a dump, but that, might better for dataintegrety.

mysql database backup issue

2001-03-22 Thread Saulius Gurklys
Hello, could anyone explain me how to backup and in case of system crash restore the mysql database (main database where data about other databases, grants,users, etc. is kept)? Thanks in advance ! Regards, Saulius Gurklys mailto:[EMAIL PROTECTED]