database commands.md

To log in to mariaDB, you need to go through the mySQL command line interface

mysql -u root -p
/*then type in password which for this project was my emplid*/

Issue these commands to get your database to run your SQL file.

USE db_name;
SOURCE backup-file.sql;

If you don't know what database you'd like to choose, issue the command:

SHOW SCHEMAS;

which in this case has an output like this:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| local_crypto       |
| mysql              |
| performance_schema |
+--------------------+

I'm going to USE local_crypto; for this project.