Backup database error


#1

how to fix it.

4/12/2561 14:22 Starting job "Backup Job - 2 " - “Full”. Computer “DESKTOP-12EOO03”. App v.“12.0.4”
4/12/2561 14:22 Connecting to MySQL Server: 5.0.51b-community-nt. 127.0.0.1
4/12/2561 14:22 The backup folder “C:\Users\kapon\OneDrive\Desktop\2561\temp\Pranas.NET\SQLBackupAndFTP\backup” has “338.989GB” free space. The temporary folder “C:\Users\kapon\OneDrive\Desktop\2561\temp\Pranas.NET\SQLBackupAndFTP\backup” has “338.989GB” free space
4/12/2561 14:22 Backing up “127.0.0.1” databases with mysqldump: Ver 8.0.12 for Win64 on x86_64 (MySQL Community Server - GPL)
4/12/2561 14:22 Getting maximum file size…
4/12/2561 14:22 The maximum file size: “”
4/12/2561 14:22 Failed to backup “xxxbase” database with “Full” backup type: mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Got error: 1043: Bad handshake when trying to connect
4/12/2561 14:22 Backing up folders
4/12/2561 14:22 Backing up “temp” folder in C:\Users\kapon\OneDrive\Desktop\2561\temp


#2

Hello,

Thanks for the details. Could you please try to enable the “Define the connection password in environment variable” at the “MySQL Backup Options” Window.


#3

6/12/2561 9:13 Starting job "Backup Job - 2 " - “Full”. Computer “DESKTOP-12EOO03”. App v.“12.0.4”
6/12/2561 9:13 Connecting to MySQL Server: 5.0.51b-community-nt. 127.0.0.1
6/12/2561 9:13 The backup folder “C:\Users\kapon\OneDrive\Desktop\2561\temp\Pranas.NET\SQLBackupAndFTP\backup” has “338.438GB” free space. The temporary folder “C:\Users\kapon\OneDrive\Desktop\2561\temp\Pranas.NET\SQLBackupAndFTP\backup” has “338.438GB” free space
6/12/2561 9:13 Backing up “127.0.0.1” databases with mysqldump: Ver 8.0.12 for Win64 on x86_64 (MySQL Community Server - GPL)
6/12/2561 9:13 Getting maximum file size…
6/12/2561 9:13 The maximum file size: “”
6/12/2561 9:13 Failed to backup “jhcisdb” database with “Full” backup type: mysqldump: Got error: 1043: Bad handshake when trying to connect
6/12/2561 9:13 Backing up folders
6/12/2561 9:13 Backing up “temp” folder in C:\Users\kapon\OneDrive\Desktop\2561\temp
6/12/2561 9:13 Compressing “C:\Users\kapon\OneDrive\Desktop\2561\temp” folder with Internal archiver. Encryption: “Off”
6/12/2561 9:13 Backup of “C:\Users\kapon\OneDrive\Desktop\2561\temp” has been successfully compressed to “”
6/12/2561 9:13 Connecting to Folder destination “C:\Users\kapon\OneDrive\Desktop\2561”
6/12/2561 9:13 Reading folder information by path: “C:\Users\kapon\OneDrive\Desktop\2561”
6/12/2561 9:13 The current destination folder is “C:\Users\kapon\OneDrive\Desktop\2561”
6/12/2561 9:13 Sending backup of “temp” to Folder destination “C:\Users\kapon\OneDrive\Desktop\2561”
6/12/2561 9:13 Cleaning up backups of "Backup Job - 2 " job
6/12/2561 9:13 Cleaning up backups of “temp” folder at Folder destination “C:\Users\kapon\OneDrive\Desktop\2561”
6/12/2561 9:13 Disconnecting from Folder destination “C:\Users\kapon\OneDrive\Desktop\2561”
6/12/2561 9:14 Job "Backup Job - 2 " finished with “1” errors


error mysqldump: Got error: 1043: Bad handshake when trying to connect

how to fix, please


#4

Hi,

Thanks for the details, we have fixed this issue, could you please install the following release and check it

Please let us know if it works.

Sorry for the inconvenience.