Using same database for main and subdomain

admin管理员组

文章数量:1394173

I have a website let's say mysite (with it's own database that I created through plesk) and i have created a subdomain with the name sub.mysite.

After trying to install wordpress on my subdomain, I figured that I can't create a second database from Pesk as my hosting does no allow this through my subscription.

Can I use the same database that I use at mysite also to my subdomain, just creating a new database user, or I will destroy the current database?

I have a website let's say mysite (with it's own database that I created through plesk) and i have created a subdomain with the name sub.mysite.

After trying to install wordpress on my subdomain, I figured that I can't create a second database from Pesk as my hosting does no allow this through my subscription.

Can I use the same database that I use at mysite also to my subdomain, just creating a new database user, or I will destroy the current database?

• database
• subdomains

Share Improve this question edited Apr 4, 2020 at 11:00 fuxia♦ 107k3939 gold badges255255 silver badges459459 bronze badges asked Apr 4, 2020 at 10:56 CornholioCornholio 2122 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

Can I use the same database that I use at mysite also to my subdomain

Yes, as long as the table names don't clash you're fine, some people have multiple WP instances using the same database, but with different table prefixes.

However, keep in mind that there is a security risk as now 2 sites have access to eachothers data.

or I will destroy the current database?

If you run a destructive query yes! But why would you do that.

---

I don't think you have anything to fear here, but, it would be much easier to just create a local dev environment and test it out. This would give you the confidence and a practice run to do it in production

本文标签： Using same database for main and subdomain