How do I separate databases?

Category: Databases

dearpete
Asked:
2013-07-05 12:25 pm EST

Hits: 827
I have a main account which I use for a blog for work. Other people have access to this site. I have an add-on domain that I use for a personal blog. I don't want the two databases mixed. How do I create a new database for the personal blog?

You must login before you can ask a follow up question.

You must login before you can submit an answer.

Oh, I think I figured it out. Disregard the question unless someone has an answer for renaming a database.
dearpete
13 Points
2013-07-05 12:56 pm EST
Hello dearpete,

In order to rename a MySQL database you'd first want to export your database via phpMyAdmin, then you'd want to create a new MySQL database with the new name you'd like to use, and finally you'd want to import your database via phpMyAdmin into the newly created database.

After that's been done, you'd typically need to go back and update any config files with the newer database name, confirm it all works, and then you can remove the original database you didn't like the name of.

Please let us know if you need anything else.

- Jacob
JacobIMH
9,968 Points
2013-07-05 01:04 pm EST

OTHER ANSWERS

0

JacobIMH
Staff
9,968 Points
2013-07-05 12:58 pm EST
Hello dearpete, and thanks for your question.

More than likely your blogs are already being stored in separate databases. As you probably already have installed two copies of your CMS (Content Management System) of choice, one in your main domain's directory, and one in your add-on domain's directory.

If this isn't the case, and they are both currently storing to the same database for some reason. Depending on the CMS you are using, you'd typically need to install a fresh copy for your personal blog, export the data from your shared database, and then import it into the new separate one.

In order for us to better assist with this question, if you could please let us know what CMS you're currently using, and if you login to cPanel and under the Databases section click on MySQL databases, do you already see multiple databases setup? That would be a good indication to see if the two blogs are sharing a database or have separate ones already.

Please let us know if you have any further questions at all.

- Jacob

You must login before you can post a comment about this answer.

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!