Exporting databases
When you export a database, you set options related to the export format you chose. Once you have set these options, you can select the tables you want to include and export the file.
When you export SQL, you can choose to export the structure (columns), data (records) or both. The structure options are:
- inclusion of a "drop table" statement; if this option is checked, restoring the database will drop (delete) any existing database with the same name.
- addition of an "auto_increment" value.
- enclosing tables and field names with back quotes.
- adding creation, update and check information to the comments section.
And the data options are:
- setting export type (INSERT, UPDATE or REPLACE)
- use complete inserts.
- use extended inserts.
- use delayed inserts.
To export an SQL file:
- Select the database you want to work with from DBManager Home.
- Click Manage Database. phpMyAdmin launches.
- Click the database name above the table list.
- Click the Export button.
- Select the tables you want to include.
- Set the SQL Structure and Data options as desired.
- Check the Save as file check box.
- Click Go.
LaTex, like SQL, allows you to set structure and data export options.The structure options control table captioning and key labelling; the data options include column labelling particulars and replace NULL string.
To export a LaTex file:
- Select the desired tables.
- Select LaTex from the Export box.
- Set the desired LaTex Options.
- Check the Save as file check box.
- Click Go.
The default values for CSV export are:
| option
|
default
|
| Fields terminated by
|
semicolon (;)
|
| Fields enclosed by
|
quotation marks (")
|
| Fields escaped by
|
backslashes (\)
|
| Lines terminated by
|
\r\n
|
| Replace NULL by
|
NULL
|
| Put field names in row
|
(checked)
|
To export a CSV file:
- Select the desired tables.
- Select CSV from the Export box.
- Set the desired CSV Options.
- Check the Save as file check box.
- Click Go.
There are only three CSV for Microsoft Excel export options: replacement string for NULL values, put field names at first row, and specify Excel platform (Windows or Macintosh).
To export a CSV for Microsoft Excel file:
- Select the desired tables.
- Select CSV for MS Excel from the Export box.
- Set the desired export options.
- Check the Save as file check box.
- Click Go
XML export options:
Other than the ability to select which tables to export, there are no XML options.
To export an XML file:
- Select the desired tables.
- Select XML from the Export box.
- Check the Save as file check box.
- Click Go.
