Page 1 of 1

MariaDB - First use

Posted: Sun Aug 18, 2013 2:34 pm
by I am Gianluca
Hi,

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:

/usr/bin/northwind_mysql.sql

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)]> 
Thank you,

Gianluca

Re: MariaDB - First use

Posted: Mon Aug 19, 2013 1:27 am
by z1p101
You could install MySQL Workbench using the package installer. It is a good and fairly straight forward GUI front end that works fine with MariaDB and could help you. Or if you just need to practice with SQL, Netbeans and Java DB/Derby make a good pair. [url=http://dev.mysql.com/doc/refman/5.0/en/mysql-batch-commands.html]Or you could start with the instructions here.[/url] A .sql file is just a text file that contains SQL commands like CREATE DATABASE/INSERT INTO TABLE/etc. so you don't have to type it all yourself.