SQL DB migration from Dev to LIVE is missing my edited Shipping Policy

[jaysbar]

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

[Basara]

Hello

All data is stored in the Database so make sure you export database correctly and clear AbanteCart cache after import

[jaysbar]

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.
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.

[Basara]

How did you export database? What tool you use

[jaysbar]

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.

[Basara]

Try to drop database manually before import