i am using solidcp with windows 2019 . when users and admin try to backup mysql database , below error shown :
i check mysql setting and root password , every thing is ok.
below is my mysql setting :
how can i solve this problem?
I found what made issue .
you gave me the wrong path for mysql server.
you said i set it as “C:\Program Files\MySQL\MySQL Server 5.7\bin”
but the correct path is “C:\Program Files\MySQL\MySQL Server 5.7”
I did every thing you said me and sent you the results .
i am so sorry solidcp does not do very essential action like backing up mysql from panel and phpmyadmin
Its difficult for us to be able to debug this issue as we cannot recreate it and nobody else appears to have this issue.
It might be easier if we are able to connect to your environment using our premium support. You can find the support plans at https://solidcp.com/services/server-support/ and using the contact form above to create a premium support ticket.
yes it has
the path is “C:\Program Files\MySQL\MySQL Server 5.7\bin” in server setting
and there is mysqldump.exe
i use this .exe in cmd successfully , but from solid cp portal , it does not work returning same error i sent before
Can you confirm the path we have set before does contain the mysqldump.exe file?
If not you will need to locate this and set that to the MySQL path.
i upgrade all servers to 1.4.4 successfully .
then replace downloaded .dll s from http://installer.solidcp.com/Files/1.4.4/SQLProvider-Fix.zip to C:\SolidCP\Server\bin
but again when try to backup mysql below error is in event viewer :
[9/10/2019 9:21:02 PM] ERROR: ‘MySQL Server 5.7’ BackupDatabase
System.ComponentModel.Win32Exception (0x80004005): The system cannot find the file specified
at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
at SolidCP.Providers.Utils.DefaultCommandLineProvider.Execute(String filePath, String args, String outputFile)
at SolidCP.Providers.Database.MySqlServer.BackupDatabase(String databaseName, String backupName)
at SolidCP.Providers.Database.MySqlServer.BackupDatabase(String databaseName, String backupName, Boolean zipBackup)
at SolidCP.Server.DatabaseServer.BackupDatabase(String databaseName, String backupName, Boolean zipBackup)
what must i do?
Can you please try download this file: http://installer.solidcp.com/Files/1.4.4/SQLProvider-Fix.zip
The DLL files should override the files in C:\SolidCP\Server asp.net v4.5\bin on the server running the SQL server.
that dll you used is for the 1.4.4 version. I would maybe reccomend upgrading to 1.4.4, what version is your enterprise server, and portal server ?
- Views1761 times
- Answers20 answers