MySql Syntax Error

Twysted

this the error i get when trying to import my sql dump into my database.

#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 attacks2 (
id int(10) unsigned NOT NULL,
attack_name' at line 1

this is the table

CREATE TABLE `attacks2` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `attack_name` varchar(16) NOT NULL default '',
  `do_what` varchar(16) NOT NULL default '',
  `magic_number` int(11) NOT NULL default '0',
  `learned_by` text NOT NULL,
  `learn_at_level` int(11) NOT NULL default '0',
  `game` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5408;

my mysql version is: MySQL - 5.0.24-standard

my mysql dumps version: MySQL - 4.1.19

NogDog

It looks like maybe the SQL file was not saved as a plain ASCII text file?

Twysted

it waas saved as sql file

mjax

Still, it doesn't look like ASCII, more like UTF-8. Try saving it as ASCII using a decent text editor, like UltraEdit or TextPad.

Twysted

ok i will see if that helps

Twysted

so save as ansi?

Twysted

i get a new error now

 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 '
  `do_what` varchar(16) NOT NULL default,
  `magic_number` int(11) NOT NULL d' at line 3

mjax

Can you show us the SQL?

Twysted

yeah here it is

it is attached

mjax

The fieldnames should be quoted using backticks instead of regular quotes (or you could use no quotes at all around the fieldname if you are using normal names).

Twysted

ok ty