I am using XAMPP on a pc atwork to host a database. I exported a backup ("bintra.sql") using phpmybackuppro. I use xampp on a mac at home, and when I try to import the sql file located on my desktop, I get this 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.
Now, the file size of bintra.sql is 922kb. The max size allowed indicated on the phpmyadmin screen is 3,072KiB, so I don't think it is the size that is preventing the import.
I'm using phpmyadmin v2.11.7
Does anyone have any ideas why no data is being received to import?
Comment Responses:
These are my upload settings from php.ini
;Whether to allow HTTP file uploads. file_uploads = On ;Temporary directory for HTTP uploaded files (will use system default if not specified). //upload_tmp_dir = ;Maximum allowed size for uploaded files. upload_max_filesize = 3M ;Maximum size of POST data that PHP will accept. post_max_size = 8M
EDIT:
Tried using Mamp instead. Works fine with the same sql file. I don't know why.
A database connection error means that your phpMyAdmin tool is not able to connect to the MySQL database. Usually, this is because the MAMP phpMyAdmin configuration file has the incorrect settings.
I HAD THE SAME PROBLEM AND THIS WORKED FOR ME :
Try these different settings in C:\wamp\bin\apache\apache2.2.8\bin\php.ini Find: post_max_size = 8M upload_max_filesize = 2M max_execution_time = 30 max_input_time = 60 memory_limit = 8M Change to: post_max_size = 750M upload_max_filesize = 750M max_execution_time = 5000 max_input_time = 5000 memory_limit = 1000M
Then restart your xampp or wamp to take effect
or stop then start only apache in xammp
I had the same problem on Windows. Turns out it was caused by the temporary directory PHP uses for uploads. By default this is C:\Windows\Temp, which is not writable for PHP.
In php.ini, add:
upload_tmp_dir = C:\inetpub\temp
Make sure to remove any other upload_tmp_dir
settings. Set permissions on C:\inetpub\temp
so IUSR
and IIS_IUSRS
have write permission. Restart the web server and you should be fine.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With