Bug #79108 | Multiple MEB and MySQL Versions now allowed | ||
---|---|---|---|
Submitted: | 4 Nov 2015 1:53 | Modified: | 4 Nov 2015 10:33 |
Reporter: | Philip Olson | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
Version: | 6.3.5 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | meb |
[4 Nov 2015 1:53]
Philip Olson
[4 Nov 2015 10:33]
Pawel Mroszczyk
Thank you for reporting this bug. However, I'm closing it as a duplicate because it's already in our internal bug-tracking system, which unfortunately, I cannot make a reference to from this bug system. But let me assure you, that the issue is being worked on. BTW, the inability to select the MEB version for a particular database instance is actually not the bug, but a side effect of another underlying problem: when versions don't match, the user is locked out of the MEB configuration screen. Workbench does actually let you pick mysqlbackup binary per database instance. As a workaround in the meantime, if you are not uncomfortable with editing configuration files manually, you can assign the path to the proper mysqlbackup binary, by editing Workbench MEB config file. On Linux, you would typically find it in your MySQL directory. Here's one on my dev machine (/etc/mysql/mebmanager.cnf): # Server wide settings for MySQL Workbench, Enterprise Backup [meb_manager] mysql_instance_1 = /var/lib/mysql/ mysql_instance_2 = /home/benny/sandboxes/msb_5_7_9/data/ [mysql_instance_1] command = /usr/bin/mysqlbackup3 <======== this is what you need to change home = /var/lib/mysqlbackuphome user = mysqlbackup password = host = i7 port = 3306 protocol = SOCKET socket = /var/run/mysqld/mysqld.sock datadir = /var/lib/mysql/ innodb_data_home_dir = mysql_version = 5.6.24 datadir_owner = mysql [mysql_instance_2] command = /usr/bin/mysqlbackup4 <======== this is what you need to change home = /var/lib/mysqlbackuphome-5.7.9 user = mysqlbackup password = host = i7 port = 5709 protocol = SOCKET socket = /tmp/mysql_sandbox5709.sock datadir = /home/benny/sandboxes/msb_5_7_9/data/ innodb_data_home_dir = mysql_version = 5.7.9-enterprise-commercial-advanced datadir_owner = benny On Windows, look for it in your MySQL configuration path. C:\ProgramData\MySQL\..... somewhere in there, or C:\Program Files\MySQL\..... , depending on how your system is configured. I hope this helps.