Thursday 24 April 2014

Add large size database in phpmyadmin ....

step 1

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

C:\wamp\apps\phpmyadmin3.4.5\config.inc.php 

Note:  phymyadmin3.4.5 folder name is different in different version of wamp

step 2:

Find the line with $cfg['UploadDir'] on it and update it to:

$cfg['UploadDir'] = 'upload';


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


step 4:

copy and paste the  large sql file into upload directory which you want importing to phymyadmin

step 5: 

select sql file from drop down list from phymyadmin to import



No comments:

Post a Comment