Issues connecting to MySql server - Cannot connect to DBMS

Application issues
1

Hello.

Im current testing this tool.
We have the following database servers.
Azure SQL
MS SQL
MySQL

Azure SQL and MS SQL are working as intended and i have tested back and restores.

MySQL server seems to have an issue where the connection when tested fails instantly.
to me it doesn’t even look as it the application is trying to make the connection.
it make no difference what server address i put in the application fails.

Screenshot 2023-11-23 084216

I have installed the latest C++ redistribution as suggested.
this is a windows 2019 Data Centre version with the latest windows updates installed.

Any suggestions ?

2

its a shame really.
this application seems to work so well for the MS SQL and Azure SQL.
But it cannot work with MySQL then its of little use for me.

I will start looking elsewhere.

3

Hello Colin_Kent,

To resolve the issue, please try to specify the path to your bin folder in the advanced connection settings.

SQLBackupAndFTP
SQLBackupAndFTP580×547 18.5 KB

Please let us know if you have any other questions.

Thank you, and sorry for the inconvenience.

4

Hello Alexander

the setting is currently blank
Screenshot 2023-11-29 093641

5

if i change it to be this
Screenshot 2023-11-29 093744

6

i get this error
Screenshot 2023-11-29 093824

Sorry as a new user it will only allow me one screenshot per post

7

Just for clarification
this is a remote MySQL server and im trying to connect over IP
the machine on which the application is installed is a Windows server which has NOT got MySQL installed.

is this something i need to do ?

8

I only have 6 days left on my trail for this product.
i’d really like to get this resolved.

9

Hello Colin_Kent,

Thank you for the clarification.

It seems you have specified the incorrect path; the path should lead to the bin folder of MySQL, not the folder where SQLBackupAndFTP is installed.

If you are connecting to a remote MySQL Server, please install MySQL Workbench on the computer where SQLBackupAndFTP is installed and then specify the path to the bin folder of Workbench (for example, C:\Program Files\MySQL\MySQL Workbench 8.0 CE.

We can extend the trial upon your request. To do so, please provide us with your App ID (“Help” > “About”).

Please let us know if you have any other questions.

Thank you for using SQLBackupAndFTP.

10

Hello.

Thanks for that information.
i have now managed to move forward.

Why is this information not readily available ?

11

Can i get an extension for application ID
bc618117-c814-4f14-ad9e-a130d3ed55ba

Cheers
Colin.

12

Hello Colin,

Thank you for the details. The trial for your installation has been extended until December 12, 2023.

Please let us know if you have any other questions.

Thank you for using SQLBackupAndFTP.

13

Hello Alexander,
I’ve got the same issue, about the bin folder, I’m trying to take a backup of a remote mysql that is on an ubuntu instance, and I’m connecting it over the IP. The sqlbackup and ftp is on my local windows pc.
How do i give the path of bin folder, what might be the path?

14

Hello Kevin,

For incremental backups to work correctly, SQLBackupAndFTP needs to be installed on the same server as the database. Since SQLBackupAndFTP is a Windows-based application and your MySQL server is on a Linux instance, this setup is not feasible.

As an alternative, you might consider using SqlBak, which is designed to manage backups on Linux servers.

If you have any other questions, please feel free to reach out.