Fred, Thanks for your quick response!
Do you mean that only one step is enough for a backup "mysqldump -F --opt --quote-names database_name > database_name.backup"? The second step is not needed at all. Am I right? I added the option "-Q", it failed, but the "--quote-names" option works well. Maybe the version number is not high enough. Regards, Lenny Li ================================== LSS-MI Development, 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] > 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 whether the > following procedures are correct for database backup. > > 1. mysqldump -F --opt database_name > database_name.backup > > In my opinion, you should generally add the -Q option which > quotes table > and row names. Otherwise, restoring data can be really hard in case of > perhaps only one "complicated" row name... > > Regards, > Fred > > > -- > Condense soup, not books! > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]