Error trying to import a database

[Graham Walters]

I'm getting an error when using in Impex to import a database, I've read through the other posts and the problem has cropped up before, but the solution given is not appropriate to the problem I', having.
I've submitted a support ticket but haven't had a reply in about 12 hours.

When I try to import via the ACP or directly I get the following error :

ImpEx Database error

mysql error: Invalid SQL: CREATE TABLE impexerror (
                        errorid bigint(20) unsigned NOT NULL auto_increment,
                        errortype varchar(10) NOT NULL default '',
                        classnumber varchar(3) NOT NULL default '',
                        importid bigint(20) NOT NULL default 0,
                        error varchar(250) default 'NULL',
                        remedy varchar(250) default 'NULL',
                        PRIMARY KEY (errorid)
                    ) TYPE=MyISAM

mysql error: 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 'TYPE=MyISAM' at line 9

mysql error number: 1064

Date: Wednesday 13th 2013f November 2013 11:03:22 AM
Database: footbal9_football
MySQL error: 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 'TYPE=MyISAM' at line 9

I also get an error in the Primary tables ( accessmasks) if I try to import via phpmyadmin

[Lynne]

Edit your /impex/index.php file and about halfway down is this line:

                      ) TYPE=MyISAM

change it to:

                      ) ENGINE=MyISAM

[Graham Walters]

That has cured the one problem, but I now get this error when I try to connect :

ImpEx Database error

mysql error: Link-ID == false, connect failed

mysql error:

Date: Thursday 14th 2013f November 2013 04:16:04 PM
Database: talkofth_vb
MySQL error:

[z435sdr34DarknQuiet]

I changed it to and it fixed the first problem now I am getting the same error as Graham

ImpEx Database error mysql error: Link-ID == false, connect failed mysql error: Date: Thursday 14th 2013f November 2013 04:16:04 PM Database: talkofth_vb MySQL error: