Editing Backing up MySQL Database Hosted in Docker Container (section)

== Backing up and Restoring==
=== Dump Database ===

Check the container id.

<syntaxhighlight lang="bash">
$ docker ps
CONTAINER ID  IMAGE         COMMAND                CREATED         STATUS         PORTS                   NAMES
f91d97a62086  jspmysql:0.1  "docker-entrypoint..." 28 minutes ago  Up 28 minutes  0.0.0.0:6603->3306/tcp  jspmysql
</syntaxhighlight>

Execute `mysqldump` in docker terminal.

<syntaxhighlight lang="bash">
$ docker exec f91d97a62086 /usr/bin/mysqldump -u root --password=jsppassword jsptutorial > backup.sql
</syntaxhighlight>

Notice `f91d97a62086` is the container id, `jsptutorial` is the database and `backup.sql` is the output file. After running the above command, a new backup.sql file is created. ![image](https://jojozhuang.github.io/assets/images/architecture/3513/mysqldump.png)

=== Checking the Output File===

Notice that new product `(4,'iPad',399)` is added to the sql for restoring table `Product`. ![image](https://jojozhuang.github.io/assets/images/architecture/3513/newsql.png) Now you can rename this file to jsp_backup.sql or use it directly in Dockerfile to create MySQL image.

=== Restoring Data to MySQL Container===

You can also restore the data directly to the container. In docker terminal, run the following command.

<syntaxhighlight lang="bash">
$ cat backup.sql | docker exec -i f91d97a62086 /usr/bin/mysql -u root --password=jsppassword jsptutorial
</syntaxhighlight>

{{article summary
| image = 
| title = {{%PAGENAME%}}
| summary = We created a MySQL image with Dockerfile, and used this image to run MySQL container. 
}}

[[Category:Technology]]
[[Category:Software]]
[[Category:Computers]]
[[Category:Privacy]]