13 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 config.inc.php
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,



 
  In the combo box you can see the file we copied,  Now  hit the Go button in the bottom of the page, it will import the whole sql file to your database.


NOTE:
If you get the below error
 Fatal error: Maximum execution time of 300 seconds exceeded in

Edit the phpMyAdmin\libraries\config.default.php
$cfg['ExecTimeLimit'] = 300;


change the 300 to 1000 or more






No comments:

Post a Comment