MySQL Server Installation Management & Backup/Restore in C# + Windows
MySQL server manual installation, Windows service management, and C# programmatic backup/restore using mysqldump and mysql.exe command-line tools with proper argument quoting patterns.
MySQL
Posts in this category.
MySQL Server Installation Management & Backup/Restore in C# + Windows
MySQL server manual installation, Windows service management, and C# programmatic backup/restore using mysqldump and mysql.exe command-line tools with proper argument quoting patterns.
Part 1-2: Complete WinForms Walkthrough – Progress Reporting with MySqlBackup.NET
A comprehensive and complete implementation of progress reporting with MySqlBackup.NET in WinForms
Part 4: Progress Reporting in Web Application using Server-Sent Events (SSE)
Server-Sent Events (SSE), a single constant light weight connection that allows the Backend to have real-time communication with the Frontend. Efficient and Fast. Build in Vanilla ASP.NET Web Forms
Part 2: Progress Reporting in Web Application using HTTP Request/API Endpoint
Build a progress reporting web application with MySqlBackup.NET in Vanilla ASP.NET Web Forms
Part 1-1: Introduction of Progress Reporting with MySqlBackup.NET in WinForms
This article begins the series of doing progressing reporting with MySqlBackup.NET by introducing the basic walkthrough, concepts and core working mechanism.
Part 3: Using Web Socket to Do Real-Time Progress Report with MySqlBackup.NET in Vanilla ASP.NET Web Forms
Using Web Socket to do a real-time bi-direction progress report with MySqlBackup.NET in web application.
Progress Reporting with MySqlBackup.NET
A comprehensive guide to building beautiful, real-time progress reporting for MySqlBackup.NET operations using modern Web Forms with zero ViewState, featuring 7 stunning CSS themes and universal patterns that work across any .NET framework.
C# – How to Start and Stop MySQL Server Programmatically
Programmatically start and stop MySQL server in C#
Understanding the Parallel Export Mechanism in MySqlBackup.NET v2.6
Explaining how the parallel export works in MySqlBackup.NET v2.6
Performance Benchmark (MySqlBackup.NET v2.6, MySqlDump, MySQL.EXE)
A performance benchmark comparison of MySqlBackup.NET v2.6, MySqlDump v8.4.5 and MySQL.EXE v8.4.5
Understanding MySQL TIMESTAMP Timezone Handling in MySqlBackup.NET
Learn how MySQL’s timezone handling can cause timestamp corruption during database migrations and how MySQLBackup.NET’s UTC standardization prevents data integrity issues across global deployments.
Using mysqldump and mysql.exe in C# Process without using external script – Backup and Restore of MySQL databases
A journey of discovering the correct steps to use mysqldump and mysql.exe in C# Process
C#, Using mysql instance (mysql.exe) and mysqldump Command Line Tool To Backup, Restore, Export, Import MySQL Database
Using mysqldump and mysql command line This article focus on using MySQL server default built-in tool of mysqldump and mysql.exe (command line) to perform backup and restore of MySQL
Manually Install MySQL On Windows Without Using MySQL Installer
A simple walkthrough of manually installing MySQL on Windows.
MySqlExpress – Convert Rows from MySQL into C# Class Objects
An introduction of how to convert rows from MySQL into C# class object.
MySqlExpress – To Encourage Rapid Application Development with MySQL in C#
An Easier Way to Use MySQL in C#. Save efforts and time for C# coding with MySQL.
MySqlExpress – Simplifies The Usage of MySQL in C#/.NET
Accelerate the Development With MySQL in C#. MySqlExpress aims to encourage rapid application development and simplified the implementation of MySQL in C#.
[C#] Easily Convert All MySQL Databases & Tables to utf8mb4
A C# console program that will convert default character set of all database and tables to utf8mb4 and collation of utf8mb4generalci.
Backup & Restore MySQL database on CentOS/Linux/Ubuntu in C# with MySqlBackup.NET
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 […]
How To Install MySQL on CentOS 8
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 vs MySqlBackup.NET Performance Benchmark
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 […]
Set UTF8 as Default Character Set for MySQL 8.0
From MySQL 8.0, utf8mb4 is the default character set, and the default collation for utf8mb4 is utf8mb40900aici.
Authentication method ‘caching_sha2_password’ not supported by any of the available plugins
Fixing password error between old & new version of MySQL server.
Backup MySQL Database in C# – MySqlBackup.NET
Easily backup MySQL database in C#. An alternative for MySqlDump.