Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search
Reminder: On the servers affected by ChachaDDoS passwords for admin and root need to be changed necessarily

Cannot Upload .sql into phpMyAdmin

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
39 posts
  • Previous
  • 1
  • 2
  • 3
  • 4
skurudo
VestaCP Team
Posts: 8014
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Cannot Upload .sql into phpMyAdmin
  • Quote

Post by skurudo » Fri Sep 25, 2015 7:57 am

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
What error?
Top

krok
Posts: 61
Joined: Wed Oct 01, 2014 10:58 am

Re: Cannot Upload .sql into phpMyAdmin
  • Quote

Post by krok » Sun Oct 25, 2015 9:23 pm

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

hoangkoha
Posts: 5
Joined: Mon Nov 23, 2015 6:52 am

Re: Cannot Upload .sql into phpMyAdmin
  • Quote

Post by hoangkoha » Sat Feb 27, 2016 6:44 am

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.
Top

tamez11
Posts: 1
Joined: Sun Dec 04, 2016 6:48 am

Re: Cannot Upload .sql into phpMyAdmin
  • Quote

Post by tamez11 » Sun Dec 04, 2016 7:54 am

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
How can I do this on my mac? Should I open the terminal? connect to my root@ip and what commands should I type?
Top

skurudo
VestaCP Team
Posts: 8014
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Cannot Upload .sql into phpMyAdmin
  • Quote

Post by skurudo » Wed Dec 07, 2016 2:21 pm

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?
ssh root@ip
nano path-to-config
service apache2 restart
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now
Top

matolog
Posts: 3
Joined: Fri Jan 03, 2014 7:28 am
Contact:
Contact matolog
Website

Os: Ubuntu 16x
Web: apache
Re: Cannot Upload .sql into phpMyAdmin
  • Quote

Post by matolog » Sat Oct 13, 2018 2:20 pm

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).
Top

cyclone200
Posts: 21
Joined: Wed Jan 03, 2018 5:57 pm

Os: Debian 9x
Web: apache + nginx
Re: Cannot Upload .sql into phpMyAdmin
  • Quote

Post by cyclone200 » Mon Dec 03, 2018 1:49 pm

Hi,

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

Could you please help me?
Top

grayfolk
Posts: 299
Joined: Tue Jul 30, 2013 10:18 pm

Os: CentOS 7x
Web: nginx + php-fpm
Re: Cannot Upload .sql into phpMyAdmin
  • Quote

Post by grayfolk » 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
Top

cyclone200
Posts: 21
Joined: Wed Jan 03, 2018 5:57 pm

Os: Debian 9x
Web: apache + nginx
Re: Cannot Upload .sql into phpMyAdmin
  • Quote

Post by cyclone200 » Tue Dec 04, 2018 10:48 am

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
Thank you but this is not a solution...
Top


Post Reply
  • Print view

39 posts
  • Previous
  • 1
  • 2
  • 3
  • 4

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password