carltondickson/gist:b14d72d9d3631f870c48

## gistfile1.sql
# Exporting entire database:
mysqldump -u user -p database --opt | gzip > database.sql.gz

# Export table
mysqldump -uroot --opt --databases DB_NAME --tables TABLE_NAME | gzip > /tmp/TABLE_NAME.export.sql.gz

# Importing:
gunzip < database.sql.gz | mysql -u user -p database

# Credit http://failshell.io/mysql/using-gzip-and-gunzip-with-mysql-to-importexport-backups/
	# Exporting entire database:
	mysqldump -u user -p database --opt \| gzip > database.sql.gz

	# Export table
	mysqldump -uroot --opt --databases DB_NAME --tables TABLE_NAME \| gzip > /tmp/TABLE_NAME.export.sql.gz

	# Importing:
	gunzip < database.sql.gz \| mysql -u user -p database

	# Credit http://failshell.io/mysql/using-gzip-and-gunzip-with-mysql-to-importexport-backups/