Databases Archives – Page 7 of 13

By RahulOctober 2, 2017

MariaDB 10.4 stable version has been released. It is an enhanced, drop-in replacement for MySQL. MariaDB can be an better…

By RahulJuly 30, 2017

After writing a simple shell script for MySQL database backup. This is our new advance bash script for MySQL database…

By RahulJuly 23, 2017

MySQL is a popular open-source database management system used for a wide range of applications, from simple websites to large-scale…

By RahulJune 26, 2017

Q. How do I run a SQL text file on MySQL prompt? How to source .sql file on MySQL command…

By RahulMay 9, 2017

In today’s data-driven world, efficient database management is a cornerstone of smooth and effective operations for any business relying on…

By RahulFebruary 11, 2017

PostgreSQL is an open source object-relational database system. It is one of leading database server used for production servers. This…

By RahulAugust 15, 2016

Using SQL Query Window: Use WITH REPLACE option with the RESTORE command on MSSQL query window. Change database name and…

By RahulJune 17, 2016

Are you familiar with the ‘ERROR 2006 (HY000) at line XXX: MySQL server has gone away’ error message? If you…

By RahulMay 17, 2016

As a database administrator, there are certain MySQL settings and configurations that need to be tweaked, enhanced, or adjusted to…

By RahulApril 21, 2016

In large-scale software engineering, we see problems in our implementation at every step. However, the biggest challenge remains to identify…