Is it possible to dump sql file with phpmyadmin?

Previous topic

Install & configuration

Next topic

Author	Message
Antonio calvi	Thursday 17 April 2003 10:43:32 am I get this messge: Errore query SQL : -- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * -- -- -- CREATE TABLE ezapprove_items( id int( 11 ) NOT NULL auto_increment, workflow_process_id int( 11 ) NOT NULL default '0', collaboration_id int( 11 ) NOT NULL default '0', PRIMARY KEY ( id ) ) TYPE = MYISAM Messaggio di MySQL: You have an error in your SQL syntax near '--------------------------------------------------------- -- -- CREATE TABLE ez' at line 2
mikael lindqvist	Thursday 17 April 2003 10:55:08 am I had the same problem and the cause of this mess has to do with the comment style in your sql file. Replace all "--" with "#" (the latter is the older form of comment style in MySQL). Good luck!

Author

Message

Antonio calvi

Thursday 17 April 2003 10:43:32 am

I get this messge:

Errore

query SQL :

--
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * --
--
--
CREATE TABLE ezapprove_items(
id int( 11 ) NOT NULL auto_increment,
workflow_process_id int( 11 ) NOT NULL default '0',
collaboration_id int( 11 ) NOT NULL default '0',
PRIMARY KEY ( id )
) TYPE = MYISAM

Messaggio di MySQL:

You have an error in your SQL syntax near '---------------------------------------------------------
--
--

CREATE TABLE ez' at line 2

mikael lindqvist

Thursday 17 April 2003 10:55:08 am

I had the same problem and the cause of this mess has to do with the comment style in your sql file.

Replace all "--" with "#" (the latter is the older form of comment style in MySQL).

Good luck!