RDS MySQL replication error: Slave failed to initialize relay log info structure from the repository
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository This issue happens on configuring MySQL
Read More
TECHIES WORLD
For Techs.... Techniques.... Technologies....
Mysql
Mysql replication error: Relay log read failure: Could not parse relay log event entry
Relay log read failure: Could not parse relay log event entry This error is happening due to the corrupted relay
Read More
How to import MySQL dump in Windows
We can import MySQL dump in Windows through the phpmyadmin application provided by WAMP softwatre. But if the size of
Read More
How to clear MySQL query cache without restarting service
MySQL query cache will be cleared on restarting the service. But its not the right way to restart MySQL to
Read More
MySQL ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' Some times you may face this error while
Read More
How to configure log rotation for MySQL binlogs
There is not expiration for MySQL binlogs bydefault. This may cause disk space shortage in future. So it will be
Read More
How to backup MySQL procedures
Default mysqldump will not take the back up of stored procedures. So if we need to take the mysqldump including
Read More
PrestaShop server requirements and PHP configurations
This article explains the server requirements and recommended PHP configurations for the better functioning of PrestaShop. PrestaShop requires the following
Read More
Mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table
Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table When a MySQL client or the mySQL server gets
Read More
How to backup and restore MySQL database using Ansible
Ansible mysql_db module can be used to take dump and restore MySQL databases. Sample code to dump the MySQL database
Read More
How to list stored procedure for a database in MySql
A stored procedure is a set of Structured Query Language (SQL) statements with an assigned name, which are stored in
Read More