RE: A question about mysql database backup.

2004-02-27 Thread Li, Lenny Yong Bo (Lenny)
[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] Subject: Re: A question about mysql

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