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] -h [server] --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 database: mysql -u root -e "drop database nmsprime" # create the database 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 artisan folder in nmsprime cd /var/www/nmsprime/ # use php artisan to start the migrate-process php artisan migrate php artisan module:migrate
Related: Database Setup