This container relies on the repository:
https://github.com/AJNOURI/test_db
forked from:
https://github.com/datacharmer/test_db
A sample database with Which is an integrated test suite, used to test your applications and database servers
$ docker-compose up -d
Creating network "testdb_default" with the default driver
Creating testdb_myfakesql_1 ... done
$ docker-compose ps
Name Command State Ports
---------------------------------------------------------------------------------
testdb_myfakesql_1 docker-entrypoint.sh mysqld Up 0.0.0.0:3306->3306/tcp
Create "employees" database:
$ mysql -h 127.0.0.1 -u root -p -Bse "create database employees;
Load employees data:
$ mysql -h 127.0.0.1 -u root -p "employees" < "employees.sql"
Enter password:
INFO
CREATING DATABASE STRUCTURE
INFO
storage engine: InnoDB
INFO
LOADING departments
INFO
LOADING employees
INFO
LOADING dept_emp
INFO
LOADING dept_manager
INFO
LOADING titles
INFO
LOADING salaries
data_load_time_diff
00:01:38
Commit the changes to an image:
$ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
7ace9f9d5547 mysql:5.7 "docker-entrypoint..." 26 minutes ago Up 26 minutes 0.0.0.0:3306->3306/tcp testdb_myfakesql_1
ajn@~/github/fake-mysql-db/test_db$ docker commit 7ace9f9d5547 ajnouri/fakemysqldb
And push to docker hub:
$ docker push ajnouri/fakemysqldb
The push refers to a repository [docker.io/ajnouri/fakemysqldb]
cf80a4b6afc5: Pushed
c5479ef6e03d: Mounted from library/mysql
1df83efbc52b: Mounted from library/mysql
4b402dfbab7b: Mounted from library/mysql
14d83b80d542: Mounted from library/mysql
b0c77fd3841d: Mounted from library/mysql
317e578f94b9: Mounted from library/mysql
fbb39c7dedaf: Mounted from library/mysql
55d5d837463a: Mounted from library/mysql
f0f28cc0eea1: Mounted from library/mysql
813996252a80: Mounted from library/mysql
3358360aedad: Mounted from library/haproxy
latest: digest: sha256:76a8331db4530bea31ab5e144b40d748ad3056b29ab4c642ecaeed669e5a4540 size: 2828
Content type
Image
Digest
Size
118 MB
Last updated
over 8 years ago
docker pull ajnouri/fakemysqldb