Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Mysqldump rotate backup
Top Forums Shell Programming and Scripting Mysqldump rotate backup Post 302825783 by timgolding on Tuesday 25th of June 2013 06:42:03 AM
Old 06-25-2013
Mysqldump rotate backup
I have a very simple script that uses a cron job to take a daily backup of our orders database.

Code:
echo "Dumping ORDERS database";
mysqldump -u root --password='mypassword' -h '1.1.1.1' --opt --compress ORDERS $tbl_names > /Volumes/Files_Backup_1/db_backups/orders.sql
echo "Copied database to external disk";

This will make a single backup on the external hard disk. My worry is if somehow the orders database was TRUNCATED, DROPPED then that evening the database backup would overwrite the empty version of the database to the backup and i would be in big trouble. What i need to know how to do it understand how i can use mysqldump to make a weeks worth of daily backup. Maybe a mon, tue, wed, thur, fri, sat, sun backup or something similar.

I could do

Code:
mysqldump ... > database_$(date +%Y_%m_%d).sql

Or something but then my backup disk would fill up. I need some way of deleting the older backups. Any ideas
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

mysqldump script without hardcode password

OS: Linux ambglx02 2.6.16.60-0.21-default #1 Tue May 6 12:41:02 UTC 2008 i686 i686 i386 GNU/Linux Shell: bash Currently I have a mysqldump script to backup my mysql database, the command is as below: /opt/novell/mysql/bin/mysqldump --add-drop-table -u root -p -h mydb > /home/john/mydb.sql ... (5 Replies)
Discussion started by: bulkbiz
5 Replies

2. UNIX for Dummies Questions & Answers

mysqldump bus error - cored dumped

hi, I need to backup a database but I'm getting the error "bus error - core dumped" just after I run mysqldump command. The server has installed solaris 9. Any help would be appreciated (3 Replies)
Discussion started by: dahr
3 Replies

3. UNIX for Advanced & Expert Users

mysqldump slowing down the process?

Hi All, I have a data calculation process-a perl script running each and every hour which will do some calculations on the data stored in a mysql server. Normally it tooks around 2minutes (max) to complete. But in case if i did any actions on the linux box where the database is... (7 Replies)
Discussion started by: DILEEP410
7 Replies

4. Shell Programming and Scripting

Help needed for mysqldump command

I want to take a backup of a database and redirect the output of the whole process to a log file. I am using the below command: mysqldump -A --add-drop-table > mysql-daily-backup.sql &> /tmp/backup_log/mysql.log Is there anything wrong with the syntax? ---------- Post updated at 08:32 PM... (0 Replies)
Discussion started by: proactiveaditya
0 Replies

5. UNIX for Dummies Questions & Answers

Problem with my crontab file, using mysqldump

My crontab file tells cron to run a certain shell script at 10:30 AM every day. The shell script backs up my database with mysqldump and then runs a sed script that does some editing of the backup file. I have programmed the shell script to write an error message to a file I have in my home... (1 Reply)
Discussion started by: Ultrix
1 Replies

6. Shell Programming and Scripting

rsync backup mode(--backup) Are there any options to remove backup folders on successful deployment?

Hi Everyone, we are running rsync with --backup mode, Are there any rsync options to remove backup folders on successful deployment? Thanks in adv. (0 Replies)
Discussion started by: MVEERA
0 Replies

7. UNIX for Dummies Questions & Answers

Mysqldump certain tables

Hi, I have to upload part of my database periodically when i make changes to product data etc. However I only want to upload certain tables. We suffer from bandwidth chock here, so i want to write a couple of separate scripts that upload parts of the database that changed. The database is large... (5 Replies)
Discussion started by: timgolding
5 Replies

8. Shell Programming and Scripting

Need Help with automatically Import from special mysqldump

Hi @ all I need a little bit help with a tricky problem ... Here´s the situation: We´ve 2 MySQL-Servers, one is productive, the other is Backup. At the productive Server there runs every 2 hours a cron Job which does a Dump from MySQL-DB with script 'automysqlbackup.sh' and copy it then... (7 Replies)
Discussion started by: jackcracker
7 Replies

LEARN ABOUT HPUX

vxconfigbackupd

vxconfigbackupd(1M)													       vxconfigbackupd(1M)

NAME

       vxconfigbackupd - disk group configuration backup daemon

SYNOPSIS

       vxconfigbackupd [-l]

DESCRIPTION

       The vxconfigbackupd daemon automatically backs up information about a disk group's new configuration whenever the configuration is changed.

OPTIONS

       -l	 Logs backup daemon activities to the file /etc/vx/cbr/bkdaemonLog.

FILES

       /sbin/init.d/vxvm-recover
		 Startup file for vxconfigbackupd.

       /etc/vx/cbr/bk/dgname.dgid/dgid.dginfo
		 Location of backup file for disk group information.

       /etc/vx/cbr/bk/dgname.dgid/dgid.diskinfo
		 Location of backup file for disk attributes.

       /etc/vx/cbr/bk/dgname.dgid/dgid.binconfig
		 Location of backup file for binary configuration copy.

       /etc/vx/cbr/bk/dgname.dgid/dgid.cfgrec
		 Location of backup file for configuration records in vxprint -m format.

NOTES

       The vxconfigbackup command can be used to back up a disk group's configuration manually at any desired time.

       The  disk  group  configuration	backup and restore utilities do not save any data in the public region. This includes file system or other
       application data that is configured within VxVM objects.

       When a disk group is destroyed, its configuration backup information (including the backup directory) is also removed.  The only  exception
       to this behavior is when the disk group is in the precommit state of restoration.

       The  backup  directory should be large enough to accommodate copies of all the currently imported disk groups. The minimum recommended size
       of the backup directory is P * (N + 1) megabytes, where P is the private region in megabytes (by default, 32MB), and N  is  the	number	of
       disk  groups. The additional P megabytes is required to hold a temporary copy of the disk group configuration when a disk group is imported
       or a configuration change is made.

       The default backup directory is /etc/vx/cbr/bk.	The location of the backup directory can be configured	by  using  the	vxconfigbackup	-l
       backup_directory_path command.

SEE ALSO

       vxconfigbackup(1M), vxconfigrestore(1M)

VxVM 5.0.31.1							    24 Mar 2008 					       vxconfigbackupd(1M)
All times are GMT -4. The time now is 02:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy