4:04
To: [EMAIL 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 i
ED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 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 fre
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
-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
xist? 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:
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 s
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 tony2
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..
R