Swapped host, now "zen_db_cache' doesn't exist" error

[travellers]

I'm having a 'mare getting my zencart to work having moved my domain to a different host, culminating in the following error:

1146 Table 'shedtrad_zc1.zen_db_cache' doesn't exist
in:
[db_cache table]

So I did a bit of searching on here and came across a couple of threads which pointed me at the configure files in 'includes/' and 'admin/includes'. The error says that "zen_db_cache" doesn't exist and its right, it doesn't. But "db_cache does exist (i.e. no prefix). Hmmm. The thread indicated then that I'd need to remove the "zen_" from define('DB_PREFIX', but here's the rub - there is no prefix set there in either file!

I did make a further mistake in not noting down whether my database was called 'store' or 'shop' on my old installation, and because the domain has moved I haven't got that for reference anymore, but I dealt with that by creating blank databases with both names and importing my database files into each of them, so I should be covered regardless! So I now have three identical databases, called zc1 (the auto-installed one when I used Fantastico to create me a new zencart), shop, and store.

Any advice on what to try next? Pretty please?

[travellers]

Just a quick expand on the above;
Since the define('DB_PREFIX', ''); is already blank, but the error at the site URL still indicates "zen_db_cache' doesn't exist", I thought I'd check whether anything did change there if I modified the PREFIX line. So I inserted "wibble_" in both files and saved them, then rechecked the URL. I thought that should change the error from

1146 Table 'DOMAIN_zc1.zen_db_cache' doesn't exist
in:
[db_cache table]

to

1146 Table 'DOMAIN_zc1.wibble-zen_db_cache' doesn't exist
in:
[db_cache table]

but it didn't, the error is still the same either way. How come?!

[fairestcape]

Have you run FIX CACHE KEY file?

See Free Add Ons for fix_cache_key.php

[travellers]

Have you run FIX CACHE KEY file?

See Free Add Ons for fix_cache_key.php

Generates the exact same error as above

[Merlinpa1969]

you have 2 choices
1 edit the config files and lose the zen_ in the db prefix

or run the installer and choose update and add the db prefix....


it is obvious that you grabbed the wrong database when you moved,

Im hoping that it wasnt a live store.

[travellers]

you have 2 choices
1 edit the config files and lose the zen_ in the db prefix

Cant - as I said above, the prefix is already blank

  define('DB_PREFIX', '');

or run the installer and choose update and add the db prefix....

Cant do that either - I reuploaded the zc_install and ran that, and was told

Previous Zen Cart™ Installation Found
However, the version level of your database cannot be determined, usually resulting from wrong table prefixes, or other database settings mismatches.

CAUTION: Only use the Upgrade option if you are sure your configure.php settings are correct.

so am not given an option to upgrade, only overwrite!

it is obvious that you grabbed the wrong database when you moved,

Im hoping that it wasnt a live store.

No, it wasn't live, it was about to go live when I decided to move to a better host first. There was only one db though, so I cant really have grabbed the wrong one!