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 book.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 Import sub-page brings up the following:
Clicking Go should execute the file.
Chapter 8
[ 149 ]
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.
Searching Data
Here we present mechanisms that can be used to find the data we are looking for
instead of just browsing tables page-by-page and sorting them.
Pages:
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155