export customer and sales data

[neit]

Thankyou this did appear to work ok.

I have one query i have a fresh install of version 1.3.9b has only
93 tables where as version 1.3.8 and database upgrade has 95 tables should this make any difference.

[neit]

There seems to have been an issue with as It is no longer pulling entering the product_descriptions into the order which I had set it up yo do.

[neit]

Now I had everything working from a fresh install of 1.3.9b and I havehad to add an additional field to the orders table called
products_description but it did work. Now since the upgrade of the database the product description is not
showing on check out, order history or the admin section when I check an order.

[neit]

Having checked this again when I manually enter the description
into the products_description field I created orders_products
the admin side pulls out the description as expected.
The issue appears on the customer side when it does not
display the discription during checkout or enter into the database.

I'll have to dig a little deeper

[neit]

Resolved I did not amend the order.php in the store side of the script.
thanks
for the help

[Gamer]

I have basicly done the same thing.... But...

Due to PCI compliance, a non shared server was required.

Exported all of the old 1.3.7 data and upgraded it...

My issue is that Im doing everyting on a new server that won't go live untill I tell the host to switch over to the new server.


It's taken me a couple months to get everything setup the way I want.... So in that time I have gained a few customers on the old server and need to import those customers into the new server just before we go live.

My database is rather large thus I would like to know how to import just the customer & sales data.

My intention is to have a seamless transfer and reduce the down time while I move.

[kobra]

a non shared server was required.

My database is rather large thus I would like to know how to import just the customer & sales data.

Large is not an issue

Make the proper DB backup from your live site after placing on maint

Move it to your new server

at a shell prompt
enter this adjusting for your db name and Db backup

mysql database < file.sql

so this might look like

mysql jsmith_db < db_backup.sql

Then rerun zc_install and upgrade the DB Only