MYSQL Stored Procedures HELP!

software development

#1

Has anyone come accross this problem.

I use either SQLyog or MySql Query Browser to connect to the remote sql server, create a new stored procedure function. Run execute to store it then all is ok.

The sever seems to “lose” the stored procedure after a day or so for no apparent reason.

If I go in to edit it - the “bare bones” of the stored procedure is there but the content is not anymore.

So I have to delete the stored proc and then create it again.

If I do the same on my dev server at home, no problems.

Any ideas please, its driving me up the wall !!!

Miss Pixie
aka Alison