Upload Large Database Table to Server

On May 30, 2010, in Fedora, Mysql, Open Source, Tips, Tricks, by phpsolutions

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 “phpsolutions” from mysql admin server make 3 files “phpsolutions.frm”, “phpsolutions.MYD” and “phpsolutions.MYI”

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


phpsolutions-table

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 “phpsolutions.frm”, “phpsolutions.MYD” and “phpsolutions.MYI” for the table “phpsolutions” and after upload to server; we can unzip to mysql folder “/var/lib/mysql/phpsolutions”.

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

Keep up good work…. 🙂

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.