Dr Byte, Thanks for your involvement.
I have installed a new store 1.3.8. No Demo Data. Installed all of the Mods that I want and now want to bring my old data over from a 1.3.2 store.
Because I have additional mods and some missing I don't want to import the complete DB but was just aiming to bring the necessary tables to have all of my customer/product/order details.
I believe that I have done this before at least in converting from CREloaded to ZC this is how I did it.
I created a copy of my live DB (old) i compare what i believe are the tables I need such as anything customer_ and Order_ products_ etc. If the new DB is missing any columns from the tables that I compare then I add that column to the OLD DB. I then export the old table. Empty the NEW table and run the SQL query on only the exported data starting with INSERT bringing all of the OLD data to the NEW table. (not recreating the table)
However I noticed that the OLD tabes and the NEW tables have different 'indexes'
for example the OLD db Orders table has the following Indexes listed:
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 1992 orders_id
idx_status_orders_cust_zen INDEX 1992 orders_status
orders_id
customers_id
the NEW db Orders table has the following Indexes:
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 4 orders_id
idx_status_orders_cust_zen INDEX 4 orders_status
orders_id
customers_id
idx_date_purchased_zen INDEX 4 date_purchased
qbi_imported INDEX 1 qbi_imported
I uderstand that the qbi line is added from the quickbooks mod and has actually been removed now. When I import the OLD table to the new table it has not been bringing across all of these entries and presumably if it does it will wipe out the existing entries. The primary copies across and I use this as check that all of the data was imported but the other lines don't replicate across at least not how I am doing it. This has been the case even if I select 'add drop table' although I have not yet tried the options suggested by Kobra on a table by table basis.
However once I completed the table by table import I had some wierd bugs. Like I imported and thenc hecked my tax/zone etc. But my store was showing tax free prices until I logged in which is the opposite of the Old store. I checked the product info and I could not get it to accept/show a net price and a gross price. They where both the same even with 'taxable goods' selected and the tax zones/rates checked.
So I thought maybe I am doign this the hardway and I should try the store upgrade method. I imported the complete OLD DB. Went to the install directorya dn selected upgrade. I entered the username and password (the store admin) details as asked and then pressed upgrade. I had to do this 3 times each time getting a page that was fairly indescriptive and unhelpful but each time one of the upgrade steps was unticked.
On the 4th and final upgrade I got these errors:
SKIPPED: Cannot create table nochex_apc_transactions because it already exists
SKIPPED: Cannot create table nochex_sessions because it already exists
SKIPPED: Cannot create table nochex_sessions because it already exists
SKIPPED: Cannot create table nochex_sessions because it already exists
SKIPPED: Cannot create table nochex_sessions because it already exists
SKIPPED: Cannot ALTER or INSERT/REPLACE into table linkpoint_api because it does not exist. CHECK PREFIXES!
I am only concerned with the last one unless someone tells me otherwise.
but also now I can not access the site pages in any way. There is obviously some old configurations in the DB that need to be changed. Currently different server/hostname/physical path etc. I thought all of this was in the configure.php files but I gues some of it is in the DB as well. Where do I change it.
Sorry for going on so long but it is a long story.
