Hi everyone,
I am using almost identical versions of mysql (5.0.24a) and 5.0.41
I am have used MySql Administrator to backup the db needed. It has a large number of stored procedures.
When i try and import it, either using phpMyAdmin or the command line, i get an error regarding the delimiter used in the SPs.
The SPs were created by my predecessor using the MySql Query browser.
There is no option of making changes to the server.
I may be able to use something else locally, but i do not see the point.
I have been trying to work with SPs in MySql for a couple of weeks now and they seem to be very flakey when you try an deal with them in terms of editing or backup.
Also if a backup of the DB cannot be restored then doesn't that mean the backup was pointless.
Any suggestions very welcome.
Thanks
I am using almost identical versions of mysql (5.0.24a) and 5.0.41
I am have used MySql Administrator to backup the db needed. It has a large number of stored procedures.
When i try and import it, either using phpMyAdmin or the command line, i get an error regarding the delimiter used in the SPs.
The SPs were created by my predecessor using the MySql Query browser.
There is no option of making changes to the server.
I may be able to use something else locally, but i do not see the point.
I have been trying to work with SPs in MySql for a couple of weeks now and they seem to be very flakey when you try an deal with them in terms of editing or backup.
Also if a backup of the DB cannot be restored then doesn't that mean the backup was pointless.
Any suggestions very welcome.
Thanks