uhai Veteran
Joined: 23 Aug 2007 Posts: 1358 Location: Eppingen, Germany
|
Posted: Sun Mar 02, 2014 10:17 pm Post subject: Importfehler mysql nach mariadb |
|
|
Hallo,
ich will eine online stehende mysql-Datenbank (MYSQL Server 5.1.66, Client 5.0. lokal in mariadb (Server 5.5.32, Client 5.0.11) (über phpmyadmin (online 3.4.9/ lokal 4.0.5)importieren. Dabei bekomme ich folgenden Fehler:
Code: | Fehler
SQL-Befehl:
--
-- Datenbank: `usr_#####`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `j17_assets`
--
CREATE TABLE IF NOT EXISTS `j17_assets` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`parent_id` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.',
`lft` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
`rgt` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
`level` int( 10 ) unsigned NOT NULL COMMENT 'The cached level in the nested tree.',
`name` varchar( 50 ) NOT NULL COMMENT 'The unique name for the asset.\n',
`title` varchar( 100 ) NOT NULL COMMENT 'The descriptive title for the asset.',
`rules` varchar( 5120 ) NOT NULL COMMENT 'JSON encoded access control.',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `idx_asset_name` ( `name` ) ,
KEY `idx_lft_rgt` ( `lft` , `rgt` ) ,
KEY `idx_parent_id` ( `parent_id` )
) TYPE = MYISAM AUTO_INCREMENT =193;
MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=193' at line 24 |
Zeile 24ff:
Code: | --
-- Tabellenstruktur für Tabelle `j17_assets`
--
CREATE TABLE IF NOT EXISTS `j17_assets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.',
`lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
`rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
`level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.',
`name` varchar(50) NOT NULL COMMENT 'The unique name for the asset.\n',
`title` varchar(100) NOT NULL COMMENT 'The descriptive title for the asset.',
`rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_asset_name` (`name`),
KEY `idx_lft_rgt` (`lft`,`rgt`),
KEY `idx_parent_id` (`parent_id`)
) TYPE=MyISAM AUTO_INCREMENT=193 ;
-- |
Zeile 1064:
Code: | (21, 'mainmenu', 'Home', 'home', '', 'home', 'index.php?option=com_content&view=featured', 'component', -2, 1, 1, 0, 0, 0, '0000-00-00 00:00:00', 0, 1, '', 0, '{"show_headings":1,"show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"front","show_pagination":"","show_pagination_limit":"","show_feed_link":"","show_noauth":"","show_title":0,"link_titles":"","show_intro":2,"show_section":"","link_section":"","show_category":"","link_category":"","show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":0,"show_print_icon":0,"show_email_icon":0,"show_hits":"","feed_summary":"","page_title":"","show_page_title":1,"pageclass_sfx":"","menu_image":"","secure":0}', 167, 168, 0, '*', 0),
(22, 'usermenu', 'Submit News', 'submit-news', '', 'submit-news', 'index.php?option=com_content&task=new§ionid=1&Itemid=0', 'component', 0, 1, 1, 22, 0, 0, '0000-00-00 00:00:00', 0, 2, '', 6, '{"show_headings":"","show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"","show_pagination":"","show_pagination_limit":"","show_feed_link":"","show_noauth":"","show_title":"","link_titles":"","show_intro":"","show_section":"","link_section":"","show_category":"","link_category":"","show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":"","pageclass_sfx":"","menu_image":"","secure":0}', 169, 170, 0, '*', 0),
(23, 'usermenu', 'Submit WebLink', 'submit-weblink', '', 'submit-weblink', 'index.php?option=com_weblinks&task=new', 'url', 0, 1, 1, 0, 0, 0, '0000-00-00 00:00:00', 0, 2, '', 6, '{"show_headings":"","show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"","show_pagination":"","show_pagination_limit":"","show_feed_link":"","show_noauth":"","show_title":"","link_titles":"","show_intro":"","show_section":"","link_section":"","show_category":"","link_category":"","show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":"","pageclass_sfx":"","menu_image":"","secure":0}', 171, 172, 0, '*', 0),
(24, 'usermenu', 'Check-In My Items', 'check-in-my-items', '', 'check-in-my-items', 'index.php?option=com_users&task=CheckIn', 'url', 0, 1, 1, 25, 0, 0, '0000-00-00 00:00:00', 0, 2, '', 6, '{"show_headings":"","show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"","show_pagination":"","show_pagination_limit":"","show_feed_link":"","show_noauth":"","show_title":"","link_titles":"","show_intro":"","show_section":"","link_section":"","show_category":"","link_category":"","show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":"","pageclass_sfx":"","menu_image":"","secure":0}', 173, 174, 0, '*', 0),
(25, 'usermenu', 'Logout', 'logout', '', 'logout', 'index.php?option=com_login', 'components', 1, 1, 1, 19, 0, 0, '0000-00-00 00:00:00', 0, 2, '', 6, '{"show_headings":"","show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"","show_pagination":"","show_pagination_limit":"","show_feed_link":"","show_noauth":"","show_title":"","link_titles":"","show_intro":"","show_section":"","link_section":"","show_category":"","link_category":"","show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":"","pageclass_sfx":"","menu_image":"","secure":0}', 175, 176, 0, '*', 0),
(26, 'usermenu', 'Your Details', 'your-details', '', 'your-details', 'index.php?option=com_users&task=UserDetails', 'url', 1, 1, 1, 25, 0, 0, '0000-00-00 00:00:00', 0, 2, '', 6, '{"show_headings":"","show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"","show_pagination":"","show_pagination_limit":"","show_feed_link":"","show_noauth":"","show_title":"","link_titles":"","show_intro":"","show_section":"","link_section":"","show_category":"","link_category":"","show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":"","pageclass_sfx":"","menu_image":"","secure":0}', 177, 178, 0, '*', 0),
(27, 'topmenu', 'Alltagsradler', 'alltagsradler', '', 'alltagsradler', 'index.php?option=com_content&view=category&layout=blog&id=7', 'component', 1, 1, 1, 22, 0, 0, '0000-00-00 00:00:00', 0, 1, '', 6, '{"show_headings":1,"show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"","show_pagination":2,"show_pagination_limit":1,"show_feed_link":"","show_noauth":"","show_title":1,"link_titles":"","show_intro":4,"show_section":"","link_section":4,"show_category":0,"link_category":0,"show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":1,"pageclass_sfx":"","menu_image":"","secure":0}', 5, 6, 0, '*', 0),
(28, 'topmenu', 'Fachwerk', 'fachwerk', '', 'fachwerk', 'index.php?option=com_content&view=category&layout=blog&id=13', 'component', 1, 1, 1, 22, 0, 0, '0000-00-00 00:00:00', 0, 1, '', 6, '{"show_description":0,"show_description_image":0,"num_leading_articles":1,"num_intro_articles":4,"num_columns":2,"num_links":4,"orderby_pri":"","orderby_sec":"","multi_column_order":0,"show_pagination":2,"show_pagination_results":1,"show_feed_link":1,"show_noauth":"","show_title":"","link_titles":"","show_intro":"","show_section":"","link_section":"","show_category":"","link_category":"","show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":1,"pageclass_sfx":"","menu_image":"","secure":0}', 11, 12, 0, '*', 0),
(29, 'usermenu', 'Upload Pictures', 'upload-pictures', '', 'upload-pictures', 'index.php?option=com_galleria&task=multiple_add_pics_step_1', 'url', 0, 1, 1, 0, 0, 0, '0000-00-00 00:00:00', 0, 2, '', 6, '{"show_headings":"","show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"","show_pagination":"","show_pagination_limit":"","show_feed_link":"","show_noauth":"","show_title":"","link_titles":"","show_intro":"","show_section":"","link_section":"","show_category":"","link_category":"","show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":"","pageclass_sfx":"","menu_image":"","secure":0}', 165, 166, 0, '*', 0),
(30, 'topmenu', 'Womo-Seiten', 'womo-seiten', '', 'womo-seiten', 'index.php?option=com_content&view=category&layout=blog&id=19', 'component', 1, 1, 1, 22, 0, 0, '0000-00-00 00:00:00', 0, 1, '', 6, '{"show_headings":1,"show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"","show_pagination":2,"show_pagination_limit":1,"show_feed_link":"","show_noauth":"","show_title":1,"link_titles":"","show_intro":4,"show_section":"","link_section":6,"show_category":0,"link_category":0,"show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":1,"pageclass_sfx":"","menu_image":"","secure":0}', 17, 18, 0, '*', 0),
(31, 'topmenu', 'DiGiPhotos', 'digiphotos', '', 'digiphotos', 'index.php?option=com_content&view=category&layout=blog&id=27', 'component', 1, 1, 1, 22, 0, 0, '0000-00-00 00:00:00', 0, 1, '', 6, '{"show_headings":"","show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"","show_pagination":"","show_pagination_limit":"","show_feed_link":"","show_noauth":"","show_title":"","link_titles":"","show_intro":"","show_section":"","link_section":"","show_category":"","link_category":"","show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":"","pageclass_sfx":"","menu_image":"","secure":0}', 7, 8, 0, '*', 0),
(32, 'topmenu', 'Familie', 'familie', '', 'familie', 'index.php?option=com_content&view=category&layout=blog&id=33', 'component', 0, 1, 1, 22, 0, 0, '0000-00-00 00:00:00', 0, 1, '', 6, '{"show_headings":5,"show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"","show_pagination":2,"show_pagination_limit":1,"show_feed_link":"","show_noauth":"","show_title":1,"link_titles":"","show_intro":5,"show_section":"","link_section":8,"show_category":0,"link_category":0,"show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":5,"pageclass_sfx":"","menu_image":"","secure":0}', 15, 16, 0, '*', 0),
(33, 'mainmenu', 'Gästebuch', 'gã¤stebuch', '', 'gã¤stebuch', 'undefined', 'components', -2, 1, 1, 23, 0, 0, '0000-00-00 00:00:00', 0, 1, '', 0, '{"show_headings":"","show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"","show_pagination":"","show_pagination_limit":"","show_feed_link":"","show_noauth":"","show_title":"","link_titles":"","show_intro":"","show_section":"","link_section":"","show_category":"","link_category":"","show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":"","pageclass_sfx":"","menu_image":"","secure":0}', 155, 156, 0, '*', 0),
(34, 'mainmenu', '-------', '-------', '', '-------', '', 'separator', -2, 1, 1, 0, 0, 0, '0000-00-00 00:00:00', 3, 1, '', 0, '{"show_headings":"","show_date":"","date_format":"","filter":1,"filter_type":"","orderby_sec":"","show_pagination":"","show_pagination_limit":"","show_feed_link":"","show_noauth":"","show_title":"","link_titles":"","show_intro":"","show_section":"","link_section":"","show_category":"","link_category":"","show_author":"","show_create_date":"","show_modify_date":"","show_item_navigation":"","show_readmore":"","show_vote":"","show_icons":"","show_pdf_icon":"","show_print_icon":"","show_email_icon":"","show_hits":"","feed_summary":"","page_title":"","show_page_title":"","pageclass_sfx":"","menu_image":"","secure":0}', 157, 158, 0, '*', 0),
|
Mit SQL bin ich nicht so vertraut und eine Doku für die Syntax oder den Import von / in mariadb konnte ich nicht finden. Kann mir da jemand bitte etwas helfen?
BTW: Wie kann ich in bluefish das Syntaxhighlighting für sql aktivieren? Und wie druckt bluefish den Code mit Syntaxhghlighting?
Uhai |
|