Phpmyadmin 简明教程

phpMyAdmin - Exports

phpMyAdmin 提供直观的用户界面来导出数据库。

phpMyAdmin provides an intuitive user interface to export database(s).

export default

单击转至按钮，phpMyAdmin 将生成创建数据库/表和其他相关实体所需的 SQL。

Click on Go button and phpMyAdmin will generate SQL required to create databases/tables and other relevant entities.

除了 SQL 之外，用户还可以选择其他流行选项，如 csv、json、yaml 等。

Instead of SQL, user can choose other popular options as well like csv, json, yaml etc.

export options

现在选择自定义选项，phpMyAdmin 将显示很多选项，例如

Now select the custom option and phpMyAdmin will show lots of options like

  1. Databases − A list of databases to be selected. User can select multiple databases.

  2. Output − Options to save output to a file with customization options like name, charset, compression. It also provides options to skip large tables, rename exported databases/tables/columns and so on.

  3. Format Specific Options − Options to display/hide comments, enclose export in a transaction, export views as tables, export metadata and database selection for compatabilities and so.

  4. Object Creation Options − Options to add drop database/tables etc if exists, auto increment id, add create view, add create trigger statements, using backquotes to enclose table and column names etc.

  5. Data Creation Options − Options to truncate table before insert delayed statements and insert ignore statements. Options to choose format while preparing sql for insert data, set the maximum length of created query, dump timestamp columns in UTC etc.