Showing posts from September, 2012

Importing Large MySql File Using phpMyAdmin

For importing large MySQL file using phpmyadmin follow the below procedure
i am using XAMPP, same should work with WAMP also

1) Go to the phpmyadmin folder D:\xampp\phpMyAdmin  or D:\xampp\phpMyAdmin\libraries\config.default.php
2) Open the file
3) find the line or insert the below line, this says the upload folder should be where we will be storing the sql file for importing
 $cfg['UploadDir'] = 'upload';
4) Create a folder  ‘upload'  in C:\xampp\phpMyAdmin

Now we can place large sql file, created using mysqldump or mysql export. I had placed a sql file with file name test-db-dump.sql

5) Now go the DB through phpMyAdmin and click on the import tab as seen below,