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 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 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.. > > Regards, > Uma > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -------------------------------------------------------------- > Zie ook/see also: http://www.knmi.nl/maildisclaimer.html > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > . -- Vidhya CS .