Change Db Name

[Henrietta]

Is it possible to change the name of a database and how it connects from my website?

 

I am not sure if that is the correct term for what I want to do. I have a zen cart which 'got lost' in our server move. I loaded a new cart with a slightly different name and started stocking it. Then my original cart came back. I would like to use the newer cart for a different project but don't want confusion on its name.

 

Site is:

 

www.200westmain.com

 

original cart:

www.200westmain.com/thefrontroom

 

replacement cart:

www.200westmain.com/frontroom

which I would like to change to something completely different.

 

I am not terribly tech literate so instructions need to keep that in mind. If it is too difficult I can delete it and start over. Thank you!

[TCH-Bruce]

What you are describing are URLs (web addresses) to access your cart where "thefrontroom" and "frontroom" are subfolders in your account.

 

You can create another subfolder and copy the contents of the "frontroom" folder into it.

 

Your configuration file tells your cart which database to use and how to connect to it. Your database name would be something like your-cpanelname_name-of-database.

 

You configuration file for the cart would have variables pointing to the database.

 

>BDNAME="your-cpanelname_your-database";
USER="your-cpanelname_user";
PASSWORD="password-for-above-user";
HOST="localhost";

 

There could be other variables in your configuration file but those are the ones controlling access to the database.

[TCH-Bruce]

More thoughts on your folder names. If you did not create them as subdomains you can simply change the name of the folder using the file manager in cPanel. Of course you would have to change any links going to the cart.

 

And if you really want to change the database name, you can open a ticket with the help desk and ask them to change it for you. But you will have to modify the configuration file to be able to access it.

[Henrietta]

What you are describing are URLs (web addresses) to access your cart where "thefrontroom" and "frontroom" are subfolders in your account.

 

You can create another subfolder and copy the contents of the "frontroom" folder into it.

 

Your configuration file tells your cart which database to use and how to connect to it. Your database name would be something like your-cpanelname_name-of-database.

 

You configuration file for the cart would have variables pointing to the database.

 

>BDNAME="your-cpanelname_your-database";
USER="your-cpanelname_user";
PASSWORD="password-for-above-user";
HOST="localhost";

 

There could be other variables in your configuration file but those are the ones controlling access to the database.

 

Thank you Bruce for your clear, concise and easy to understand reply!

 

BIG eHUG

[TCH-Bruce]

You're welcome