Importing Structure and Data - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 134

This error message is expected, since the directory does not exist. It is supposed
to have been created inside the current phpMyAdmin installation directory. The
message might also indicate that the directory exists, but can't be read by the
web server. (In PHP safe mode, the owner of the directory and the owner of the
phpMyAdmin-installed scripts must be the same.)
Using an SFTP or FTP client, we create the necessary directory and can upload a file
there (for example books.sql ) bypassing any PHP timeouts or upload maximum
limits. Note that the file itself must have permissions that allow the web server to
read it. In most cases, the easiest way is to allow everyone to read the file.
Refreshing the SQL sub-page 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 like .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,
since we see all the steps used to generate this file.
Summary
In this chapter, we learned the 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.