Setting up on a new Server and I have a problem

[touchclothing]

I set up an already built zencart site on my server we are going to redesin the site but did not want to do it on the live site so I took the site and put it on my server. I set up a data base for it and I change the configure.php to match but now I am getting this error message:
1146 Table 'digitalm_vvip.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

[DrByte]

It cannot find your database tables.
Did you import them properly?
Do you have the correct DB_PREFIX setting on your new server as you did on your old server? If not, Zen Cart cannot find the tables it's looking for.

FAQ: https://www.zen-cart.com/tutorials/index.php?article=99

[touchclothing]

No I did not import the data base I just started a new one?

[touchclothing]

I read over the thread so what I need to do is a fresh install on the new server with a new data base and then take a back of the other data base and do a recover install on the new data base. But what if the new data base has a differnt name?

[DrByte]

But what if the new data base has a differnt name?

... then you use that new name in your configure.php files.

To keep it as simple as possible, just be sure to use the same "Table Prefix" in your new database when doing the zc_install step, as you had in your old database.

Then all you need to do is import the database content from old to new.
(as well as copying all the files over via FTP)

[touchclothing]

I have one other question Do I need to do the install or could I just load the site up and then change the configure.php to the new data base name and then do a restore for the data base? Or do I need to do a fresh install?

[touchclothing]

ok one last question what if I have more then one data base and I only want to restore one of them how do I do that?

[touchclothing]

Ok I did a back up of the old data base not how do I put it into the new data base? on a different server with a different data base name?

[touchclothing]

I guess this is that part that I can't get to work????

6- Using phpMyAdmin, restore your old site's database into the new database you created in step 4.

[DrByte]

I guess this is that part that I can't get to work????

6- Using phpMyAdmin, restore your old site's database into the new database you created in step 4.

This FAQ may help: https://www.zen-cart.com/tutorials/i...hp?article=103