Backup & Restore MySQL database on CentOS/Linux/Ubuntu in C# with MySqlBackup.NET

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

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…

HTML Table – Freeze Row and Column with CSS

HTML Table – Freeze Row and Column with CSS

Having a freeze pane effect on HTML Table. Freeze/Fixed/Frozen the Columns and Rows in HTML Table by using CSS. This work was inspired by an article written by Manish Malviya, and I would like to thank for his sharing of freezing the table rows columns at https://blogs.perficient.com/2021/01/18/freezing-row-and-column-in-html-table-using-css/ Video Walkthrough Guide Examples Example 1: As shown…

HTML Table Cell Styling for Excel by using “mso-number-format”

HTML Table Cell Styling for Excel by using “mso-number-format”

HTML CSS table cell styling for manipulating the data format in Excel. Very useful for publishing an Excel document for download. Attribute Description mso-number-format:”0″ NO Decimals mso-number-format:”0.000″ 3 Decimals mso-number-format:”#,##0.000″ Comma with 3 dec mso-number-format:”mm/dd/yy” Date7 mso-number-format:”mmmm\ d,\ yyyy” Date9 mso-number-format:”m/d/yy\ h:mm\ AM/PM” D -T AMPM mso-number-format:”Short Date” 01/03/1998 mso-number-format:”Medium Date” 01-mar-98 mso-number-format:”d-mmm-yyyy” 01-mar-1998 mso-number-format:”Short…

Visual Studio 2022 is Here

Visual Studio 2022 is Here

Welcome VS 2022. We’re happy to have you here. Great work guys. Let’s start the engine. Download Visual Studio 2022: https://visualstudio.microsoft.com/ Launch Event News: https://devblogs.microsoft.com/visualstudio/visual-studio-2022-now-available/ Official Launch Video: https://visualstudio.microsoft.com/launch/ Youtube Launch Event Video:

MySqlDump vs MySqlBackup.NET Performance Benchmark

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…