MySQL refactoring

How to Rename a MySQL Database?

Eventually, it appears necessary to change the name of a database in MySQL. For that purpose, we used to apply a simple RENAME DATABASE command that existed in earlier versions of MySQL. However, it became no longer available in the newer versions as it posed risks. The reason was that the RENAME DATABASE query could result in the loss of essential database contents, which clearly was undesirable.

(more…)

How to Change a Column Name in MySQL

Learn how to safely rename a column in a MySQL database using a universal multi-featured tool – dbForge Studio for MySQL.

(more…)