- Clone the original project from GitHub https://github.com/datacharmer/test_db.git.
- Rename the directory to employees.
- Create your own git repository and push the files to it.
- Rename the original README.md to README-original.md
- Add this README.md
- Delete the Sakila Test Database
- Run
mysql 'cat ~/.mysql/oofenloch@localhost' < employees.sql
to install the database. - Run the test script:
./sql_test.sh 'mysql -uoofenloch -pFakePassword -P3307'
oofenloch@teben:~/workspaces/mysql$ git clone https://github.com/datacharmer/test_db.git
Cloning into 'test_db'...
remote: Enumerating objects: 105, done.
remote: Total 105 (delta 0), reused 0 (delta 0), pack-reused 105
Receiving objects: 100% (105/105), 74.27 MiB | 5.47 MiB/s, done.
Resolving deltas: 100% (54/54), done.
oofenloch@teben:~/workspaces/mysql$ mv test_db employees
oofenloch@teben:~/workspaces/mysql$ cd employees/
oofenloch@teben:~/workspaces/mysql/employees$ git status
On branch master
Your branch is up to date with 'origin/master'.
nothing to commit, working tree clean
oofenloch@teben:~/workspaces/mysql/employees$ git remote rename origin old-origin
oofenloch@teben:~/workspaces/mysql/employees$ git remote add origin https://teben.hopto.org:9080/mysql/employees.git
oofenloch@teben:~/workspaces/mysql/employees$ git push -u origin --all
Enumerating objects: 105, done.
Counting objects: 100% (105/105), done.
Delta compression using up to 8 threads
Compressing objects: 100% (50/50), done.
Writing objects: 100% (105/105), 74.27 MiB | 36.49 MiB/s, done.
Total 105 (delta 54), reused 105 (delta 54)
remote: Resolving deltas: 100% (54/54), done.
To https://teben.hopto.org:9080/mysql/employees.git
* [new branch] master -> master
Branch 'master' set up to track remote branch 'master' from 'origin'.
oofenloch@teben:~/workspaces/mysql/employees$ git push -u origin --tags
Everything up-to-date
oofenloch@teben:~/workspaces/mysql/employees$ git mv README.md README-original.md
oofenloch@teben:~/workspaces/mysql/employees$ git rm -r sakila/
rm 'sakila/README.md'
rm 'sakila/sakila-mv-data.sql'
rm 'sakila/sakila-mv-schema.sql'
oofenloch@teben:~/workspaces/mysql/employees$
oofenloch@teben:~/workspaces/mysql/employees$ mysql `cat ~/.mysql/oofenloch@localhost` < employees.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
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:00:20
oofenloch@teben:~/workspaces/mysql/employees$
``