Phpmyadmin import filesize  [SOLVED]

Locked
User avatar
info@eurhosting.net
KeyHelp Translator
Posts: 45
Joined: Tue 24. May 2016, 15:17
Location: Brno
Contact:

Phpmyadmin import filesize

Post 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
Stop stop stop
If hosting is not your main focus, I can be of help to mantain your servers
User avatar
info@eurhosting.net
KeyHelp Translator
Posts: 45
Joined: Tue 24. May 2016, 15:17
Location: Brno
Contact:

Re: Phpmyadmin import filesize

Post by info@eurhosting.net »

Could be the
upload_max_filesize
in the php.ini? That need a server reboot?
Stop stop stop
If hosting is not your main focus, I can be of help to mantain your servers
User avatar
Daniel
Keyweb AG
Posts: 114
Joined: Mon 25. Jan 2016, 04:42

Re: Phpmyadmin import filesize

Post by Daniel »

Hello,

you need to change the "upload_max_filesizie"

Code: Select all

/etc/php5/fpm/pool.d/keyhelp.conf
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.
Mit freundlichen Grüßen / Best regards
Daniel Marckardt

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
https://www.keyweb.de - https://www.keyhelp.de
**************************************************************
User avatar
info@eurhosting.net
KeyHelp Translator
Posts: 45
Joined: Tue 24. May 2016, 15:17
Location: Brno
Contact:

Re: Phpmyadmin import filesize [SOLVED]  [SOLVED]

Post 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.
Stop stop stop
If hosting is not your main focus, I can be of help to mantain your servers
User avatar
Tobi
Community Moderator
Posts: 2812
Joined: Thu 5. Jan 2017, 13:24

Re: Phpmyadmin import filesize

Post 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
Gruß,
Tobi


-----------------------------
wewoco.de
Das Forum für Reseller, Digital-Agenturen, Bildschirmarbeiter und Mäuseschubser
Locked