+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: transfer ownership of a mysql database to another user (/thread-5676.html)
transfer ownership of a mysql database to another user - brianhenson - 02-11-2009 01:53 PM
is there a way to transfer a database from one user to another?
RE: transfer ownership of a mysql database to another user - pgentoo - 02-11-2009 02:43 PM
You can probably do this manually... Give this a try (on a test database/user first.
)- Edit the domain_id field of the corresponding record in the sql_database table, to change from the old domain, to the new domain.
I think this should work, but no promises.
-
pGentoo
RE: transfer ownership of a mysql database to another user - brianhenson - 02-24-2009 04:01 AM
it worked perfectly after doing it and reloading mysql. thanks
(02-11-2009 02:43 PM)pgentoo Wrote: You can probably do this manually... Give this a try (on a test database/user first.
- Edit the domain_id field of the corresponding record in the sql_database table, to change from the old domain, to the new domain.
I think this should work, but no promises.
-
pGentoo
RE: transfer ownership of a mysql database to another user - sci2tech - 02-24-2009 04:50 AM
You need to also transfer any users added to this database
