Jump to content
xt:Commerce Community Forum
Sign in to follow this  
eselchenm72

An die Profis. Brauch Hilfe wegen Shopumzug

Recommended Posts

Hi all, bitte erschlagt mich jetzt nicht, wenn Ihr das lest. :ph34r:

Bei meinem Webhoster habe ich leider nur eine Datenbank zu meiner Verf?gung.

Dort habe ich ein Content-Sytem von Mambo, einen Shop von OS-Commerce, ein Forum von WoltLab und nat?rlich den Shop von XT-Commerce.

Jetzt hab ich Trottel folgendes Problem::wacko:

Ich bin mit dem Shop von XT-Commerc so zufrieden, das ich mich entschieden habe ein Upgrade zu machen damit er eine eigene Datenbank und eine eigene Domain erh?lt.

Doch wie bekomme ich jetzt heraus, welche Daten auf der Datenbank (SQL) zm XT-Commerce-Shop geh?ren? :wacko:

Anhang

Shop von XT-Commerce wird benutzt und soll auf eine eigene Datenbank

Shop von OS-Commerce wird nicht benutzt.(egal wenn er gel?scht wird)

Mambo Content-System wird benutzt

WoltLab-Forum wird benutzt

Share this post


Link to post
Share on other sites

Im Verzeichnis "/includes" gibt es die Datei "database_tables.php", in der alle xtCommerce-Tabellennamen definiert sind.


 18  // define the database table names used in the project

 19  define('TABLE_ADDRESS_BOOK', 'address_book');

 20  define('TABLE_ADDRESS_FORMAT', 'address_format');

 21  define('TABLE_BANNERS', 'banners');

 22  define('TABLE_BANNERS_HISTORY', 'banners_history');

 23  define('TABLE_CATEGORIES', 'categories');

 24  define('TABLE_CATEGORIES_DESCRIPTION', 'categories_description');

 25  define('TABLE_CONFIGURATION', 'configuration');

 26  define('TABLE_CONFIGURATION_GROUP', 'configuration_group');

 27  define('TABLE_COUNTER', 'counter');

 28  define('TABLE_COUNTER_HISTORY', 'counter_history');

 29  define('TABLE_COUNTRIES', 'countries');

 30  define('TABLE_CURRENCIES', 'currencies');

 31  define('TABLE_CUSTOMERS', 'customers');

 32  define('TABLE_CUSTOMERS_BASKET', 'customers_basket');

 33  define('TABLE_CUSTOMERS_BASKET_ATTRIBUTES', 'customers_basket_attributes');

 34  define('TABLE_CUSTOMERS_INFO', 'customers_info');

 35  define('TABLE_CUSTOMERS_IP', 'customers_ip');

 36  define('TABLE_CUSTOMERS_STATUS', 'customers_status');

 37  define('TABLE_CUSTOMERS_STATUS_HISTORY', 'customers_status_history');

 38  define('TABLE_LANGUAGES', 'languages');

 39  define('TABLE_MANUFACTURERS', 'manufacturers');

 40  define('TABLE_MANUFACTURERS_INFO', 'manufacturers_info');

 41  define('TABLE_ORDERS', 'orders');

 42  define('TABLE_ORDERS_PRODUCTS', 'orders_products');

 43  define('TABLE_ORDERS_PRODUCTS_ATTRIBUTES', 'orders_products_attributes');

 44  define('TABLE_ORDERS_PRODUCTS_DOWNLOAD', 'orders_products_download');

 45  define('TABLE_ORDERS_STATUS', 'orders_status');

 46  define('TABLE_ORDERS_STATUS_HISTORY', 'orders_status_history');

 47  define('TABLE_ORDERS_TOTAL', 'orders_total');

 48  define('TABLE_SHIPPING_STATUS', 'shipping_status');

 49  define('TABLE_PRODUCTS', 'products');

 50  define('TABLE_PRODUCTS_ATTRIBUTES', 'products_attributes');

 51  define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', 'products_attributes_download');

 52  define('TABLE_PRODUCTS_DESCRIPTION', 'products_description');

 53  define('TABLE_PRODUCTS_NOTIFICATIONS', 'products_notifications');

 54  define('TABLE_PRODUCTS_OPTIONS', 'products_options');

 55  define('TABLE_PRODUCTS_OPTIONS_VALUES', 'products_options_values');

 56  define('TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS', 'products_options_values_to_products_options');

 57  define('TABLE_PRODUCTS_TO_CATEGORIES', 'products_to_categories');

 58  define('TABLE_REVIEWS', 'reviews');

 59  define('TABLE_REVIEWS_DESCRIPTION', 'reviews_description');

 60  define('TABLE_SESSIONS', 'sessions');

 61  define('TABLE_SPECIALS', 'specials');

 62  define('TABLE_TAX_CLASS', 'tax_class');

 63  define('TABLE_TAX_RATES', 'tax_rates');

 64  define('TABLE_GEO_ZONES', 'geo_zones');

 65  define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones');

 66  define('TABLE_WHOS_ONLINE', 'whos_online');

 67  define('TABLE_ZONES', 'zones');

 68  define('TABLE_PRODUCTS_XSELL', 'products_xsell');

 69  define('TABLE_CONTENT_MANAGER', 'content_manager'); 

 70  define('TABLE_PRODUCTS_CONTENT','products_content');

 71  define('TABLE_COUPON_GV_CUSTOMER', 'coupon_gv_customer');

 72  define('TABLE_COUPON_GV_QUEUE', 'coupon_gv_queue');

 73  define('TABLE_COUPON_REDEEM_TRACK', 'coupon_redeem_track');

 74  define('TABLE_COUPON_EMAIL_TRACK', 'coupon_email_track');

 75  define('TABLE_COUPONS', 'coupons');

 76  define('TABLE_COUPONS_DESCRIPTION', 'coupons_description');

 77  define('TABLE_BLACKLIST', 'card_blacklist');

 78  define('TABLE_BOT_LOG', 'bot_log');


(Der Teil hinter dem Komma gibt den Tabellennamen an.) Wenn Du zus?tzliche Contributions eingebaut hast, k?nnen da durchaus noch mehr Tabellen definiert sein. Ich habe die Tabellennamen extrahiert und sortiert, so dass Du z.B. ?ber PHPMyAdmin gezielt die zu sichernden Tabellen ausw?hlen kannst.

address_book

address_format

banners

banners_history

bot_log

card_blacklist

categories

categories_description

configuration

configuration_group

content_manager

counter

counter_history

countries

coupon_email_track

coupon_gv_customer

coupon_gv_queue

coupon_redeem_track

coupons

coupons_description

currencies

customers

customers_basket

customers_basket_attributes

customers_info

customers_ip

customers_status

customers_status_history

geo_zones

languages

manufacturers

manufacturers_info

orders

orders_products

orders_products_attributes

orders_products_download

orders_status

orders_status_history

orders_total

products

products_attributes

products_attributes_download

products_description

products_notifications

products_options

products_options_values

products_options_values_to_products_options

products_to_categories

products_xsell

reviews

reviews_description

sessions

shipping_status

specials

tax_class

tax_rates

whos_online

zones

zones_to_geo_zones


Share this post


Link to post
Share on other sites
Sign in to follow this  

×
×
  • Create New...