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. >> > >
