MySQL BigDump.php

[ibmkillr]

Ok so I a found the BigDump script to get my 6mb sql file onto my new host. My new host is godaddy and they only allow 2mb files to be sent up in myphpadmin. So I figured I would try bigdump. I ssh'd to my old server, mysqldump my current gallery2 database and am now trying to put it into godaddy. Here is the error I am getting:

----------------------------------------------------------
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

[wheelie34]

Hi Kurt and welcome to webmasterworld

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.

[ibmkillr]

Thank you for the suggestion. Unfortunatly I am still getting the error at line 19 with the changes.

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

[wheelie34]

No sorry, just for the record though, I tried your code on a PHP4 server and it worked fine, I don't have access to PHP5

Someone else should be able to help, it must be a known issue.

[phranque]

welcome to WebmasterWorld, ibmkillr!
(long time lurker!)

wheelie34:
i think ibmkillr was referring to mysql 4 vs 5, not php 4 vs 5...