How to re-sync the MySQL DB if Master and Slave (replication) ?

This is the full step-by-step procedure to resync a master-slave replication from scratch: At the master: And copy the values of the result of the last command somewhere. Without closing the connection to the client (because it would release the read lock) Continue reading How to re-sync the MySQL DB if Master and Slave (replication) ?

MacOS – Install mysql client without the server

If you want to use Mysql client in a Mac without installing Mysql Server, just do the following: 1) Install MySqlWorkbench https://www.mysql.com/products/workbench/ 2) Run the following command in terminal _ What others are reading:Laravel 5.8.5 ReleasedLaravel 5.8.3 ReleasedLaravel 5.7.26 ReleasedMacOS Continue reading MacOS – Install mysql client without the server

Linux – Import Multiple .sql dump files into mysql database

If you have a directory with a bunch of .sql files that mysql dumps of each database on my server. e.g. database1-2011-01-15.sql database2-2011-01-15.sql … To import all to the db we can: What others are reading:How to re-sync the MySQL Continue reading Linux – Import Multiple .sql dump files into mysql database