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.

Tags:

Php

Phpmyadmin