<commit_before># Log into MariaDB (MySQL) console

mysql -u root -p


# While inside the MariaDB console,
# drop the 'escape' database,
# and create it again.

drop database escape;
create database escape;
ctrl-d


# Import SQL commands into MariaDB
# to create starting data.

cd escape-reality/db
mysql -u root -p escape < sql-to-mock-database.sql<commit_msg>Add step to restart Node server<commit_after># Step 1: ---------------------------------------------
# Log into MariaDB (MySQL) console

mysql -u root -p


# Step 2: ---------------------------------------------
# While inside the MariaDB console,
# drop the 'escape' database,
# and create it again.

drop database escape;
create database escape;
ctrl-d


# Step 3: ---------------------------------------------
# Restart Node to make Sequelize
# create the initial tables

node server/server.js


# Step 4: ---------------------------------------------
# Import SQL commands into MariaDB
# to create starting data.

cd escape-reality/db
mysql -u root -p escape < sql-to-mock-database.sql
{'fraction_non_alphanumeric': 0.2419047619047619, 'fraction_numerical': 0.0038095238095238095, 'mean_word_length': 1.8873626373626373, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7191430', 'n_tokens_mistral': 284, 'n_tokens_neox': 274, 'n_words': 117}