Sometimes, the only thing that we want is to drop a database(not in PRODUCTION) and recreate it from scratch, especially when we are in the process of automating the deployment of our MySQL databases, for instance using liquibase. Therefore, it is not uncommon in an initial testing process to wish to drop and recreate our tested database.

This article is part of a series dedicated to showing some examples of Databases common problem and how to address it, this time the turn is for MySQL, a great RDBSM and extremely popular relational system. Here the link to the blog of my company TheWorkshop where I decided to contribute with this series of articles, I hope you enjoy it.

https://theworkshop.com/es/blog/how-to-load-millions-of-rows-into-mysql-without-agony/