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

`some_bits` bit(3) NOT NULL,
PRIMARY KEY (`isbn`),
KEY `by_title` (`title`(30)),
KEY `author_language` (`author_id`,`language`),
KEY `isbn` (`isbn`),
FULLTEXT KEY `description` (`description`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `book`
--
INSERT INTO `book` (`isbn`, `title`, `page_count`, `author_
id`, `language`, `description`, `cover_photo`, `genre`, `date_
published`, `stamp`, `some_bits`) VALUES('1-234567-89-0',
'A hundred years of cinema (volume 1)', 600, 1, 'en', '',
0x89504e470d0a1a0a0000000d494844, '', '0000-00-00 00:00:00', '2008-12-
20 14:14:35', b'011');
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.
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 versions prior to 2.6.0, the
MySQL-specific character, ' # ', was used.