Jump to content


- - - - -

Importing Large Files with phpmyadmin


  • Please log in to reply
No replies to this topic

#1 wildweaselmi

wildweaselmi

    Administrator

  • Administrators
  • 1,024 posts

Posted 05 January 2012 - 08:24 AM

Find the config.inc.php file located in the phpmyadmin directory. Some examples:
WINDOWS WAMP: C:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php
UBUNTU: /etc/phpmyadmin/config.inc.php

Find the line with $cfg['UploadDir'] on it and update it to:
WINDOWS WAMP: $cfg['UploadDir'] = 'upload';
UBUNTU:  $cfg['UploadDir'] = '/etc/phpmyadmin/upload';

Create a directory called ‘upload’ within the phpmyadmin directory.
WINDOWS: C:\wamp\apps\phpmyadmin3.2.0.1\upload\
UBUNTU: /etc/phpmyadmin/upload

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





Similar Topics Collapse

  Topic Forum Started By Stats Last Post Info

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users