MySQLDumper-Board Forum Index Follow me on Twitter

Portal  •   Forum  •  Downloads  •  Profile  •  Search   •  Register  •  Log in to check your private messages  •  Log in  •  


 MSD 1.24 ..problem with restore between MYSQLversions

Post new topicReply to topic
Author Message
bheppner
first backups
first backups





Joined: 11 Jul 2010
Posts: 1


blank.gif

PostPosted: 2010-07-11, 12:41    MSD 1.24 ..problem with restore between MYSQLversions Reply with quoteBack to top

I have backuped a MYSQL DB Version 5.1.46 with msd 1.24 and wanted to restore it on another Server with mysql DB version 5.051a...but there I get an error:

MySQL says:
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 'USING BTREE, KEY `FK_ATTRIBUTE_VARCHAR_ENTITY` (`entity_id`), KEY `FK_CATA' at line 17
Error in Query:
CREATE TABLE `catalog_category_entity_varchar` ( `value_id` int(11) NOT NULL AUTO_INCREMENT, `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0', `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0', `store_id` smallint(5) unsigned NOT NULL DEFAULT '0', `entity_id` int(10) unsigned NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`value_id`), UNIQUE KEY `IDX_BASE` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`) USING BTREE, KEY `FK_ATTRIBUTE_VARCHAR_ENTITY` (`entity_id`), KEY `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE` (`attribute_id`), KEY `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE` (`store_id`), CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1723 DEFAULT CHARSET=utf8;


Any Idea to solve

OfflineView user's profileSend private message    
Anzeigen











Posted:    Anzeigen Back to top


    
Display posts from previous:      
Post new topicReply to topic


 Jump to:   


Show permissions
Similar topics
Topic Author Forum Replies Posted
No new posts [solved] Restore:Can't create table '... rob40 Gelöst/Erledigt 6 2012-05-13, 20:41 View latest post
No new posts Restore Issue - Multifile restore stops znmnky Errors and questions 6 2012-04-03, 21:51 View latest post
No new posts Dump restore stuck anthonyinit Errors and questions 4 2012-03-31, 04:45 View latest post
No new posts Wiederherstellung bricht ab (restore.... bursch Gelöst/Erledigt 2 2012-03-14, 14:29 View latest post
No new posts Warning: Too few arguments.....restor... Alfr3d Errors and questions 1 2012-02-22, 11:01 View latest post

 
CrackerTracker © 2004 - 2012 CBACK.de

Powered by Orion based on phpBB © 2001, 2002 phpBB Group
CBACK Orion Style based on FI Theme
All times are GMT + 2 Hours

phpBB SEO