Hey everyone,

This got me thinking, is there a way to backup a data stream, or the 
re-directed output from a process?

Mat Harvest
Infrastructure Services 
Shared Information Solutions 
Tel: +61 7 3035 7213
Mobile: +61 412 402 047 
mathew.harvest AT sis.qld.gov DOT au 

-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On 
Behalf Of Yaron Zabary
Sent: Saturday, 14 March 2009 8:27 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] Mysql


   This is our Wiki page on that subject:

Backup of MySQL database

The following script should run from cron:

  #!/bin/bash
  D=`date +%Y%m%d%H%M`
  mysqldump --add-drop-table --all-databases -uroot -ppass | gzip -9 > 
/var/mysqlbackup/backup.$D.gz

This script is suitable for relatively small databases (a few GBytes 
worth of data) because it basically does a full backup every day. For 
larger databases, the right way is to setup a full every month and 
backup the logs every day. This procedure is described in the MySQL manual.

Backup Individual Databases from a MySQL server

mysqldump  --add-drop-table -uroot -ppass DB_NAME1 DB_NAME2 DB_NAME3 | 
gzip -9 > /var/mysqlbackup/backup.dbname.gz

Restore MySQL database

gunzip < [backupfile.gz] | mysql -uroot -ppass [dbname]

     * when restoring a single db to a new machine, (migrating dbs) its 
required to "GRANT PRIVILEGES" for the relevant users in the target 
MySQL server

Ólafur Þ. Sveinbjörnsson wrote:
> Hi, I was  wondering if anybody knows if there is a backupsolution for Mysql 
> from Networker ?
> 
>  
> 
> Best Regards
> 
> _________________________________________
> 
> 
> Olafur Sveinbjornsson
> System Manager
> 
> Corparate Solutions
> 
> System Service
> 
> Skýrr
> 
> olafur.sveinbjornsson AT skyrr DOT is <mailto:olafur.sveinbjornsson AT skyrr 
> DOT is> 
> 
> ots AT skyrr DOT is
> <mailto:stefan.hrafn.hagalin AT skyrr DOT is> 354 822 7668
> 
> 354 569 5226
> http://www.skyrr.is
> <http://www.skyrr.is/> _________________________________________
> 
>  
> 
>  
> 
> http://www.skyrr.is/legal/disclaimer.txt
> <http://www.skyrr.is/legal/disclaimer.txt> 
> 
>  
> 
> 
> To sign off this list, send email to listserv AT listserv.temple DOT edu and 
> type "signoff networker" in the body of the email. Please write to 
> networker-request AT listserv.temple DOT edu if you have any problems with 
> this list. You can access the archives at 
> http://listserv.temple.edu/archives/networker.html or
> via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER


-- 

-- Yaron.

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER



"Queensland celebrates its 150th anniversary in 2009. Check out what's on today 
at www.q150.qld.gov.au."

********************************* DISCLAIMER *********************************
The information contained in the above e-mail message or messages (which 
includes any attachments) is confidential and may be legally privileged.  It is 
intended only for the use of the person or entity to which it is addressed.  If 
you are not the addressee any form of disclosure, copying, modification, 
distribution or any action taken or omitted in reliance on the information is 
unauthorised.  Opinions contained in the message(s) do not necessarily reflect 
the opinions of the Queensland Government and its authorities.  If you received 
this communication in error, please notify the sender immediately and delete it 
from your computer system network.

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER