Skip to main content

how to import more than 2 mb to 1024 mb data base file in phpmyadmin

how to import more than 2 mb to 1024 mb data base file in phpmyadmin


I tried and i got the error message saying the size is greater. I tried with php.ini and increased the size of upload

===================

change upload_max_filesize 2M  to 1024M

==================

; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
  upload_max_filesize = 300M


Find:
===========================

post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

==============================

Change to:

post_max_size = 1024M
upload_max_filesize = 1024M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M 

Comments

Popular posts from this blog

How to delete Torrent power account

Sanjay Tech solutions 3 easy tips to delete torrent power account  Step 1 : login in to your account Step 2 : click on more profile settings Step 3 : you see red button with deactivate account click then enter your password Your account deactivate 

Anaconda update error PermissionError(13, 'Permission denied')

sanjay@luck:~$ conda update -n base conda Solving environment: done ## Package Plan ##   environment location: /home/sanjay/anaconda3   added / updated specs:     - conda The following packages will be UPDATED:     conda: 4.4.10-py36_0 --> 4.5.4-py36_0 Proceed ([y]/n)? y Preparing transaction: done Verifying transaction: done Executing transaction: failed ERROR conda.core.link:_execute(481): An error occurred while uninstalling package 'defaults::conda-4.4.10-py36_0'. PermissionError(13, 'Permission denied') Attempting to roll back. Rolling back transaction: done PermissionError(13, 'Permission denied') =========== you need to give a writable directory permission. on anaconda install directory. --> $ sudo chmod -R 755 anaconda3 sanjay@luck:~$ sudo chmod -R 777 anaconda3/  ============== sanjay@luck:~$ conda update anaconda-navigator Solving environment: done ## Package Plan ##   environment location: /home/sanjay/anaconda3   added / u