I need to practice on SQL, thus I've installed MariaDB (mariadb-server through Ubuntu repository) on my laptop.
Can anybody share with me a Beginners Guide on how to set up everything and getting started?
I have a basic knowledge of the SQL language (I'm using it at work via MS SQL Server 2008) but never set up the server and client.
To practice I've downloaded a .sql database offered by Microsoft and saved it on this path:
The issue is that I don't know how to start and import the database. I've never really used it through command line.
To start MariaDB I use this command, although I'm not really sure is the best practice (I don't like to run any program as root)
Code: Select all
gianluca@gianluca-Aspire-S3-391 ~ $ mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 37 Server version: 5.5.32-MariaDB-1~raring-log mariadb.org binary distribution Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>