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.

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,622
    Likes Received:
    24
    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.
     
    #2 cPanelTristan, Aug 8, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - backup databases mysql
  1. kavos1332

    cPanel does not backup MySQL databases

    kavos1332, Oct 14, 2016, in forum: Data Protection
    Replies:
    3
    Views:
    578
    cPanelMichael
    Oct 14, 2016
  2. Dhaupin

    Renaming databases in phpMyAdmin leading to backup failures

    Dhaupin, Apr 10, 2017, in forum: Data Protection
    Replies:
    2
    Views:
    147
    Dhaupin
    Apr 13, 2017
  3. furquan

    Backup databases multiple times a day

    furquan, Apr 9, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    276
    cPanelMichael
    Apr 10, 2017
  4. Abdelmks

    SOLVED Make backup only for databases

    Abdelmks, Mar 21, 2017, in forum: Data Protection
    Replies:
    3
    Views:
    381
    cPanelMichael
    Mar 23, 2017
  5. Tornado

    Partial Failure Error with Backup

    Tornado, Jul 20, 2017 at 2:16 AM, in forum: Data Protection
    Replies:
    5
    Views:
    40
    cPanelMichael
    Jul 20, 2017 at 9:36 AM

Share This Page