Jump to content
SCH_001

Moving customers and Orders v2.3.4 -> v2.3.4.1 CE

Recommended Posts

Hi guys, bear in mind I am a shop owner with some some computer back ground.
I need to move my customers and orders from v2.3.4 to v2.3.4.1 CE Frozen

So table wise is the below everything I need?
customers
address_book
orders
orders_products
orders_products_attributes
orders_products_download
orders_status
orders_status_history
orders-total

In phpmyadmin, there are a heap of choices to make during the export
IE do I want data and structure or only data?
with all the tick boxes do I need to turn any off that are on / turn any on that are current off?

During import do I need to do anything other than select the file and click import?

Many thanks

 

Share this post


Link to post
Share on other sites
Posted (edited)

Backup the database!

Export data only.

Import a file or text.

The main thing to backup!

+ customers_basket,  customers_basket_attributes, customers_info, sessions

Edited by ruden

Share this post


Link to post
Share on other sites

Thanks @bonbec but to be able to migrate to a new setup the shop needs to be fully setup with stock and all the oddon's etc leaving customers as the last to bring across so the script to update a database to a new version just won't cut it

 

Share this post


Link to post
Share on other sites

Simply compare the old table with the new and if structure is the same just export data only and truncate table in new site and import data.

If table structure is not the same then edit old data to make it match new table stuctucture and then truncate new table and import data only.

I found it best to do one table at a time on a test database ( ie not the live one) and only when all imports were done with no errors repeat it on the live db.


 

Share this post


Link to post
Share on other sites

So @JcMagpie when you say compare the table you mean the below. If the layout of each is the same then all will be good. So in this case address book is good

When you say one table at the time so can export / import the address book and if all good move on to the next one?
image.png.a8c0354fca6bb9aae3f237862ef5987c.pngimage.png.80bc20e06a09314ccd9282d94bfded0b.png

Share this post


Link to post
Share on other sites

No you need to look at the raw data in the db. Use export to out put the raw data like this. Thisis a comparison of offical osC and CE Edge address book table structure.

Your looking for any difference between the tables, I simply use WinMerge to compare the 2 files. If they are the same your good to go.

image.thumb.png.fc2d8aa8048fc8ef1ccf6b89890822a9.png


 

Share this post


Link to post
Share on other sites

Do this for each table and you should be fine. As allways backup. I would always recomend making a copy of the new site db so if it all goes tit's up you can just replace the db.

Begin by accessing phpMyAdmin via cPanel or Plesk.
  1. Select the database you wish to copy (by clicking on the database from the phpMyAdmin home screen).
  2. Once inside the database, select the Operations tab.
  3. Scroll down to the section where it says "Copy database to:"
  4. Type in the name of the new database.

 

 


 

Share this post


Link to post
Share on other sites
Posted (edited)

@JcMagpie ok so I have copy a back of the database out. But can not work out how to export raw data I keep ending up with all the data stored in it

Edited by supercheaphobb

Share this post


Link to post
Share on other sites

Found it export the structure only...

Ok this is going to take a while so back later

Share this post


Link to post
Share on other sites

So not a good start the charset seems to be different the old database which we are moving data from is on the right and I have checked the export options for " Character set of the file: " and latin1 is not an options

New frozen database on the left

image.thumb.png.18db0c644b827c46b44043bffdfddb35.png

 

Share this post


Link to post
Share on other sites

Just do a test import and see how it goes, not much point in over thinking things. If the structure is the same it should be fine.

This is a frozen table set.

image.thumb.png.5835b430dc8de3b8de8728bc5a9907ae.png


 

Share this post


Link to post
Share on other sites

So apart from the charset the tables where all the same. And gave it a go and all worked - fantastic

According to google = Using truncate table is better then using delete as it ignores all the indexes and just removes everything

So even if I have test sales and orders in the database using truncate and import will empty the database before filling it with the new data -> which is exactly what I wanted

A few more evenings of moving product and adding new product and we should be able to move the shop to it's new home and go live = wow

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×