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

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.

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

• 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.

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