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

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 tony2001

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 some

Re: Abt Mysqldump

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

RE: Abt Mysqldump

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

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

RE: Abt Mysqldump

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