phpmyadmin error 1064

[Leandro17]

when I try to import the db with new phpmyadmin, it leaves me the following error...

CREATE TABLE mybb_adminlog (
uid int( 10 ) unsigned NOT NULL default '0',
dateline bigint( 30 ) NOT NULL default '0',
scriptname varchar( 50 ) NOT NULL default '',
action varchar( 50 ) NOT NULL default '',
querystring varchar( 150 ) NOT NULL default '',
ipaddress varchar( 50 ) NOT NULL default '',
KEY scriptname ( scriptname , action )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL ha dicho: Documentación
#1064 - 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 mybb_adminlog (
uid ' at line 1

I use mybb 1.2.2 in a server with php 5.2.5 and MySQL 4.1.22
and I want to transfer it to a server with php 5.2.5 and mysql 5.0.67-community

[Tomm M]

Try removing ENGINE = MYISAM DEFAULT CHARSET = latin1. Remember, there may be more than one instance of this in your file, so try and remove them all.

You should upgrade to 1.2.14 as soon as possible to benefit from the latest security patches and features. You can get the download from http://mybboard.net/download/71/zip, and then follow the update procedures that aren't in the download package here:

1.2 Fix 1
1.2 Fix 2
1.2 Fix 3
1.2 Fix 4

1.2.2 is almost 2 years old, and even 1.2.14 won't be supported shortly. For the benefit of you and your users you really should upgrade, and you should also consider upgrading to 1.4 too...

[Leandro17]

Try removing ENGINE = MYISAM DEFAULT CHARSET = latin1. Remember, there may be more than one instance of this in your file, so try and remove them all.

I have erased it and it leaves me the same error

Error

consulta SQL:

-- MyBB Database Backup
-- Generated: 29th November 2008 at 15:38
------------------------------------- --
CREATE TABLE mybb_adminlog (
uid int( 10 ) unsigned NOT NULL default '0',
dateline bigint( 30 ) NOT NULL default '0',
scriptname varchar( 50 ) NOT NULL default '',
action varchar( 50 ) NOT NULL default '',
querystring varchar( 150 ) NOT NULL default '',
ipaddress varchar( 50 ) NOT NULL default '',
KEY scriptname ( scriptname , action )
);

MySQL ha dicho: Documentación
#1064 - 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 mybb_adminlog (
`ui' at line 1

[Tomm M]

I'm not too sure... the only other thing I can think of is to remove

-- MyBB Database Backup
-- Generated: 29th November 2008 at 15:38
------------------------------------- --

[Matt]

I suggest you make a fresh backup and try again.

[Leandro17]

thanks, I have already solved it importing the backup with Sypex Dumper

now I will try to upgrade the forum