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!

backup all the databases when mysql is not running

Discussion in 'General Discussion' started by ukagg, Aug 7, 2011.

  1. ukagg

    ukagg Active Member

    Joined:
    Aug 14, 2002
    Messages:
    35
    Likes Received:
    0
    Trophy Points:
    156
    Hi,

    My hard disk has gone bad and data center has rebooted the server in single user mode with only networking and ssh enabled (that means mysql is not running). Then I backed up all the accounts to secondary drive using following command:-

    /usr/local/cpanel/scripts/cpbackup --force

    But, now I find all the account backups are missing mysql databases backups.

    Please advice how can I backup the mysql databases of all the users.

    Regards
    Umesh
     
    #1 ukagg, Aug 7, 2011
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,606
    Likes Received:
    33
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    You will have to copy the files and hope they are intact:

    Code:
    cp -R /var/lib/mysql /pathtootherdrive/mysql
    Other than either copying them to the new drive or scping them to another server, there isn't much choice here. If MySQL isn't running, a dump file cannot be created for each database.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelTristan, Aug 8, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - backup databases mysql
  1. keat63

    Backup all MySQL Databases?

    keat63, Feb 27, 2019, in forum: Data Protection
    Replies:
    13
    Views:
    382
    cPanelMichael
    Mar 4, 2019
  2. VJIADIS

    mysql databases (only) backup

    VJIADIS, Jan 18, 2018, in forum: Data Protection
    Replies:
    1
    Views:
    741
    cPanelMichael
    Jan 19, 2018
  3. pseudofluous

    Isolate databases from transferred backup

    pseudofluous, Sep 8, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    246
    pseudofluous
    Sep 12, 2018
  4. sp3ctre69

    System backup & databases

    sp3ctre69, Aug 15, 2017, in forum: Data Protection
    Replies:
    4
    Views:
    812
    Ekushey
    Aug 15, 2017
  5. 2Pro4u

    Would a backup of the cPanel partition be enough if mysql upgrade goes wrong?

    2Pro4u, Apr 15, 2019 at 3:11 PM, in forum: Database Discussion
    Replies:
    1
    Views:
    60
    cPanelMichael
    Apr 17, 2019 at 10:39 AM

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.
    Accept Learn More...
    Dismiss Notice