example_mysql.md

Mysql Example

• Back

Load database

1. Launch docker database

• docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -p 3306:3306 -d mysql:5.6.50

1. connect to database using mysql workbench
   • user: root
   • password: my-secret-pw
2. Restore backup
   • download AdventureWorks-MySQL-with-FKs.zip
   • copy AdventureWorks-MySQL-with-FKs.sql and run in mysql workbench to load

Commands

1. generate output see DONT forget to specify schemas if you don't want to generate all your mysql databases

   schemacrawler \
     --server=mysql --schemas=adventureworks \
     --port=3306 --user=root --host=host.docker.internal --password=my-secret-pw \
     --info-level=maximum \
     --command script \
     --script-language python \
     --script ./share/mermaid.py > ./share/output_mysql.md
   • NOTES:
     • FIXME: where generator doesn't close, some type error in mermaid.py
     • Maximum text size in diagram exceeded, apparently mermaid has limits see
2. other commands
   • schemacrawler -h > ./share/help.txt

   • schemacrawler \
       --server=mysql --schemas=adventureworks \
       --port=3306 --user=root --host=host.docker.internal --password=my-secret-pw \
       --info-level=maximum --command=schema > ./share/raw_mysql.txt

   • schemacrawler \
       --server=mysql --schemas=adventureworks \
       --port=3306 --user=root --host=host.docker.internal --password=my-secret-pw \
       --info-level=maximum execute --command list