phpmyadmin cannot handle database bigger than 2MB?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

phpmyadmin cannot handle database bigger than 2MB?

Postby nhatminh1209 » 02. February 2017 13:45

Everytime working with import and export database in my website, phpmyadmin show me that the maximum database to handle is 2mb.

I wonder when I working with the database much more than 2mb. Is there any other programs can handle that problem for me?

Thanks
nhatminh1209
 
Posts: 6
Joined: 02. February 2017 12:11
XAMPP version: 5.6.28
Operating System: Windows 7

Re: phpmyadmin cannot handle database bigger than 2MB?

Postby zanzibarneon » 02. February 2017 18:15

To increase to 200MB, edit the configuration file xampp\php\php.ini
and change the following lines to :

post_max_size=200M
upload_max_filesize=200M
zanzibarneon
 
Posts: 14
Joined: 18. February 2011 09:18

Re: phpmyadmin cannot handle database bigger than 2MB?

Postby nhatminh1209 » 03. February 2017 12:35

zanzibarneon wrote:To increase to 200MB, edit the configuration file xampp\php\php.ini
and change the following lines to :

post_max_size=200M
upload_max_filesize=200M

I did and it worked.
Thanks
Anyway, do you have any idea why did they put the default max upload size to 2MB? Because at this time, I don't have any database more than 200mb to check if that is possilbe and have no problem.
nhatminh1209
 
Posts: 6
Joined: 02. February 2017 12:11
XAMPP version: 5.6.28
Operating System: Windows 7

Re: phpmyadmin cannot handle database bigger than 2MB?

Postby Altrea » 03. February 2017 16:47

because php/phpmyadmin is not the best way to import a large database.
if i would to need to import such a large database file i would do it with help of the mysql/mariadb command line interface.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8895
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: phpmyadmin cannot handle database bigger than 2MB?

Postby zanzibarneon » 04. February 2017 21:55

Yes it is strangely low.
Most PHP/MYSQL hosting providers give you at least 250MB.
It is true that using the command line options are much faster and more reliable.
But then phpMyAdmin imports extra import formats.
zanzibarneon
 
Posts: 14
Joined: 18. February 2011 09:18

Re: phpmyadmin cannot handle database bigger than 2MB?

Postby Altrea » 04. February 2017 23:47

zanzibarneon wrote:Most PHP/MYSQL hosting providers give you at least 250MB.

Most hosting providers don't let you import the database in the CLI.
Most hosting providers don't let you connect your database remotely to use other tools like MySQL Workbench.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8895
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: phpmyadmin cannot handle database bigger than 2MB?

Postby Nobbie » 05. February 2017 00:33

nhatminh1209 wrote:Anyway, do you have any idea why did they put the default max upload size to 2MB?


Why not? "They" are the developers of PHP(!), not of PhpMyAdmin. As this option is a global PHP option, not a PhpMyAdmin option. It is set to 2MB as for most people it is enough. And as you may change it to your needs, i neither understand the problem nor the question.
Nobbie
 
Posts: 9629
Joined: 09. March 2008 13:04

Re: phpmyadmin cannot handle database bigger than 2MB?

Postby Nobbie » 05. February 2017 00:34

zanzibarneon wrote:Yes it is strangely low.


see above -- that option is NoT a PhpMyAdmin option, it is a PHP option valid or ALL PHP scripts. Simply increase the size, if needed. Whats wrong about that???
Nobbie
 
Posts: 9629
Joined: 09. March 2008 13:04

Re: phpmyadmin cannot handle database bigger than 2MB?

Postby zanzibarneon » 05. February 2017 11:06

Yes fair point.
I'm merely making a respectful suggestion that it may avoid catching out some new users if the value was a little higher.
zanzibarneon
 
Posts: 14
Joined: 18. February 2011 09:18

Re: phpmyadmin cannot handle database bigger than 2MB?

Postby nhatminh1209 » 07. February 2017 18:26

Fact is: I set up a server on my own. That's the problem. If I'm using a host provider, I would never have to worried about this problem.
nhatminh1209
 
Posts: 6
Joined: 02. February 2017 12:11
XAMPP version: 5.6.28
Operating System: Windows 7

Re: phpmyadmin cannot handle database bigger than 2MB?

Postby Nobbie » 07. February 2017 22:31

nhatminh1209 wrote:If I'm using a host provider, I would never have to worried about this problem.


It depends. If you need a value higher than your provider applied, you cannot simply edit php.ini and apply a different value. Same problem for timeout etc. - it depends on your provider, if and how you may configure all these values.
Nobbie
 
Posts: 9629
Joined: 09. March 2008 13:04


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 39 guests