Page 1 of 1
Phpmyadmin import filesize
Posted: Tue 30. Aug 2016, 13:26
by info@eurhosting.net
Hello
How to increase the max filesize in phpmyadmin of importing db?
At the moment if I'm not wrong is 64mega
Re: Phpmyadmin import filesize
Posted: Tue 30. Aug 2016, 13:30
by info@eurhosting.net
Could be the
upload_max_filesize
in the php.ini? That need a server reboot?
Re: Phpmyadmin import filesize
Posted: Tue 30. Aug 2016, 20:04
by Daniel
Hello,
you need to change the "upload_max_filesizie"
And perform a restart via:
Code: Select all
/etc/init.d/apache2 restart; /etc/init.d/php-fpm restart
But its not recommended to import such large dumps through phpmyadmin. It should be proceed by the usage of the cli/ssh dump for less possible errors and better performance.
Re: Phpmyadmin import filesize [SOLVED] [SOLVED]
Posted: Tue 30. Aug 2016, 20:49
by info@eurhosting.net
Hello Daniel
Thank you very much for this useful hint.
I'm aware, but customer is not able to do it himselfe and doesn't want to be billed for the service so we agreed to allow him temporarily to enlarge the filesize for the upload.
Re: Phpmyadmin import filesize
Posted: Mon 23. Jan 2017, 08:29
by Tobi
info@eurhosting.net wrote: but customer is not able to do it himselfe and doesn't want to be billed for the service
I always recommend bigdump.
See:
http://www.ozerov.de/bigdump/
You upload the file via FTP (no file upload limit
) and the usage is pretty simple. This script even works with very large Imports.
Another possibility would be to import the file from shell
Code: Select all
mysql -h localhost -u username --password=secret database < importfile.sql