migration - adding existing databases

[zydoon]

Hi,

I installed ISC-CP on an existing hosting server.
so far so good, everything is running as visitors expect, but the webmasters need more.

actually, the want to see their respective databases on their account. of course the databases axists already and runinng fine.

any idea to assign them ?

kind regards,
Zydoon.

[BeNe]

Quote:the want to see their respective databases on their account

In ispCP directly ? mmmhhh tricky...
As a workaround, give the Webmaster the right to the DB´s and he can use PHPMyAdmin.

Greez BeNe

[zydoon]

Yeah, that's what I did, and it's working, but it's better to have everything in place isn't ?

I tried something, I went to raw sql and assigned to DBs and DB_users to ISPCP users, it's a risky business, should be very carefull. And finally it's cool, just as I wanted to be

[kparzinger]

Hi, i can understand this problem. Following case on myself:

I installed some webpages and sql databases and any else what is needed. To administrate manually i don`t have the time and now i installed ispCP.

Yeeeeaaahh is the best i ever saw but:
- I registered all users and domains i had
- I moved all webpages to the right place on var/www/virtual...
- The old SQL databases are working fine

But is there a possibility to link the existing databases to the new users?

For example:

domain.de --> link to sql database dom_db (created earlier without ispCP).

A other solution is to export the content, delete the database, recreate the datase and import the data. Its very bad :-(

Please help me, if possible...
BR Klaus

[aseques]

(05-26-2011 05:31 AM)kparzinger Wrote:  Hi, i can understand this problem. Following case on myself:

I installed some webpages and sql databases and any else what is needed. To administrate manually i don`t have the time and now i installed ispCP.

Yeeeeaaahh is the best i ever saw but:
- I registered all users and domains i had
- I moved all webpages to the right place on var/www/virtual...
- The old SQL databases are working fine

But is there a possibility to link the existing databases to the new users?

For example:

domain.de --> link to sql database dom_db (created earlier without ispCP).

A other solution is to export the content, delete the database, recreate the datase and import the data. Its very bad :-(

Please help me, if possible...
BR Klaus

If you want, you can use my domain.php scripts: http://isp-control.net/documentation/dok...mmands_cli that's what I used a long time ago to move from plesk to ispcp and I am mantaining them with current versions too.
.- domain.php --action create_db will trigger the creation process of the database (inserting into ispcp structure and granting the proper privileges)
.- domain.php --action create_db_user you create new users into ispcp.

[kparzinger]

Good to know, yesterday i moved it manually, but i keep this script for the future. Its possible that i can need it. Thanks.