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 we will learn how to use show tables and Select table_name in order to list and print table names. Connect MySQL Interactive...
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 will learn MySQL default port number and alternative port numbers. TCP 3306 The default port for the MySQL service is...
Blog / CentOS / Debian / Fedora / Kali / Linux / Mint / PostgreSQL / RedHat / Ubuntu
by İsmail Baydan · Published 27/01/2018
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 examine how to create user with different rights, privileges, database. We will mainly follow createuser tool for these and createuser is a...
Blog / CentOS / Debian / Fedora / Kali / Linux / Mint / PostgreSQL / RedHat / Ubuntu
by İsmail Baydan · Published 26/01/2018 · Last modified 27/01/2018
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 how to install PostgreSQL into Linux distributions like Debian, Ubuntu, Mint, Fedora, CentOS, RedHat by using different ways like package...
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...
Blog / Database / MariaDB / MySQL
by İsmail Baydan · Published 04/07/2017 · Last modified 23/04/2018
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...
Blog / CentOS / Database / Debian / Fedora / Kali / Linux / Mint / MongoDB / RedHat / Ubuntu
by İsmail Baydan · Published 29/06/2017
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 become very popular. MongoDb is an NoSQL database server to store and retrieve data. In this tutorial we will look...
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 version of Php is 7.0 but the 5.X series Php is most popular version. Features Php gets it features from...
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 and tables, populating data into tables. MySQL installation can be done with the following tutorial for Linux operating systems. How...
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
1 2 3 4 5 | mysqldump [OPTIONS] database [tables] OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...] OR mysqldump [OPTIONS] --all-databases [OPTIONS] |
Help
1 | $ mysqldump --help |
Connect Remote Database Server...
