Title: MySQL Version Problems
Last modified: October 9, 2019

---

# MySQL Version Problems

 *  [efc](https://wordpress.org/support/users/eceleste/)
 * (@eceleste)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/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.

The topic ‘MySQL Version Problems’ is closed to new replies.

 * ![](https://ps.w.org/search-and-replace/assets/icon-256x256.png?rev=1776844)
 * [Search & Replace](https://wordpress.org/plugins/search-and-replace/)
 * [Support Threads](https://wordpress.org/support/plugin/search-and-replace/)
 * [Active Topics](https://wordpress.org/support/plugin/search-and-replace/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/search-and-replace/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/search-and-replace/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [efc](https://wordpress.org/support/users/eceleste/)
 * Last activity: [6 years, 6 months ago](https://wordpress.org/support/topic/mysql-version-problems/)
 * Status: not resolved