Need Mysql assistance

[nicedomain4sale]

Please help me. I try to restore backup from phpmyAdmin. But this error happened.

My version:
PHP version 4.3.10
MySQL version 4.0.24-standard

SQL-query:

 CREATE TABLE `ibf_admin_logs` (
`id` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`act` varchar( 255 ) default NULL ,
`code` varchar( 255 ) default NULL ,
`member_id` int( 10 ) default NULL ,
`ctime` int( 10 ) default NULL ,
`note` text,
`ip_address` varchar( 255 ) default NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL said: Documentation
#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 'DEFAULT CHARSET=latin1' at line 10

 

[eagle12]

remove all instances of:

DEFAULT CHARSET = latin1

It looks like the version of MySQL you are running doesn't support it. If you remove the above line, you should be able to run it without problem.

 

[nicedomain4sale]

Thanks.
It fixed now.