Databases Reference
In-Depth Information
The import feature can be accessed from several panels:
• The
Import
menu available from the home page, the
Database
view, or the
Table
view
• The
Import
iles
menu offered inside the Query window (as explained
in
Chapter
11
)
The default values for the
Import
interface are defined in
$cfg['Import']
.
Before examining the actual import dialog, let us discuss some limits issues.
Limits for the transfer
When we import, the source file is usually on our client machine and, therefore, must
travel to the server via HTTP. This transfer takes time and uses resources that may be
limited in the web server's PHP configuration.
Instead of using HTTP, we can upload our file to the server using a protocol such as
FTP, as described in the
Reading
iles
from
a
web
server
upload
directory
section. This
method circumvents the web server's PHP upload limits.
Time limits
First, let us consider the time limit. In
config.inc.php
, the
$cfg['ExecTimeLimit']
configuration directive assigns, by default, a maximum execution time of 300 seconds
(five minutes) for
any phpMyAdmin script, including the scripts that process data
after the file has been uploaded. A value of
0
removes the limit, and in theory, gives
us infinite time to complete the import operation. If the PHP server is running in
safe mode, modifying
$cfg['ExecTimeLimit']
will have no effect. This is because
the limits set in
php.ini
or in user-related web server configuration files (such as
.htaccess
or virtual host configuration files), take precedence over this parameter.
Of course, the time it effectively takes depends on two key factors:
• Web server load
• MySQL server load
Search WWH ::
Custom Search