Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Move a database from one account to another

Discussion in 'Database Discussion' started by Abbas, Oct 26, 2008.

  1. Abbas

    Abbas Member

    Dec 12, 2002
    Likes Received:
    Trophy Points:
    We've shifted our forums from one domain to another and thus I need to move the forums database from account1 to account2. What would be the easiest/fastest way to accomplish this?

  2. JawadArshad

    JawadArshad Well-Known Member

    Apr 8, 2008
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    DataCenter Provider
    - You can download your databases via cPanel >> Backups and restore them on the destination.

    - You can create dumps of databases on the source server, transfer them over to the destination server and restore them. Here are the steps.

    Login via SSH

    1- go to /var/lib/mysql
    2- mysqldump dbname > dbname.sql
    This will create the database dump
    3- scp dbname.sql root@hostname:/var/lib/mysql
    4- Create empty database on destination using command.
    mysqladmin create dbname
    5- mysql dbname < dbname.sql
    to restore the database dump

    Make sure the version of MySQL are same on both sides and you know your way around Linux. If you do not have root access, simply download the database dumps from cPanel >> Backups, upload them on the destination and ask your host to restore them.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 JawadArshad, Oct 29, 2008
    Last edited: Oct 29, 2008

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice