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]
