cool. Thanks.
On Mon, Jul 7, 2014 at 11:32 AM, Stanley Brinkerhoff <[email protected]> wrote: > https://code.google.com/p/mysqlbackup/ > > Does everything you want. > > > On Mon, Jul 7, 2014 at 11:32 AM, Dan Coutu <[email protected]> wrote: > >> Oooo, mysqlshow I didn't know about. The -B switch doesn't exist on >> RHEL/Centos 5 machines. >> >> Dan >> >> >> On Mon, Jul 7, 2014 at 11:08 AM, Tisdell, Dave <[email protected]> >> wrote: >> >>> Thanks!!! >>> >>> >>> On Mon, Jul 7, 2014 at 11:06 AM, Aaron S. Hawley < >>> [email protected]> wrote: >>> >>>> Hey Dave, >>>> >>>> Sounds like you're asking about mysqldump --all-databases, but to >>>> answer your scripting question: >>>> >>>> $ mysql -B -e 'show databases;' | grep -v -e '^Database$' -e >>>> '^information_schema$' | while read db; do mysqldump "$db" > >>>> "$db".sql; bzip2 "$db.sql"; done >>>> >>>> There is a mysqlshow command, but it has the fancy formatting. The -B >>>> option gives unix friendly output. And the grep -v removes 2 lines >>>> you probably don't care about. >>>> >>>> On Mon, Jul 7, 2014 at 10:52 AM, Tisdell, Dave <[email protected]> >>>> wrote: >>>> > Hi all, >>>> > >>>> > I have several mysql databases that I want to run separate backups of >>>> rather >>>> > than doing an entire database dump into 1 file. >>>> > The idea is that each database backup would go into its own directory >>>> at the >>>> > end of the backup path i.e. >>>> > /dbbackups/database1/db-back1 >>>> > /dbbackups/database 2/db-back2 >>>> > etc >>>> > What I have done so far is use the sql "SHOW DATABASES" command to >>>> redirect >>>> > to a dblist text file. What I would like the script to do is go >>>> through the >>>> > file and backup every database in the list. I am already using sed to >>>> remove >>>> > the word database that gets generated by the show command and any >>>> databases >>>> > I don't want backed up from the list so that the result is a list of >>>> > databases that want backed up. >>>> > Periodically databases get added. The idea is that the backup will >>>> > automatically add the new databases without my editing the script >>>> based >>>> > upong the list generated by the "Show Databases" command. >>>> > I am getting to a level of complexity in scripting that I have not >>>> done >>>> > before. I want the same set of commands run on every db in the list. >>>> > Thanks. >>>> > >>>> > Dave >>>> > >>>> > -- >>>> > David Tisdell. Music Teacher >>>> > Browns River Middle School >>>> > 20 River Road >>>> > Jericho, VT 05465 >>>> > [email protected] (e-mail) >>>> > >>>> > This e-mail may contain information protected under the Family >>>> Educational >>>> > Rights and Privacy Act (FERPA). If this e-mail contains student >>>> information >>>> > and you are not entitled to access such information under FERPA, >>>> please >>>> > notify the sender. Federal regulations require that you destroy this >>>> e-mail >>>> > without reviewing it and you may not forward it to anyone. >>>> >>>> >>>> >>>> -- >>>> In general, we reserve the right to have a poor >>>> memory--the computer, however, is supposed to >>>> remember! Poor computer. -- Guy Lewis Steele Jr. >>>> >>> >>> >>> >>> -- >>> David Tisdell. Music Teacher >>> Browns River Middle School >>> 20 River Road >>> Jericho, VT 05465 >>> [email protected] (e-mail) >>> >>> This e-mail may contain information protected under the Family >>> Educational Rights and Privacy Act (FERPA). If this e-mail contains student >>> information and you are not entitled to access such information under >>> FERPA, please notify the sender. Federal regulations require that you >>> destroy this e-mail without reviewing it and you may not forward it to >>> anyone. >>> >> >> > -- David Tisdell. Music Teacher Browns River Middle School 20 River Road Jericho, VT 05465 [email protected] (e-mail) -- This e-mail may contain information protected under the Family Educational Rights and Privacy Act (FERPA). If this e-mail contains student information and you are not entitled to access such information under FERPA, please notify the sender. Federal regulations require that you destroy this e-mail without reviewing it and you may not forward it to anyone.
