48 Snippets
RECENT
ADD SNIPPET
FAVORITES
FEEDS
LOGIN
Login:
Password:
Remember me:
Create new account...
Tagged as sh
Simple Daily MySQL Backup Script
Posted by
eric
on Nov 05, 2007
•
dev.mysql.com
Running this script will back up and zip all mysql databases.
#!/bin/sh mysqldump --opt --all-databases | bzip2 -c > /var/backup/databasebackup-`date -I`.sql.bz2
0 reviews
•
mysql
,
sh
,
one-liner
1
0
Please
submit
any bugs/features and
report
abuse. Thanks!
Top Users
eric
(18)
snipsniper
(9)
boxfan
(5)
mavenmaven
(5)
kylejginavan
(4)
jimbojw
(3)
jaduks
(1)
juanwalker
(1)
boyan
(1)
danielbalieiro
(1)
Top Tags
attachments
(1)
autocomplete
(1)
awk
(1)
axis
(1)
base64
(1)
bash
(1)
calendar
(1)
clone
(1)
colloquy
(1)
command-line
(2)
constant
(1)
copy
(1)
daemon
(1)
date
(1)
email
(2)
embed
(1)
file
(1)
firefox
(2)
formatting
(1)
google
(1)
human_name
(1)
iframe
(1)
javascript
(5)
linux
(6)
loop
(1)
maven
(6)
mediawiki
(1)
mysql
(2)
object
(2)
one-liner
(7)
php
(5)
plugin
(2)
pom
(4)
rails
(4)
range
(1)
regexp
(1)
ruby
(20)
sed
(7)
select
(1)
session
(1)
settings
(2)
sh
(1)
sort
(1)
ssl
(1)
string
(1)
suggest
(1)
table
(1)
time
(1)
timeout
(1)
unix
(6)
urls
(1)
variable
(1)
vi
(1)
with_scope
(1)
xml
(6)