Automated WHM MySQL backup not working

Question

I am using WHM's automated backup system to make daily backups of my database. I have it set that it only makes a backup of what has changed. I've had this running for a while now and thought it was working fine until I tried downloading the backup today, and realized there was nothing in it. The only text inside of the sql file is:

-- MySQL dump 10.11
--
-- Host: localhost    Database: pokerrpg_pokerrpg
-- ------------------------------------------------------
-- Server version   5.0.81-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 */;

Answer 1

Do you have WHM set to keep weekly or monthly backups as well? Check the /pathtobackupfolder/cpbackups/weekly/ and see if you happen to have a full copy in there. I've personally never had anything but frustration come from trying to use WHM's backup feature. It's really just an un-tarred pkgacct file. You can do some really simple mysql backups with mysqldump and cron.

/usr/bin/mysqldump -u db_user -pdb_user_pass db_name > /full/path/to/dumpfile.sql

Where 'db_user' is the database username, 'db_user_pass' is that database user's password, 'db_name' is the name of the database to be dumped, and '/full/path/to/dumpfile.sql' is the location that you'd like the database to be dumped to.

You can also create a .my.cnf (note leading . is needed) in your /home/username directory containing the following:

[client]
user = DBUSERNAME
password = DBPASSWORD
host = localhost

[mysql]
database = DBNAME

(Where DBUSERNAME, DBPASSWORD, DBNAME refer to Database username, password, and database name.)

Adding this as your cron job:

mysqldump > /full/path/to/dumpfile.sql

You can set up cron jobs through cPanel->'Cron Jobs'

Answer 2

Yes, I was just testing one of my backup after so long. Guess what, the "Account Restore" backup only created the database, but not the tables/data inside it.

I should try your mysqldump.

Thanks