InMotion Hosting Support Center

How do I separate databases?

Category: Databases

2013-07-05 12:25 pm EST

Hits: 869
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.
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
9,968 Points
2013-07-05 01:04 pm EST



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?

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Need more Help?


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:
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!