Forum Moderators: open
----------------------------------------------------------
BigDump: Staggered MySQL Dump Importer v0.28b
Processing file: gallery2.sql
Starting from line: 1
Error at the line 19: ) TYPE=MyISAM;
Query: --
---------------------------------------------------------
--
--
CREATE TABLE g2_AccessMap (
g_accessListId int(11) NOT NULL default '0',
g_permission int(11) NOT NULL default '0',
g_userOrGroupId int(11) NOT NULL default '0',
PRIMARY KEY (g_accessListId,g_userOrGroupId),
KEY g2_AccessMap_83732 (g_accessListId),
KEY g2_AccessMap_18058 (g_permission),
KEY g2_AccessMap_48775 (g_userOrGroupId)
) TYPE=MyISAM;
MySQL: 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 '--------------------------------------------------------- -- -- CREATE TABLE g2_' at line 2
Stopped on error
----------------------------------------------------------------
If anyone has any idea what I need to do here, please let me know, I was using mysql 4 and am importing this sql file to mysql 5. I can create the database in v 4 if that is easiest.
Kurt
I am not 100% sure this will help, one of the clever guys will correct me if I am wrong, have you tried
ENGINE=MyISAM;
A week ago I was trying to import a PHP5 db onto an old server and thats all I needed to change.
Error at the line 19: ) ENGINE=MyISAM;
Query: --
---------------------------------------------------------
--
--
CREATE TABLE g2_AccessMap (
g_accessListId int(11) NOT NULL default '0',
g_permission int(11) NOT NULL default '0',
g_userOrGroupId int(11) NOT NULL default '0',
PRIMARY KEY (g_accessListId,g_userOrGroupId),
KEY g2_AccessMap_83732 (g_accessListId),
KEY g2_AccessMap_18058 (g_permission),
KEY g2_AccessMap_48775 (g_userOrGroupId)
) ENGINE=MyISAM;
MySQL: 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 '--------------------------------------------------------- -- -- CREATE TABLE g2_' at line 2
-------------------------------------------------------------------
Any other ideas?
Kurt
Someone else should be able to help, it must be a known issue.
wheelie34:
i think ibmkillr was referring to mysql 4 vs 5, not php 4 vs 5...
