Techawaken

Importing large database (> 2 MB) using phpMyAdmin

If you try importing a mysql database backup file greater than 2 MB then you may receive an error – “No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.”. No Worries! you just need to make few changes to your php.ini file.

phpMyAdmin

Open php.ini file for editing:

1. Search for the text “upload_max_filesize”

view plain
print
01;;;;;;;;;;;;;;;;
02; File Uploads ;
03;;;;;;;;;;;;;;;;
04 
05; Whether to allow HTTP file uploads.
06; http://php.net/file-uploads
07file_uploads = On
08 
09; Temporary directory for HTTP uploaded files (will use system default if not
10; specified).
11; http://php.net/upload-tmp-dir
12upload_tmp_dir = "F:\software\xampp\tmp"
13 
14; Maximum allowed size for uploaded files.
15; http://php.net/upload-max-filesize
16upload_max_filesize = 2M
17 
18; Maximum number of files that can be uploaded via a single request
19max_file_uploads = 20

By default it is set to “2M”. Increase it to the maximum database size you want to upload.

2. Search for “post_max_size” and set it to a value greater “upload_max_filesize”

view plain
print
1; Maximum size of POST data that PHP will accept.
2; Its value may be 0 to disable the limit. It is ignored if POST data reading
3; is disabled through enable_post_data_reading.
4; http://php.net/post-max-size
5post_max_size = 8M

By default its set to “8M”. If you set “upload_max_filesize” > 8MB, say 10 MB but do not change the default “post_max_size” then phpMyAdmin will not allow upload a file greater than 8MB.

3. Search for “memory_limit” and set it to a value greater “upload_max_filesize” and “post_max_size”

view plain
print
1; Maximum amount of memory a script may consume (128MB)
2; http://php.net/memory-limit
3memory_limit = 128M

By default “memory_limit” is set to “128M”.

Alternatively you can always use the MySql client program to upload large databases as below:

view plain
print
1mysql -h hostname -u username -p databasename < wordpress.bak.sql

You will prompted to enter the “password”, enter it and press enter.

Leave a Comment

Back to top