Cacher is the code snippet organizer for pro developers

//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;