phpMyAdmin - Imports


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

Import Dashboard

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

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

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

  • Other Options − Options to check foreign integrity checks.

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

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