MySQL Slave Creation with innobackupex
Hello everyone, today we wanted to share with you the creation of a slave of a MySQL machine in Linux with the utility innobackupex by Percona without using local storage. …
Change active WordPress theme from PHPmyAdmin
Hello everyone. Today we are going to tell you about a solution that saved us many hours of work recently. By deactivating plugins looking for error, we deactivated a necessary …
5 parameters to optimize MySQL in 2021
Hello everyone, today we are going to share with you 5 parameters to optimize MySQL . In MySQL on all operating systems, you have a configuration file. In this configuration …
Physical backup of a MySQL database to Google Cloud
Hello everyone, today we wanted to share with you a way to make a physical backup of a MySQL database on Google Cloud . With this way of making the …
JSON data types in MySQL. Learn with these examples
Hello again, today we wanted to comment on the changes that have been made in MySQL for the use of JSON data types within the MySQL tables themselves. As we …
Rename a database in MySQL
Good friends. Over time, it seems necessary to rename a database in MySQL. For that purpose, we used to apply a simple RENAME DATABASE command that existed in previous versions …