I have a very simple script that uses a cron job to take a daily backup of our orders database.
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
Or something but then my backup disk would fill up. I need some way of deleting the older backups. Any ideas
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)
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)
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)
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)
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)
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)
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)
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
dgcfgbackup
dgcfgbackup(1M)dgcfgbackup(1M)NAME
dgcfgbackup - create or update VxVM volume group configuration backup file
SYNOPSIS
/usr/sbin/dgcfgbackup [-f dg_conf_path ] dg_name
DESCRIPTION
The dgcfgbackup command saves the VxVM configuration for a disk group in a default or alternate configuration backup file (see the descrip-
tion of the-f option).
By default, dgcfgbackup is run automatically each time that a VxVM command changes the VxVM configuration. In this case, it always uses
the default configuration backup file. An existing default configuration backup file is renamed with an extension of .old.
Options and Arguments
dg_name Specifies the name of a disk group.
-f dg_conf_path
Saves the configuration using an alternate file name specified by dg_conf_path. If this option is omitted, the default file name
is /etc/vxvmconf/dg_name.conf.
EXIT CODES
dgcfgbackup exits with a zero status on successful completion. An non-zero exit status indicates that errors occurred when information
from the disk group was being accessed.
EXAMPLES
Back up VxVM configuration information for disk group testdg in the default backup file /etc/vxvmconf/testdg.conf:
dgcfgbackup testdg
Back up VxVM configuration information for disk group datadg in the alternate configuration backup file /tmp/datadg.backup:
dgcfgbackup -f /tmp/datadg.backup datadg
NOTES
It is recommended that any alternate configuration backup file be created in the root file system (as is the case with the default path
name). This facilitates disk group recovery during maintenance mode, such as after a system crash.
AUTHOR
dgcfgbackup was developed by the Hewlett-Packard Company.
SEE ALSO dgcfgrestore(1M)VxVM 5.0.31.1 24 Mar 2008 dgcfgbackup(1M)