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 shou

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 Li, Lenny Yong Bo (Lenny)
t, R&D, Lucent Qingdao [EMAIL PROTECTED] 86-532-8702000-5033 http://gdcsr60.gdc.lucent.com/~lennyli > -Original Message- > From: Frederic Wenzel [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 25, 2004 4:13 PM > To: Li, Lenny Yong Bo (Lenny) > Cc: [EMAIL PROTECTED

RE: A question about mysql database backup.

2004-02-25 Thread Li, Lenny Yong Bo (Lenny)
- > From: Frederic Wenzel [mailto:[EMAIL PROTECTED] > 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

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 gen