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..
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
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
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
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