mysql - 无法使用 mysqlserverclone 实用程序克隆现有的 mysql 服务器

Question

我使用 mysql installer for windows 安装了 mysql server 5.7.12 utilities 1.5.6。我通过安装程序向导配置了 mysql-server。然后，我尝试使用 mysqlcloneserver 实用程序克隆此服务器:

mysqlserverclone --server=root:mysql@localhost:3306 --new-data="C:/Users/quyet/Documents/DBMS/fabric/store" --mysqld="--server-id=2 --log-bin --log-slave-updates --gtid-mode=ON --enforce-gtid-consistency" --new-port=13000 --delete-data

运行命令后，命令输出此错误:

WARNING: Using a password on the command line interface can be insecure.
# WARNING: Root password for new instance has not been set.
# Cloning the MySQL server running on localhost.

The console has detected that the utility 'mysqlserverclone' ended with an error code.
You can get more information about the error by running the console command 'show last error'.

我运行命令:

show last error

并得到这个输出:

Execution of utility: 'mysqlserverclone --server=root:mysql@localhost:3306 --new-data=C:/Users/quyet/Documents/DBMS/fabric/store --mysqld=--server-id=2 --log-bin --log-slave-updates --gtid-mode=ON --enforce-gtid-consistency --new-port=13000 --delete-data' ended with return code '1' and with the following error message:
Traceback (most recent call last):
  File "G:\ade\build\sb_0-16486154-1442332453.92\Python-2.7.6-windows-x86-32bit\lib\site-packages\cx_Freeze\initscripts\Console.py", line 27, in <module>
  File "scripts\mysqlserverclone.py", line 211, in <module>
  File ".\mysql\utilities\command\serverclone.py", line 180, in clone_server
  File ".\mysql\utilities\common\tools.py", line 254, in get_mysqld_version
IOError: [Errno 13] Permission denied: 'version_check'

我在谷歌上搜索过，但发现了任何类似的问题。任何帮助都感激不尽 !

Answer 1

有点过时，但它可能会有所帮助。以管理员身份运行 Mysql Utils 控制台