How to import SQL file in phpmyadmin which is over sized then allowed.

I am creating this tutorial using the Ubuntu so some of the directory may not be the same:

Step 1: 

Open the file named config.inc.php which is especially located in  /etc/phpmyadmin/config.inc.php
in Window generally located at : C:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php

Step 2: 
Now find the line containing $cfg['UploadDir'] = ''; 
and replace it 
with $cfg['UploadDir'] = '/etc/phpmyadmin/upload'; 

in Window it will work
$cfg['UploadDir'] = 'upload'; 

Step 3: Now create the new folder named upload in the same directory of config.inc.php

Step 4: Now copy or place your .sql file in that upload folder.

Step 5: Now restart the server and refresh the upload page in the phpmyadmin

Step 6: Now You will be able to see the select option just below the upload option and now you can select the .sql file to import. Thats it now it start to import as a charm

Happy Importing :)

0 comments:

Post a Comment