Backup MySQL Error ...
 
Notifications
Clear all

Backup MySQL Error (Server Core Issue?)

6 Posts
3 Users
0 Likes
1,563 Views
Posts: 60
 Ric
Topic starter
(@ric)
Trusted Member
Joined: 8 years ago

Hi All,

When attempting a backup of any MySQL DBs from SCP I get the following error:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Error executing 'BACKUP' task on 'DB_NAME' SQL_DATABASE ---> Server was unable to process request. ---> The directory name is invalid
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.EnterpriseServer.esDatabaseServers.BackupSqlDatabase(Int32 itemId, String backupName, Boolean zipBackup, Boolean download, String folderName)
at SolidCP.Portal.SqlBackupDatabase.BackupDatabase()

 

SCP v1.1.2
MySQL v5.7.17
MySQL Connector NET v6.9.9

Any Ideas?

5 Replies
Posts: 60
 Ric
Topic starter
(@ric)
Trusted Member
Joined: 8 years ago

Just thinking, could this be an issue with running Windows 2012 R2 Core as the OS?

Does anyone else run Windows Core and can you confirm if this issue occurs?

Reply
Posts: 1456
Admin
(@trobinson)
Noble Member
Joined: 8 years ago

Hello,

 

Can you double check your Installation Folder in the MySQL Provider?

 

Kind Regards,

 

Trevor Robinson

Reply
Posts: 60
 Ric
Topic starter
(@ric)
Trusted Member
Joined: 8 years ago

Hi,

Do you mean the configuraiton of MySQL in SCP? If so it is:

Internal Address:  mysql01.domain.com
External Address:  mysql01.domain.com
MySQL Instllation Folder:  C:Program FilesMySQLMySQL Server 5.7bin

Note:  mysql01.domain.com is just a host file record.

Everything else (create DB/user & delete DB/user) works fine.

Reply
Posts: 234
(@hxkd)
Reputable Member
Joined: 7 years ago

If you are having this very issue, you need to make sure that your application pool is set to the bitness of the apps on the server, ie mysql is running in 64bit mote, your .net app pool on the solidcp website must be 64bit, if you have it set to enable 32bit apps you will get this issue. This seems to go hand in hand with the other apps as well. The issue here is if you have 32bit and 64bit apps on the same server then there is a major issue. this needs to be resolved, maybe a switch needs to be put in the server configs to ask if the app is 64bit or not, and based on this the correct locations are used..

Reply
Page 1 / 2
Share: