MySQL Backup doesn't work anymore

Application issues
1

I’ve upgraded “MySQL Backup And FTP” to the latest “SQL Backup and FTP” 12.0.4 Professional. The installer removed the old installation and imported the existing backup job. Since then, backup jobs are failing! I’ve tested the MySQL Server connection, the backup path connection and had no issues.

When I change the connection from server type "MySQL Server (TCP/IP) to “MySQL Server (phpMyAdmin)”, the backup works. But it is slowly and my Windows Server has a 99% CPU workload.

LOG:

2018-11-19 07:44:21.3882|ERROR|26|Pranas.NET.SqlBak.Job.MySql.Helpers.DumpHelper|DoBackup|System.Exception
at Pranas.NET.SqlBak.Job.MySql.Helpers.DumpHelper.DoBackup(String pathOfDump, MySqlConnectionInfo connectionInfo, String dbName, String outputFileName, MySqlBackupOptions mySqlBackupOptions, CancellationToken cancellationToken)
2018-11-19 07:44:21.3882|ERROR|26|Pranas.NET.SqlBak.Job.MySql.impl.Operations.MySqlDatabaseOperation|BackupDatabase|System.Exception
at Pranas.NET.SqlBak.Job.MySql.Helpers.DumpHelper.DoBackup(String pathOfDump, MySqlConnectionInfo connectionInfo, String dbName, String outputFileName, MySqlBackupOptions mySqlBackupOptions, CancellationToken cancellationToken)
at Pranas.NET.SqlBak.Job.MySql.impl.Operations.MySqlDatabaseOperation.BackupDatabase(String databaseName, String outfileName, ObjectType objectType, IDatabaseBackupOptions backupOptions, CancellationToken cancellationToken)
2018-11-19 07:44:21.3882|TRACE|26|Net.Pranas.SqlBak.Job.Core.JobHandler|BackupDatabases. Backup exception|System.Exception
at Pranas.NET.SqlBak.Job.MySql.Helpers.DumpHelper.DoBackup(String pathOfDump, MySqlConnectionInfo connectionInfo, String dbName, String outputFileName, MySqlBackupOptions mySqlBackupOptions, CancellationToken cancellationToken)
at Pranas.NET.SqlBak.Job.MySql.impl.Operations.MySqlDatabaseOperation.BackupDatabase(String databaseName, String outfileName, ObjectType objectType, IDatabaseBackupOptions backupOptions, CancellationToken cancellationToken)
at Net.Pranas.SqlBak.Job.Business.Common.BaseDatabaseHandler.BackupDatabase(String path, String databaseName, IJobRunInfo runInfo, IDbBackupType backupType, DateTime backupTime)
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupDatabases(IJob job, IDatabaseHandler dbHandler, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters runParameters, WorkingFolders folders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Dictionary2 archiveFileNames, Nullable1 customMaxFileSize, IDestinationHandler destinationHandler)
2018-11-19 07:44:21.3882|DEBUG|26|Net.Pranas.SqlBak.Log.Core.Logger|Serialize. Limit: “8192”|System.Exception
at Pranas.NET.SqlBak.Job.MySql.Helpers.DumpHelper.DoBackup(String pathOfDump, MySqlConnectionInfo connectionInfo, String dbName, String outputFileName, MySqlBackupOptions mySqlBackupOptions, CancellationToken cancellationToken)
at Pranas.NET.SqlBak.Job.MySql.impl.Operations.MySqlDatabaseOperation.BackupDatabase(String databaseName, String outfileName, ObjectType objectType, IDatabaseBackupOptions backupOptions, CancellationToken cancellationToken)
at Net.Pranas.SqlBak.Job.Business.Common.BaseDatabaseHandler.BackupDatabase(String path, String databaseName, IJobRunInfo runInfo, IDbBackupType backupType, DateTime backupTime)
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupDatabases(IJob job, IDatabaseHandler dbHandler, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters runParameters, WorkingFolders folders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Dictionary2 archiveFileNames, Nullable1 customMaxFileSize, IDestinationHandler destinationHandler)

3

Dario,
We are sorry to hear that. This is our top priority, we will get back to you promptly.

4

Hi Dario,

We have checked your logs, thanks.

This issue happens when mysqldump.exe utility is run and to find the reason why it occurs we need more details, could you please do the following:

1.Run the following command via Command Prompt (please specify your password instead of xxxxxxxxx)

C:\Program Files (x86)\SQLBackupAndFTP\DBMS\MySql\mysqldump.exe -h localhost --user "root" "--password=xxxxxxxxx" -P 3306 "frontrecord" --result-file="C:\Users\svc.backup\AppData\Local\Temp\Pranas.NET\SQLBackupAndFTP\backup\frontrecord201811190756.sql" --comments --skip-disable-keys --skip-add-drop-database --skip-add-drop-table --quote-names --complete-insert --extended-insert --max_allowed_packet=1024M --hex-blob --lock-tables=true --default-character-set=utf8 --column-statistics=0 --force --quick --skip-add-locks --skip-lock-tables --create-options --set-charset

and check if you get the same error message.

2.Please check your Windows Event Log (Application and System) are there any error messages related to mysql\mysqldump.exe\SqlBackupAndFtp

3.Could you please tell us do you use any software that is responsible for the security? If yes, please try to disable it for a while, for the test, or add SQLBackupAndFTP and C:\Program Files (x86)\SQLBackupAndFTP\DBMS\MySql\mysqldump.exe file to the exception list.

Sorry for the inconvenience.

5

Hi Alexander

Thank you for support. The problem is solved.

I had to install «Visual C++ Redistributable for Visual Studio 2015» https://www.microsoft.com/en-us/download/confirmation.aspx?id=48145, as I received «MSVCP140.dll is missing» after running mysqldump.exe through command line.

Best regards,
Dario

6

Hi Dario,

Good news, thanks for the info.

Please feel free to contact us, if there is anything we can help you with.

7

That solution worked for me!! This should be part of the installer if it depends on the c++ runtime files.

Thanks!!