Shooting from the Hip. MySQL at the Command Line.

Average rating: ****.
(4.29, 7 ratings)

There are many GUI applications to deal with databases and with MySQL in
particular. But for die hard command line enthusiasts, who grew up with
Linux, the shell prompt is still prince.
You would be surprised at the vast amount of operations that you can do
from the command line. Running commands on several databases at once,
filtering users, getting detailed metadata, transferring data from the
operating system to a database and the other way around, creating scripts
from database data, creating SQL commands from database data.
That, and more, you can learn by attending this tutorial. Learn the art of
the command line as a shortcut to quick and efficient administration, and
as help for demanding developers.

Table of contents:

  • mysql command line essentials
  • Loops on the command line.
  • Using a configuration file
  • .bashrc aliases, variables, and functions
  • Obtaining query details and execution time
  • Getting the server’s version
  • Transferring tables from one server to another
  • Getting the server PID file
  • SELECTINTO OUTFILE without access to the server
  • Creating a CSV file
  • Excluding one or more tables from a dump
  • Executing a command for each database or table
  • creating dynamic queries with database metadata
  • and more …
Photo of Giuseppe Maxia

Giuseppe Maxia


Giuseppe Maxia, a.k.a. “The Data Charmer” works as QA Director at Continuent.

He’s an active member of the MySQL community and long timer open source enthusiast.

During the past decades he has worked in various IT related fields, with focus on databases, object oriented programming, system administration.

Fluent in Italian, English, Perl, Python, SQL, Lua, C, Bash, and good speaker of C++, French, Spanish, Java.

Works in cyberspace, with a virtual team.

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.