Suche

[rmxdesignz]

hallo ich habe einen datenbank-backup gemacht, um es auf einem anderen server zu importieren... beim hochladen der sql datei kommt immer dieser fehler...

Code Auswählen Erweitern

Fehler
SQL-Befehl:

CREATE TABLE `mx69541_authors` (

`aid` varchar( 25 ) COLLATE latin1_german2_ci NOT NULL default '',
`name` varchar( 50 ) COLLATE latin1_german2_ci NOT NULL default '',
`url` varchar( 255 ) COLLATE latin1_german2_ci NOT NULL default '',
`email` varchar( 100 ) COLLATE latin1_german2_ci NOT NULL default '',
`pwd` varchar( 40 ) COLLATE latin1_german2_ci NOT NULL default '',
`counter` int( 11 ) NOT NULL default '0',
`radminarticle` tinyint( 2 ) NOT NULL default '0',
`radmintopic` tinyint( 2 ) NOT NULL default '0',
`radminuser` tinyint( 2 ) NOT NULL default '0',
`radminsurvey` tinyint( 2 ) NOT NULL default '0',
`radminsection` tinyint( 2 ) NOT NULL default '0',
`radminlink` tinyint( 2 ) NOT NULL default '0',
`radminephem` tinyint( 2 ) NOT NULL default '0',
`radminfaq` tinyint( 2 ) NOT NULL default '0',
`radmindownload` tinyint( 2 ) NOT NULL default '0',
`radminreviews` tinyint( 2 ) NOT NULL default '0',
`radminnewsletter` tinyint( 2 ) NOT NULL default '0',
`radminforum` tinyint( 2 ) NOT NULL default '0',
`radmincontent` tinyint( 2 ) NOT NULL default '0',
`radminency` tinyint( 2 ) NOT NULL default '0',
`radminsuper` tinyint( 2 ) NOT NULL default '1',
`admlanguage` varchar( 30 ) COLLATE latin1_german2_ci NOT NULL default '',
`radmingroups` tinyint( 2 ) NOT NULL default '0',
`radmincalendar` tinyint( 2 ) NOT NULL default '0',
`user_uid` int( 11 ) unsigned default NULL ,
PRIMARY KEY ( `aid` ) ,
KEY `user_uid` ( `user_uid` ) ,
KEY `name` ( `name` ) ,
KEY `radminarticle` ( `radminarticle` ) ,
KEY `radmintopic` ( `radmintopic` ) ,
KEY `radminuser` ( `radminuser` ) ,
KEY `radminsurvey` ( `radminsurvey` ) ,
KEY `radminsection` ( `radminsection` ) ,
KEY `radminlink` ( `radminlink` ) ,
KEY `radminephem` ( `radminephem` ) ,
KEY `radminfaq` ( `radminfaq` ) ,
KEY `radmindownload` ( `radmindownload` ) ,
KEY `radminreviews` ( `radminreviews` ) ,
KEY `radminnewsletter` ( `radminnewsletter` ) ,
KEY `radminforum` ( `radminforum` ) ,
KEY `radmincontent` ( `radmincontent` ) ,
KEY `radminency` ( `radminency` ) ,
KEY `radminsuper` ( `radminsuper` ) ,
KEY `admlanguage` ( `admlanguage` ) ,
KEY `radmingroups` ( `radmingroups` ) ,
KEY `radmincalendar` ( `radmincalendar` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_german2_ci;



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 'collate latin1_german2_ci NOT NULL default '',
  `name` varchar

was soll ich tun..?! Bitte helft mir

[jubilee]

schmeiss einmal die default'' raus (alle)

MfG