Partial Imports
If the file is too big, there are ways in which we can resolve the situation. If we still
have access to the original data, we could use phpMyAdmin to generate smaller
CSV export files, choosing the Dump n rows starting at record # n dialog. If this is
not possible, we will have to use a text editor to split the file into smaller sections.
Another possibility is to use the upload directory mechanism, which accesses the
directory defined in $cfg['UploadDir']. This feature is explained later in the
present chapter.
In recent phpMyAdmin versions, the Partial import feature can also solve this file
size problem. By selecting the Allow interrupt??¦ checkbox, the import process will
interrupt itself if it detects it is close to the time limit. We can also specify a number
of queries to skip from the start, in case we successfully imported a number of rows
and wish to continue from that point.
Temporary Directory
On some servers, a security feature called open_basedir can be set up in a way
that impedes the upload mechanism. In this case, or for any other reason when
uploads are problematic, the $cfg['TempDir'] parameter can be set with the
value of a temporary directory??”probably a subdirectory of phpMyAdmin's main
directory??”into which the web server is allowed to put the uploaded file.
Importing Structure and Data
[ 142 ]
Importing SQL Files
Any file containing MySQL statements can be imported via this mechanism.
Pages:
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148