Question How to assign databases to a domain manually

[onki]

Server operating system version

ubuntu 20.04

Plesk version and microupdate number

17.8

Hi,

Is there a procedure to assign a database manually to a domain?
There are several databases on my Plesk server that are not assigned to a domain and so the cannot be found easily.

Best regards
Onki

 

[Nikolay]

Hi,
If a database is created via Plesk and registered in Plesk under a subscription, you can link DB to a domain as follows:
- browse to Domain > Databases page in Plesk
- there is a drop-down menu 'Related to' against databse name
- select a domain that you would like to link with a particular database

If a database is created directly in SQL console and Plesk is not aware of its existence you can try the following:
- create a dump of the database
- delete it from the server
- then log into Plesk, browse to subscription you need, databases and create a database with the same name
- use Import Database option to import data

For this procedure, I would recommend to test it with some dummy database first.
Also, you can avoid removal of existing database, just create dump, create a new database in Plesk with new name and import data

 

[harmut]

Side question: Which reason is there to use "Assign this database to a site"? Is it only for keeping track and not get confused? I have a database which is used by a subdomain, but in /smb/database/list/ is shown "Assign this database to a site". Can I change this assignments which any technical consequences to the site?

 

[Kaspar@Plesk]

Is it only for keeping track and not get confused?

Yes

Can I change this assignments which (without?) any technical consequences to the site?

and yes