Hallo
Wie es von 2.0 zu 2.1 ausschaut weiß ich nicht. Das habe ich noch nicht probiert.
Von 2.1 au 2.2 geht es aber nicht ganz einfach.
Den weg den ich begehen würde ist folgender:
1. Einen neunen 2.2 Shop aufsetzen.
2. Contentelemente und Einstellungen übertragen.
3. Aus der 2.1 DB die Tabellen suchen, die man in den Shop mit nehmen muss und dumpen. Ich denke, dass das folgende sien dürften:
- adress_book
- categories
- categories_description
- customers
- customers_info
- customers_ip
- manufacturers
- manufacturers_info
- products
- products_attributes
- products_attributes
- products_content
- products_description
- products_graduated_prices
- products_images
- products_notifications
- products_options
- products_options_values
- products_options_values_to_products_options
- products_parameters
- products_parameters_description
- products_parameters_groups
- products_parameters_groups_description
- products_to_categories
- products_vpe
- products_xsell
- products_xsell_grp_name
- reviews
- reviews_description
Falls die Bestellhistorie mit genommen werden soll müssen wohl noch einige Tabellen mehr exportiert werden.
Nun die zu übertragenden Tabellen in der 2.2 DB entleeren.
DELETE FROM address_book
DELETE FROM categories;
DELETE FROM categories_description;
DELETE FROM customers;
DELETE FROM customers_info;
DELETE FROM customers_ip;
DELETE FROM manufacturers;
DELETE FROM manufacturers_info;
DELETE FROM products;
DELETE FROM products_attributes;
DELETE FROM products_attributes;
DELETE FROM products_content;
DELETE FROM products_description;
DELETE FROM products_graduated_prices;
DELETE FROM products_images;
DELETE FROM products_notifications;
DELETE FROM products_options;
DELETE FROM products_options_values;
DELETE FROM products_options_values_to_products_options;
DELETE FROM products_parameters;
DELETE FROM products_parameters_description;
DELETE FROM products_parameters_groups;
DELETE FROM products_parameters_groups_description;
DELETE FROM products_to_categories;
DELETE FROM products_vpe;
DELETE FROM products_xsell;
DELETE FROM products_xsell_grp_name;
DELETE FROM reviews;
DELETE FROM reviews_description;
Nun die alten Daten in die neue DB importieren und anpassen. Zum Beispiel mit phpmysql.
Was sich definitiv geändert hat ist die Sprachzuordnung. Das beachte ich hier mal:
UPDATE categories_description SET language_id = "999" WHERE language_id="1";
UPDATE categories_description SET language_id = "888" WHERE language_id="2";
UPDATE categories_description SET language_id = "2" WHERE language_id="999";
UPDATE categories_description SET language_id = "1" WHERE language_id="888";
UPDATE manufacturers_info SET languages_id = "999" WHERE languages_id="1";
UPDATE manufacturers_info SET languages_id = "888" WHERE languages_id="2";
UPDATE manufacturers_info SET languages_id = "1" WHERE languages_id="888";
UPDATE manufacturers_info SET languages_id = "2" WHERE languages_id="999";
UPDATE products_description SET language_id = "999" WHERE language_id="1";
UPDATE products_description SET language_id = "888" WHERE language_id="2";
UPDATE products_description SET language_id = "1" WHERE language_id="888";
UPDATE products_description SET language_id = "2" WHERE language_id="999";
UPDATE products_options_values SET language_id = "999" WHERE language_id="1";
UPDATE products_options_values SET language_id = "888" WHERE language_id="2";
UPDATE products_options_values SET language_id = "1" WHERE language_id="888";
UPDATE products_options_values SET language_id = "2" WHERE language_id="999";
UPDATE products_parameters_description SET language_id = "999" WHERE language_id="1";
UPDATE products_parameters_description SET language_id = "888" WHERE language_id="2";
UPDATE products_parameters_description SET language_id = "1" WHERE language_id="888";
UPDATE products_parameters_description SET language_id = "2" WHERE language_id="999";
UPDATE products_parameters_groups_description SET language_id = "999" WHERE language_id="1";
UPDATE products_parameters_groups_description SET language_id = "888" WHERE language_id="2";
UPDATE products_parameters_groups_description SET language_id = "1" WHERE language_id="888";
UPDATE products_parameters_groups_description SET language_id = "2" WHERE language_id="999";
UPDATE products_vpe SET language_id = "999" WHERE language_id="1";
UPDATE products_vpe SET language_id = "888" WHERE language_id="2";
UPDATE products_vpe SET language_id = "1" WHERE language_id="888";
UPDATE products_vpe SET language_id = "2" WHERE language_id="999";
UPDATE products_xsell_grp_name SET language_id = "999" WHERE language_id="1";
UPDATE products_xsell_grp_name SET language_id = "888" WHERE language_id="2";
UPDATE products_xsell_grp_name SET language_id = "1" WHERE language_id="888";
UPDATE products_xsell_grp_name SET language_id = "2" WHERE language_id="999";
UPDATE reviews_description SET languages_id = "999" WHERE languages_id="1";
UPDATE reviews_description SET languages_id = "888" WHERE languages_id="2";
UPDATE reviews_description SET languages_id = "1" WHERE languages_id="888";
UPDATE reviews_description SET languages_id = "2" WHERE languages_id="999";
UPDATE products_options SET language_id = "999" WHERE language_id="1";
UPDATE products_options SET language_id = "888" WHERE language_id="2";
UPDATE products_options SET language_id = "1" WHERE language_id="888";
UPDATE products_options SET language_id = "2" WHERE language_id="999";
Ich denke mal, dass damit ein guter Teil ereldigt sein sollte.
Hoffe es hilft ein wenig.
Bernd
P.S.: Ach ja: Natürlich alles ohne Gewähr.