Bug #90636 mysqldbcompare incompatible with mysql 8.0

Submitted: 25 Apr 2018 22:20 Modified: 25 Apr 2018 23:38
Reporter: Robert Jacob Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Utilities Severity:S3 (Non-critical)
Version:1.6.5 OS:Any
Assigned to: CPU Architecture:Any

[25 Apr 2018 22:20] Robert Jacob 
Description:
mysqldbcompare requires mysql.proc table which has been removed in version 8 of mysql

How to repeat:
[root@db2-au mysql]# mysqldbcompare --server1=root:pwd@localhost --skip-data-check --skip-row-count template:autosql
# WARNING: Using a password on the command line interface can be insecure.
# server1 on localhost: ... connected.
# Checking databases template and autosql on server1
#
ERROR: Query failed. 1146 (42S02): Table 'mysql.proc' doesn't exist

Suggested fix:
change all system table queries to use the information_schema views
[25 Apr 2018 23:38] MySQL Verification Team 
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=83701.
[25 Jul 2018 16:40] Gayathri Jayaraman 
Any fix for this to use the mysql utilities 1.6.5 with 8.0.11?
I am having the same error when using mysqldbcopy to copy databases between 2 mysql 8.0.11 instances. Appreciate any fix to this issue.
[22 Apr 2020 13:47] Gauravkumar Mishra 
I am observing same issue with mysqldbcompare and mysqldbcopy.
An early fix will be appreciated.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.