ispCP - Board - Support
migration - adding existing databases - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Migration (/forum-35.html)
+--- Thread: migration - adding existing databases (/thread-10441.html)

migration - adding existing databases - zydoon - 04-18-2010 05:47 PM

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.

RE: migration - adding existing databases - BeNe - 04-19-2010 03:54 PM

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

RE: migration - adding existing databases - zydoon - 04-19-2010 05:34 PM

Yeah, that's what I did, and it's working, but it's better to have everything in place Smile 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 Smile

RE: migration - adding existing databases - kparzinger - 05-26-2011 05:31 AM

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

RE: migration - adding existing databases - aseques - 05-26-2011 04:08 PM

(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/doku.php?id=dev:daemon_commands_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.

RE: migration - adding existing databases - kparzinger - 05-27-2011 02:04 AM

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