tags:

views:

18

answers:

1
Q: 

can I have one db for multiple wordpress sites but multiple wp codes/installations

I need

  • few Wordpress sites for testing purposes.
  • It would be great if I can use only one db
  • but I need few wordpress codes/instalations (because I need different settings and plugins for each site.

Can I have all that running on one mySQL db? Would use the same db_name, db_user, db_password, etc… and the only thing I change for the every other blog is the prefix?

+1  A: 

It should be perfectly possible. when you setup wordpress there's a field to specify the table prefix (default is wp_) when setting up the database. These settings are also stored in wp-config.php

jay.lee  2010-09-23 08:01:16
so if I change the prefix `wp_` to something else it will do the job?
Radek  2010-09-23 10:36:06
yes, just use a different prefix for each installation. However, if you have a plugin that creates DB tables without using the prefix you may encounter some problems.
jay.lee  2010-09-23 16:14:03
you mean without the correct prefix? so it could happen that plugin from xyz site would write to yyy site database :-)
Radek  2010-09-23 23:50:17
I meant that some plugins create their own database tables (separate from WPs) and they may disregard the prefix. So having multiple installs of the plugin on the same DB may result in them all pointing to the same place.
jay.lee  2010-09-24 00:29:22
cool, thank you for the clarification. I like your avatar.
Radek  2010-09-27 00:44:30

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL