Knowledgebase
Portal Home > Knowledgebase > Articles Database > cPanel automated backup is NOT backuping one big database
cPanel automated backup is NOT backuping one big database
Posted by ovisopa, 05-02-2008, 02:51 AM 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.
Posted by Patrick, 05-02-2008, 09:25 AM 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?
Posted by ovisopa, 05-02-2008, 11:12 AM 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 "exista
"; } 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.
Add to Favourites 
Print this Article
Also Read
