Errno 145 Cannot open Monitor.myi file

[ncite]

In the Pacsone logs we are getting an bad query errno 145. It says it can't open monitor.myi file.

When this happens we can't send or receive images from any of the machines with ae titles.

How can we fix the monitor.myi. Server is windows 2003 running pacsone 6.1.1, php 5.0.2, mysql 3.23.

[pacsone]

The version of MySQL running on your server seems quite out of date (3.23?), so you should upgrade it to a more recent MySQL release instead (5.0.x now).

Also, the error message suggests you are running the MyISAM engine, which is known to cause table corruptions for large tables. You can run the MySQL repair table command from the MySQL shell after logging into the PacsOne Server database to fix the MONITOR table. But you should switch to the more robust/transaction-safe InnoDB engine instead of MyISAM.

[ncite]

What would the command line be to repair the Monitor.myi table. The database name is cmipacs1 with the username root.

[pacsone]

After logging into the PacsOne Server database from a local command shell:

Code: Select all

C:\mysql\bin>mysql -u root -p cmipacs1

You can then repair the monitor table by running the following command from the MySQL shell prompt:

Code: Select all

mysql>repair table monitor;

[ncite]

I was able to repair the monitor table and that corrected the problems we where having. Thanks for your help.

I also dumped the database and imported it in to mysql 5.0. How do you change from the MyISAM to the InnoDB engine?

[pacsone]

You can Google for such topic since it's very popular. Here's one sample:

http://www.linux.com/archive/feed/46370

[ncite]

I'll give that a try. Thanks for all your help.