|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: A question about mysql database backup.
From: Adam Hardy (adam.sql
cyberspaceroad.org)
Date: Fri Feb 27 2004 - 11:38:51 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 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...
>
Are back-ticks actually part of ANSI SQL?
Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]