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;