otkrsk · August 29, 2015 14:05
diff --git a/backup_restore_mysql_dump b/backup_restore_mysql_dump
 #backup all databases in one file (eventually add the option --add-locks):
 mysqldump -u [username] -p[root_password] [database_name] > file.sql

 #backup all databases in one gzipped file:
 mysqldump -u [username] -p[password] -–all-databases | gzip > file.sql.gz

 #restore all databases:
 mysql -u [username] -p[password] < file.sql
	#backup all databases in one file (eventually add the option --add-locks):
	mysqldump -u [username] -p[root_password] [database_name] > file.sql

	#backup all databases in one gzipped file:
	mysqldump -u [username] -p[password] -–all-databases \| gzip > file.sql.gz

	#restore all databases:
	mysql -u [username] -p[password] < file.sql