OurSQL Episode 32: Backup tools you already have [Backup series #2]

This week we continue our series on backup tools, we talk about the backup tools that ship with MySQL.

Show notes:

Previous backup series podcast:
Backup glossary [Backup series #1]

In the backup glossary we asked if anyone knew how to get logical data out of physical InnoDB files. Mike Hamrick of Blue Gecko wrote in to say that Percona's InnoDB recovery tool helps to do just that. He writes:

"The 'page_parser' tool will read ibdata files or individual .ibd files and turn them into a series of 16k page files suitable for processing with a tool called 'constraints_parser' which spits out a number of tab separated lines of table data suitable for a LOAD DATA INFILE.

These tools are not for the faint of heart! You have to manually build a separate version of the contstraints_parser tool for every table you wish to recover, based on a C header file which defines the structure of the table you're recovering. Although quite rough around the edges, these tool can save your butt when all you have are a hand full of data files."

Sarah's notes about the IOUC meeting - http://www.bluegecko.net/mysql/notes-from-international-oracle-usergroup...
Giuseppe's notes about the MySQL Council - http://datacharmer.blogspot.com/2011/01/mysql-council-is-up-and-running-...

We welcome new Oracle ACE’s:
Giuseppe Maxia http://datacharmer.blogspot.com/
Patrick Galbraith http://capttofu.livejournal.com/

About the Oracle ACE and ACE Director qualifications and how to nominate - http://www.oracle.com/technetwork/community/index-083638.html

“So you want to be an Oracle ACE?” presentation by Sheeri at 2008 Oracle OpenWorld: http://www.youtube.com/watch?v=wrbPNs-8Cx8

Backup tools you already have:
mysqlhotcopy manual page with details on the options we spoke about.

mysqldump manual page with details on the options we spoke about.

Ear Candy:
Changing the pager with \P on the mysql commandline client

Upcoming events:
Percona Live
Wednesday, 16th February 2011
Conference runs from 8:30am - 6:00pm. Ignite Percona follows from 7:00pm - 9pm.
$125 per ticket

Collaborate - http://collaborate11.ioug.org/
Sunday, April 10th through Thursday, April 14th in Orlando, Florida.
$200 off the early bird registration (through March 10th - $1385 for IOUG members, so with the discount it is $1185) with code: MYSQ
Pricing can be found at http://collaborate11.ioug.org/Home/Registration/tabid/82/Default.aspx

O’Reilly MySQL Conference: MySQL and Beyond - http://en.oreilly.com/mysql2011/
Monday April 11 - Thursday April 14th Santa Clara, California.
15% discount code for podcast listeners: oursql
Pricing can be found at https://en.oreilly.com/mysql2011/public/register

OpenDatabaseCamp, aka OpenSQLCamp - Friday May 6 - Sunday May 8, 2011 - http://opensqlcamp.org/Events/Sardinia2011/
Google Group for OurSQLCamp: http://groups.google.com/group/opensqlcamp
To sponsor: http://opensqlcamp.org/Events/Sardinia2011/Sponsors
OpenDatabaseCamp is FREE.

Open Source Bridge - Tuesday June 21 - Friday June 24, Portland OR - http://opensourcebridge.org/
OSBridge is a volunteer-run conference for developers working with open source technologies and for people interested in learning the open source way
A limited number of early bird tickets are $195 (regular price is $300), get yours before they run out or expire on Feb 28th at http://osbridge.eventbrite.com/

Kaleidoscope aka kscope - http://kscope11.com/
Sunday June 26th - Thursday June 30th Long Beach, California (near Los Angeles).
Early bird pricing (through March 25th) is $1400 for ODTUG members
Pricing information can be found at http://kscope11.com/registration
Get a $100 discount using the MySQL Podcast Listener code: MYSQLPCL. Start a "New Registration" at https://caat.odtug.com/odtug_2011_registration.html and insert the discount code on the code page.

OSCon - the Open Source Convention - Mon July 25 - Fri Jul 29, Portland OR - http://www.oscon.com/oscon2011
The Facebook group
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast