You can use mysqldump and mysql.exe for backup and restoration after installing MariaDB using the sudo yum install mariadb.x86 64 command in your EC2 instance.
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.
MySQL Generated Columns
The generated column feature, which has been available since MySQL 5.7, enables the generation of some columns’ data based on predefined phrases. This is comparable
MySQL JSON_EXTRACT Examples
JSON_EXTRACT returns data from a JSON document, selected from the parts of the document matched by the path arguments. Returns NULL if any argument is
AWS RDS – Delete Option Group
Once an option group has been allocated to an instance, it cannot be deleted. The option group must be removed from all instances. When attempting
AWS RDS – Audit logs in Cloudwatch
When I first started utilizing AWS RDS, I ran into a slew of issues. Most of them are due to a lack of knowledge, and
How to bring the Database online from the Suspect Mode in SQL server
Is your SQL database marked as suspect? Learn how to bring the Database online from the Suspect Mode in SQL server with manual as well
Big Data & SQL 