Re: MYSQLDUMP on remote Ubuntu from Windows 10 now fails with Got error: 2059: "Authentication plugin 'caching_sha2_password' cannot be loaded:

[William Damage]

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.