Assuming your host allows a database to be accessed from different domains, then essentially just need to use a different $table_prefix in the wp-config.php for each domain’s WordPress installation.
See Installing_Multiple_Blogs for details.
Thread Starter
hayem
(@hayem)
All my sites are with 1and1.
which part do i have to change
$table_prefix = ‘wp_’
what else do I need to change?
all the file names wp_ and folders wp_ ?
Thank you
Does each site have a different database? And now you want to put all the tables for all the sites in one database?
Thread Starter
hayem
(@hayem)
can all domain names on the same hosting access the same database?
if yes what do I have to change?
They can access the same database (if the host lets you) but they can NOT access the same tables.
Sometimes try to answer the questions before you go further!
You’ll need to ask your host that question.
But if they say yes, and you are going to put the WordPress files for all the domains in one database, you’ll need to change the prefix for each domain. This tool may help with that: http://blogsecurity.net/wordpress/tool-130707/
Of course you’ll need to change the $table_prefix accordingly for each WordPress install.
Please make backup copies of your databases before doing anything. Don’t ignore this suggestion, please. See WordPress Backups.
Thread Starter
hayem
(@hayem)
thank you guys for your help.