cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New

Mysql stored procedure defintion vanishes in shared hosting

For some unknown reason , the definition of stored procedures vanishes in shared hosting. Called customer support. Was informed that stored procedures are available only for a limited duration in shared hosting. Minimum duration it would be available - no information. Advise - use VPS . 

I strongly believe that GoDaddy should document this limitation and state as much.

 

Any workaround or solution to this problem ?

1 REPLY 1

This is an issue among other hosting providers as well. Apparently, stored procedures are stored in a root area, which is bad for security, so hosting providers may disable them on shared servers. Python-MySQL communication may be impacted as well.

 

And, no, this was not documented by my other host either.