I need to backup my databases to do some changes. Hi, I'm not OP but was wondering if you could shed some insight. Mysqldump Ver 8.0.15 for Linux on x86_64 (MySQL Community Server - GPL)įinally, the loose-local-infile=1 is an entry I entered in /etc/mysql/my.cnf to be able to load data from local files into my database. Check if you have the latest version of NMM. I did not remove the old MySQL server but when I check the version using: SHOW VARIABLES LIKE '%version%' Īlso, when I go to /usr/bin/ and execute: mysqldump -version I get: mysqldump: unknown variable 'loose-local-infile=1'. Please note that I also upgraded both MySQL workbench and MySQL server. I did not change anything apart from shutting down my device and start it. Please note that the export worked with me yesterday. Note, this is the result for locating mysqldump. I tried to change it to both:Īfter each change, I close and open the MySQL workbench. In the current event record, either the event number in the data set or the Tivoli Workload Scheduler for z/OS node number is invalid. Each event must come from one of 16 possible event data sets on each Tivoli Workload Scheduler for z/OS node. It suggest going to Edit -> Preferences -> Administration and to change the path to mysqldump tool to where mysqldump is. The normal mode manager (NMM) could not determine the origin of the event. But still the backup does not work in both types (self-contained sql file or dump project files). Although the old files are not there, I click ok. Please note that I first get warning syaing the existing data will be overwritten (I deleted old backup but I am saving the new one under same name). Please verify the log for more information I click export but I get error saying:Ĭould not get mysqldump version Workbench was unable to get mysqldump I choose the file path where I want to export the backup (external hard drive). When I click on Data export I select the scheme and make sure all the tables needed are checked. I need to backup my database from the workbench.

I use MySQL workbench 6.3 on Ubunut 18 using MySQL server 8+.

Nmm could not get version information