Mysqldump Version Mismatch

[piratemac541]

Hello. I’m using Docker and Mysql Workbench as recommended in PHP & MySql Novice to Ninja. I’ve started making my own site and am trying to export the database structure and contents to put onto a web server. When I try to do a Data Export I get the following message:

/Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump is version 8.0.22, but the MySQL Server to be dumped has version 10.8.3.

Because the version of mysqldump is not the same as the server, some features may not be backed up properly.

It is recommended you upgrade or downgrade your local MySQL client programs, including mysqldump, to a version equal to or newer than that of the target server.

The path to the dump tool must then be set in Preferences → Administrator → Path to mysqldump Tool:

I’m guessing this is because I’m runnning a relatively older version of MySQL Workbench that would work on Mac Catalina. I’m not feeling at all confident about messing with the settings of Docker and was wondering if anyone has any insights?

Maybe there is some other way of getting an SQL file out Docker rather than Workbench?

[piratemac541]

Incase it’s useful to anyone here is a bit of a workaround:

Mysqldump from Docker container

Hello. Wondering if anyone could help with this, as my understanding of Docker is limited I’ve been following along with the PHP Novice To Ninja books and have created my own site based on it locally in a Docker container. I know want to extract an SQL file of the database structure to deploy on a web server, but MySQL Workbench (which the book recommends) can’t Data Export with the Docker environment detailed in the book. So I found the following: Blockquote docker exec -i mysql_contain…