Resetting the database

Make a backup!

Before resetting the database make sure that you have a backup of your existing database.

Helpful commands:

# backup command:
mysqldump -u [username] -p[password] --verbose [name of database] > [filename.backup.sql]

# restore command:
mysql -u [username] -p[password] [name of database] < [filename.backup.sql]

The username is "nmsprime" in a standard installation. The password was generated at the time of installation and is located in: /etc/nmsprime/env/global.env
on the line "DB_PASSWORD="

Between the -p and the password is no space-character! If your passwort is "hello1234", then this part of the command will be: -phello1234

Steps for dropping and creating the database

# drop your existing databases and create the databases again
mysql -u root -e "DROP DATABASE nmsprime; DROP DATABASE nmsprime_ccc; CREATE DATABASE nmsprime CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci'; CREATE DATABASE nmsprime_ccc CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci';"

# change directory to the nmsprime folder
cd /var/www/nmsprime/

# use php artisan to start the migration-process
php artisan migrate
php artisan module:migrate

Related: Database Setup