Actually, it looks like this is the problem: I already have WordPress in use on the one domain. In the instructions, I see this tidbit:
“If you have only one database and it is already in use, you can install WordPress in it – just make sure to have a distinctive prefix for your tables, to avoid over-writing any existing database table.”
Can someone please translate into non-techie language — what tables and how and where do I give them a prefix?
thanks!
Nevermind, I finally found the info. In case anybody else is looking, it’s here: http://codex.wordpress.org/Installing_Multiple_Blogs
you should use different databases for different domains, how ever if you want to use same database you should change the table prefix in wp-config.php. give different table prefix to each of your wordpress blogs.
in your wp-config.php, you will find these lines where you will enter the name of user and database and password.
define('DB_NAME', 'wordpress'); // The name of the database
define('DB_USER', 'username'); // Your MySQL username
define('DB_PASSWORD', 'password'); // ...and password
below few lines there will be
$table_prefix = 'wp_';
change it to acc. to your preference like
$table_prefix = 'wp1_';
$table_prefix = 'wp2_';
$table_prefix = 'xxx_';
table prefix are used to store the content you upload while writing posts and pages and if you keep same prefix it will mess up with other blog’s database tables.
just remember to give different name to different blog
its up-to you if you wanna use same user-name or different.
oh! when you posted the comment, i think i was busy writing it