Cannot Upload .sql into phpMyAdmin

[skurudo]

Still got a problem, I've changed the php.ini but error still comes up
anyway of expanding the upload limit in sql

What error?

[krok]

same problem on debian, tried setting chmod 777 but didnt work. any idea?

[hoangkoha]

Today i got same problem like us, my os is CentOS 6.5 with VestaCP
Version:0.9.8 (x86_64)
Release:15
I pay to use chroot ftp, it worked very well but this problem is terrible. Edit /etc/php.ini, increase upload_max_filesize, post_max_size, reboot server and CAN NOT UPLOAD DATABASE.SQL FILE.

// SOLVED, System block my IP, i'm sorry VestaCP team.

[tamez11]

Most probably dump size exceed default php limits. Try to increase post_max_size and upload_max_filesize values. I guess 64M should be enough.
Open /etc/php5/apache2/php.ini and set

Code: Select all

post_max_size = 64M
upload_max_filesize = 64M

Then restart the apache.

Code: Select all

apachectl restart

If you are using CentOS or RHEL, then the php.in location is /etc/php.ini

How can I do this on my mac? Should I open the terminal? connect to my root@ip and what commands should I type?

[skurudo]

How can I do this on my mac? Should I open the terminal? connect to my root@ip and what commands should I type?

ssh root@ip
nano path-to-config
service apache2 restart

[matolog]

on debian worked for me

Code: Select all

nano /etc/php.ini

and expand resoruces as bescribed.

Actually I had some problem with nano, so I used F4 in MidnightCommander (then F2 for save and F10 for quit).

[cyclone200]

Hi,

I have this problem and I've done everything mentioned above...

Could you please help me?

[grayfolk]

Hi,

I have this problem and I've done everything mentioned above...

Could you please help me?

Use console for import: https://stackoverflow.com/a/17666279

[cyclone200]

Hi,

I have this problem and I've done everything mentioned above...

Could you please help me?

Use console for import: https://stackoverflow.com/a/17666279

Thank you but this is not a solution...

[nextstation.cl]

Thank you so much! This works for me until I get the solution!

I got the same situation explained in starting post, but changes in php.ini wont give me any positive result, except my phpMyAdmin panel now tells me that I got 64mb file upload limit.
I also tried to set the tmp folder manually and set permissions to 777 ( I am running ubuntu 12.04.03 if that matters) and still no luck.
Any comments?

As a temporary solution I used import from terminal:
From the mysql console:

Code: Select all

mysql> use DATABASE_NAME;
mysql> source path/to/file.sql;

But phpMyAdmin still aint work for import... Dont feel good about it.