RE: Abt Mysqldump

2003-09-02 Thread Matthew Smith
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

Re: Abt Mysqldump

2003-09-02 Thread Albert
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

Re: Abt Mysqldump

2003-09-02 Thread Vidhya CS
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

RE: Abt Mysqldump

2003-09-02 Thread Matthew Smith
-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

Re: Abt Mysqldump

2003-09-02 Thread Vidhya CS
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:

RE: Abt Mysqldump

2003-09-02 Thread Hoeven, Maarten van der
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

Re: Abt Mysqldump

2003-09-02 Thread Antony Dovgal
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

Abt Mysqldump

2003-09-02 Thread Uma Shankari T.
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