Re: INOUT parameter problem.

[jan]

I converted a few SP from Mssql. They worked fine, exept one. I found out that I used IN in one parameter of the SP. I tried to change it to INOUT using the MSSQL Administrator. At that moment the server crashed.
after restarting the server al my SP's were lost. And the server crashes as soon I select a database in the administrator or the QueryBrowser.


051202 21:31:08 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.16-nt' socket: '' port: 3306 Official MySQL binary
051204 20:37:21 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
051204 20:37:21 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 144223.
InnoDB: Doing recovery: scanned up to log sequence number 0 144223
InnoDB: Last MySQL binlog file position 0 0, file name
051204 20:37:22 InnoDB: Started; log sequence number 0 144223
051204 20:37:22 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.16-nt' socket: '' port: 3306 Official MySQL binary
051204 20:38:40 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.