MySQL is free and opensource database server which is very popular in opensource community. MySQL is used by alot of applications and companies like Facebook, Google etc. In this tutorial we will learn how to install MySQL into deb or apt based distributions like Ubuntu, Debian, Mint and Kali. This guide can...
Backup and Restore operations are important part of the database administration. mysqlimport command is used to load data in file into Mysql or Mariadb servers. Mysql import is generally used by providing SQLfile. Syntax Syntax of mysqlimport is like below. mysqlimport OPTIONS DBNAME FILE OPTION is used provide detailed configuration DBNAME is the...
One of the most important task of a database administrator is backing up and restoring databases. MySQL is a popular database server and provides tool named mysqldump for backup and restore operations. We will look different usage types of mysqldump in this tutorial. Syntax
mysqldump [OPTIONS] database [tables]
mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
mysqldump [OPTIONS] --all-databases [OPTIONS]
$ mysqldump --help
Connect Remote Database Server...
MySQL is very popular opensource database. MySQL is created by MySQL AB a Swedish company and then bought by Sun. Sun is bought by Oracle and MySQL is currently owned by Oracle. MySQL is very popular at opensource community. In this post we will look how to list databases in...
I have some MySQL databases. I have no previous experience about MySQL. How can list existing databases with bash? MySQL and MariaDB are using same code base and tools. So we can use following instructions to list MariaDB too. First be sure MySQL/MariaDB service is running
$systemctl status mariadb
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: active (running) since Cts 2016-11-05 09:23:09 UTC; 1min 0s ago
Process: 1950 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 1922 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 1949 (mysqld_safe)
├─1949 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─2106 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/l...
Kas 05 09:23:05 cen1 systemd: Starting MariaDB database server...
Kas 05 09:23:05 cen1 mysqld_safe: 161105 09:23:05 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Kas 05 09:23:05 cen1 mysqld_safe: 161105 09:23:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Kas 05 09:23:09 cen1 systemd: Started MariaDB database server.
We can enter...
I need some application that will provide online file sharing and synchronization. It should be free. Open Source solution is preferred. It seems that we will install OwnCloud which is is an open source, self-hosted file sync and share app platform. There are a lot of things like calendar sync, active...
Sql is the language where a lot of data can be get with different logic. In an enterprise environment we may need to use complex sql queries to get meaningful data. Inner is one of the logic where we join two tables with different magic. Example Tables The tables we...
Mysql is one of the most popular databases in IT world. It is open source and have rich features were paid databases provides. MariaDB is fork of the MySQL and very similar to it. We have already looked how to login and do simple steps in this post Getting Help...
Mariadb is an open source database forked from another popular open source database MySQL. MariaDB developers are original developers of the MySQL. After Oracle get management of the MySQL project they become unhappy with the management of the Oracle and started MariaDB project. Latest available version for MariaDB was 10.1.18...