carltondickson · March 26, 2023 15:18 · uacode · Oct 27, 2020
diff --git a/gistfile1.sql b/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/