Upload Large Database Table to Server

30 May

Hello Friends,

Sometime we want to upload large database table to server but phpMyAdmin have limit to upload SQL large *.sql files..

When we create database table “svnlabs” from mysql admin server make 3 files “svnlabs.frm”, “svnlabs.MYD” and “svnlabs.MYI”

These files are located at “/var/lib/mysql/svnlabs”.. we can check this location by phpinfo.php



We can upload all these 3 files to server using ftp or rsync.

Here source location may be either Windows or Linux and destination may be both.

We can upload zip of all 3 files “svnlabs.frm”, “svnlabs.MYD” and “svnlabs.MYI” for the table “svnlabs” and after upload to server; we can unzip to mysql folder “/var/lib/mysql/svnlabs”.

As files successfully uploaded to online server we can check new table “svnlabs” from phpMyAdmin.

Keep up good work…. 🙂

Leave a comment

Posted by on May 30, 2010 in Fedora, MySQL, Open Source, Tips, Tricks


Tags: , , , , , ,

Leave a Reply

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

You are commenting using your 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: