We frequently run into issues when restoring databases that were created using the mysqldump command. One of them is shown below. ERROR 1227 (42000) at
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
MySQLDump Usage in AWS RDS
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and
EC2 AWS RDS – MySQLDump Generated Column Error
One of the errors encountered while restoring the MySQL backup created using mysqldump is as follows. I encountered it in my EC2 jump server that
Error while Installing MySQL in EC2 Jump Server
Please read the post from earlier to learn how to set up a MySQL community server and client on EC2, which serves as a bridge
Installing MySQL in EC2 Jump Server
As a best practice, bastion hosts (jump servers) are frequently used to access privately accessible hosts inside of a system environment. A system on a
Transaction Control Language – SQL Server
Transaction Control Language (TCL) commands are used to manage transactions in the database generated by DML statements. The statements are allowed to be grouped together
Big Data & SQL 