sql suffix, but not necessarily so) and CSV files
(comma-separated values, although the separator is not necessarily a comma). Future
versions might be able to import files in more formats. There is also an interface to
the MySQL LOAD DATA INFILE statement, enabling us to load text files containing
data, also called CSV. The binary field upload covered in Chapter 6 can be said to
belong to the import family.
Importing and uploading are synonyms in this context.
Since phpMyAdmin version 2.7.0, there is an Import menu in the Database view and
in the Table view that regroups import dialogs, and an Import files menu available
inside the Query window (as explained in Chapter 12).
Another feature was added in version 2.11.0: an import file may contain the
DELIMITER keyword; this enables phpMyAdmin to mimic the mysql command-line
interpreter. The DELIMITER feature is used to delineate the part of the file containing
a stored procedure, because these procedures can themselves contain semicolons.
The default values for the Import interface are defined in $cfg['Import'].
Before examining the actual import dialog, let's look at some limits issues.
Importing Structure and Data
[ 140 ]
Limits for the Transfer
When we import, the source file is usually on our client machine, so it 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.
Pages:
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145