Sign inSign up

ajnouri/fakemysqldb

By ajnouri

•Updated over 8 years ago

Image
0

313

ajnouri/fakemysqldb repository overview

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

⁠Building mysql docker container

$ 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

Tag summary

Content type

Image

Digest

Size

118 MB

Last updated

over 8 years ago

docker pull ajnouri/fakemysqldb