export database from 2.5.6 & import to 3.1.1

  • Posts: 50
  • Thank you received: 2
11 years 4 months ago #111238

On exporting remote database from 2.5.6 and importing into local 3.1.1
As I see it these are the relevant tables.
My object is to keep customers and orders up to date.

Alter table jos_hikashop_order.
At the end add column
order_invoice_created
type=int 10
attribute= unsigned
null= no
default = 0
****************
Then import to 3.1.1
jos_hikashop_address
jos_hikashop_history
jos_hikashop_order
jos_hikashop_order_product
jos_hikashop_user
jos_users
jos_user_notes
jos_user_usergroup_map

Am I missing anything?
Rgds
emmdee

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 4 months ago #111274

Hi,

You can update the version of HikaShop of the Joomla 2.5.6 site, and install the latest one on Joomla 3.1.1 by this way all the Hikashop tables will be the same.

Then export/import all the HikaShop related tables to be sure to not lose anything.
With these elements it should be ok.

And if something is missing, you can still take it from 2.5.6 and add it to 3.1.1

Please Log in or Create an account to join the conversation.

Time to create page: 0.063 seconds
Powered by Kunena Forum