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 Shell We need to connect or run command in MySQL to list table names. We will connect to the 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 TCP 3306. This port can be also used for MariaDB database server. List with netstat Command We can use netstat...
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 wrapper for the CREATE ROLE Sql statement. By the way we have allready examined the PostgreSQL Database Server installation in the...
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 management or downloading setup file. Show PostgreSQL Package Version For Ubuntu, Debian, Mint, Kali with Apt In apt-get or apt based...
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 geospatial index Supported Operating Systems Current version of redis is 3.2.9 . Redis supports following...
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...
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 how to install MongoDB on Linux and distributions like Ubuntu, Debian, CentOS, Fedora, RedHat. Fedora, CentOS, RedHat We will use...
[rps-include post=6522] 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 different languages like C, C++, Java etc. Php supports class, inheritance, primitive types, file operations. Php generally used...
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 to Install Mariadb/Mysql Server in Linux Fedora? Following operations can be done in MariaDB without any problem. MariaDB 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
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 By default mysqldump will try to connect local MySQL server database. Remote databases server can be specified with -h option as...
