RSS

[mysql | tip] Custom import huge table in phpmyadmin

08 Dec

For importing, huge table in phpmyadmin without using sqlyog or file uploading through ftp and even if bigdump couldn’t upload your huge file then there is an easy way around to achieve the target by custom exporting the table first into number of files by first checking out the maximum file size to be allowed for importing file.

By custom export, it means to say exporting thousands of rows in a single file as shown in following screen-shots:

custom export

custom export

OR

custom export

custom export

and thus exporting table in number of files and then import all files one by one.
While moving vBulletin post table, this really helped me 🙂

Advertisements
 
Leave a comment

Posted by on December 8, 2011 in mysql

 

Tags: , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: