Error #1064 While Importing Database On Mysql 5.5

[seintitus]

I am getting an error while trying to import database on mysql 5.5. Here is the error:

 

 

Error

 

SQL query:

CREATE TABLE `dp_banks` (

`id`

INT

(

11

)

NOT

NULL

AUTO_INCREMENT

,

`owner`

INT

(

11

)

NOT

NULL

DEFAULT

'0'

,

`bname`

VARCHAR

(

128

)

NOT

NULL

DEFAULT

''

,

`baddress`

VARCHAR

(

128

)

NOT

NULL

DEFAULT

''

,

`bcity`

VARCHAR

(

64

)

NOT

NULL

DEFAULT

''

,

`bzip`

VARCHAR

(

16

)

NOT

NULL

DEFAULT

''

,

`bcountry`

CHAR

(

2

)

NOT

NULL

DEFAULT

''

,

`bstate`

VARCHAR

(

32

)

NOT

NULL

DEFAULT

''

,

`bphone`

VARCHAR

(

32

)

NOT

NULL

DEFAULT

''

,

`bnameacc`

VARCHAR

(

128

)

NOT

NULL

DEFAULT

''

,

`baccount`

VARCHAR

(

32

)

NOT

NULL

DEFAULT

''

,

`btype`

CHAR

(

2

)

NOT

NULL

DEFAULT

''

,

`brtgnum`

VARCHAR

(

9

)

NOT

NULL

DEFAULT

''

,

`bswift`

VARCHAR

(

32

)

NOT

NULL

DEFAULT

''

,

`status`

TINYINT

(

1

)

NOT

NULL

DEFAULT

'0'

,

`default`

TINYINT

(

1

)

NOT

NULL

DEFAULT

'0'

,

PRIMARY

KEY

(

`id`

)

) TYPE = MYISAM AUTO_INCREMENT =1;

 

 

 

MySQL said: #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 'TYPE=MyISAM AUTO_INCREMENT=1' at line 19

[schimpfk]

On the line #19 type:

TYPE=MyISAM AUTO_INCREMENT

[Ice IT Support]

It should be ENGINE, and the DEFAULT CHARSET should also be defined:

ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;