What Data Needs To Be Moved?

[RobbieBlokeToys]

Hi,

 

I'm moving from one server to another, and I've successfully moved all the data from the old install to the new.

However, in that time, another three customers have placed orders.

 

I really don't want to be moving everything again, so is there a list of database content that I need to move?

 

I attempted this once, but when I did so the addresses for the customers in the shopping carts section in the back office were all offset by one. The active orders were okay, but the active carts were all confused.

 

I really need to know which database sections are updated when a customer joins or an order is placed, then I just need to move these to update the new install before switching to it.

 

Thanks!

[RobbieBlokeToys]

Really?

No one knows the answer to this?

There must be at least one Prestashop person here who knows which database tables are vital to customer and order data!

 

I guess I'm just going to have to move every single one of them yet again and waste another 6 hours of my life, with another 6 hours of down time for my site

 

Here's a tip PS, how about making it a little easier by giving all essential DB tables a specific prefix? Perhaps in groups, with a list detailing which each one holds? That way we have a better understanding of the mess we're dealing with.

[DanielRomanMartinez]

Hello!!

1- Copy and paste the prestashop folder.

 

2- Change the config. /config/settings.inc.php

 

3- Go to Backoffice and change the URL. Preferences -> SEO and URLs.

 

4- Clean cache. 

 

5- Enjoy. 

 

-----

 

Possible problems.

 

1- Problems about .htaccess, Error 500.

 

You have to regenerate .htaccess from backoffice.

 

Preferences -> SEO and URLs. 

 

Change option:

 

URL Friendly --> NO and SAVE.

 

And then, change it AGAIN. 

 

URL Friendly --> NO and SAVE.

 

2- You can't login and login page is without CSS

 

Is about DB. Your database has information about your old server. You have to change it.

 

Download your database, and search with a notepad: PS_SHOP_DOMAIN y el PS_SHOP_DOMAIN_SSL

 

If is not solver, search your domiain name.

 

3- Blank Login page.

 

Some file is corrupted, be sure all prestashop is uploaded correctly. 

 

Regards, Dani.

[DanielRomanMartinez]

And.. if you want import only orders... I think is really easier, import all prestashop to new site.

 

The orders are : ps_orders

To import correctly ps_orders you need..

id_shop_group

id_shop

id_carrier

id_lang

id_customer

id_cart

id_currency

id_address_delivery

id_address_invoice

 

Because that information is really important. 

[RobbieBlokeToys]

And.. if you want import only orders... I think is really easier, import all prestashop to new site.

 

The orders are : ps_orders

 

To import correctly ps_orders you need..

 

id_shop_group

id_shop

id_carrier

id_lang

id_customer

id_cart

id_currency

id_address_delivery

id_address_invoice

 

Because that information is really important. 

Hi, thanks for your response.

 

I haven't moved the entire PS install because the previous install has problems which cannot be resolved. I have attempted to find support for why my site seems to go down every morning at the same time, and there is no assistance aavailable.

So, as a solution, I have created a new PS on a new VPS, to avoid any problems in the original, and then moved all vital data over to the new VPS.

 

The info you give above is very helpful, but I fear this is incorrect and doesn't cover all the needed tables.

 

I have attempted to do this a couple of times already, and while all customer and order data seems to be there, when using the "active carts" page all information for customers was offset by one. So, the newest cart (not order or customer) showed the order of one person but the address of another. This would surely mess up their cart if they were to return to place an order after creating that cart? They would arrive and see someone elses information in their cart.

 

So, I need to know in which table this data is held also.

[prestatent]

Hi

 

See list below (PS 1.6.1.1). When an order is complete I don't think you need any cart details for the customer as it will be in the orders table. If you are going to do this again, I would put the site in "Maintenance" or "Catalog" mode. That way, no-one can create an order while you're performing the move, and you won't have to do it again. I think the tables below are all you need. Maybe someone from the PS team can confirm (or not).

 

Whatever you do, create a full site backup before moving (database and codebase).

 

 

ps_address

ps_customer
ps_customer_group
ps_customer_message
ps_customer_message_sync_imap
ps_customer_thread

ps_orders
ps_order_carrier
ps_order_cart_rule
ps_order_detail
ps_order_detail_tax
ps_order_history
ps_order_invoice
ps_order_invoice_payment
ps_order_invoice_tax
ps_order_message
ps_order_message_lang
ps_order_payment
ps_order_return
ps_order_return_detail
ps_order_return_state
ps_order_return_state_lang
ps_order_slip
ps_order_slip_detail
ps_order_slip_detail_tax

[DanielRomanMartinez]

Hello,

 

Yes sorry, to export/import orders you need export/import more information from another tables, exactly what tables? I don't know, let's wait for someone from PS Team.

 

I would like to know too... 

 

Btw, have you checked some module to import orders? Maybe exists and can help you... 

 

Dani.