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 systems of same version. "Uma Shankari T." wrote: > MS> > MS> > MS>use > MS>mysql database-name < backupfilename > MS>I think , the backup file name should have .sql extension , like backup.sql > MS> > MS>"Hoeven, Maarten van der" wrote: > MS> > > i have dumped the another 2 database contents with the text file > extension..even before i have done this many times but now it is giving > error..is there any other possibility to correct this ?? > > Regards, > Uma -- Vidhya CS .