phpmyadmin cannot handle database bigger than 2MB?

[nhatminh1209]

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

[zanzibarneon]

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

[nhatminh1209]

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.

[Altrea]

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.

[zanzibarneon]

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.

[Altrea]

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.

[Nobbie]

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]

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???

[zanzibarneon]

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.

[nhatminh1209]

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.

[Nobbie]

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.