Linux install template- import old datase

[awebb-designer]

I am upgrading the database again.
SKIPPED: Cannot drop index page_accessed on table admin_activity_log because it does not exist.
SKIPPED: Cannot drop index access_date on table admin_activity_log because it does not exist.
SKIPPED: Cannot add index idx_page_accessed_zen to table admin_activity_log because it already exists.
SKIPPED: Cannot add index idx_access_date_zen to table admin_activity_log because it already exists.

[awebb-designer]

I am back where I started yesterday? Please help

[awebb-designer]

I did a clean install with my old database and not of the information came through?

[DrByte]

The product is contained in the database tablenames which match the pattern of (DB_PREFIX value) + 'products'
Same with product descriptions: DB_PREFIX value + 'products_description'

So, if your old site has DB_PREFIX set to '' then the data is in a table named 'products'.
If your old site has DB_PREFIX set to 'zen_' then the data is in a table named 'zen_products'.
If your old site has a DB_PREFIX set to 'fred_' then the data is in a table named 'fred_products'.

Thus, if your NEW store isn't using the SAME setting for DB_PREFIX in BOTH your admin and non-admin configure.php files, it will look like your data is missing ... because it's not present in the tables you're telling it to look in.