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.

backups are empty!

Discussion in 'Data Protection' started by cybermaster, May 6, 2009.

  1. cybermaster

    cybermaster Registered

    Joined:
    Sep 13, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    hi
    today i have problem to get my database backup from cPanel(Download a MySQL Database Backup) , but every time i tried, backups saved with no 0 capacity! what is the problem and how can i fix this problem?
     
  2. beley

    beley Active Member

    Joined:
    Feb 27, 2003
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    Have you by chance logged in via SSH and un-tarred any backups from the Cpanel backups directory? I noticed a few months ago that if we un-archived a backup into the same backup directory it would not update the backup file, instead it would always show as 0 bytes.

    When we deleted the folder (named the username) from the cpanel backup directory (daily, weekly, or monthly) the backups ran successfully again.
     
  3. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Are you logged in as the cPanel user with the cPanel user's password or by some other means (e.g. Reseller's password, root user etc.)?
     
  4. cybermaster

    cybermaster Registered

    Joined:
    Sep 13, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    i logged with user and pass, i checked one another user in this server and that worked! i dont test with root user.

    :confused: i will try that!
     
  5. cybermaster

    cybermaster Registered

    Joined:
    Sep 13, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    i checked it with root user everything is fine, cPanel user cant do this and backups are empty! what is the problem?:confused:
     
  6. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    That's very weird, since it's typically the opposite (the cPanel user gets the full backup but the root user gets empty database backups). I recommend letting a technical analyst take a look at this: http://tickets.cPanel.net/submit

    For anyone wondering, the reason root and reseller users can lead to empty database backups is they do not have permissions to the cPanel user's databases (unless a .my.cnf file with the username and password is set up in that user's home directory). A lack of permissions results in empty database backups.
     
  7. gkgcpanel

    gkgcpanel Well-Known Member

    Joined:
    Jun 6, 2007
    Messages:
    217
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    This is apparently a bug in the Backup Wizard vs Backup. If you use the Backup Wizard, the SQL dumps are empty. If you use Backup, they are fine...

    I've tested this with about 3 different sites on 3 different cPanel servers.

    Just an FYI to those here and to the cPanel team that this needs to be corrected.
     
  8. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Please do not cross-post. You can find followup to your post at: http://forums.cpanel.net/f4/mysql-backup-cpanel-80453.html
     
Loading...

Share This Page