AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: jaysbar on September 06, 2016, 12:24:18 PM

Title: SQL DB migration from Dev to LIVE is missing my edited Shipping Policy
Post by: jaysbar on September 06, 2016, 12:24:18 PM
Hi

I edited my Returns, Shipping and Privacy policy. I migrated the DB from Test/Dev to LIVE. Everything is fine except my Shipping Policy has not migrated. Is this part of SQL or in a separate file somewhere?

My shipping policy on the LIVE site still has the default "Some description" header.

Thanks
Title: Re: SQL DB migration from Dev to LIVE is missing my edited Shipping Policy
Post by: Basara on September 07, 2016, 02:36:23 AM
Hello

All data is stored in the Database so make sure you export database correctly and clear AbanteCart cache after import
Title: Re: SQL DB migration from Dev to LIVE is missing my edited Shipping Policy
Post by: jaysbar on September 07, 2016, 02:50:12 AM
Hi Basara

This is the 2nd time my export and import has missed out changes.

Just for reference, here are my findings:

1. Export DB from Test site (Abantecarte 1.2.7 which was upgraded via the Admin GUI to 1.2.8)
2. Import DB to my LIVE site which was a clean install of 1.2.8.
3. Clear all cache on LIVE site
4. A banner which is set to OFF is still displaying on my Storefront (so I manually switched to ON then OFF)
5. My Shipping Policy is missing some lines on the Storefront. But in Admin it looks perfect. So I manually edit by adding a word and deleting the word, save, then it appears perfect on my Storefront.

Title: Re: SQL DB migration from Dev to LIVE is missing my edited Shipping Policy
Post by: Basara on September 07, 2016, 03:53:14 AM
How did you export database? What tool you use
Title: Re: SQL DB migration from Dev to LIVE is missing my edited Shipping Policy
Post by: jaysbar on September 07, 2016, 05:42:21 AM
Hi Basara

I always export and import my database using PHPAdmin. Inuse the default settings and export as a .sql file.

In then drop ALL tables and import.
Title: Re: SQL DB migration from Dev to LIVE is missing my edited Shipping Policy
Post by: Basara on September 07, 2016, 06:00:10 AM
Try to drop database manually before import