Database – Page 5 – POFTUT

Install Redis To Linux, Ubuntu, Debian ,Fedora, CentOS, RedHat

Redis supports different operating system and Linux distributions. We will look how to install and start redis in Linux distributions Ubuntu, Debian, Fedora, CentOS and RedHat in this tutorial. Install Fedora, CentOS, RedHat We can install redis server on Fedora, CentOS and RedHat with the following yum command. $ yum install redis -y Install Ubuntu, Debian … Read more

Redis Tutorial

Redis is open source BSD licensed database or key-value store. Redis provides fast and simple data store features mainly used for caching purposes in web applications. Redis is written in C programming language. Supported Data Structures Redis supports following data structures to store and retrieve data. string hash list set sorted set queries bitmap hyperloglog … Read more

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 … Read more

Things To Do With Computer When Bored

We work for earn money. We consume our time for money but sometimes we may be bored. Changing current work will made us more happy and will refresh our mind. Here we will provide some useful things to do when we are bored. Consuming time with useful work is important for us. Read Technical Tutorials … Read more

How To Install and Configure MongoDB NoSQL Database To Linux, Ubuntu, Debian, CentOS, Fedora

How To Install and Configure MongoDB NoSQL Database To Linux, Ubuntu, Debian, CentOS, Fedora

SQL is a very powerful language to query, insert, delete, modify data. In recent years the IT industry has developed some alternative ways to store and retrieve data. NoSQL type database servers become very popular. MongoDB is a NoSQL database server to store and retrieve data. In this tutorial, we will look at how to … Read more

How To Create a Database and Table In MySQL and MariaDB?

How To Create Database and Table In MySQL and MariaDB?

MySQL database is a very popular database server used by a lot of small and big companies. In this tutorial we will look at the basics of MySQL server like creating databases and tables, populating data into tables. MySQL installation can be done with the following tutorial for Linux operating systems. How to Install Mariadb/Mysql … Read more

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 mysqldump [OPTIONS] database [tables] OR      mysqldump [OPTIONS] –databases [OPTIONS] DB1 [DB2 … Read more

How To Drop MySQL Database?

MySQL is a very popular opensource database it is used by a lot of different types and size companies. In this post, we will look at how to drop or delete MySQL databases? Login MySQL Database Dropping/Deleting/Removing a database in MySQL server is a simple and fast solution that will delete data as well as … Read more

How To List MySQL Database Users?

How To List MySQL Database Users?

MySQL database server has users to connect and use databases and tables. Users provide security for database operations. MySQL server comes with default users or in the operations, a lot of users are created. In this post, we will look at how to list these users. Connect To MySQL Database We will connect to the … Read more

How To List MySQL / MariaDB Database?

How To List MySQL / MariaDB Database?

MySQL is a 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 in the opensource community. In this post, we will look at how to list databases in MySQL. Check … Read more