Exporting Structure and Data (Backup) - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 113

The default values selected here depend on config.inc.php , more 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 subpanels. The top panel Export and the bottom panel
Save as file are always there. However, the third panel varies (using dynamic
menu techniques) in order to show the options for the export mode chosen
(which is SQL here).
The export subpanel
This subpanel contains a table selector, from where we choose the tables and the
format that we want. The SQL format is useful for our needs, as 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 , CodeGen , Texy! text , Open Document Spreadsheet , Open Document
Text , and XML. Another format, Native MS Excel, is available after further software
installation and configuration. (See the section on Native MS Excel in this chapter.)
We shall now discuss the formats (and the options available once they have been
chosen) that can be selected with the Export subpanel.
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.
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 3.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 21, 2008 at 12:55 PM
-- Server version: 5.0.67
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";