If they live in different directories they don’t “bother” each other. I have about 5-6 different installs in different directories.
If you are going to use the same database for both, don’t forget to change the table prefix (from the default wp_) to something else!
Thread Starter
Nurice
(@nurice)
Where is the table prefix? Are you talking about in WP-admin or in MySQL? or PhpMyAdmin. I use CPanel and named the database different name than whatever default it offered in MySQL when I set it up. Is that what you are referring to?
WP has been my first experience with databases so I’m trying to figure it all out.
It is in your wp-config.php file.
// ** MySQL settings ** //
define('DB_NAME', 'wordpress'); // The name of the database
define('DB_USER', 'username'); // Your MySQL username
define('DB_PASSWORD', 'password'); // ...and password
define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value
// You can have multiple installations in one database if you give each a unique prefix
$table_prefix = 'wp_'; // Only numbers, letters, and underscores please!
Thread Starter
Nurice
(@nurice)
Ok sounds great. I see the stuff I entered in MySQL when I set it up there also.
So if I changed it to wp1 would my admin login still be http://myblog/wp-admin or would it change to http://myblog/wp1-admin?
Also, would I have to log into http://myblog/wp-config and reconfigure anything after I changed it, or am I done after I change the table prefix in wp-config and upload?
Sorry so many questions, this is all new to me. Thanks for your help.
OK, so you have one blog that is in a database and –
supposedly – is using the default wp_ prefix.
This blog, let’s say, lives at
example.com/blog
As I stated above: If, and only if you are going to install the second blog in the same database (for example, when the host gives you only 1 database), then before installing the second you will have to put your info into the config file of the second blog, so you’ll be using something like wp1_
and this blog will live at
example.com/wordpress
I repeat, if you have lots of mysql databases in your hosting package, forget this whole stuff, put them in different databases.
Even if you have the two blogs that HAVE to have the files installed in different directories, the login or admin won’;t be as you wrote, but like this:
example.com/blog/wp-admin/
example.com/wordpress/wp-admin etc.
And a final note: if you have 2 blogs that means 2 times all the files uploaded to your server, including the wp-config.php file. If you have 10 blogs = ten wp-config files, one in every directory.
Thread Starter
Nurice
(@nurice)
Ok I think I got it. I don’t have to change anything with my existing blog, but would need to change the wp-config for the second blog before I installed it if in the same database.
I think I may have more than one database allowed at that domain, will check and see first.
You’ve been a great help! Thank you.
If you are using any permalink rules for managing urls, you could end up with a conflict if you nest an *actual* directory inside your WordPress install. Just be careful…
i was wondering what the advantage or disadvantages were in doing separate installs with a shared database vs separate databases? like how it will affect processing more to have it in the same database, etc?
