.

.
How to import large sql files into mysql using phpmyadmin wamp server

How to import large sql files into mysql using phpmyadmin wamp server

21:32
When you try to import sql file to wamp server usually it cann't upload more than  2,048KiB size and gives error message like













When you try to import sql file to wamp server usually it cann't upload more than  2,048KiB size and gives error message like


There is another way to upload large size of sql file to wamp server

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


EmoticonEmoticon

Subscribe to: Post Comments (Atom)