Dump SQL

mysqldump -u USER -p PASSWORD -h HOST DATABASE > data-dump.sql mysqldump -u USER -p PASSWORD DATABASE > data-dump.sql mysqldump -u USER -p PASSWORD DATABASE | gzip > `date +dump%Y%m%d_%H%M%S.sql.gz` mysql -u root -p PASSWORD CREATE DATABASE new_database; mysql -u USER -p PASSWORD DATABASE < data-dump.sql USE new_database; SHOW TABLES; https://www.oslogic.ru/knowledge/443/dampy-baz-dannyh-mysql-mysqldump/