On Tue, 2 Sep 2003 17:02:37 +0530 (IST)
Uma Shankari T. [EMAIL PROTECTED] wrote:
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..
what exactly does it say ?
---
WBR,
Antony Dovgal aka tony2001
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
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
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
try to export the database once again , using the command
mysqldump database-name file.sql .
then try importing the same using
mysql database-name file.sql .(delete all the backups before trying this)
by the way , are you trying to export/import between diff versions of mysql / or
between diff
02, 2003 8:29 AM
Subject: RE: Abt Mysqldump
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
PROTECTED]
Subject: Re: Abt Mysqldump
Matthew (UK),
I have two questions regarding this:
1. are you using the tick that is under the ~ sign on US keyboards, or the '
which is under the quotes on US keyboards?
I tried both and get an error executing the following query in mysql client
gui screen