I have a crucial database (mysql).
My server is running cpanel. It has daily backup but it is not enough as it is running a lot of transaction daily.
I would like to run the backup to backup database only every 30 mins using cronjob. How do i do that in crontab. I have root access to the server.
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 version5.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 */;
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.
Is the same type of file created through cPanel, going into backup then downloading the database backup as going through cPanel/phpmyadmin to export then saving the file as gzipped?
View 3 Replies View RelatedI have a 1GB MySQL database (compresses down to 300MB) and would like an automated method of backing it up to a remote server. Both accounts are shared hosting accounts (if it matters, both are running CPanel, no shell access on either).
View 13 Replies View Relatedmy plesk server was running OK for the last 13 months and suddenly it breaks apart on its own and I cant make it work again. [URL]
Is there a way to backup database at this stage? How?
Planning to reformat my windows server. and start over.
I'm having a problem with Plesk Panel 11.0.9 update #64. All other page running perfect. But when I go to "Backup Manager --> Database Backup Repository --> Upload Backup File" then Plesk Panel show error: Internal Server Error 500.0.
On server, it show detail below: .....
