Title: More than 1 WordPress/Database Last modified: August 18, 2016 --- # More than 1 WordPress/Database * Anonymous * [21 years, 10 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/) * Can I run more than 1 WordPress in a Database? If yes, how does it work? Thx, unleashed/Thomas Viewing 12 replies - 1 through 12 (of 12 total) * [Mark (podz)](https://wordpress.org/support/users/podz/) * (@podz) * [21 years, 10 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-80832) * Yes. Look inside wp-config.php, you will see ‘table_prefix’ By default, it says‘ wp_’ Change that to whatever you want, eg: wp1_ blog2_ Then just install 🙂 * [ccheaton](https://wordpress.org/support/users/ccheaton/) * (@ccheaton) * [21 years, 10 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-80834) * Actually, that’s just multiple blogs in the same database. If you want to run more than one database, then you just have to create a new database, but you can retain the same table prefix names. * [vohiyaar](https://wordpress.org/support/users/vohiyaar/) * (@vohiyaar) * [21 years, 10 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-80877) * ccheaton, as I understood the question too, Anon wanted to run multiple installations of WordPress in a single database. Podz has provided the correct solution for doing that. * [shadow](https://wordpress.org/support/users/shadow/) * (@shadow) * [21 years, 10 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-80879) * Now I am confused. Is it possible to use the same prefix names in two blogs then, thus allowing for two completely different blog styles using the same database content ? * [ccheaton](https://wordpress.org/support/users/ccheaton/) * (@ccheaton) * [21 years, 10 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-80883) * You’re right about the question. Sorry. Basically, there are two options: 1) Use the same database, and have 2 blogs with different table prefixes. 2) Use two different named databases (WordPress, WP2, for example) and then use the same table prefixes for both. I don’t know which is faster, but if the blogs aren’t both yours, it might be better to use two different databases, since when dumping the contents, etc… it will be easier to keep the data separate from the other blog. * Thread Starter Anonymous * [21 years, 10 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-80915) * Thx for the answer, as ccheaton said I want to have 2 or more WPs in one Database. Are there any limitations how many WPs I can put into a Database? * [Mark (podz)](https://wordpress.org/support/users/podz/) * (@podz) * [21 years, 10 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-80920) * Only your database size. I have run 6 in one db without any issue and I’m sure others have done similar. * [Root](https://wordpress.org/support/users/root/) * (@root) * [21 years, 10 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-80925) * @ shadow as I understand it the answer to your question is no. You can set up any number of index pages calling the same data from the same database. But the url for the comments and stuff will remain the same for all of them. You would therefore have multiple index styles but only one comment style. HTH. * [ccheaton](https://wordpress.org/support/users/ccheaton/) * (@ccheaton) * [21 years, 10 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-80930) * Well, all Shadow wants to do, it would seem, is to use multiple styles like Alex King does. Did he write the style switcher? I can’t remember. * Thread Starter Anonymous * [21 years, 10 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-80967) * Yes, there is a WP Style Switcher plugin on his site ([http://www.alexking.org/](http://www.alexking.org/)) * [shadow](https://wordpress.org/support/users/shadow/) * (@shadow) * [21 years, 10 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-80981) * Sorry, I was just asking a question based on the previous comments. I have no need for a style switcher. I already have one in use. Thank you 🙂 * [bilateral](https://wordpress.org/support/users/bilateral/) * (@bilateral) * [20 years, 11 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-81167) * hi, i have followed the instructions as given, changed the ‘table_prefix’ to wp_2, but when i try to configure the logins etc of my new blog at [http://myurl.com/wp-admin/install.php](http://myurl.com/wp-admin/install.php) i get an error message which reads “No input file specified.” any tips? Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘More than 1 WordPress/Database’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 12 replies * 7 participants * Last reply from: [bilateral](https://wordpress.org/support/users/bilateral/) * Last activity: [20 years, 11 months ago](https://wordpress.org/support/topic/more-than-1-wordpressdatabase/#post-81167) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics