Exporting Structure and Data - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 111

The default values selected here depend on config.inc.php , more specially
specifically on the $cfg['Export'] array of parameters. For example, the
$cfg['Export']['format'] parameter is set to 'sql' so that the SQL export mode
is chosen by default.
The export panel has three sub-panels. The top panel Export and the bottom panel
Save as file are always there, and the third panel varies (using dynamic menu
techniques) so as to show the options for the export mode chosen (which is SQL here).
The Export Sub-Panel
This sub-panel contains a table selector, where we choose the tables and the format
that we want. The SQL format is useful, for our needs, since it creates standard SQL
commands that would work on any SQL server. Other possible formats include
LaTeX , PDF , Microsoft Excel 2000 , Microsoft Word 2000 , Comma-Separated Values
( CSV ), YAML, Open Document Spreadsheet, Open Document Text, and XML .
Another format, Native MS Excel , is available after further software installation and
configuration. (See the section Native MS Excel in this chapter.)
Even if we can export from phpMyAdmin into all these formats, only
the SQL and CSV formats can be imported back using the current
phpMyAdmin version. Use only these two formats for backup .
We shall now discuss the formats (and the options available once they have been
chosen) that can be selected with the Export sub-panel.
SQL
We will start by clicking Select All ; we want all the tables. We know that the tables are
small, so the on-screen export will not be too large. For the moment, let's deselect the
Extended inserts checkbox. We then click Go , which produces the following output:
-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 16, 2007 at 12:55 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `marc_book`
--