I need help with a very basic question. I want to have 6 ccTLD domains for one site, all hosted in the same server. THese will be domain.com, domain.it, domain.de and son on. For easier administration, I would like to have one database serving all 6 sites, so that: 1. When people enter their data in any of the sites, is is all archived in the same database. 2.When I update the database that feeds the web page, I need only to update one database & not all 6 of them. Is this possible? Are there any drawbacks to this apporach?
It probably depends on the server. Ask your web host. Though it's probably as easy as on each domain in the settings, use the same info for the same database. The mySQL database isn't even located on the domain.
Than you Nintendo. I understand then that it should be quite easy. I do not have the web page created yet so I have the chance of choosing a web host that can give me this service. I understrand then that the maintenance of the web page (updating the database that feeds the web page) and working with the clients who log is would be basically the same, independently if I have one domain (in 6 languages) or one domain which is different for each language. Is this correct? Anything I am not considering?
It'll be no problem. Just use the same dbase name,userid, and password for the programs on all 6 domains. If you need to track the data in one database, but seperately, one of the things I've seen done is to use different table names; like domain1_table1 and domain2_table1, where the first contains data from the first site, the second table contains the same data that came in from the second domain.
Wheel. Thank you for your comments & help. I understand then that I could work with 1 database for the 6 domains & this should not have any disadvantage from working with one database for 1 domain.
You can use same DB only if cPanel is installed on the server. As cPanel uses localhost as mysql Host.
This I can speak from experience. 1. You shouldn't have too many problems if all the sites are hosted on the same machine(or have access to the machine). 2. Setup your system such that it does not flag a security/admin problem. My story. I create one db, and one user, and used the same user across several domains. Because that one user was heavily used, it flagged the hosting provider as a possible db-abuser. Meaning I wasn't fairly sharing resources on a shared server. So the domain hosting the db was shut down. Being that was my centralized domain, meaning my email was on it too, I got no warning. After a few hours, things were cleared up. Moral of the story, if you share a server, you need to 'appear' like you are playing fairly. Maybe creating a separate user/password for each site, will help. imho, tom
Brother i have my own dedicated Running with cPanel installed in it. I'm using same DB same sql User, Same sql Password. You can't deny this fact like this without giving a proper reason for it.
Sure. Cpanel has absolutely nothing to do with it. You can do this with our without cpanel, the existence of cpanel on a server has nothing to do with how mysql operates. Saying 'only if cPanel is installed' is incorrect. The fact that cpanel 'uses localhost as mysql host' also has nothing to do with it either. In short, both the cpanel and the localhosts have absolutely nothing to do with the question from the OP. Which is why I said your post is wrong. Dude, you are ROOT!
Wanna see the example? b4 making fun as if i'm the root. Uh? But you havnt specified the reason why we can't use the same DB on more than one sites? lol Really man, it seems you have sme ego prob.
lol can i make 2 shared accounts for you so that you can check it yourself? haha I bet you will say no as your ego will cme in bet. lol or anyone wanna test this thing to prove if we can use same db and it's config for other domains too... hosted on the same server.
oohhooho! You put -ve reputation just i crossed your talk? lol i wont do these kiddish work.. 1. Talk sense. 2. Stop being like a kid. 3. Show some respect for others and try to listen what they are saying 4. You still havnt given the reason why we can't go for same DB for different websites. (Still Waiting for the reason).
Gentlemen, I believe you have both tried to help midi. Lets not let a difference of opinion derail the thread. It seems so much of what we can or can't do depends on how hosts configure their servers.
1. Create a database 2. Create a database user for each sites 3. Assign the database permission of all the user created to the created database 4. On the table add an id that would indicate which site it belongs You can do the database manipulation in the phpmyadmin provided by the cpanel. Google notes: Hope all of your site will not show duplicate contents since it has a single db or your doom. Else just use a server alias if you can configure your apache. Hope it helps.