Running: mysqldump.exe -defaults-file="c:\users\user1\appdata\local\temp\tmpnkltww.cnf" -user=root -host=127.0.0.1 -protocol=tcp -port=10142 -default-character-set=utf8 -skip-triggers "local" When attempting the export, a dialogue showing the following warning indicating a version mismatch was displayed: To export a DB using MySQL Workbench, connect to a DB server, then navigate to Server > Data Export. I didn’t have any problems running queries, so I didn’t think about it again. I made a mental note of the warning, but decided to proceed anyway. When setting the site up in MySQL Workbench (my preferred MySQL client), I was presented with the following warning when testing the connection: My Local setup was configured to use MariaDB v10.4.10. (You know, like the warning message suggests when you try and do otherwise.) Use MySQL v5.7 or v8 when setting up a site in Local by Flywheel rather than using Maria DB. TL DR: Make sure that the version of mysqldump that your MySQL client (MySQL Workbench in my case) points to is the same as the DB version as what is used by the server. Unknown table 'column_statistics' in information_schema (1109) The first error I ran into when trying to export a DB was: Issue 1: MySQL database export error due to client/server version mismatch Database client: MySQL Workbench v8.0.22.These issues could appear on any platform, though. I recently encountered a couple of frustrating MySQL database export errors and wanted to share the solutions I used with other folks, as well as document it for future me.
0 Comments
Leave a Reply. |