Hi, I know this has been asked a few times already. BUT, I went and signed up for annual hosting only realising that I get access to only 2 mySQL DB's afterwards. I am planning on hosting more than 1 blog, (though I wanted to move my current one from Blogger to my own server... Now, it seems like I can't use WordPress for more than 1 blog at a time. Is this true? And, if so, what would people recommend...? Thanks. Sorry, and feel free to kick my ass if you're sick and tired of seeing this question...
I'm not sure and couldn't find it in my own WP quick, but I believe you can use one DB for multiple WP installations using a prefix... maybe someone can confirm this?
Yeah, you can have as many installations on one DB as you want with WordPress. Just change the prefix
yeah, install WP manually (not via cPanel) and give each installation a different prefix like wp1_ wp2_ etc
You can have one mysql database, but have several database applications. They don't need to be separated under mysql. You simply rename your tables or prefixes if running the same app. If you have a database with a table called fullabull, you can have another database with the same table called fullabull2. Most apps designed today allow you to name your tables uniquely: a few years ago hosts only allowed one mysql database., so if you had multiple apps, you had to do it this way. If you run 2 "databases" under one, if the tables are already unique, you simply use the same mysql login for both. If you have to rename tables, you do it in the backup .sql text file, and then reupload. Or when installing the new application.
ok. sorry for being such a newbie, but I haven't even installed WP yet. When you say add a prefix, where are you talking about? For example, is it: - Make directory wp1 - install WP with DB_ONE - Make directory wp2 - install wp with DB_ONE again? thanks.
sorry flawebworks, i was posting at the same time as you... I think I only have access to 2 DBs (running on the same DB application). I will have to double check though. In WP, can I point it to the new tables automatically. If this is all in the documentation already, I apologise...
I think the best you can do right now is just install WP and try. It wouldn't hurt, you can always delete everything if you screwed something up since you're just testing. If you try to install WP twice (or more), you should indeed point these installations to the same DB, but see to change the prefix somehow. Oh, I've done a little search for you. For wp2.0 you should check the file config.php, which has the line: // Change the prefix if you want to have multiple blogs in a single database. $table_prefix = 'wp_'; // example: 'wp_' or 'b2' or 'mylogin_' Code (markup): Make sure you make the wp_ part unique for every installation, preferably before you run the install script. Good luck!
thanks TMAN (and just-4-teens). Now THAT'S what I was looking for. that doesn't seem hard at ALL!!! Just another reason why i'm asking how easy this is is because I don't even have shell access on the server. (I know, I know, living in the dark ages here)... Unless this is the norm. Never worked on a pro website before. It was a christmas present to myself. WHAT A GEEK!!!
Well, it's not hard at all indeed, you just have to look into it If you've any other questions, feel free to ask around, that's what forums are for