phpMyAdmin = Grrr...

So here I am running PerlBill. I decide I need a fresh install of the PerlBill files. I BACKUP the database in phpMyAdmin by exporting a schema of structure AND data and had this all saved as a file.

So I reinstall PerlBill and everything is fine and dandy until I try to restore the MySQL backup created by phpMyAdmin. I get the following error on the first table in the document:

Code: 
Error

SQL-query :  

CREATE TABLE announce(

id smallint( 5 ) unsigned NOT NULL auto_increment,
author varchar( 255 ) default NULL ,
subject varchar( 255 ) default NULL ,
message text,
staff char( 1 ) default NULL ,
users char( 1 ) default NULL ,
time varchar( 16 ) default NULL ,
GROUP varchar( 255 ) default NULL ,
attachment_file varchar( 255 ) default NULL ,
PRIMARY KEY ( id ) 
) TYPE = MYISAM 

MySQL said: 


You have an error in your SQL syntax.  Check the manual that 
corresponds to your MySQL server version for the right syntax to
 use near 'group varchar(255) default NULL,
  attachment_file varchar(255
With a little fiddling, I see that EVERY CREATE TABLE in the .sql file returns with this error. So, tell me this: Why won't phpMyAdmin create a database from a file it created itself?

My biggest problem is the fact that some slightly important information is in that database, not anything drastic, just important.

EDIT: I realised, after a kind WHT member showed me, that I had forgotten to select extended/complete inserts. Now I suppose the question is, does anyone know of a parser or of a process that will allow me to restore the data?

Thanks,
Bret

 

 

 

 

Top