Tag: database

How To List MySQL Tables with “show tables” SQL Query

Posted on 15/06/2018 by İsmail Baydan

MySQL stores given relation data in tables. While using tables we generally need to check and list existing tables. We can use different ways to list tables. In this tutorial

What Is MySQL Default Port Number?

Posted on 13/02/201808/12/2018 by İsmail Baydan

MySQL is very popular database in the opensource community. While developing applications or connecting MySQL database we need to specify the MySQL port implicitly or explicitly. In this tutorial we

How To Define, Add, Create User For Postgres or PostgreSQL Server?

Posted on 27/01/201827/01/2018 by İsmail Baydan

PostgreSQL Database Server have a lot of tools to manage the suite. Creating user is one of the most popular issue to manage Postgres Database. In this tutorial we will

How To Install PostgreSQL Server Into Linux, Debian, Ubuntu, CentOS, Mint, Fedora, Redhat?

Posted on 26/01/201827/01/2018 by İsmail Baydan

PostgreSQL is very popular open source database. It is used by big companies like Google, Facebook etc. PostgreSQL can be used without a cost. In this tutorial we will look

Redis Tutorial

Posted on 05/07/201705/07/2017 by İsmail Baydan

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

Mysql Database Import Tutorial with Examples

Posted on 04/07/201723/04/2018 by İsmail Baydan

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

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

Posted on 29/06/2017 by İsmail Baydan

Sql is very powerful language to query, insert, delete, modify data. Recents years the IT industry have developed some alternative ways to store and retrieve data. NoSQL type database servers

Php Tutorial

Posted on 31/05/201730/07/2017 by İsmail Baydan

Php is a programming language mainly developed for web programming. Php language is created by Rasmus Lerdorf in 1994. Php have different version those have create in history. Most recent

How To Create Database and Table In MySQL and MariaDB?

Posted on 27/03/201730/11/2018 by İsmail Baydan

MySQL database is very popular database server used by a lot of small and big companies. In this tutorial we will look the basics of MySQL server like creating database

Backup and Restore MySQL Databases With Mysqldump In Linux

Posted on 13/03/201730/11/2018 by İsmail Baydan

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