New install - different host - fine until database

[Lyon]

Hi all, I am moving a working ZenCart to a new host. I have both installs in the most recent version. Everything was going fine until I dropped my (new) database and tried to replace it with my (old) database.

When I try and use the fix cache key I get this error message.

1146 Table 'han082780907019a.zenconfiguration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from zenconfiguration]


I have no clue what it means or how to fix it.

When I go to the admin area I get this error code:
1146 Table 'han082780907019a.project_version' doesn't exist
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


And the store front shows this error code:
1146 Table 'han082780907019a.zenconfiguration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from zenconfiguration]

I am a sql newb and really need some help. I have been at this all week with no joy.

[DrByte]

You probably have skipped the step about preserving the right table prefix (DB_PREFIX) as mentioned in the FAQ on moving to a new server: https://www.zen-cart.com/tutorials/i...hp?article=100

[Lyon]

You probably have skipped the step about preserving the right table prefix (DB_PREFIX) as mentioned in the FAQ on moving to a new server: https://www.zen-cart.com/tutorials/i...hp?article=100

Thanks. Is there any way to fix it without starting from scratch?

[DrByte]

Set the DB_PREFIX on the new server to match the one on the old server.
Or, manually rename the hundred or so tables by hand.

[2004g35]

just want to make sure I understand before I start - I am moving DB's and my site to another server and I want to lose the zen_ prefix I put in ages ago. My two config files need to lose the zen_ prefix and then I need to manually rename my 100 tabels - leaving off the zen_ prefix - right? Is there a quick sql patch that just renames everything for me? Thanks in advance for your help

[DrByte]

In the zc_install process you use for installing and upgrading, there is a prefix-rename option on the database-upgrade screen.