How to import table in phpmyadmin? I got error of file size

Question

I want to import database in phpmyadmin but i got error like this... "No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration."

my file size is 4.8 mb,

please give me solution....

Answer 1

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.

Answer 2

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..