Hello
How to increase the max filesize in phpmyadmin of importing db?
At the moment if I'm not wrong is 64mega
Phpmyadmin import filesize [SOLVED]
- info@eurhosting.net
- KeyHelp Translator
- Posts: 45
- Joined: Tue 24. May 2016, 15:17
- Location: Brno
- Contact:
Phpmyadmin import filesize
Stop stop stop
If hosting is not your main focus, I can be of help to mantain your servers
If hosting is not your main focus, I can be of help to mantain your servers
- info@eurhosting.net
- KeyHelp Translator
- Posts: 45
- Joined: Tue 24. May 2016, 15:17
- Location: Brno
- Contact:
Re: Phpmyadmin import filesize
Could be the
upload_max_filesize
in the php.ini? That need a server reboot?
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
If hosting is not your main focus, I can be of help to mantain your servers
Re: Phpmyadmin import filesize
Hello,
you need to change the "upload_max_filesizie"
And perform a restart via:
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.
you need to change the "upload_max_filesizie"
Code: Select all
/etc/php5/fpm/pool.d/keyhelp.conf
Code: Select all
/etc/init.d/apache2 restart; /etc/init.d/php-fpm restart
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
**************************************************************
Daniel Marckardt
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
https://www.keyweb.de - https://www.keyhelp.de
**************************************************************
- info@eurhosting.net
- KeyHelp Translator
- Posts: 45
- Joined: Tue 24. May 2016, 15:17
- Location: Brno
- Contact:
Re: Phpmyadmin import filesize [SOLVED] [SOLVED]
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.
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
If hosting is not your main focus, I can be of help to mantain your servers
Re: Phpmyadmin import filesize
I always recommend bigdump.info@eurhosting.net wrote: but customer is not able to do it himselfe and doesn't want to be billed for the service
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
Tobi
-----------------------------
wewoco.de
Das Forum für Reseller, Digital-Agenturen, Bildschirmarbeiter und Mäuseschubser