C# with MySQL

The idea is to build a project in .NET Core and publish it as Linux package. MySqlBackup.NET is an open source .NET Library (C#/VB.NET) to backup & restore MySQL database. Here, we’re looking into how MySqlBackup.NET can be run on CentOS/Linux to perform backup & restore of MySQL database. We can test this out with…

This tutorial explains how to install MySQL version 8 on a CentOS 8 server. The origin of this tutorial/article was written by Mark Drake from DigitalOcean.com (Updated on March 19, 2020) at https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-centos-8 Introduction MySQL is an open-source database management system, commonly installed as part of the popular LEMP (Linux, Nginx, MySQL/MariaDB, PHP/Python/Perl) stack. It implements the relational model and Structured…

MySqlDump and MySqlBackup.NET are both used to backup/restore MySQL database. Both can be used in C# (.NET) projects. This is a study specially made for the open source project MySqlBackup.NET. Date: Sep 24, 2021 This benchmark test was carried out in the following setup/environment/parameters: There are some other elements that have a great impact on…

From MySQL 8.0, utf8mb4 is the default character set, and the default collation for utf8mb4 is utf8mb4_0900_ai_ci.

Fixing password error between old & new version of MySQL server.