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.

Cpanel SQL Backup only 1kb ?

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

  1. mrix

    mrix Registered

    Joined:
    Feb 26, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    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

    Cheers
    mrix
     
  2. mambovince

    mambovince Well-Known Member

    Joined:
    Jan 15, 2005
    Messages:
    192
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    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
     
  3. ChrisRHS

    ChrisRHS Well-Known Member

    Joined:
    Jul 12, 2006
    Messages:
    292
    Likes Received:
    5
    Trophy Points:
    18
    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.
     
Loading...

Share This Page