Import/Export Large MYSQL Databases http://www.lullabot.com/blog/news/importexport-large-mysql-databases

mysql

//Copy/Export a Large Database
mysqldump -u [USERNAME] -p [DBNAME] | gzip > [/path_to_file/DBNAME].sql.gz
//Import a Large Database
//First, unzip the file.
//gzip -d [/path_to_file/DBNAME].sql.gz
mysql -u root -p
SHOW DATABASES;
CREATE DATABASE [DBNAME];
USE [DBNAME];
SOURCE [/path_to_file/DBNAME].sql;