Habe meine Datenbank 1.0.6.0 importiert. Vor dem Backup habe ich Template XTC5 (original) eingestellt und das Backup ohne Komprimierung mit vollständigen inserts gestellt im alten Shop.
Mit Fehlern ausgeführt:
INSERT INTO carriers (carrier_id, carrier_name, carrier_tracking_link, carrier_sort_order, carrier_date_added, carrier_last_modified) VALUES (1, 'DHL', 'http://nolp.dhl.de/nextt-online-public/set_identcodes.do?lang=$2&idc=$1', '10', NOW(), '')
INSERT INTO carriers (carrier_id, carrier_name, carrier_tracking_link, carrier_sort_order, carrier_date_added, carrier_last_modified) VALUES (2, 'DPD', 'https://extranet.dpd.de/cgi-bin/delistrack?pknr=$1+&typ=1&lang=$2', '20', NOW(), '')
INSERT INTO carriers (carrier_id, carrier_name, carrier_tracking_link, carrier_sort_order, carrier_date_added, carrier_last_modified) VALUES (3, 'GLS', 'https://gls-group.eu/DE/de/paketverfolgung?match=$1', '30', NOW(), '')
INSERT INTO carriers (carrier_id, carrier_name, carrier_tracking_link, carrier_sort_order, carrier_date_added, carrier_last_modified) VALUES (4, 'UPS', 'http://wwwapps.ups.com/WebTracking/track?track=yes&trackNums=$1', '40', NOW(), '')
INSERT INTO carriers (carrier_id, carrier_name, carrier_tracking_link, carrier_sort_order, carrier_date_added, carrier_last_modified) VALUES (5, 'HERMES', 'http://tracking.hlg.de/Tracking.jsp?TrackID=$1', '50', NOW(), '')
INSERT INTO carriers (carrier_id, carrier_name, carrier_tracking_link, carrier_sort_order, carrier_date_added, carrier_last_modified) VALUES (6, 'FEDEX', 'http://www.fedex.com/Tracking?action=track&tracknumbers=$1', '60', NOW(), '')
INSERT INTO carriers (carrier_id, carrier_name, carrier_tracking_link, carrier_sort_order, carrier_date_added, carrier_last_modified) VALUES (7, 'TNT', 'http://www.tnt.de/servlet/Tracking?cons=$1', '70', NOW(), '')
INSERT INTO carriers (carrier_id, carrier_name, carrier_tracking_link, carrier_sort_order, carrier_date_added, carrier_last_modified) VALUES (8, 'TRANS-O-FLEX', 'http://track.tof.de/trace/tracking.cgi?barcode=$1', '80', NOW(), '')
INSERT INTO carriers (carrier_id, carrier_name, carrier_tracking_link, carrier_sort_order, carrier_date_added, carrier_last_modified) VALUES (9, 'KUEHNE-NAGEL', 'https://knlogin.kuehne-nagel.com/apps/fls.do?subevent=search&knReference=$1', '90', NOW(), '')
INSERT INTO carriers (carrier_id, carrier_name, carrier_tracking_link, carrier_sort_order, carrier_date_added, carrier_last_modified) VALUES (10, 'ILOXX', 'http://www.iloxx.de/net/einzelversand/tracking.aspx?ix=$1', '100', NOW(), '')
INSERT INTO carriers (carrier_id, carrier_name, carrier_tracking_link, carrier_sort_order, carrier_date_added, carrier_last_modified) VALUES (11, 'LogoiX', 'http://www.logoix.com/cgi-bin/tnt.pl?q=$1', '110', NOW(), '')
ALTER TABLE `currencies` ADD UNIQUE KEY `idx_code` (`code`)
ALTER TABLE `products_options_values_to_products_options` ADD KEY `idx_products_options_id` (`products_options_id`)
ALTER TABLE whos_online ADD PRIMARY KEY (session_id)
CREATE TABLE module_backup ( configuration_id INT(11) NOT NULL AUTO_INCREMENT, configuration_key VARCHAR(64) NOT NULL, configuration_value text NOT NULL, last_modified datetime DEFAULT NULL, PRIMARY KEY (configuration_id), UNIQUE idx_configuration_key (configuration_key) )
ALTER TABLE orders DROP cc_type
ALTER TABLE orders DROP cc_owner
ALTER TABLE orders DROP cc_number
ALTER TABLE orders DROP cc_expires
ALTER TABLE orders DROP cc_start
ALTER TABLE orders DROP cc_issue
ALTER TABLE orders DROP cc_cvv
ALTER TABLE admin_access DROP blacklist
ALTER TABLE admin_access CHANGE fck_wrapper filemanager INT(1) NOT NULL DEFAULT 0
ALTER TABLE products_vpe ADD PRIMARY KEY (products_vpe_id, language_id)
ALTER TABLE products_xsell_grp_name ADD PRIMARY KEY (products_xsell_grp_name_id, language_id)
ALTER TABLE countries ADD UNIQUE idx_countries_iso_code_2 (countries_iso_code_2)
ALTER TABLE countries ADD UNIQUE idx_countries_iso_code_3 (countries_iso_code_3)
ALTER TABLE coupon_gv_customer DROP INDEX customer_id
ALTER TABLE coupons_description DROP INDEX coupon_id
ALTER TABLE coupons_description ADD PRIMARY KEY (coupon_id, language_id)
ALTER TABLE coupon_email_track ADD UNIQUE idx_coupon_id (coupon_id)
ALTER TABLE customers_status DROP INDEX idx_orders_status_name
ALTER TABLE customers_status ADD UNIQUE idx_customers_status_name (customers_status_name, language_id)
ALTER TABLE campaigns ADD UNIQUE idx_campaigns_refID (campaigns_refID)
ALTER TABLE banners_history ADD KEY idx_banners_id (banners_id)
ALTER TABLE languages ADD UNIQUE idx_code (code)
ALTER TABLE languages DROP INDEX idx_languages_name
ALTER TABLE content_manager DROP INDEX content_meta_title
ALTER TABLE content_manager ADD KEY idx_content_group (content_group)
ALTER TABLE customers ADD KEY idx_customers_email_address (customers_email_address)
ALTER TABLE customers_ip DROP INDEX customers_id
ALTER TABLE customers_ip ADD KEY idx_customers_id (customers_id)
ALTER TABLE newsletter_recipients ADD UNIQUE idx_customers_email_address (customers_email_address)
ALTER TABLE newsletter_recipients ADD KEY idx_mail_key (mail_key)
ALTER TABLE orders_products_attributes ADD KEY idx_orders_id (orders_id)
ALTER TABLE orders_products_attributes ADD KEY idx_orders_products_id (orders_products_id)
ALTER TABLE orders_products_download ADD KEY idx_orders_id (orders_id)
ALTER TABLE orders_products_download ADD KEY idx_orders_products_id (orders_products_id)
ALTER TABLE orders_total DROP INDEX idx_orders_total_orders_id
ALTER TABLE orders_total ADD KEY idx_orders_id (orders_id)
ALTER TABLE products ADD KEY idx_products_status (products_status)
ALTER TABLE products_description DROP INDEX products_name
ALTER TABLE products_description ADD KEY idx_products_name (products_name)
ALTER TABLE products_graduated_prices DROP INDEX products_id
ALTER TABLE products_graduated_prices ADD KEY idx_products_id (products_id)
ALTER TABLE reviews ADD KEY idx_products_id (products_id)
ALTER TABLE shop_configuration DROP INDEX configuration_key
ALTER TABLE shop_configuration ADD KEY idx_configuration_key (configuration_key)
ALTER TABLE specials DROP INDEX idx_specials_products_id
ALTER TABLE specials ADD KEY idx_products_id (products_id)
ALTER TABLE specials ADD KEY idx_status (STATUS)
ALTER TABLE products_content ADD KEY idx_products_id (products_id)
ALTER TABLE address_book DROP INDEX idx_address_book_customers_id
ALTER TABLE address_book ADD KEY idx_customers_id (customers_id)
ALTER TABLE banktransfer DROP INDEX orders_id
ALTER TABLE banktransfer ADD KEY idx_orders_id (orders_id)
ALTER TABLE campaigns_ip ADD KEY idx_campaign (campaign)
ALTER TABLE coupon_gv_queue DROP INDEX uid
ALTER TABLE coupon_gv_queue ADD KEY idx_customer_id (customer_id)
ALTER TABLE tax_rates ADD KEY idx_tax_zone_id (tax_zone_id)
ALTER TABLE zones_to_geo_zones ADD KEY idx_geo_zone_id (geo_zone_id)
CREATE TABLE newsfeed ( news_id INT( 11 ) NOT NULL AUTO_INCREMENT, news_title VARCHAR( 128 ) NULL, news_text TEXT NULL, news_link VARCHAR( 128 ) NULL, news_date INT( 11 ) NULL, PRIMARY KEY (news_id), UNIQUE idx_news_link (news_link) )
ALTER TABLE geo_zones ADD UNIQUE idx_geo_zone_name (geo_zone_name)
ALTER TABLE `database_version` ADD `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
ALTER TABLE admin_access DROP module_paypal_install
ALTER TABLE `products` ADD KEY `idx_manufacturers_id` (`manufacturers_id`)
ALTER TABLE admin_access DROP fck_wrapper
ALTER TABLE `personal_offers_by_customers_status_3` ADD KEY `idx_products_id` (`products_id`)
ALTER TABLE `categories` ADD KEY `idx_categories_status` (`categories_status`)
ALTER TABLE `countries` ADD KEY `idx_status` (`status`)
ALTER TABLE `customers` ADD KEY `idx_customers_default_address_id` (`customers_default_address_id`)
ALTER TABLE `languages` ADD KEY `idx_status` (`status`)
ALTER TABLE `tax_rates` ADD KEY `idx_tax_class_id` (`tax_class_id`)
ALTER TABLE `zones` ADD KEY `idx_zone_country_id` (`zone_country_id`)
ALTER TABLE `products_xsell` ADD KEY `idx_xsell_id` (`xsell_id`), ADD KEY `idx_products_id` (`products_id`), ADD KEY `idx_products_xsell_grp_name_id` (`products_xsell_grp_name_id`)
ALTER TABLE `orders` ADD KEY `idx_date_purchased` (`date_purchased`)
ALTER TABLE `orders` ADD KEY `idx_payment_class` (`payment_class`)
ALTER TABLE `orders_status_history` ADD KEY `idx_orders_id` (`orders_id`)
Der Shop scheint im ersten Anschein nach zu laufen.