MySQL Version Problems

This plugin produces exports that cannot be moved between version 5 and version 8 of MySQL.

We often have to move databases from hosts where MySQL is running an old version (such as version 5.7) to hosts where MySQL is running a new version (such as 8.0), and sometimes from new to old. For example, our local development environment is in MySQL 8.0 and our host is in 5.7.

When we try to make these moves with this plugin using the replace domain feature and the resulting database download, it fails. The plugin reports “The file does not seem to be a valid SQL file. Import not possible.”

However, when we do a regular database export from one site using PHPmyadmin and then an import using Sequel Pro we have no trouble at all.

Clearly it is possible to produce an export from one version of MySQL that can be imported to another version of MySQL, but this plugin does not do this. It would be very helpful if the plugin could be made more careful in the database exports it produces, ensuring that they are compatible with a wider set of MySQL versions.

Also, it would be great if the button on the Replace Domain URL tab said “Prepare SQL file with new domain” rather than “Do Replace Domain/URL”. The current title of the button causes anxiety because it is not clear that the changes are not actually being made to the current database.