Databases Reference
In-Depth Information
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
), 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.8.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 15, 2006 at 03:32 PM
-- Server version: 5.0.21
-- PHP Version: 5.1.4
--
-- Database: 'dbbook'
--
-- --------------------------------------------------------
--
-- Table structure for table 'authors'
--
CREATE TABLE 'authors' (
Search WWH ::
Custom Search