phpMyAdmin cannot upload or import databases.

[furtif]

Hello,

Sorry for my english.

I have a problem with phpMyAdmin during import of sql files.

In fact, i have this error message when i start the import.

"Aucune données n'a été reçu en vue de l'importation. Aucun nom de fichier n'a été fourni, ou encore la taille du fichier a dépassé la limite permise par votre configuration de PHP. "

In english, i thinks is :
"No data has been received for import. No filename
has been provided, or the file size exceeded the limit
by your PHP configuration."

But, my php configuration accept a size file of 50m.

Please, do you have any solution for this problem ?

Thanks a lot

[madaboutlinux]

phpMyAdmin uses it's own php.ini saved under

/usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini

Change the upload limit in the above file and try to import the sql file once again.

[furtif]

Hi,

Thanks for your answer.

I have look into this configuration file, but i don't thinks that is the origin of problem.

file_uploads    = On                            ; Whether to allow HTTP file uploads
upload_tmp_dir  = /tmp                  ; temporary directory for HTTP uploaded files (will use system default if not specified)
upload_max_filesize = 128M

post_max_size = 128M

My sql file take 8ko.

Do you have an other idea for this problem ?

Thanks a lot

[bamm]

Did you ever figure this out?

I'm having the same issue. The file I'm trying to import is only 402kb and the post max size in php.ini is set to 8mb

Thanks for any help.

[Graywolfie]

This same issue began for me today also. I import a csv file daily. It did not work today and resulted in the error. I tried the same file that worked yesterday and it also did not work.

Increasing values in the php.ini file has no positive effect.

A separate thrid party program for managing MySQL databases allowed the file to be imported without issue.

The problem must be with a very recent change to cPanel/phpMyAdmin.

Looking forward to a fix.

(EDIT) FYI - the file in question is only 276KB. The process has worked fine for nearly 2 years. Something broke...

[eastitaly]

Same problem here

cPanel 11.25.0-R43470 (RELEASE tree)

[Maat]

Hello all,

I had the same problem today : with the root password, no problem to import a file in PhpMyAdmin but error when trying with a user password.

I solved the problem changing the line in the file /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini :

"; upload_tmp_dir ="
TO
"upload_tmp_dir = /tmp"

[Utkman]

This fix worked perfectly for me -thanks.

[Graywolfie]

Making this change in the php.ini file did not work for me. Also, import does not work whether logged in as root or not.

Any other suggestions?

(EDIT) - I should clarify; I modified the file located at /usr/local/lib and then restarted apache. The change shows up in the phpinfo script located on the domain in question. Should I attempt to modifiy the file listed above? and if so, will the changes stick?

[mohit]

Thanks, Maat, you solved my problem.

Graywolfie, you need to edit the php.ini file which is used for phpmyadmin
as said by Maat.

pico /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini

[Maat]

Hello all,

The problem is here again after the Cpanel update. I just contact the Cpanel Support....
I'll keep you informed.

[Graywolfie]

Thanks Maat and Mohit for the advice. Since I currently have a workaround I'll monitor the comments here.

It will be better to have a proper fix than a band-aid on the issue. Anyone who wants to use the import option should not need to edit the php.ini file first. Whatever broke it in the first place needs to be undone.

I'm just happy to know it wasn't just me having the issue.

[Maat]

I had an answer from Cpanel support :

- Edit the file as said in my previous post
- Run "/scripts/makecpphp" to fix the php.ini
- Try a "/scripts/upcp" to test if the file is still correct after the update

That should do it.

[eastitaly]

Maat's latest post seems to solve the problem for me [ tested on cPanel 11.25.0-R43471 (RELEASE tree) ]

[cPanelGregK]

We are aware of an issue where uploads of sql dumps via phpMyAdmin are failing, due to the lack of a setting for upload_tmp_dir.

To correct ths issue, edit /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini and change

 'upload_tmp_dir '

to

'upload_tmp_dir  = /tmp '