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 you 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 "CREATE DATABASE nmsprime CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci';" # change directory to the artisan folder in nmsprime cd /var/www/nmsprime/artisan # use php artisan to start the migrate-process php artisan migrate
For manually recreating the database, please refer to: Database Setup