The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Is it possible to only restore the databases from WHM?

Discussion in 'Database Discussions' started by Vliegtuig, May 27, 2010.

  1. Vliegtuig

    Vliegtuig Well-Known Member

    Joined:
    Jan 21, 2010
    Messages:
    74
    Likes Received:
    2
    Trophy Points:
    6
    One of our clients asked us to retrieve old database data which has been accidentally lost.

    Too save time, I prefer to use the WHM interface to restore an account backup, but it seems to have no option to restore ONLY the database and keep the home dir intact.

    Am I overlooking something? Also, I am wondering wether a homedir restore removed all new e-mails as well (since they reside in the homedir). So basically, these are the two questions:

    • Is there a way to restore only the database and keep the homedir intact?
    • Does restoring the homedir remove all new mail since the last backup?
    • If so, is there a way to restore the homedir without overwriting the mail dir?

    Any help would be greatly appreciated.

    Thanks in advance.
     
  2. serlex

    serlex Well-Known Member

    Joined:
    Oct 20, 2009
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    6
    I can't find any way of doing this via WHM, however you can achieve your goal via SSH:

    Code:
    mysql -u user_name -p user_dbname < filename.sql
    (you'll be prompted for the db user's password)
     
  3. serlex

    serlex Well-Known Member

    Joined:
    Oct 20, 2009
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    6
    Found on another post:

    To restore a database, please do the following:
    • Login to your control panel and click Backups.
    • Click the Browse button next to the option which says Restore a MySQL Database.
    • Select the .sql.gz file which you want restored.
    • Click the Open button and click the Upload button.
     
Loading...

Share This Page