mysqldump error

[Anon]

Hi;

I've made a mysqldump of a database on one server, and I'm trying to import it into a new server,

but when I mysql database < file.sql,

it tells me there's an error in the dumpfile.. seems to be a parse error or something.

any ideas?

[Anon]

mysqldump -u user_name -p database_name < file.sql

[[deleted]]

What's the exact error?

[Anon]

ERROR 1064 at line 11: You have an error in your SQL syntax near 'in tinyint(4) NOT NULL default '0',
out tinyint(4) NOT NULL default '0',
des' at line 6

it seems to be a parse error or something, but i don' understand why mysqldump would create a parse error 😕

thanks for the help,
jay

[[deleted]]

can you post the first ten lines of the dump?

[Anon]

Here's the section that's getting the error, though the others are just like it.

#

Table structure for table affils

#

CREATE TABLE affils (
id tinyint(4) NOT NULL auto_increment,
name tinytext NOT NULL,
filename tinytext NOT NULL,
url tinytext NOT NULL,
in tinyint(4) NOT NULL default '0',
out tinyint(4) NOT NULL default '0',
description text NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) TYPE=MyISAM COMMENT='this is the affiliates table';

[Anon]

Seems I have fixed the problem.

That table wasn't supposed to be there anyways as it was only a test i was playing around with that i forgot to delete =)

i deleted the table, and it works fine now 🙂

sorry for the trouble lol eek!
jay