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

RE: Abt Mysqldump

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

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