Hi pals,
Does anyone know any wordpress plugin to share the database for multiple websites?
![]() ![]() |
Are they separate installs? You can use a different suffix during the install, so change the wp_ to aa_ etc.
yes they are seperate installs.
i can change the prefix but then the will be using different database or different tables. I wanted to share the database. It means my multiple websites can use the same database and same tables.
helping others at evgenyk.nz
You need to tell us what you're trying to achieve rather than your proposed solution. Please also define what you mean by "share the database" - it seems you mean "use the same database tables", which AFAIK is not possible and would be a bad idea if it was possible.
You can do it, but you probably don't want to. As others have said, we need context.
To ensure you have the same content, you could have a "master" and pull into the rest via RSS or with something like https://github.com/wp-sync-db/wp-sync-db
If you do desperately want all the sites using one database, there are some wp-config settings you can use to override the database for site-specific settings like name, URL etc. But still, not recommended.
they/them
Prodigi - Optimised IT Solutions
WebOps/DevOps, Managed IT, Hosting and Internet/WAN.
danielfaulknor:
You can do it, but you probably don't want to. As others have said, we need context.
To ensure you have the same content, you could have a "master" and pull into the rest via RSS or with something like https://github.com/wp-sync-db/wp-sync-db
If you do desperately want all the sites using one database, there are some wp-config settings you can use to override the database for site-specific settings like name, URL etc. But still, not recommended.
I just want to have a single login for all my admins. But its not just that i also want to login at one place to get all my woocommerce orders ;)
nzwhiffy:
danielfaulknor:
You can do it, but you probably don't want to. As others have said, we need context.
To ensure you have the same content, you could have a "master" and pull into the rest via RSS or with something like https://github.com/wp-sync-db/wp-sync-db
If you do desperately want all the sites using one database, there are some wp-config settings you can use to override the database for site-specific settings like name, URL etc. But still, not recommended.
I just want to have a single login for all my admins. But its not just that i also want to login at one place to get all my woocommerce orders ;)
you are right i think better not to ;)
I might right a custom script to synch my wp users and woocommers order tables. This way whereever i login i will get same orders. I think that is easy instead of sharing everything.
cheers!
![]() ![]() |