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.

Full Backup fails with Mysql

Discussion in 'General Discussion' started by speckados, May 23, 2004.

  1. speckados

    speckados Well-Known Member

    Joined:
    May 21, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Acequias :: Granada :: España
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    My english it's bad but simply.

    10 Machines with fedora and Cpanel.

    WHM 9.2.0 cPanel 9.3.0-R5 Fedora - WHM X v3.1.0

    On ALL MACHINES after decompress fullbackup get all mysql_backup.sql with 0 bytes.

    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting_autopilot.sql
    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting_b21.sql
    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting_frgn1.sql
    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting_hosting.sql
    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting_ncls1.sql
    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting_news.sql
    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting_phpb1.sql
    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting_soporte.sql
    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting.sql
    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting_tienda2.sql
    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting_tienda.sql
    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting_wrdp1.sql
    -rw-r--r-- 1 root wheel 0 may 23 15:03 hosting_wrdp2.sql

    This error get to much time (latest version same problem)

    A customer think "well, I've a full backup for my account, NOT problem".. and go to restore and.... 0 BD's backup.
     
  2. kahoz

    kahoz Well-Known Member

    Joined:
    Nov 7, 2003
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Portugal
    i already had that problem but the thing now is a bit difrent.

    i have many .sql files ..incomplete, and i recenly made an OS restore.. result, many databases lost :(
     
  3. kmsd

    kmsd Well-Known Member

    Joined:
    May 21, 2003
    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    6
    You would think this problem would take priority!! But, it's been a known issue for at least a month now.
     
  4. Paonza

    Paonza Member

    Joined:
    Apr 19, 2004
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    I have the same problem... i have done a full backup but inside the folder /mysql into tar.gz file all the file .sql are 0 lenght! no database are backuped! :mad:
    this is a huge problem...

    regards
    Fabio Vaona
    http://www.fvsotware.com
     
  5. Jedia

    Jedia Well-Known Member

    Joined:
    Mar 18, 2004
    Messages:
    200
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    CN
    I have this problam too, users backup in Cpanel, MySQL does not backupd:(
     
  6. Paonza

    Paonza Member

    Joined:
    Apr 19, 2004
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    I partial solve this problem using a direct url to phpmyadmin for a fast backup of mysql db...

    try this:

    http://$my_phpmyadmin_url/export.php?lang=en-utf-8&server=$server_num&db=$dbname&export_type=database&what=sql&sql_structure=structure&sql_data=data&asfile=sendit&filename_template=$filenametemplate&compression=zip

    I have installed a personal version of phpmyadmin in a folder of my domain, i have configured config.inc.php whit the list of oll my database for each domain... each database increase the $server_num, so first db have $server_num = 1 and so on...

    I'm waiting a new version of cpanel that could solve this problem....

    regards,
    Fabio Vaona
    www.fvsoftware.com
     
  7. Jedia

    Jedia Well-Known Member

    Joined:
    Mar 18, 2004
    Messages:
    200
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    CN
    works fine on phpmyadmin, but system backup does not include MySQL databases :(
     
  8. Paonza

    Paonza Member

    Joined:
    Apr 19, 2004
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Yes, i know...
    I used this link for backup mysql AND the cpanel full backup for save the files...

    I hope this cpanel bug will solve soon...

    regards
    Fabio Vaona
    www.fvsoftware.com
     
  9. kahoz

    kahoz Well-Known Member

    Joined:
    Nov 7, 2003
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Portugal
    is this issue already solved ?
     
  10. Paonza

    Paonza Member

    Joined:
    Apr 19, 2004
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Yes I think....
    Now, my fullbackup works and save mysql data.

    regards,
    Fabio Vaona
    www.fvsoftware.com
     
Loading...

Share This Page