Saturday 21 April 2018

get all Create table scripts from Database


mysqldump --no-data --user=USERNAME --password=PASSWORD --host=HOST DATABASE_NAME TABLE_NAME

Example:
If you want the entire database, just remove TABLE_NAME:
in below statement transport is DATABASE_NAME, it fetches all table create statements.

$ mysqldump --no-data --user=root --password=password --host=localhost transport > sql.txt

Wednesday 4 April 2018

Netflix Conductor UI

navigate to 'ui' folder in command promp and type below commands one by one:

npm install gulp -g
gulp watch

npm install -- to install npm


Inside server build.gradle

systemProperty 'jdbc.url', 'jdbc:mysql://localhost:3306/conductor'systemProperty 'jdbc.username', 'root'systemProperty 'jdbc.password', 'password'systemProperty 'db', 'mysql'