How to import table in phpmyadmin? I got error of file size
Follow theses steps
Go to the PHP folder -> search for php.ini
Seach for the below line and change it according to your need.
; Maximum allowed size for uploaded files.
upload_max_filesize = 2M
Restart the server to confirm changes.
You need to edit the php.ini file for changing the file size. the line is
upload_max_filesize = 2M
You need to change the file size that you need to import.For ex: if you need to import a 10 mb file,then change it into
upload_max_filesize = 10M
Then restart your server.
try to edit after change into php.ini :
upload_max_filesize = 10M
post_max_size = 20M
memory_limit = 128M
also change the value of max_execution_time
EDIT: if you want then do all that stuff with command line:
mysql -h[Host Name] -u[User Name] [Database Name]<[SQL File Name] -p
through this you will import the database..
Copy the data from the file, put it into the sql tab of phpmyadmin, and press the "Go" button.