Tag: MySQL

ASP.NET Core SQL Server and MySQL database logging with Serilog
ASP.NET / C# / Coding / SQL / Web

ASP.NET Core SQL Server and MySQL database logging with Serilog How to use the ASP.NET Core's built-in ILogger logging API to write application logs to SQL Server, MySQL and/or MariaDB using Serilog logging provider

- by Ryan - Leave a Comment

In this article we'll see how to take advantage of Serilog, a neat open-source diagnostic logging library for .NET applications, to log our ASP.NET Core web application’s data to a …

ASP.NET Core SQL Server and MySQL database logging with Serilog How to use the ASP.NET Core's built-in ILogger logging API to write application logs to SQL Server, MySQL and/or MariaDB using Serilog logging provider Read More
10 Must-Have features for a WordPress Website in 2019
Coding / SQL / Web

WordPress: SQL query to add or remove categories on multiple posts A set of useful MySQL queries to perform bulk operations against the WordPress Database such as adding and/or removing categories on multiple posts

- by Ryan - 7 Comments.

In this article I will try to explain how to perform a series of operations on the WordPress categories associated with articles using SQL queries that act directly on the …

WordPress: SQL query to add or remove categories on multiple posts A set of useful MySQL queries to perform bulk operations against the WordPress Database such as adding and/or removing categories on multiple posts Read More
How to automatically set File System Permissions for a WordPress Web Server with a BASH Script
Coding / SQL

WordPress - WP Post Views Counter plugin - import data from Yuzo Related Posts How to import the view count data of each existing post from Yuzo Related Posts to WP Post Views Counter WordPress Plugin

- by Ryan - Leave a Comment

Today a friend asked me to uninstall the Yuzo Related Post plugin from her WordPress blog because she want to switch to the Jetpack built-in "related posts" feature. She could …

WordPress - WP Post Views Counter plugin - import data from Yuzo Related Posts How to import the view count data of each existing post from Yuzo Related Posts to WP Post Views Counter WordPress Plugin Read More
MySQL Master-Master Replication setup in 5 easy steps
Linux / Operating Systems / Servers & Services

Linux - MySQL and MariaDB sock file folder issues - how to fix How to force MySQL and MariaDB services to create the /var/run/mysqld/mysqld.sock and /var/run/mariadb/mariadb.sock files and folders

- by Ryan - Leave a Comment

Yesterday I wrote a small tutorial explaining how to fix a common MySQL or MariaDB problem related to the pid file not being created upon the service startup. That same …

Linux - MySQL and MariaDB sock file folder issues - how to fix How to force MySQL and MariaDB services to create the /var/run/mysqld/mysqld.sock and /var/run/mariadb/mariadb.sock files and folders Read More
Come installare MariaDB 10.x su CentOS 7.x e metterlo in sicurezza per l'utilizzo in produzione
Linux / Operating Systems / Servers & Services

Linux - MySQL and MariaDB pid-file folder issues - how to fix How to force MySQL and MariaDB services to create the /var/run/mysqld/mysqld.pid and /var/run/mariadb/mariadb.pid files and folders

- by Ryan - 6 Comments.

If you've stumbled upon this post it most likely means that you've just discovered that your MySQL or MariaDB service, despite running without issues, are not creating their mysqld.pid or …

Linux - MySQL and MariaDB pid-file folder issues - how to fix How to force MySQL and MariaDB services to create the /var/run/mysqld/mysqld.pid and /var/run/mariadb/mariadb.pid files and folders Read More
Come installare MariaDB 10.x su CentOS 7.x e metterlo in sicurezza per l'utilizzo in produzione
Coding / Linux / Servers & Services / SQL

How to safely upgrade from MariaDB 10.x to 10.3 without losing data A quick tutorial explaining how to perform a seamless upgrade from a previous version of MariaDB 10 to MariaDB 10.3 keeping all the existing databases intact

- by Ryan - 6 Comments.

It has been a while since MariaDB 10.3 has been out, bringing its stunning pack of changes, improvements and new features - most notably, System-versioned tables and Sequences. If you found this …

How to safely upgrade from MariaDB 10.x to 10.3 without losing data A quick tutorial explaining how to perform a seamless upgrade from a previous version of MariaDB 10 to MariaDB 10.3 keeping all the existing databases intact Read More
Backup MySQL or MariaDB Server with a single Command-Line using mysqldump
Coding / Servers & Services / SQL

Backup MySQL or MariaDB Server with a single Command-Line using mysqldump How to perform a full backup of a MySQL or MariaDB Server instance on a Windows or Linux machine with single command-line

- by Ryan - 1 Comment

If you like playing with MySQL or MariaDB servers, you most likely know that both of these great open-source DBMS come with mysqldump, a neat command-line utility that can be used to …

Backup MySQL or MariaDB Server with a single Command-Line using mysqldump How to perform a full backup of a MySQL or MariaDB Server instance on a Windows or Linux machine with single command-line Read More
Wordpress - Error establishing a database connection repeatedly and intermittently (MySQL / MariaDB) - Fix
Coding / PHP / Servers & Services / Web

WordPress - Error establishing a database connection repeatedly and intermittently (MySQL / MariaDB) - Fix What to do if you're randomly and repeatedly getting the "Error establishing a database connection" with your WordPress installation using MySQL or MariaDB

- by Ryan - Leave a Comment

The "Error establishing a database connection" WordPress error is a rather common one. You can either get it upon each request, meaning that you WordPress site is entirely down, or intermittently (randomly …

WordPress - Error establishing a database connection repeatedly and intermittently (MySQL / MariaDB) - Fix What to do if you're randomly and repeatedly getting the "Error establishing a database connection" with your WordPress installation using MySQL or MariaDB Read More
The Importance of learning SQL Programming Language
Coding / SQL

The Importance of learning SQL Programming Language Why SQL Programming Language Is Essential While Building and Developing a Database with DBMS such as MS SQL Server, PostgreSQL, MySQL, MariaDB & more

- by Ariya Stark - Leave a Comment

Programming is simply setting instructions that will help a computer perform a certain task. A programmed computer can be used to generate accurate algorithms. Over the years, computers have evolved …

The Importance of learning SQL Programming Language Why SQL Programming Language Is Essential While Building and Developing a Database with DBMS such as MS SQL Server, PostgreSQL, MySQL, MariaDB & more Read More
Zen Cart Review - Open-Source Store Management System for the E-commerce Industry
Web

Zen Cart Review - Open-Source Store Management System for the E-commerce Industry An extensive review of the most popular alternative to Magento in the Store & E-Commerce Management System

- by Nitesh Ranjan - Leave a Comment

As an entrepreneur, you are likely to experience strategic blackouts, tactical disorientations. And yes, at times, you are going to be baffled by new ideas both limiting and perspective. And …

Zen Cart Review - Open-Source Store Management System for the E-commerce Industry An extensive review of the most popular alternative to Magento in the Store & E-Commerce Management System Read More