How do I increase MYSQL timeouts. I am getting a timeout on restore of a db. it takes more than a hour
I do not see any settings
System.Net.WebException: The operation has timed out
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
at Microsoft.Web.Services3.WebServicesClientProtocol.GetResponse(WebRequest request, IAsyncResult result)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.EnterpriseServer.esDatabaseServers.RestoreSqlDatabase(Int32 itemId, String[] uploadedFiles, String[] packageFiles)
at SolidCP.Portal.SqlRestoreDatabase.RestoreDatabase()
thanks
Hello,
With such large DB restores its generally recommended to do this directly on the server as its the most efficient way to handle the data and avoids timeouts.
Regards,
Trevor
@trevor thank you for the reply.
I found that using phpMyAdmin is a lot faster and does not timeout. I am going to advice my clients to use that to restore rather than the solidcp portal
