Exporting Structure and Data (Backup) - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 127

• CREATE TABLE OPTIONS / IF NOT EXISTS : Adds the IF NOT EXISTS
modifier to CREATE TABLE statements, avoiding an error during import if the
table already exists.
• CREATE TABLE OPTIONS / AUTO_INCREMENT : Puts auto-increment
information from the tables into the export, ensuring that the inserted rows
in the tables will receive the next exact auto-increment ID value.
• Enclose table and ield names with backquotes : In the MySQL world,
backquotes are the normal way of protecting table and column names that may
contain special characters. In most cases, it is useful to have them. However,
backquotes are not recommended if the target server (where the export file will
be imported) is running a SQL engine that does not support backquotes.
The following screenshot displays options relevant to a Data export: