Results 1 to 4 of 4
  1. #1

    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

  2. #2
    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

  3. #3
    The long route, I just though there was an easier way.

  4. #4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •