Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Importfehler mysql nach mariadb
View unanswered posts
View posts from last 24 hours
View posts from last 7 days

 
Reply to topic    Gentoo Forums Forum Index Deutsches Forum (German)
View previous topic :: View next topic  
Author Message
uhai
l33t
l33t


Joined: 23 Aug 2007
Posts: 868
Location: Eppingen, Germany

PostPosted: Sun Mar 02, 2014 10:17 pm    Post subject: Importfehler mysql nach mariadb Reply with quote

Hallo,

ich will eine online stehende mysql-Datenbank (MYSQL Server 5.1.66, Client 5.0.8) 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&sectionid=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
_________________
Asus 4A785TD-M EVO mit AMD Phenom(tm) II X4 945
Dell Mini 10v
http://www.openstreetmap.org
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Deutsches Forum (German) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum