Category
Q. How to import large files in mysql ?
 
 


Answer :
For upload large file follow the following steps
Step-1 : Find the config.inc.php file located in the phpmyadmin directory. Generally it is located here:
C:\\\\\\\\wamp\\\\\\\\apps\\\\\\\\phpmyadmin3.2.0.1\\\\\\\\config.inc.php

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 :Place the large sql file that sql file you are trying to import into the new upload directory.

Step-5 :When you go onto the db import page within phpmyadmin console you will notice a drop down present that wasn�t there before � it contains all of the sql files in the upload directory that you have just created. You can now select this and begin the import.
Posted By : moderator
Post Answer :  
Answer * :
Are You? Already Member New User
   
User Name / Email * :
Password * :
Security Code * :

(Enter security code above shown on image)