Mastering phpMyAdmin 3.4 for Effective MySQL Management

Exporting a version

As the complete SQL code at the time of creation for a specific version has been stored along with all of the tracked statements that occurred since that moment, we might want to reuse them in their executable form. At the bottom of the Tracking report panel, an Export as dialog is available, offering three variants for exporting. If we choose SQL dump (file download) menu option, then all of the statements stored for this version are transferred in a file that we can save to our workstation. For the author table, this would produce a file containing the following lines:

# Tracking report for table `author` # 2011-10-14 14:24:12 DROP TABLE IF EXISTS `author`; CREATE TABLE `author` ( `id` int(11) NOT NULL, `name` varchar(30) ...