How to increase the phpMyAdmin import file limit
1
2
3
Step into the Reading
Baidu Experience: jingyan.baidu.com
PhpMyAdmin is a php-written, web-based way to control and manipulate MySQL databases. Because the operation is simple by the vast number of users who use MySQL, users who use phpMyAdmin may encounter such a problem, when you are ready to import MySQL backup when found unable to import, because the phpMyAdmin import limit is 2M, this can embarrass a lot of users, What ca
The example in this article tells the PHP run prompt: Fatal error allowed memory size is not enough to resolve. Share to everyone for your reference. Here's how:
Some friends new configuration of the environment or their own newly written program run will encounter fatal error:allowed memory size of 134217728 bytes exhausted error, this problem is not written by the program caused, Another is the environment configuration is not good also will appear, like php5.1.27+apache2.2.3 appears in the w
Open PHP.ini, first findFile_uploads = on; switch to allow uploading of files over HTTP. The default is on, which is openUpload_tmp_dir; files uploaded to the server where temporary files are stored, if not specified, will use the system default temporary folderUpload_max_filesize = 8m; Hope business, that is, the maximum size allowed to upload files. Default is 2MPost_max_size = 8m; The maximum value that
Baidu Editor Ueditor is developed by the Baidu Web front-end research and development department to see the Rich Text Web editor, with a lightweight, customizable, pay attention to user experience and other characteristics, open source based on the MIT protocol, allow free use and modify code, so by many open-minded people favor. But sometimes we are quoted in the Baidu editor will encounter in the upload of large-capacity video report HTTP request error, then encounter this situation should be
PHP.ini can't upload big file perfect solution
1, open the php.ini (open the way needless to say, Baidu a lot of)
2. Find Post_max_size
The form submits the maximum number, which is not a restriction on the size of an individual file to upload, but rather a restriction on the submission data for the entire form.
The default is 8M, set to the value you want, this parameter is recommended to set larger than upload_max_filesize
3. Find File Uploads
Open PHP.ini, first findFile_uploads = on; switch to allow uploading of files over HTTP. The default is on, which is openUpload_tmp_dir; files uploaded to the server where temporary files are stored, if not specified, will use the system default temporary folderUpload_max_filesize = 8m; Hope business, that is, the maximum size allowed to upload files. Default is 2MPost_max_size = 8m; The maximum value that
, default to on that is open
Ini_set (' file_uploads ', ' on ');
The time limit for receiving data through post, get, and put is limited to 90 seconds default value: 60
Ini_set (' Max_input_time ', ' 90 ');
The script execution time is changed from the default 30 seconds to 180 seconds.
Ini_set (' max_execution_time ', ' 180 ');
The post variable is modified from 2M to 8M, and this value is changed to be larger than upload_max_filesi
Tables are the number of tables that are already open). That is, if Open_tables is approaching Table_cache, and opened_tables this value is gradually increasing, consider increasing the size of this # value. There is also the time when table_locks_waited is higher, also need to increase table_cache.
external-locking = FALSE
#使用 –skip-external-locking mysql option to avoid external locking. This option is turned on by default
Max_allowed_packet = 32M
#设置在网络传输中一次消息传输量的最大值. The system de
is: 4194304, that is: 4MB).4, save, and then restart the IIS Admin Service services, restart IIS.
Ii. Solutions in the php.ini
1, find post_max_size, refers to the form post to PHP can receive the maximum value, including all the values in the form, the default is 8M, see you need to change.2, look for file uploads, first confirm file_uploads = on; whether to allow the switch to upload files via HTTP, by default on is open.3, find upload_max_filesi
Open PHP.ini, first findFile_uploads = on; switch to allow uploading of files over HTTP. The default is on, which is openUpload_tmp_dir; files uploaded to the server where temporary files are stored, if not specified, will use the system default temporary folderUpload_max_filesize = 8m; Hope business, that is, the maximum size allowed to upload files. Default is 2MPost_max_size = 8m; The maximum value that
Locate the php.ini file in the php file in the D:\xampp\php directory, and open it with WordPad:1. Findpost_max_size, which is the maximum value that can be received by post to PHP via the form, including all values in the form, by default, 8M, to see if you need to change.2, find the file uploads, first confirmfile_uploads= on; whether to allow the switch to upload files over HTTP, the default is on is on. Upload_tmp_dir;3. Findupload_max_filesize; t
/
#innodb_log_arch_dir =/var/lib/mysql/
# you can set ... _buffer_pool_size up to 50-80%
# of RAM But beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set ... _log_file_size to% of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
[Mysqldump]
Quick
Max_allowed_packet = 16M
[MySQL]
No-auto-rehash
# Remo
2013] [Notice] Child 2964:starting threads worker.
[Thu APR 11 18:31:31 2013] [Notice] Child 2964:listening on port 80.
After consulting the Apache and the Forum data, found that the win platform with regular preg_match_all or preg_match analysis of the longer string, causing the Apache crash restart because the Windows platform under the default allocated thread stack space Threadstacksize is too small to cause. Win32 default is only 256KB, and in Linux, the default is
of more than 4M:
1, first in the service to shut down the IIS Admin Service services.
2, find windows/system32/inetsrv/under the MetaBase.xml file.
3, with WordPad Open, find aspbufferinglimit to change it to the desired value (the default is: 4194304, that is: 4MB).
4, save, and then restart the IIS Admin Service services, restart IIS.
Second, PHP part
1, find post_max_size, refers to the form post to PHP can receive the maximum value, including all the values in the form, the default is
memory, the larger the setting. Defaults to 2402, to 512-1024 best
innodb_additional_mem_pool_size=8m defaults to 2M
innodb_flush_log_at_trx_commit=0 wait until Innodb_log_buffer_size queue is full and then unified storage, the default is 1
innodb_log_buffer_size=4m defaults to 1M
Innodb_thread_concurrency=8 a few of your server CPUs are set to a few, default to 8
key_buffer_size=256m defaults to 218 to 128 best
tmp_table_size=64m defaults to 16M up
Needless to say, you have to find the PHP configuration file php.ini trouble:Open PHP.ini, first find; File uploads;Area, there are several parameters that affect file uploads:File_uploads = on; whether to allow the switch to upload files over HTTP. The default is on, which is openUpload_tmp_dir files are uploaded to the server where temporary files are stored, and the system default temporary folder is used if unspecifiedUpload_max_filesize = 8m busi
This example describes the PHP run Tip: Fatal error allowed memory size memory solution. Share to everyone for your reference. The specific methods are as follows:
Some friends a newly configured environment or a newly-written program of your own will run into the fatal error:allowed memory size of 134217728 bytes exhausted error, a problem that is poorly written, Another is that the environment configuration is not good will appear, like php5.1.27+apache2.2.3 in the windows2003 will appear in
transaction. are assigned to each connection max_heap_table_size=64m#### Maximum capacity allowed for stand-alone memory tables READ_BUFFER_SIZENBSP;=Nbsp;2m#### MySQL read-in buffer size read_rnd_buffer_size=16m#### MySQL Random read buffer size sort_buffer_size=8m ### #排序缓冲被用来处理类似ORDER by and Groupby queues are caused by the sort join_buffer_size=8m ### #联合查询所能使用的缓冲区大小, This parameter corresponds to the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.