I have written a shell script that creates a backup of my MySQL database.
I've tested a few of backup utilities and still haven't found one that would satisfy me.
Almost every one of them has two options:
- full backup - not an option to use frequently
- incremental backup - seems right, but there's one thing about it:
Incremental backup builds on a base of a full backup, backing up only those files, that were created/changed.
I currently have a Deja Dup Backup utility in Ubuntu 12.04 to run scheduled backups every day but the backup never runs. The Overview tab always reports "Most recent backup: n days ago" and "Next automatic backup: Today". I can run a backup on demand no problem so as far as I can tell it's not a network availability issue or a permissions issue. It just appears not to run on schedule.
Hi,
I'm running a shell script to do a daily backup of my mysql database. The backup is done using:
Code:
mysqldump db1 > db1.sql --user=rootuser --password=rootpassword && mysqldump db2 > db2.sql --user=rootuser --password=rootpassword
This file is saved in my root directory replacing the old/exisiting backups.
I'm trying to setup a backup script on Ubuntu. Every day I want to copy my local source directory to a backup directory on a remote server uniquely named with the date. (e.g., backup-jan1/, backup-jan2/, etc) It should store a mirror of the earliest state and use difference files to recreate the new backup points.
This is pretty simple with rsync.
I have a server running Ubuntu 10, it mostly has PHP websites with MySQL databases.
I need to write a backup script
to backup the database
to zip up all the php files.
Is it better security to do write my backup script in PHP or shell? Or does it not matter?
I like PHP more, because that lets me have the database password in only one place, a PHP file.
how can I modify or create again the whole process of creating a backup in Windows Backup?
I'm doing until now backup to an external drive, and when it ran out of space on the backup fails.
It is possible that the automatic Windows Backup delete the oldest backup?
Regards
I have setup a job that runs every night and makes a full backup of all databases on the server.
During the day, another job makes differential backups every few hours.
The problem comes when a new database is created.
The differential backup job fails every time, until the full backup job runs for the first time since the database was added.
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 07-JUL-10
Recovery Manager complete.
RMAN BACKUP COMPLETED AT Wed Jul 7 02:07:12 EST 2010
START CREATE TAR FILE AT Wed Jul 7 02:07:12 EST 2010
START CLENUP OLD TAR FILE AT Wed Jul 7 02:08:05 EST 2010
CLEAN UP OLD TAR FILE FINISHED AT Wed Jul 7 02:08:05 EST 2010