Successful MySQL/MariaDB Backup and Recovery Strategies

Total: 2 Average: 4

A vital part of preventing any kind of data loss in any situation is having appropriate backup and recovery policies. It is also essential to ensure data recovery at any point in time of the application workflow life cycle. Both MySQL and MariaDB offer solutions for these cases. This article will explore the existing options and procedures as well other potential backup options for MySQL and MariaDB.

Read More

A Quick Guide on Installing MySQL on Ubuntu

Total: 1 Average: 5

This article will present the step-by-step installation process of the MySQL server on Ubuntu. For demonstration purposes, I created a virtual machine using Oracle VM virtual box and set up Ubuntu 18.04 on the virtual box. I’d recommend you referring to the article Creating a Virtual Machine with Oracle VM Virtual Box for a better understanding of the installing process and creating a virtual machine on Oracle VM virtual box. Also, you may turn to the article How to Install Ubuntu 18.04 for more information about installing Ubuntu 18.04 on the virtual machine.

CodingSight - A Quick Guide on Installing MySQL on Ubuntu
Read More

How to Create and Deploy Azure Database for MySQL Server using Azure Portal and Workbench

Total: 1 Average: 5

This article describes the step-by-step deployment process of the Azure Database for MySQL Server.

Open the Azure portal and log in using the appropriate credentials. Note: For demonstration purposes, I got a pay-as-you-go subscription to Microsoft Azure. For more information about the Azure MySQL pricing model and various Azure subscriptions, refer to Subscriptions, licenses, accounts, and tenants for Microsoft’s cloud offerings.

Read More

The Top 5 Facts About MySQL INSERT for T-SQL Developers

Total: 1 Average: 5

Developers are lifelong students. Gaining new knowledge as fast as we can is always our gig. If you’re coming from the T-SQL camp, what’s the faster way to learn MySQL? Often you want to compare syntaxes. Last time, you learned about creating a table in MySQL. Our today’s post will take you a step further. We’ll insert records with MySQL INSERT.

Read More

ODBC Driver for MySQL: How to Install and Set up Connection (Step-by-step)

Total: 2 Average: 5

This article focuses on the step-by-step processes of installing and configuring the ODBC driver for MySQL. In particular, it will cover the following issues:

  1. Installing the ODBC driver on Windows 10.
  2. Configuring the ODBC data source with ODBC driver for MySQL.
  3. Creating a basic list report with PowerBI that uses the ODBC driver for the data population from the MySQL database.
Read More

CREATE TABLE MySQL vs T-SQL with Syntax Examples

Total: 1 Average: 5

Are you a T-SQL developer learning the basics of MySQL? Then, one of the things you might want to learn is MySQL CREATE TABLE statement. Besides, the fastest way to learn a new SQL database platform is by comparing its common functionality and syntax.

That’s what we are going to do today. But the full syntax is a lot. So, we will only cover 5 basic points to get you up and running with MySQL CREATE TABLE command.

CodingSight - Top 5 MySQL CREATE TABLE Syntax for T-SQL Developers
Read More