DB import nicht möglich

[alex_d]

Hallo!

Erstmal vorneweg - ich habe bereits in die tutorials, docs und posts geschaut, war auch hilfreich- hat aber nicht zur Lösung begetragen...

Habe ein Board, will das nun auf einem neuen hosting paket wieder installieren, board files sind da board vers. 2.0.11 läuft auch aber das
back up von der alten db ist einfach nicht einspielbar weder via board:
meldung = keine daten oder leere datei oder so
von phpmyadmin kommt:

CREATE TABLE phpbb_topics(

topic_id mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
forum_id smallint( 8 ) unsigned NOT NULL default '0',
topic_title char( 60 ) NOT NULL default '',
topic_poster mediumint( 8 ) NOT NULL default '0',
topic_time int( 11 ) NOT NULL default '0',
topic_views mediumint( 8 ) unsigned NOT NULL default '0',
topic_replies mediumint( 8 ) unsigned NOT NULL default '0',
topic_status tinyint( 3 ) NOT NULL default '0',
topic_vote tinyint( 1 ) NOT NULL default '0',
topic_type tinyint( 3 ) NOT NULL default '0',
topic_first_post_id mediumint( 8 ) unsigned NOT NULL default '0',
topic_last_post_id mediumint( 8 ) unsigned NOT NULL default '0',
topic_moved_id mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( topic_id ) ,
KEY forum_id( forum_id ) ,
KEY topic_moved_id( topic_moved_id ) ,
KEY topic_status( topic_status ) ,
KEY topic_type( topic_type )
)ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL meldet:


#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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 20


Von bigdump:

Error at the line 37: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Query: CREATE TABLE phpbb_auth_access ( group_id mediumint(8) NOT NULL default '0',
forum_id smallint(5) unsigned NOT NULL default '0', auth_view tinyint(1) NOT NULL default '0',
auth_read tinyint(1) NOT NULL default '0', auth_post tinyint(1) NOT NULL default '0',
auth_reply tinyint(1) NOT NULL default '0', auth_edit tinyint(1) NOT NULL default '0',
auth_delete tinyint(1) NOT NULL default '0', auth_sticky tinyint(1) NOT NULL default '0',
auth_announce tinyint(1) NOT NULL default '0', auth_vote tinyint(1) NOT NULL default '0',
auth_pollcreate tinyint(1) NOT NULL default '0', auth_attachments tinyint(1) NOT NULL default
'0', auth_mod tinyint(1) NOT NULL default '0', KEY group_id (group_id),
KEY forum_id (forum_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

MySQL: 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 18

Stopped on error

Hat irgendjemand eine Idee was man noch machen könnte?
Die db sollte sich doch irgendwie updaten lassen, oder?

Alex