Hi
The only problem I get with mysqldump is that if I have used a reserved word
as a column name, then the create starement fails.
(eg
CREATE TABLE fred (
KEY int(10) not null default '0'
);
will fail (but as produced by mysqldump)
However, if you edit the file and put ` characters either side of the column
name (ie KEY above) then it then works.
You can sort this in the first instance if you use the '--quote-names' or
'-Q' option to mysqldump
(OK, so I've just read the man page for the first time as well)
Regards
Matthew
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 02 September 2003 18:39
To: [EMAIL PROTECTED]
Subject: Re: Abt Mysqldump
use
mysql database-name < backupfilename
I think , the backup file name should have .sql extension , like backup.sql
"Hoeven, Maarten van der" wrote:
> What are the errors?
>
> For example, is the error like unable to create the tables, because the
> tables still exist? See the dumpfile if tables are created (by default).
> If so, delete the tables first, and redump back the dumpfile.
>
> -----Original Message-----
> From: Uma Shankari T. [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 02, 2003 1:33 PM
> To: [EMAIL PROTECTED]
> Subject: Abt Mysqldump
>
> Hello,
>
> I have dumped the database contents as one txt file by using this
> command
>
> mysqldump databasename -uusername -ppasswd > textfilename.
>
> but while redumping back to mysql it is giving some errors in the
> textfile..is there any possibility to redump the contents without any
> error..
>
> Regards,
> Uma
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> --------------------------------------------------------------
> Zie ook/see also: http://www.knmi.nl/maildisclaimer.html
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
> .
--
Vidhya CS
.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
