mariadb – POFTUT

Tagged: mariadb

0

How To Install LAMP Stack On Linux, Ubuntu, Debian,Mint,Fedora

LAMP stack is a popular term in IT world. It is used to express multiple application package to server PHP applications. Here is the formula Linux+Apache+MySQL+PHP=LAMP . LAMP stack can be created by installing these components one by one. In this tutorial we assume that we have already installed the Linux distribution like Ubuntu, Debian, CentOS, Mint . Installing Apache or Httpd We will start by installing Apache web server. Apache...

0

How To Install MySQL On Ubuntu, Debian, Mint Kali

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 be used for other deb or apt based distributions too. Update Repository Information It is not a reuirement but a best practice...

0

Mysql Database Import Tutorial with Examples

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 name of the database we want to import FILE is the file which contains the data and schema Import SQL File...

0

Backup and Restore MySQL Databases With Mysqldump In Linux

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

Help

Connect Remote Database Server By default mysqldump will try to connect local MySQL server database. Remote databases server can be specified with -h option as...

2

How To List MySQL / MariaDB Database?

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 MySQL. Check MySQL Service Status We need to be sure that MySQL daemon is running we will check with following...

0

How To List MySQL/MariaDB Databases

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. Check Database Service First be sure MySQL/MariaDB service is running

As we can see from systemctl output the database service is working properly. Login To MySQL Interactive Shell In order to...

0

How To Install OwnCloud On CentOS Linux?

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 feed notifications etc. but for now we will just install ownCloud. Get Repository Keys and Add Repository We need to...

0

What is The Difference Between Inner and Outer Join?

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 In order to understand Inner and Outer Joins we will use following example tables with their data. We will use two tables those...

0

How To Use Mysql / MariaDB From Console?

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 In order to connect to a MySQL or MariaDB database server we will use mysql command. mysql command provides a...

Enjoy this blog? Please spread the word :)