Web Development Tips and Tricks

Web Development Tips and Tricks

Saturday, January 28, 2012

Importing large files into mysql with phpmyadmin

Today I am wrting how to import large file withphpmyadmin


Find the config.inc.php file located in the phpmyadmin directory. In my my system it is located :

Step1)
C:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php
Find the line with $cfg['UploadDir'] on it and update it to:
$cfg['UploadDir'] = 'upload';

Step2)
Create a directory called ‘upload’ within the phpmyadmin directory.
C:\wamp\apps\phpmyadmin3.2.0.1\upload\

Then place the large sql file that you are trying to import into the new upload directory. Now when you go onto the database import page within your phpmyadmin console you will notice a drop down present that wasn’t there before .
You can now select this and begin the import.


website design in lucknow, web design in lucknow, website design company in lucknow, web designing in lucknow, website designing company in lucknow, website development company india, web development company , mlm software development lucknow, mlm softwre company, mlm lucknow, mlm website design lucknow, website develpoment, web designing company lucknow , website designing company , web designing, seo services company lucknow , seo services company, seo services, seo company lucknow , seo experts lucknow , search engine optimization, seo outsourcing lucknow , e-commerce solution company lucknow , e-commerce application, hire php web developer, web development companies in lucknow , web design companies in lucknow

No comments:

Post a Comment