Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Sibiu, Romania
    Posts
    229

    cPanel automated backup is NOT backuping one big database

    Hello,

    i recently find out that I don;t have an database backup for one of my biggest websites.

    The database I'm talking about has 228 tables (198.6 MB)

    In the backup file I only get this :

    -- MySQL dump 10.11
    --
    -- Host: localhost Database: lxxxxxxa_sXXXl
    -- ------------------------------------------------------
    -- Server version 5.0.45-community-log

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    /*!40103 SET TIME_ZONE='+00:00' */;
    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

    Any Ideea ?

    The other databases I have tried are all ok, but none is this big. Is there any size limit ?

    I have uploaded an printscreen with the setings of my WHM.

  2. #2
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    8,910
    I've seen this before, but it was on a FreeBSD server and was caused by a limit of the max open files. What OS are you using, and have you tried to manually mysqldump the database?
    Patrick William | RACK911 Labs | Software Security Auditing
    400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com

    www.HostingSecList.com - Security notices for the hosting community.

  3. #3
    Join Date
    Dec 2002
    Location
    Sibiu, Romania
    Posts
    229
    WHM 11.15.0 cPanel 11.18.1-S20683
    CENTOS Enterprise 4.6 i686 on standard - WHM X v3.1.0
    Load Averages: 0.25 0.50 0.56

    I was using a script like the one bellow to make other backups than the Cpanels backups, but now I see that it generates the same small file

    $cmd = `mysqldump -h localhost -u $username -p$password --opt --databases db_name`;
    $date = date("Y-m-d");

    if(file_exists("$pathtofile/$date.sql")){
    echo "<b>exista </b><br>";
    }
    else
    {
    $new_file = fopen("$pathtofile/$date.sql", "w");
    fputs($new_file, "$cmd");
    fclose($new_file);
    $filee = "$pathtofile/$date.sql";

    }
    $cmd = `gzip $filee`;
    $filee = "$pathtofile/$date.sql.gz";

    exactly the same script is used for my forum database, which is a little smaller, only the db_name is changed .. this backup is ok.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •