The Debian 8 default repositories contain MySQL packages. You can simply install MySQL on Debian 8 Jessie machine with few simple commands. But the default repositories don’t contain the latest MySQL version. So this tutorial will help to install MySQL on Debian 8 Jessie system with the latest version. Go through the step by...
MySQL is an opensource, Relational Database Management System. MySQL is a most popular database server for Linux systems, it also supports a large number of platforms. In MySQL, we can easily create a stored procedure and execute SQL queries. MySQL Community Edition is a freely downloadable version and uses for your applications. In this...
MongoDB (named from “huMONGOus”) is a full flexible index support and rich queries database. Mongodb is a NoSQL database. MongoDB provides large media storage with GridFS. Click here for more details about this version of MongoDB. Use this tutorial to install MongoDB server 3.4 on Debian 9, Debian 8 and Debian 7 systems. Step...
PostgreSQL 10 Released. PostgreSQL is an open source object-relational, highly scalable, SQL-compliant database management system. PostgreSQL is developed at the University of California at Berkeley Computer Science Department. This article will help you to install PostgreSQL 10 on CentOS, RHEL and Fedora Systems. Step 1 – Add Postgres Yum Repository The first step is...
MariaDB 10.3 stable version has been released on Oct 09, 2017. It is an enhanced, drop-in replacement for MySQL. MariaDB can be an better choice for choice for database professionals looking for a robust, scalable, and reliable SQL server. MariaDB has a number of updated features over MySQL. Use below links to read features...
After writing a simple shell script for MySQL database backup. This is our new advance bash script for MySQL database dump. This script will provide you to backup MySQL database and upload backups various remote locations like FTP, SFTP and Amazon s3 bucket. This script is available on our Github account with all supporting...
Q. How do I use MySQL command without prompting password? How do I use mysqldump command without using the password in the script? How do I use MySQL commands without passing the password in crontab? In this tutorial, you will find a way to use MySQL commands without passing passwords as command line parameter...
Q. How do I run a SQL text file on MySQL prompt? How to source .sql file on MySQL command prompt? How do execute the .sql file in MySQL command prompt? How to Run SQL Text File on MySQL Command Prompt? If you are on MySQL command prompt and need to execute all SQL...
This can be an important query for your while debugging slowness of SQL server. This will help you find currently running SQL queries on SQL Server. You can find which queries are running from a long time and utilizing CPU. To run this query, start SQL Server Management Studio, Open New Query window and...
PostgreSQL is an open source object-relational database system. It is one of leading database server used for production servers. This tutorial will help you to install PostgreSQL database server on Debian 9, Debian 8 and Debian 7 systems. How to Install PostgreSQL on Ubuntu Step 1 – Setup Apt Repository First, you need to...