Docker uses the mysqldump command to back up and export mysql data in the project

mysqldump command

Introduction: A database backup program

Format: mysqldump [options] [db_name [tbl_name ...]] Description: The mysqldump client utility performs a logical backup, generating a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another SQL server. The mysqldump command can also generate output in CSV, other delimited text, or XML formats.

The following figure shows the renamed image name uoj. Now we need to export mysql in this image.

Run the following command:

docker exec -it uoj mysqldump -uroot -proot app_uoj233 >/data/database_bak/app_uoj233.sql

#Note: uoj is the image name -u is the database username -p is the database password app_uoj233 is the data name in the project, /data/database_bak/ is the export directory, app_uoj233.sql is the exported sql file, i.e. the database 

Summarize

The above is what I introduced to you. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!