Results 1 to 4 of 4
-
09-03-2007, 01:43 AM #1Aspiring Evangelist
- Join Date
- Mar 2001
- Posts
- 357
How do I change database owner from beta account to live account
In moving my site to Drupal, I have had it on a "Beta" account on the same server. I need to move the DB to the "Live" site. How do I re-assign it using the master PHPMyAdmin through WHM to change the owner of the DB from "Beta site" to "Live site"?
Thanks
-
09-03-2007, 01:50 AM #2Web Hosting Master
- Join Date
- Oct 2004
- Location
- Kerala, India
- Posts
- 4,771
Assuming you have done the configuration part on the new site.
Make a database on the new site. Restore the database from the earlier database dump file. Create the user with the same password as earlier from the cpanel mysql area of the new site. Add the user to the new database. There you go.David | www.cliffsupport.com
Affordable Server Management Solutions sales AT cliffsupport DOT com
CliffWebManager | Access WHM from iPhone and Android
-
09-03-2007, 01:51 AM #3Aspiring Evangelist
- Join Date
- Mar 2001
- Posts
- 357
The long route, I just though there was an easier way.
-
09-03-2007, 01:58 AM #4Web Hosting Master
- Join Date
- Oct 2004
- Location
- Kerala, India
- Posts
- 4,771
You create a new database user in the beta site and add that user that database and supply those values in the new site conf file. Here the database used by the new site will be the same database.
David | www.cliffsupport.com
Affordable Server Management Solutions sales AT cliffsupport DOT com
CliffWebManager | Access WHM from iPhone and Android