## Backup #All #docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql # Structure docker exec CONTAINER /usr/bin/mysqldump -u root --password=root --no-data DATABASE > structure.sql # Data docker exec CONTAINER /usr/bin/mysqldump -u root --password=root --no-create-info DATABASE > data.sql # Ignore tables #docker exec CONTAINER /usr/bin/mysqldump -u root --password=root --ignore-table=name_of_db.name_of_table DATABASE > ignore_tables.sql # Restore cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE