Just to add to this, I use this via cron:
mysqldump -u root -pPASSWORD_HERE --compress Rivendell | gzip -9 -c >
/media/backup/Rivendell_Backup/db/$(date +%Y-%m-%d).sql.gz
I have a SAMBA share from another server mounted to
/media/backup/Rivendell_Backup (via /etc/fstab)
This command does the mysqldump listed below with the --compress option
so that MySQL will compress on the fly, the output is then dumped into
gzip and it creates a date stamped gz file e.g.:
2012-07-30.sql.gz
I only have about 1,000 carts at the moment and a few weeks worth of
logs so the dump is zipping down to about 500k which is quite tiny by my
reckoning.
I also do an rsync on /var/snd to the same samba share in the same
script which although not a traditional tape/off site backup works for
me at the moment.
Wayne Merricks
The Voice Asia
On 31/07/12 17:55, Brooks Whiteford wrote:
Bill,
Try this:
mysqldump -u*<SQL USER>* -p*<SQL PW>* *<DATABASE NAME>* > dumpfilename.sql
Thanks,
Brooks
On Tue, Jul 31, 2012 at 12:48 PM, Bill Putney <[email protected]
<mailto:[email protected]>> wrote:
This has probably already been covered lots of times. <sigh>
I want to make a crontab entry to backup the Rivendell MySQL database.
Anyone know what that command line would look like?
Thanks, Bill Putney - KPTZ Port Townsend, WA
_______________________________________________
Rivendell-dev mailing list
[email protected]
<mailto:[email protected]>
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
#######################
Scanned by MailMarshal
#######################
############
Attention:
The information contained in this message is confidential and intended
for the addressee(s) only. If you have received this message in error
or there are any problems, please notify the originator immediately.
The unauthorised use, disclosure, copying or alteration of this message
is strictly forbidden. Christian Vision or any of its subsidiaries will
not be liable for direct, special, indirect or consequential damages
arising from alteration of the contents of this message by a third party
or as a result of any virus being passed on. Please note that we reserve
the right to monitor and read any e-mails sent or received by the
company under the Telecommunications (Lawful Business Practice)
(Interception of Communications) Regulation 2000. Christian Vision is
registered in England as a limited company 2842414 and as a charity
1031031
############
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
