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.

Restore ONLY a MySQL db without restoring anything else?

Discussion in 'Data Protection' started by sneader, Feb 20, 2009.

  1. sneader

    sneader Well-Known Member

    Joined:
    Aug 21, 2003
    Messages:
    1,145
    Likes Received:
    31
    Trophy Points:
    178
    Location:
    La Crosse, WI
    cPanel Access Level:
    Root Administrator
    I have a customer that deleted a MySQL db from cPanel, by accident. They would like that db restored from the daily backup, but they don't want the rest of their directory overwritten or mail overwritten.

    In the "Restore Backup" in WHM, you can uncheck "restore mail config" which I believe will leave e-mail untouched. And you can check/uncheck Restore MySQL dbs if you want to control whether MySQL dbs are restored.... but is there any way to just do the MySQL dbs without restoring anything else?

    Also, for future reference, is there a way to restore only a SINGLE MySQL db, without restoring ALL dbs?

    - Scott
     
    #1 sneader, Feb 20, 2009
  2. hzJayJ

    hzJayJ Well-Known Member

    Joined:
    Nov 14, 2008
    Messages:
    76
    Likes Received:
    1
    Trophy Points:
    58
    You can run the command to restore the database from the backup sql file through the shell

    mysql database_name < database_name.sql
     
    #2 hzJayJ, Feb 20, 2009
(You must log in or sign up to post here.)
Loading...
Similar Threads - Restore MySQL without
  1. Naila

    Mysql Always Restarting During Full Backup Restore

    Naila, Jun 20, 2017 at 7:42 AM, in forum: Database Discussions
    Replies:
    4
    Views:
    57
    Naila
    Jun 22, 2017 at 1:35 PM
  2. djbaxter

    SOLVED The MySQL restore process died from the “SEGV” signal.

    djbaxter, Mar 11, 2017, in forum: Data Protection
    Replies:
    8
    Views:
    1,157
    cPanelMichael
    Apr 4, 2017
  3. cornishman33

    Restore Database From Remote MySQL

    cornishman33, Oct 7, 2016, in forum: Data Protection
    Replies:
    1
    Views:
    308
    cPanelMichael
    Oct 11, 2016
  4. gnusys

    cPanel account restore does not work for remote mysql profile

    gnusys, Feb 6, 2016, in forum: Database Discussions
    Replies:
    3
    Views:
    683
    cPanelMichael
    Feb 8, 2016
  5. urgido

    problem with mysql on restored process from cpmove file

    urgido, Aug 22, 2015, in forum: Database Discussions
    Replies:
    9
    Views:
    785
    cPanelMichael
    Sep 4, 2015

Share This Page