Database Uploads for WordPress with PHP: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
m →Notes |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
...wanna import a big database file for WordPress using phpMyAdmin? Good luck. The default settings PHP settings in php.ini will likely prevent that. | ...wanna import a big database file for WordPress using phpMyAdmin? Good luck. The default settings PHP settings in php.ini will likely prevent that. | ||
Solution? | === Solution? === | ||
Change settings in /etc/php.ini (or other locations like /opt/remi, if using REMI for multiple PHP versions. | |||
= php.ini | == php.ini == | ||
Below are the main settings to modify. Jack 'em up higher if you have the RAM and / or need to import some really big stuff.<syntaxhighlight lang="ini"> | |||
<syntaxhighlight lang="ini"> | |||
upload_max_filesize = 512M | upload_max_filesize = 512M | ||
post_max_size = 600M | post_max_size = 600M | ||
| Line 19: | Line 13: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
=== Directive Definitions === | |||
; <code>upload_max_filesize</code> | |||
: Maximum size of an uploaded SQL file. | |||
; <code>post_max_size</code> | |||
: Maximum total HTTP POST request size. Set this larger than <code>upload_max_filesize</code>. | |||
; <code>memory_limit</code> | |||
: Maximum memory PHP may use. For large imports, set this larger than <code>post_max_size</code>. | |||
; <code>max_execution_time</code> | |||
: Maximum script execution time, in seconds. | |||
; <code>max_input_time</code> | |||
: Maximum time PHP may spend receiving input, including uploads. | |||
== Settings can also be done in phpMyAdmin == | |||
If it isn't desirable to modify system wide php.ini settings, just do it for phpMyAdmin. Location of where the config file is varies depending on the 'flavor' of Linux being used. | |||
<syntaxhighlight lang="php"> | <syntaxhighlight lang="php"> | ||
| Line 44: | Line 39: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
<code>$cfg[' | === More Definitions === | ||
; <code>$cfg['ExecTimeLimit']</code> | |||
: phpMyAdmin execution time limit. | |||
; <code>$cfg['MemoryLimit']</code> | |||
: phpMyAdmin memory limit override. | |||
< | |||
</ | |||
; <code>$cfg['UploadDir']</code> | |||
: Allows SQL files to be copied to a server-side upload directory and selected from phpMyAdmin, avoiding browser upload limits. | |||
<syntaxhighlight lang="ini"> | == .htaccess too == | ||
Settings can be done on a per website basis too.<syntaxhighlight lang="ini"> | |||
upload_max_filesize = 512M | upload_max_filesize = 512M | ||
post_max_size = 600M | post_max_size = 600M | ||
| Line 69: | Line 58: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
== | == Remember == | ||
* | * Don't forget to restart PHP-FPM or other PHP related daemons / services if editing php.ini, as those settings won't apply until that's done | ||
* | * Restarting httpd or apache2, etc, won't cut it. | ||
== | == References == | ||
* [https://www.php.net/manual/en/ini.core.php PHP Manual: Core php.ini directives] | * [https://www.php.net/manual/en/ini.core.php PHP Manual: Core php.ini directives] | ||
* [https://www.php.net/manual/en/features.file-upload.common-pitfalls.php PHP Manual: File upload common pitfalls] | * [https://www.php.net/manual/en/features.file-upload.common-pitfalls.php PHP Manual: File upload common pitfalls] | ||
* [https://www.php.net/manual/en/configuration.changes.php PHP Manual: | * [https://www.php.net/manual/en/configuration.changes.php PHP Manual: Changing configuration settings] | ||
* [https://www.php.net/manual/en/configuration.file.per-user.php PHP Manual: .user.ini files] | * [https://www.php.net/manual/en/configuration.file.per-user.php PHP Manual: .user.ini files] | ||
* [https://docs.phpmyadmin.net/en/latest/config.html phpMyAdmin Documentation: Configuration] | * [https://docs.phpmyadmin.net/en/latest/config.html phpMyAdmin Documentation: Configuration] | ||
* [https://docs.phpmyadmin.net/en/ | * [https://docs.phpmyadmin.net/en/latest/faq.html#i-cannot-upload-big-dump-files-memory-http-or-timeout-problems phpMyAdmin FAQ: Cannot upload big dump files] | ||
Latest revision as of 23:04, 3 June 2026
...wanna import a big database file for WordPress using phpMyAdmin? Good luck. The default settings PHP settings in php.ini will likely prevent that.
Solution?
Change settings in /etc/php.ini (or other locations like /opt/remi, if using REMI for multiple PHP versions.
php.ini
Below are the main settings to modify. Jack 'em up higher if you have the RAM and / or need to import some really big stuff.
upload_max_filesize = 512M
post_max_size = 600M
memory_limit = 768M
max_execution_time = 600
max_input_time = 600Directive Definitions
upload_max_filesize- Maximum size of an uploaded SQL file.
post_max_size- Maximum total HTTP POST request size. Set this larger than
upload_max_filesize.
memory_limit- Maximum memory PHP may use. For large imports, set this larger than
post_max_size.
max_execution_time- Maximum script execution time, in seconds.
max_input_time- Maximum time PHP may spend receiving input, including uploads.
Settings can also be done in phpMyAdmin
If it isn't desirable to modify system wide php.ini settings, just do it for phpMyAdmin. Location of where the config file is varies depending on the 'flavor' of Linux being used.
$cfg['ExecTimeLimit'] = 600;
$cfg['MemoryLimit'] = '768M';
$cfg['UploadDir'] = 'upload';More Definitions
$cfg['ExecTimeLimit']- phpMyAdmin execution time limit.
$cfg['MemoryLimit']- phpMyAdmin memory limit override.
$cfg['UploadDir']- Allows SQL files to be copied to a server-side upload directory and selected from phpMyAdmin, avoiding browser upload limits.
.htaccess too
Settings can be done on a per website basis too.
upload_max_filesize = 512M
post_max_size = 600M
memory_limit = 768M
max_execution_time = 600
max_input_time = 600Remember
- Don't forget to restart PHP-FPM or other PHP related daemons / services if editing php.ini, as those settings won't apply until that's done
- Restarting httpd or apache2, etc, won't cut it.