Importing Structure and Data - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 146

Refreshing the Import subpage brings up the following:

Clicking Go should execute the file.

Automatic decompression is also available for the files located in the upload
directory. The file names should have extensions such as .bz2 , .gz , .sql.bz2 ,
or .sql.gz .

Using the double extensions ( .sql.bz2 ) is a better way to indicate that a
.sql file was produced and then compressed, as we see all the steps used
to generate this file.

Summary
This chapter covers:

• Various options in phpMyAdmin that allow us to import data

• The different mechanisms involved in importing SQL and CSV files•

• The limits that we might hit when trying a transfer, and ways to bypass

these limits

Chapter 9 will explain how to do single-table searches (covering search criteria
specification) and how to search in the whole database.