MySQL Forums
Forum List  »  Newbie

Re: MYSQLDUMP on remote Ubuntu from Windows 10 now fails with Got error: 2059: "Authentication plugin 'caching_sha2_password' cannot be loaded:
Posted by: William Damage
Date: June 22, 2021 06:03AM

It fails immediately on the mysqldump line. This script still works on the Mysql 5.7 server.

@Echo off
SET host_source=example_host.com
SET host_target=example_target.com
SET db=example_db

if "%1%"=="-l" GOTO skip_remote_load

echo %DATE% %TIME% Starting dump of %db% from remote %host_source% to %host_target%...

mysqldump --defaults-group-suffix=_%host_source% --single-transaction --opt --max_allowed_packet=2048M -h %host_source% %db% > dump.sql

:skip_remote_load

echo %DATE% %TIME% Starting local import...

mysql -e "DROP DATABASE IF EXISTS %db%;CREATE DATABASE %db%;"

mysql -e "SET autocommit=0;SET unique_checks=0;SET foreign_key_checks=0;"

mysql %db% < dump.sql

mysql -e "COMMIT;SET unique_checks=1;SET foreign_key_checks=1;"

echo %DATE% %TIME% Starting file sync...

ncftpget -T -R -v -f ftp.txt \www\joomla\level_1\%host_target% public_html/images
ncftpget -T -R -v -f ftp.txt \www\joomla\level_1\%host_target%\language public_html/language/overrides

echo %DATE% %TIME% Complete.

Options: ReplyQuote


Subject
Written By
Posted
Re: MYSQLDUMP on remote Ubuntu from Windows 10 now fails with Got error: 2059: "Authentication plugin 'caching_sha2_password' cannot be loaded:
June 22, 2021 06:03AM


Sorry, only registered users may post in this forum.

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.