freelance84 Posted October 10, 2011 Share Posted October 10, 2011 Running Ubuntu 11.04. Got all the LAMP and phpMyadmin working Trying to upload my database but failing. I've changed the 'upload_max_file_size' to '10M', and the 'post_max_size' to '15M', the memory limit is set at -1 thus no limit. I restarted the entire server but still the phpmyadmin says it can onlt upload the default max of 2MiB. tried to upload my db but it did indeed fail... How can I change this? Quote Link to comment https://forums.phpfreaks.com/topic/248809-max-file-size-preventing-db-upload/ Share on other sites More sharing options...
freelance84 Posted October 10, 2011 Author Share Posted October 10, 2011 I have also written a my.cnf file: nano /etc/my.cnf [mysqld] datadir=/var/lib/mysql skip-locking skip-innodb skip-networking safe-show-database query_cache_limit=1M query_cache_size=32M ## 32MB for every 1GB of RAM query_cache_type=1 max_user_connections=200 max_connections=500 interactive_timeout=10 wait_timeout=20 connect_timeout=20 thread_cache_size=128 key_buffer=64M ## 64MB for every 1GB of RAM join_buffer=1M max_connect_errors=20 max_allowed_packet=16M table_cache=1024 record_buffer=1M sort_buffer_size=1M ## 1MB for every 1GB of RAM read_buffer_size=1M ## 1MB for every 1GB of RAM read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM thread_concurrency=2 ## Number of CPUs x 2 myisam_sort_buffer_size=64M server-id=1 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout but still no joy Quote Link to comment https://forums.phpfreaks.com/topic/248809-max-file-size-preventing-db-upload/#findComment-1277801 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.