Need help transferring database --> Database needs to be loaded onto 2 other sites.

[DrByte]

No, the 2 databases don't have to have the same "name". Just set the new server's name in the configure.php file. That would have already been done for you when you ran zc_install by following the FAQ I pointed you to earlier.

You're probably using different DB_PREFIX values on the different servers, thus causing the tables to not be found. The FAQ article also mentions this point as something to address during the move process. Maybe you missed that?

[Lockerroom]

No, the 2 databases don't have to have the same "name". Just set the new server's name in the configure.php file. That would have already been done for you when you ran zc_install by following the FAQ I pointed you to earlier.

You're probably using different DB_PREFIX values on the different servers, thus causing the tables to not be found. The FAQ article also mentions this point as something to address during the move process. Maybe you missed that?

Yes I did miss that. You are referring to this part here?

Store Identifier (Table-Prefix)

What is the prefix you would like used for database tables? Example: zen_ Leave empty if no prefix is needed.
You can use prefixes to allow more than one store to share the same database. more info...

So as it stands right now...

In my cPanel I see my database it is called

locker_zc1

my database is locker and my prefix is zc1?

[DrByte]

No, the "prefix" would be the letters added to the beginning of all the names of your tables inside your database. It has NOTHING to do with the name of the database itself.

It's simple. Table names might be like this:
"address_book"
"customers"
"orders"

and if you have a "prefix" added to the beginning of those names, they might look like:
"myprefix_address_book"
"myprefix_customers"
"myprefix_orders"
... in which case your prefix would be "myprefix_" ... as shown in the DB_PREFIX setting in *that* server's configure.php files.

[Lockerroom]

No, the "prefix" would be the letters added to the beginning of all the names of your tables inside your database. It has NOTHING to do with the name of the database itself.

It's simple. Table names might be like this:
"address_book"
"customers"
"orders"

and if you have a "prefix" added to the beginning of those names, they might look like:
"myprefix_address_book"
"myprefix_customers"
"myprefix_orders"
... in which case your prefix would be "myprefix_" ... as shown in the DB_PREFIX setting in *that* server's configure.php files.

Awesome.

Okay now how do I go back and change the prefix after I've already installed Zen Cart.

I finally figured out what the problem is!

Thanks so much!

[DrByte]

Is there a reason not to install clean, using the right prefix, now that the light has come on?

[Lockerroom]

Is there a reason not to install clean, using the right prefix, now that the light has come on?

I already started a clean install.

Thanks.