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.

In a bit of panic, MySQL has not been backing up!

Discussion in 'General Discussion' started by WebJIVE, Sep 30, 2010.

  1. WebJIVE

    WebJIVE Well-Known Member

    Joined:
    Sep 30, 2007
    Messages:
    53
    Likes Received:
    3
    Trophy Points:
    8
    OK, I'm in a bit of a panic here because cPanel was set to Entire MySQL Directory and I can't locate ANY mysql backup data. HELP!

    I use ftp as the remote backup type and when I checked the daily dir, the individual account backups were there but, when you decompress them, no MySQL data.
     
  2. prashant_ohol

    prashant_ohol Active Member

    Joined:
    Nov 22, 2004
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    In this case please open the support ticket with cPanel.



    Regards,
    Prashant
     
  3. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Check backup logs

    The cpbackup logs are stored in /usr/local/apache/logs/cpbackup. There will be one log file for each cpbackup run. Check the logs for MySQL-related errors. There should be some indication as to why the databases are not being backed up.
     
  4. WebJIVE

    WebJIVE Well-Known Member

    Joined:
    Sep 30, 2007
    Messages:
    53
    Likes Received:
    3
    Trophy Points:
    8
    OK, this is a sample from that log and no errors but, also no indication that backup is touching MySQL either...

    [cpbackup] Started at Tue Sep 28 23:00:02 2010
    [cpbackup] Running account backup with target : /home/cpbackuptmp/cpbackup/daily
    pkgacct started.
    pkgacct version 8.3 - user : rollout - archive version: 3 - running with uid 0
    Copying Reseller Config...Done
    Copying Suspension Info (if needed)...Done
    Copying SSL Certificates, CSRS, and Keys...Done
    Copying Domain Keys....Done
    Copying Counter Data....Done
    Copying Bandwidth Data.......rolloutscooters.com...Done
    Copying Dns Zones.......rolloutscooters.com...Done
    Copying Mail files....Done
    Copying frontpage files....Done
    Copying proftpd file....Done
    Copying www logs.............
    Done
    Copy userdata............
    Copy custom virtualhost templates............
    Done
    Leaving timeout safety mode
    Copying mailman lists....Done
    Copying mailman archives....Done
    Copying homedir....Done
    Entering timeout safety mode
    Copying cpuser file.......Done
    Copying crontab file.......Done
    Copying quota info.......Done
    Storing Subdomains....
    Done
    Storing Parked Domains....
    Done
    Storing Addon Domains....
    Done
    Storing ssl domain......Done
    Copying password.......Done
    Copying shell.......Done
    Creating Archive ....Done
    pkgacctfile is: /home/cpbackuptmp/cpbackup/daily/rollout.tar.gz
    md5sum is: 6028f1e84b7c7ca7b6451d29e815f6ba

    size is: 23017823
    Net::FTP=GLOB(0x96e64fc)<<< 220 (vsFTPd 2.0.5)
    Net::FTP=GLOB(0x96e64fc)>>> USER SL70514-1
    Net::FTP=GLOB(0x96e64fc)<<< 331 Please specify the password.
    Net::FTP=GLOB(0x96e64fc)>>> PASS ....
    Net::FTP=GLOB(0x96e64fc)<<< 230 Login successful.
    Net::FTP=GLOB(0x96e64fc)>>> TYPE I
    Net::FTP=GLOB(0x96e64fc)<<< 200 Switching to Binary mode.
    Net::FTP=GLOB(0x96e64fc)>>> MKD /cpbackup
    Net::FTP=GLOB(0x96e64fc)<<< 550 Create directory operation failed.
    Net::FTP=GLOB(0x96e64fc)>>> MKD /cpbackup/daily
    Net::FTP=GLOB(0x96e64fc)<<< 550 Create directory operation failed.
    Net::FTP=GLOB(0x96e64fc)>>> CWD /cpbackup/daily
    Net::FTP=GLOB(0x96e64fc)<<< 250 Directory successfully changed.
    Net::FTP=GLOB(0x96e64fc)>>> ALLO 23017823
    Net::FTP=GLOB(0x96e64fc)<<< 202 ALLO command ignored.
    Net::FTP=GLOB(0x96e64fc)>>> PASV
    Net::FTP=GLOB(0x96e64fc)<<< 227 Entering Passive Mode (10,0,78,86,179,45)
    Net::FTP=GLOB(0x96e64fc)>>> STOR rollout.tar.gz
    Net::FTP=GLOB(0x96e64fc)<<< 150 Ok to send data.
    Net::FTP=GLOB(0x96e64fc)<<< 226 File receive OK.
    Net::FTP=GLOB(0x96e64fc)>>> QUIT
    Net::FTP=GLOB(0x96e64fc)<<< 221 Goodbye.
     
  5. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    cpbackup.conf

    Could you paste the full contents of your /etc/cpbackup.conf file? Specifically, I am interested in the MYSQLBACKUP value in the file.
     
  6. WebJIVE

    WebJIVE Well-Known Member

    Joined:
    Sep 30, 2007
    Messages:
    53
    Likes Received:
    3
    Trophy Points:
    8
    I also fired up a support ticket. We're changed a setting in the cPanel backup to Both to see if we get both. Here's the file contents thoughh...


    BACKUP2 yes
    BACKUPACCTS yes
    BACKUPCHECK yes
    BACKUPDAYS 0,1,2,3,4,5,6
    BACKUPDIR /backup
    BACKUPENABLE yes
    BACKUPFILES no
    BACKUPFTPDIR /cpbackup
    BACKUPFTPHOST ******** commented out
    BACKUPFTPPASSIVE yes
    BACKUPFTPUSER ******** commented out
    BACKUPINC no
    BACKUPINT daily
    BACKUPLOGS yes
    BACKUPMOUNT no
    BACKUPRETDAILY 1
    BACKUPRETMONTHLY 1
    BACKUPRETWEEKLY 1
    BACKUPTYPE ftp
    COMPRESSACCTS yes
    DIEIFNOTMOUNTED no
    GZIPRSYNCOPTS --rsyncable
    MYSQLBACKUP both
     
Loading...

Share This Page