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!

Cpanel SQL Backup only 1kb ?

Discussion in 'General Discussion' started by mrix, Feb 26, 2010.

  1. mrix

    mrix Registered

    Feb 26, 2010
    Likes Received:
    Trophy Points:
    Hello all, I am having a problem backing up a website I own:confused:
    Basically I log in to cpanel and click the Databases backup and it downloads:)
    I then check the file.gz and its only 1kb in size?
    I know for a fact the database is around 30mb.

    I then decide to click on the "Download or Generate a Full Web Site Backup"

    Its then starts it backup and at some point when finished I can download.
    When I open and check all the files it shows that the Mysql.SQL file is just 1kb:confused:

    The odd thing is, is when I download the Main Home directory files they are all in tact.

    Thanks for any help / idea`s

  2. mambovince

    mambovince Well-Known Member

    Jan 15, 2005
    Likes Received:
    Trophy Points:
    London, UK
    I can confirm.
    having same issue on 2 different VPS's runung Stable version:
    cPanel 11.25.0-S43473

    Also related, if you go to the account cPanel screen ->> click on icon 'MySQL Databases' it displays all databases have '0' size.

    My VPS supplier thinks this is only affecting MySQL 4.x
    But that would be a lot of cPanel installs out there :eek:

    - Vince
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. ChrisRHS

    ChrisRHS Well-Known Member

    Jul 12, 2006
    Likes Received:
    Trophy Points:
    Go into the users home directory and delete the .my.cnf file. This is where the users MySQL user name and password is stored, and, sometimes, when a user updates the account password, this file does not get updated. Remove it, and it will get recreated.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

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.
    Dismiss Notice