Phpmyadmin 简明教程

phpMyAdmin - Imports

phpMyAdmin 提供了一个直观的界面，用于导入数据库。

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

import default

选择要导入的文件。phpMyAdmin 允许导入 zip 文件和未压缩的文件。最大大小限制为 2GB。单击“执行”按钮，phpMyAdmin 将导入数据库并相应地显示成功/失败/错误消息。

Choose a file to import. phpMyAdmin allows to import zip file as well as uncompressed file. Max size limit is 2GB. Click on Go button and phpMyAdmin will import the databases and show the success/failure/error messages accordingly.

import success

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

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

import options

  1. Partial Import − This option is very handy while importing large databases. It allows to prevent PHP timeout and allows to skip queries as well.

  2. Other Options − Options to check foreign integrity checks.

  3. Format − phpMyAdmin allows six differents format to be used in import process.

import formats

  1. Format Specific Options − Options to choose database specific formats. For zero values, auto increment can be disabled.