Jump to content

Importing Large Files with phpmyadmin


Recommended Posts

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';[/code]

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...