MyBB Community Forums

When I'll restore my backup file (from MyBB 1.22), phpMyAdmin show error as below.

Error

SQL-query :  

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 ''
)ENGINE = MYISAM DEFAULTCHARSET = latin1 

MySQL said: 


You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 8

and the first part (data from backup file) of these error as below.

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 ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO mybb_adminlog (uid,dateline,scriptname,action,querystring,ipaddress) VALUES ('1','1162744755','index.php','home','','203.113.81.9');

I don't know what is it wrong? and how I restore it to my phpMyAdmin data base?

Thank you.

Try this:

Change

DEFAULTCHARSET = latin1

to

CHARSET = latin1