V 
VPS Hosting Referral Code PCGPDB


MAN PAGES INDEX
Welcome, Guest. Please login or register.
Did you miss your activation email?
July 31, 2010, 09:04:09 AM

Login with username, password and session length
bashconsole.org > Linux commands > 1. General Commands > mysqldump
 « previous next »
Pages: [1] Print
Author Topic: mysqldump  (Read 479 times)
bashconsole
Administrator
Newbie
*****
Posts: 30


View Profile Email
« on: May 09, 2009, 11:52:14 PM »
NAME
       mysqldump - a database backup program

SYNOPSIS
       mysqldump [options] [db_name [tbl_name ...]]


http://bashconsole.org/man.1.mysqldump
Logged
bashconsole
Administrator
Newbie
*****
Posts: 30


View Profile Email
« Reply #1 on: May 09, 2009, 11:59:08 PM »
Code:
#!/bin/sh
date=`date -I`
mysqldump --all-databases | gzip > /var/backup/mysqlbackup-$date.sql.gz
or
Code:
mysqldump --all-databases | bzip2 -c > /var/backup/mysqlbackup-$date.sql.bz2

For cron
Code:
#!/bin/sh

date=`date -I`

/usr/bin/mysqldump -uuser --password=password -hlocalhost --all-databases --opt --allow-keywords --flush-logs --hex-blob --quote-names |bzip2 -z9 > /var/database.backup/mysql-$date.sql.bz2
Logged
Pages: [1] Print
« previous next »
Jump to:  

Page created in 0.063 seconds with 21 queries. (Pretty URLs adds 0.012s, 2q)