MySql - SQL Dump

1 - About

A SQL dump is a dump of database in a sql script

3 - Management

They are managed with mysqldump

3.1 - Creation

With docker

docker exec some-mysql sh -c 'exec mysqldump --all-databases -uroot -p"$MYSQL_ROOT_PASSWORD"' > /some/path/on/your/host/all-databases.sql

3.2 - Restoring

with docker and the i option

docker exec -i some-mysql sh -c 'exec mysql -uroot -p"$MYSQL_ROOT_PASSWORD"' < /some/path/on/your/host/all-databases.sql

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap