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

INSERT INTO `book` (`isbn`, `title`, `page_count`, `author_id`,
`language`, `description`, `cover_photo`, `genre`, `date_published`,
`stamp`, `some_bits`) VALUES('1-234567-22-0', 'Future souvenirs', 200, 2,
'en', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '\0');
INSERT INTO `book` (`isbn`, `title`, `page_count`, `author_id`,
`language`, `description`, `cover_photo`, `genre`, `date_published`,
`stamp`, `some_bits`) VALUES('1-234567-90-0', 'A hundred years of cinema
(volume 2)', 602, 1, 'en', '', '', '', '0000-00-00 00:00:00', '0000-00-00
00:00:00', '\0');
In this export example, the data for one of the topics (starting with 0x8950 ) has been
truncated for brevity. In fact, it would contain the full hexadecimal representation of
the cover_photo ield of this topic.
The first part of the export comprises comments (starting with the characters, -- ) that
detail the utility (and version) that created the file, the date, and other environment
information. We then see the CREATE and INSERT queries for each table.
Starting with version 2.6.0, phpMyAdmin generates ANSI-compatible
comments in the export file. These comments start with -- . They help
with importing the file back on other ANSI SQL-compatible systems. In
previous versions, the MySQL-specific character, ' # ', was used.
SQL Options
SQL options are used to define exactly what information the export will contain. We
may want to see the structure, the data, or both. Selecting Structure generates the
section with CREATE queries, and selecting Data produces INSERT queries: