Category
- Php
- JAVA
- DOTNET
- Vbscript
- C
- vb
- html
- Mysql
- Oracle
- sql
- Db
- Computer
- Commerce
- Business
- Arts
- Cashier
- Audit
- Banking
- Accounts
- Math
- Physics
- Biology
- Others
Home >> Asked Questions >> Mysql
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.
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
Most Viewed Questions