Vesta Control Panel - Forum

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

skid wrote: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

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

cyclone200 wrote: ↑

Mon Dec 03, 2018 1:49 pm

Hi,

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

Could you please help me?

grayfolk wrote: ↑

Mon Dec 03, 2018 4:08 pm

cyclone200 wrote: ↑

Mon Dec 03, 2018 1:49 pm

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

Fenkins wrote: ↑

Mon Dec 16, 2013 2:49 pm

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.