Probleme beim Import von dump.sql
Verfasst: 30.01.2003 19:17
Hi, nachdem ich versucht habe über das Webinterface von PHPMyAdmin bei Hosteurope meine dump.sql hochzuladen, kommt folgende Fehlermeldung.
Ich habe die dump.sql folgendermaßen erstellt
mysqldump.exe -a Name > dump.sql
wo liegt der Fehler?
Datenbank filewave_org auf localhost
Fehler
SQL-Befehl :
* - * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - * - * - 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 )
) TYPE = MyISAM
MySQL meldet:
You have an error in your SQL syntax near '---------------------------------------------------------
--
--
CREATE TABL' at line 2
Ich habe die dump.sql folgendermaßen erstellt
mysqldump.exe -a Name > dump.sql
wo liegt der Fehler?
Datenbank filewave_org auf localhost
Fehler
SQL-Befehl :
* - * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - * - * - 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 )
) TYPE = MyISAM
MySQL meldet:
You have an error in your SQL syntax near '---------------------------------------------------------
--
--
CREATE TABL' at line 2