How to Change Definer in MySQL Views

In this article, as shown in the title of the article which is how to change definer inMySQL views, this article is written to show how to change definer in MySQL views. At first, definer of a file is actually specified in the MySQL Database dump file  where it can actually be changed.  It is quite simple to change it if the prerequisite on accessing MySQL Database Server can be fulfilled.

The prerequisite can be specified as follows :

Continue reading “How to Change Definer in MySQL Views”

Ubuntu Linux Error Message : dpkg: error processing package mysql-server-5.7 (–configure)

This error specified in the title of this article popped out in the middle of the execution of apt command. It is an error which has been bothering for quite sometime. It is because the upgrade process of MySQL Database Server in the Ubuntu Linux Operating System, every operation involving apt tool for package management system include installing, updating and removing packages will generate an error message specified in the title of the article at the end. So, below are steps taken which is basically trial and error in sequential order to be able to completely remove the nuisance of error message generated in the title of this article as follows :

dpkg: error processing package mysql-server-5.7 (--configure)

Below are several of those steps taken :

1. Using dpkg –configure -a.

The first step taken is using ‘dpkg –configure -a’ which is executed since mysql-server-5.7 is considered installed but it hasn’t been configured yet. Below is the output of the command generated :

Continue reading “Ubuntu Linux Error Message : dpkg: error processing package mysql-server-5.7 (–configure)”

MySQL Error Message : ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./db’, errno: 39)

This is an article written to describe on how to solve the error generated in MySQL Database Server. The error itself is an error specifically triggered upon dropping a database which in this context is executed through a command typed in MySQL Command Console. The error specifically mentioned in the title of this article “ERROR 1010 (HY000): Error drop database (can’t rmdir ‘./db’, errno:39)”. Where the ‘./db’ in the error message is referring to the name of the database which is going to be dropped.

The error is shown in detail through the execution of the following command :

Continue reading “MySQL Error Message : ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./db’, errno: 39)”

MySQL Error Message : ERROR 1114 (HY000) at line 4032: The table ‘table’ is full

This is an article where the focus of the main discussion is about how to solve the error message of MySQL Database Server generated upon restoring a dump file into a single database. The error specifically shown in the title of the article which is ‘ERROR 1114 (HY000) at line 4032: The table named ‘table’ is actually full. So, the error happened at the time of restoring a single database is in progress. It is shown as follows :

root@hostname:/etc/mysql/conf.d# mysql -uroot -p mydb < /root/mydb_20170919_140100.sql
Enter password: 
ERROR 1114 (HY000) at line 4780: The table 'xx_first_table' is full
root@hostname:/etc/mysql/conf.d#

As shown in the restoring progress of the database named ‘mydb’ using the dump file named ‘mydb_20170919_140100.sql’ as located in the ‘/root/’, the process eventually stop and generated an error shown in the following highlight :

Continue reading “MySQL Error Message : ERROR 1114 (HY000) at line 4032: The table ‘table’ is full”

How to List All Database in PostgreSQL via Command Line

This article is describing on how to list all database in PostgreSQL Database Server via command line. So, the environment used in order to execute the command to list all database in PostgreSQL Database Server is an environment equipped with a CLI (Command Line Interface). An example of a CLI tool in this context is a terminal or any other interface equipped with a bash prompt.

Steps for listing all database in PostgreSQL via command line will be described in the following steps :

1. Check the PostgreSQL Database Server’s service. It is a necessity for connecting or accessing service of PostgreSQL Database Server. For further reference, read the article titled ‘Check PostgreSQL Service Status’ in this link.

Continue reading “How to List All Database in PostgreSQL via Command Line”