errors while adding dump file..

[admin]

Hi there,

I have a problem with a dump file a friend created for me. When I want to add it to my table in mysql, I get the following error :


ERROR 1064 at line 1: You have an error in your SQL syntax near 'Database dmdb2000
CREATE TABLE genre (
_rowid int(10) unsigned DEFAULT '0' NO' at line 1


This is the part in the dump file where it gives the error:

# --------------------------------------------------------
#
# Table structure for table 'genre'
#

CREATE TABLE genre (
_rowid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
name varchar(31) NOT NULL,
PRIMARY KEY (_rowid),
KEY g (name)
);

It's a dump of a working Database, unfortunatly it doensn't exist anymore, so I have to do it whit this dump-file.

Any help is welcome..

Thnxx in advance,

Psy