By _dynamic on

Hi!
I'm new to database management, but I have set up a Drupal site locally and now I want to export it to my host on the web. I already set up another drupal site on this host, so there is already a database there. Is it possible to set up two different sites in subfolders and also have two different databases for them? I use PHPMyAdmin. When I have tried to import my local database, phpmyadmin tells me there is already a table with that name. (it seems it conflicts with the existing db). When I run the command "create database database_name" it tells me "#1044 - Access denied for user: 'username@localhost' to database 'database_name' "
Can I configure phpmyadmin so that I can create several databases?
It must be possible to have tables with the same name in different databases?

⋅ Categories: Drupal 5.x

Comments

halfer’s picture

halfer commented

That sounds like you have your connection credentials incorrect, not a problem with creating tables. Yes, it is possible to set up two different sites in subfolders - the docs look pretty good on this topic.

From memory I think you can squeeze multiple Drupal installations into the one database by setting a prefix parameter for your tables. However I may be wrong and I have never done this.