How To Backup Database Via Cron

Jul 21, 2008

i need to backup database,that not that much huge a small database,now iam useing cpanel server so iam takeing via phpmyadmin manually,now i need to set cron to take backup at every 12hours and save it on specified path,

View 11 Replies


ADVERTISEMENT

Simplest Way To Auto Cron A Mysql Database

Oct 2, 2009

I use a php script usually but that does not work for large files.

I have a 130mb mysql database on linux using cPanel.
What is the easiest way to set up say a monthly cron to back this up to the root server?

View 14 Replies View Related

How Set Up Cron Job Auto Empty A Tables Of A Database

Dec 20, 2008

How to set up cron job auto empty a table of an database at specify time.

OS: Centos 5 64 bit , Cpanel: cPanel 11.24.4-R32486 - WHM 11.24.2 - X 3.9

View 11 Replies View Related

How Can I Backup CPanel With Cron

Nov 6, 2008

I just went through a week of nightmares, because my host lost hard drives and stuff.. lost my data, etc.. what ever..

I want to work out how I can cron cPanel backups. I did a search online for a cPanel backup manager, but I didn't have much luck.

Or, maybe there's some other way to get regular backups?

I don't really need to backup my whole sites. I keep my files locally, but of course I don't have the databases locally -- or the email records.

All I "really" need is the database SQL files, so that I can rebuild my forums if need be, and also the email setup files -- because I have over 50 domains and I have emails set up on all of them.

I want to have them emailed to myself.

There's an option in cPanel too, which allows me to "generate/download a full backup".. well, how do I "restore" the backup? ie: I know how to backup and restore the home directory, databases and email stuff (there's 3 options in cPanel), but there doesn't seem to be anywhere to restore the full backup.

Anyway, can anyone give me advice on how to keep backups of my cPanel accounts? I don't trust hosts anymore. They say they back stuff up, but they never to.

View 5 Replies View Related

Cpanel Cron Backup To Ftp

Nov 19, 2007

Im setting up new windows server, packed with only FTP server (FileZilla) to remote backups.

How can i get my cpanel account make backups and upload them to my FTP server as an cron job? Offcourse i have option to backup via cpanel, but this is needed to do manually every time (setting remote ftp ip, account, passwd etc,).

Is there a option in cpanel / whm to do full-backup all my accounts in my reseller account? Or do i need to do it per account? Some of my servers is only reseller accounts without root access, only reseller account.

View 1 Replies View Related

Cron Job To Send Backup Copy

Jun 3, 2009

Is it possible to get [Crone job] that sends a backup copy for single user in the server to another hosting via FTP which has [Domain name/ User /Password] either weekly or 3 times a week

View 10 Replies View Related

Backup MySQL Databases By Cron

Apr 1, 2007

how to backup MySQL databases by cron and have the backups sent to you by email, or have them uploaded by FTP. It is based on a script I found at another website though I can confirm it is fully working.

Change the commented variables in the following file and save it as backup.sh:

Code:
#!/bin/sh

# This script will backup one or more mySQL databases
# and then optionally email them and/or FTP them

# This script will create a different backup file for each database by day of the week
# i.e. 1-dbname1.sql.gz for database=dbname1 on Monday (day=1)
# This is a trick so that you never have more than 7 days worth of backups on your FTP server.
# as the weeks rotate, the files from the same day of the prev week are overwritten.
#/bin/sh /home/user/directory/scriptname.sh > /dev/null
############################################################
#===> site-specific variables - customize for your site

# List all of the MySQL databases that you want to backup in here,
# each seperated by a space
# If not run by root, only one db per script instance
databases="mydbname"

# Directory where you want the backup files to be placed
backupdir=/home/mydomain/backups

# MySQL dump command, use the full path name here
mysqldumpcmd=/usr/bin/mysqldump

# MySQL Username and password
userpassword=" --user=myuser --password=mypasswd"

# MySQL dump options
dumpoptions=" --quick --add-drop-table --add-locks --extended-insert --lock-tables"

# Unix Commands
gzip=/bin/gzip
uuencode=/usr/bin/uuencode
mail=/bin/mail

# Send Backup? Would you like the backup emailed to you?
# Set to "y" if you do
sendbackup="n"
subject="mySQL Backup"
mailto="me@mydomain.com"

#===> site-specific variables for FTP
ftpbackup="y"
ftpserver="myftpserver.com"
ftpuser="myftpuser"
ftppasswd="myftppasswd"
# If you are keeping the backups in a subdir to your FTP root
ftpdir="forums"

#===> END site-specific variables - customize for your site
############################################################

# Get the Day of the Week (0-6)
# This allows to save one backup for each day of the week
# Just alter the date command if you want to use a timestamp
DOW=`date +%w`

# Create our backup directory if not already there
mkdir -p ${backupdir}
if [ ! -d ${backupdir} ]
then
echo "Not a directory: ${backupdir}"
exit 1
fi

# Dump all of our databases
echo "Dumping MySQL Databases"
for database in $databases
do
$mysqldumpcmd $userpassword $dumpoptions $database > ${backupdir}/${DOW}-${database}.sql
done

# Compress all of our backup files
echo "Compressing Dump Files"
for database in $databases
do
rm -f ${backupdir}/${DOW}-${database}.sql.gz
$gzip ${backupdir}/${DOW}-${database}.sql
done

# Send the backups via email
if [ $sendbackup = "y" ]
then
for database in $databases
do
$uuencode ${backupdir}/${DOW}-${database}.sql.gz > ${backupdir}/${database}.sql.gz.uu
$mail -s "$subject : $database" $mailto < ${backupdir}/${DOW}-${database}.sql.gz.uu
done
fi

# FTP it to the off-site server
echo "FTP file to $ftpserver FTP server"
if [ $ftpbackup = "y" ]
then
for database in $databases
do
echo "==> ${backupdir}/${DOW}-${database}.sql.gz"
ftp -n $ftpserver <<EOF
user $ftpuser $ftppasswd
bin
prompt
cd $ftpdir
lcd ${backupdir}
put ${DOW}-${database}.sql.gz
quit
EOF
done
fi

# And we're done
ls -l ${backupdir}
echo "Dump Complete!"
exit
Upload backup.sh to your server, to any directory you want. A directory which is not web-accessible will stop your login information being seen by just anyone .

You should chmod the file to 777:

Code:
chmod 777 backup.sh
If you uploaded this file from a Windows machine you will need to convert the file to Unix format. You should run the following command by SSH in the appropriate directory:

Code:
dos2unix backup.sh
If you don't have dos2unix installed, you can install it using yum if you have that:

Code:
yum install dos2unix
If you don't have yum, get it here.

You may want to test the script at this point to make sure it's doing what you want it to. Change to the appropriate directory and run this command:

Code:
./backup.sh
Once you're happy with it, enter it into the crontab to run daily (or whenever you want). Cron jobs vary a lot depending on the configuration of your system, so check Google for how to do it on your system. The command you will need to run by cron is:

Code:
/path/to/file/backup.sh

View 2 Replies View Related

Cron Job That Deletes Backup Files Older Than 5 Days

May 31, 2009

This is on a RHEL 4 Box.

I want to create a cron job that deletes backup files that are older than 5 days. I have created a shell script (/usr/local/src/runjob.sh) that runs successfully from the SSH command line:

Code:
#pwd
/usr/local/src
#./runjob.sh
Here is the script:

Code:
#!/bin/sh
#

#
find /usr/local/apache/sites/*/BACKUPS/ -maxdepth 1 -atime +5 -iname 'test*.txt' -exec rm {} ;
Script has 777 permissions and is owned by root.

I have the following entry in crontab:

Code:
10 12 * * * /bin/sh /usr/local/src/runjob.sh >/dev/null 2>&1

As shown in the cron log, the job does run, but it does not delete the files. And there are files older than 5 days in the directory that meet the find criteria.

View 12 Replies View Related

Is It Possible To Create A Cron To Backup Mysql Data Daily

May 15, 2009

Is there any way to create a cron to backup mysql data daily ( or weekly )? I mean an "auto script" to run this command daily

mysqldump -u usernam -p password dataname > file.sql

View 11 Replies View Related

Plesk 12.x / Linux :: Scheduled Backup Don't Load (cron Job)

Jul 14, 2015

Plesk Backup work when we make instant backup but not with scheduled backup.

There is nothing in the log files (pmmcli.log & migration.log).

How can we correct?

Plesk 12 / Centos

View 1 Replies View Related

Backup BIG MySQL Database

Nov 29, 2007

What is the recommended method of backing up big MySQL database of size 2 GB ?

Quote:

# mysqldump gallery > gallery.sql
mysqldump: Got error: 1017: Can't find file: './gallery/10tir_user_group.frm' (errno: 24) when using LOCK TABLES
#

I checked the table, it is fine, but can't do the backup.

Quote:

mysql> check table 10tir_user_group;
+-------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+-------+----------+----------+
| gallery.10tir_user_group | check | status | OK |
+-------------------------+-------+----------+----------+
1 row in set (0.07 sec)

mysql>

View 13 Replies View Related

How To Backup Database (cpanel Server)

Jan 13, 2008

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.

View 4 Replies View Related

Backup For My Database To Move From Hostmonster But I Can’t

Aug 6, 2008

I just want to move from hostmonster to dedicated server

the problem is the database(vbulletin) size about 1 GB

when I try make backup for it through ssh it arraive to 723 MB then stop becuase it have highload on hostmonster system they not allowed more than 20% cpu

I take to them they tell me can’t do any thing I please them make backup but they say we can’t do any thing for you and I’m sure they can log by root and do it with ssh on less than 1 minute

how can I make backup or if there r way to move the database to the new server

2 day ago and I can’t move to the new server

View 13 Replies View Related

Phpmyadmin Large Database Backup

Feb 5, 2007

I have a large database 800MB and the export zip & gzip option does not work on this size database export.

works fine on upto 30MB table sizes, does phpmyadmin not support large table
export/backup using gzip or zip?

If its the case that i should be able to use the zip options then what would i look for to put this problem right?

if its the case large table databases are not supported what could i use instead to backup the database tables with compression (gzip)?

View 1 Replies View Related

Remote Database Backup Service

Jul 27, 2007

I have a tiny MySQL database (10MB) and I'm looking for some remote backup service. Someting that will backup the database and let me recover it if the host is in trouble.

I strongly prefer something simple and fully automated.

View 5 Replies View Related

Backup Of MySQL Database To A Remote Server

Jul 9, 2008

I 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 Related

CPanel Automated Backup Is NOT Backuping One Big Database

May 2, 2008

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.

View 2 Replies View Related

What's The Easy Way To Backup Websites/mysql Database

Jun 12, 2008

Due to LayeredTech price hike, i'm going to cancel my server with LT within two weeks.

Does anyone know an easy way to backup all the domians and mysql database in FreeBSD/DirectAdmin? Is there a built in feature in DirectAdmin that can do that?

View 5 Replies View Related

Is CPanel Backup/database The Same As Phpmyadmin/export/.gz

Jun 26, 2007

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 Related

Plesk 11.x / Windows :: Unable To Backup Database

Feb 28, 2014

when i try to make backup of mssql 2012 on plesk 11.5 i have the following error:Error: dbbackup failed: Unable to backup database 'DBANME'. Unable to open connection: A specified logon session does not exist. It may already have been terminated.i already configured temp/network directory,

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved