Overførsel af database

CHARSET=latin1 er vist kun til nyere MySQL-versioner - Prøv at fjerne disse og se om serveren ikke sluger den...

Jeg har nu prøvet dit forslag, og det har virket delvist - nu står jeg så bare med en ny fejl, der lyder som følger:

SQL-forespørgsel :

CREATE TABLE IF NOT EXISTS fusion_admin(
admin_id tinyint( 2 ) unsigned NOT NULL AUTO_INCREMENT ,
admin_rights char( 2 ) NOT NULL default '',
admin_image varchar( 50 ) NOT NULL default '',
admin_title varchar( 50 ) NOT NULL default '',
admin_link varchar( 100 ) NOT NULL default 'reserved',
admin_page tinyint( 1 ) unsigned NOT NULL default '1',
PRIMARY KEY ( admin_id )
)ENGINE = MYISAM INSERT INTO fusion_admin( admin_id, admin_rights, admin_image, admin_title, admin_link, admin_page )
VALUES ( 1, 'AD', 'admins.gif', 'Administratorer', 'administrators.php', 2 ) , ( 2, 'AC', 'article_cats.gif', 'Artikelkategorier', 'article_cats.php', 1 ) , ( 3, 'A', 'articles.gif', 'Artikler', 'articles.php', 1 ) , ( 4, 'B', 'blacklist.gif', 'Udelukkelse', 'blacklist.php', 2 ) , ( 5, 'C', '', 'Comments', 'reserved', 2 ) , ( 6, 'CP', 'c-pages.gif', 'Brugeroprettede sider', 'custom_pages.php', 1 ) , ( 7, 'DB', 'db_backup.gif', 'Sikkerhedskopiering', 'db_backup.php', 3 ) , ( 8, 'DC', 'dl_cats.gif', 'Downloadkategorier', 'download_cats.php', 1 ) , ( 9, 'D', 'dl.gif', 'Downloads', 'downloads.php', 1 ) , ( 10, 'FQ', 'faq.gif', 'FAQs', 'faq.php', 1 ) , ( 11, 'F', 'forums.gif', 'Debat', 'forums.php', 1 ) , ( 12, 'IM', 'images.gif', 'Billeder', 'images.php', 1 ) , ( 13, 'I', 'infusions.gif', 'Infusioner', 'infusions.php', 3 ) , ( 14, 'IP', '', 'Infusion Panels', 'reserved', 3 ) , ( 15, 'M', 'members.gif', 'Brugere', 'members.php', 2 ) , ( 16, 'N', 'news.gif', 'Nyheder', 'news.php', 1 ) , ( 17, 'P', 'panels.gif', 'Elementadministration', 'panels.php', 3 ) , ( 18, 'PH', 'photoalbums.gif', 'Fotoalbums', 'photoalbums.php', 1 ) , ( 19, 'PI', 'phpinfo.gif', 'PHP Info', 'phpinfo.php', 3 ) , ( 20, 'PO', 'polls.gif', 'Afstemninger', 'polls.php', 1 ) , ( 21, 'S', 'shout.gif', 'Replikboks', 'shoutbox.php', 2 ) , ( 22, 'SL', 'site_links.gif', 'Interne links', 'site_links.php', 3 ) , ( 23, 'SU', 'submissions.gif', 'Brugerforslag', 'submissions.php', 2 ) , ( 24, 'U', 'upgrade.gif', 'Opgradering', 'upgrade.php', 3 ) , ( 25, 'UG', 'user_groups.gif', 'Brugergrupper', 'user_groups.php', 2 ) , ( 26, 'WC', 'wl_cats.gif', 'Linkkategorier', 'weblink_cats.php', 1 ) , ( 27, 'W', 'wl.gif', 'Links', 'weblinks.php', 1 ) , ( 28, 'S1', 'settings.gif', 'Hovedindstillinger', 'settings_main.php', 3 ) , ( 29, 'S2', 'settings_time.gif', 'Dato og klokkeslæt', 'settings_time.php', 3 ) , ( 30, 'S3', 'settings_forum.gif', 'Debatindstillinger', 'settings_forum.php', 3 ) , ( 31, 'S4', 'registration.gif', 'Tilmeldingsindstillinger', 'settings_registration.php', 3 ) , ( 32, 'S5', 'photoalbums.gif', 'Fotoalbum', 'settings_photo.php', 3 ) , ( 33, 'S6', 'settings_misc.gif', 'Diverse indstillinger', 'settings_misc.php', 3 ) , ( 34, 'S7', 'settings_pm.gif', 'Private beskeder', 'settings_messages.php', 3 ) , ( 36, 'IP', 'infusion_panel.gif', 'Kalender', '../infusions/calendar_panel/calendar.php', 4 ) , ( 47, 'IP', 'user_gold.gif', '', '../infusions/user_gold_panel/admin/index.php', 4 ) , ( 46, 'IP', 'arcade.gif', 'Arcade Spil', '../infusions/arcade/admin/index.php', 4 ) , ( 48, 'IP', 'infusion_panel.gif', 'Fusion Community', '../infusions/member_pages/members_admin.php', 4 ) , ( 39, 'IP', 'infusion_panel.gif', 'Forslag', '../infusions/suggestion_box/suggestion_box_admin.php', 4 ) , ( 40, 'NC', 'news_cats.gif', 'News Categories', 'news_cats.php', 1 ) , ( 41, 'IP', 'infusion_panel.gif', 'Forum Rang System', '../infusions/rank_system/rank_system.php', 4 )

MySQL returnerede:
#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 'INSERT INTO fusion_admin (admin_id, admin_rights, admin_image,

Jeg fatter bjælde af det, men håber at nogen kan bidrage med noget der løser problemet :)

Så langt så godt - tak coderdk!

Den skal vel bare deles op i to?

CREATE TABLE IF NOT EXISTS fusion_admin(
admin_id tinyint( 2 ) unsigned NOT NULL AUTO_INCREMENT ,
admin_rights char( 2 ) NOT NULL default '',
admin_image varchar( 50 ) NOT NULL default '',
admin_title varchar( 50 ) NOT NULL default '',
admin_link varchar( 100 ) NOT NULL default 'reserved',
admin_page tinyint( 1 ) unsigned NOT NULL default '1',
PRIMARY KEY ( admin_id )
)ENGINE = MYISAM;

INSERT INTO fusion_admin( admin_id, admin_rights, admin_image, admin_title, admin_link, admin_page )
VALUES ( 1, 'AD', 'admins.gif', 'Administratorer', 'administrators.php', 2 ) , ( 2, 'AC', 'article_cats.gif', 'Artikelkategorier', 'article_cats.php', 1 ) , ( 3, 'A', 'articles.gif', 'Artikler', 'articles.php', 1 ) , ( 4, 'B', 'blacklist.gif', 'Udelukkelse', 'blacklist.php', 2 ) , ( 5, 'C', '', 'Comments', 'reserved', 2 ) , ( 6, 'CP', 'c-pages.gif', 'Brugeroprettede sider', 'custom_pages.php', 1 ) , ( 7, 'DB', 'db_backup.gif', 'Sikkerhedskopiering', 'db_backup.php', 3 ) , ( 8, 'DC', 'dl_cats.gif', 'Downloadkategorier', 'download_cats.php', 1 ) , ( 9, 'D', 'dl.gif', 'Downloads', 'downloads.php', 1 ) , ( 10, 'FQ', 'faq.gif', 'FAQs', 'faq.php', 1 ) , ( 11, 'F', 'forums.gif', 'Debat', 'forums.php', 1 ) , ( 12, 'IM', 'images.gif', 'Billeder', 'images.php', 1 ) , ( 13, 'I', 'infusions.gif', 'Infusioner', 'infusions.php', 3 ) , ( 14, 'IP', '', 'Infusion Panels', 'reserved', 3 ) , ( 15, 'M', 'members.gif', 'Brugere', 'members.php', 2 ) , ( 16, 'N', 'news.gif', 'Nyheder', 'news.php', 1 ) , ( 17, 'P', 'panels.gif', 'Elementadministration', 'panels.php', 3 ) , ( 18, 'PH', 'photoalbums.gif', 'Fotoalbums', 'photoalbums.php', 1 ) , ( 19, 'PI', 'phpinfo.gif', 'PHP Info', 'phpinfo.php', 3 ) , ( 20, 'PO', 'polls.gif', 'Afstemninger', 'polls.php', 1 ) , ( 21, 'S', 'shout.gif', 'Replikboks', 'shoutbox.php', 2 ) , ( 22, 'SL', 'site_links.gif', 'Interne links', 'site_links.php', 3 ) , ( 23, 'SU', 'submissions.gif', 'Brugerforslag', 'submissions.php', 2 ) , ( 24, 'U', 'upgrade.gif', 'Opgradering', 'upgrade.php', 3 ) , ( 25, 'UG', 'user_groups.gif', 'Brugergrupper', 'user_groups.php', 2 ) , ( 26, 'WC', 'wl_cats.gif', 'Linkkategorier', 'weblink_cats.php', 1 ) , ( 27, 'W', 'wl.gif', 'Links', 'weblinks.php', 1 ) , ( 28, 'S1', 'settings.gif', 'Hovedindstillinger', 'settings_main.php', 3 ) , ( 29, 'S2', 'settings_time.gif', 'Dato og klokkeslæt', 'settings_time.php', 3 ) , ( 30, 'S3', 'settings_forum.gif', 'Debatindstillinger', 'settings_forum.php', 3 ) , ( 31, 'S4', 'registration.gif', 'Tilmeldingsindstillinger', 'settings_registration.php', 3 ) , ( 32, 'S5', 'photoalbums.gif', 'Fotoalbum', 'settings_photo.php', 3 ) , ( 33, 'S6', 'settings_misc.gif', 'Diverse indstillinger', 'settings_misc.php', 3 ) , ( 34, 'S7', 'settings_pm.gif', 'Private beskeder', 'settings_messages.php', 3 ) , ( 36, 'IP', 'infusion_panel.gif', 'Kalender', '../infusions/calendar_panel/calendar.php', 4 ) , ( 47, 'IP', 'user_gold.gif', '', '../infusions/user_gold_panel/admin/index.php', 4 ) , ( 46, 'IP', 'arcade.gif', 'Arcade Spil', '../infusions/arcade/admin/index.php', 4 ) , ( 48, 'IP', 'infusion_panel.gif', 'Fusion Community', '../infusions/member_pages/members_admin.php', 4 ) , ( 39, 'IP', 'infusion_panel.gif', 'Forslag', '../infusions/suggestion_box/suggestion_box_admin.php', 4 ) , ( 40, 'NC', 'news_cats.gif', 'News Categories', 'news_cats.php', 1 ) , ( 41, 'IP', 'infusion_panel.gif', 'Forum Rang System', '../infusions/rank_system/rank_system.php', 4 );

(Med semikolonner som afsluttere)

Aha - på den måde :o)

Jeg prøver igen... Takker

Der var den!!!
Kanon - jeg takker coder dk..
Opretter du et svar så du kan få dine points?? :)

Emil

Ok :)