We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Cannot Upload .sql into phpMyAdmin
Re: Cannot Upload .sql into phpMyAdmin
What error?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
Re: Cannot Upload .sql into phpMyAdmin
same problem on debian, tried setting chmod 777 but didnt work. any idea?
Re: Cannot Upload .sql into phpMyAdmin
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.
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.
Re: Cannot Upload .sql into phpMyAdmin
How can I do this on my mac? Should I open the terminal? connect to my root@ip and what commands should I type?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 setThen restart the apache.Code: Select all
post_max_size = 64M upload_max_filesize = 64M
If you are using CentOS or RHEL, then the php.in location is /etc/php.iniCode: Select all
apachectl restart
Re: Cannot Upload .sql into phpMyAdmin
ssh root@iptamez11 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?
nano path-to-config
service apache2 restart
Re: Cannot Upload .sql into phpMyAdmin
on debian worked for me 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).
Code: Select all
nano /etc/php.ini
Actually I had some problem with nano, so I used F4 in MidnightCommander (then F2 for save and F10 for quit).
-
- Posts: 27
- Joined: Wed Jan 03, 2018 5:57 pm
- Os: Debian 8x
- Web: apache + nginx
Re: Cannot Upload .sql into phpMyAdmin
Hi,
I have this problem and I've done everything mentioned above...
Could you please help me?
I have this problem and I've done everything mentioned above...
Could you please help me?
-
- Support team
- Posts: 1111
- Joined: Tue Jul 30, 2013 10:18 pm
- Contact:
- Os: CentOS 6x
- Web: nginx + php-fpm
Re: Cannot Upload .sql into phpMyAdmin
Use console for import: https://stackoverflow.com/a/17666279cyclone200 wrote: ↑Mon Dec 03, 2018 1:49 pmHi,
I have this problem and I've done everything mentioned above...
Could you please help me?
-
- Posts: 27
- Joined: Wed Jan 03, 2018 5:57 pm
- Os: Debian 8x
- Web: apache + nginx
Re: Cannot Upload .sql into phpMyAdmin
Thank you but this is not a solution...grayfolk wrote: ↑Mon Dec 03, 2018 4:08 pmUse console for import: https://stackoverflow.com/a/17666279cyclone200 wrote: ↑Mon Dec 03, 2018 1:49 pmHi,
I have this problem and I've done everything mentioned above...
Could you please help me?
-
- Posts: 10
- Joined: Sat Oct 12, 2019 2:08 pm
- Contact:
- Os: Ubuntu 17x
- Web: apache + nginx
Re: Cannot Upload .sql into phpMyAdmin
Thank you so much! This works for me until I get the solution!
Fenkins wrote: ↑Mon Dec 16, 2013 2:49 pmI 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:
But phpMyAdmin still aint work for import... Dont feel good about it.Code: Select all
mysql> use DATABASE_NAME; mysql> source path/to/file.sql;