How do I separate databases?

  • Answered
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?
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