Reply to thread

My MP is totally screwed up, it says;

2010-03-05 19:14:23.240234 [MPMain(1)]: BusinessLayer: GetProgramsForAllChannels caused an Exception - Table '.\mptvdb\program' is marked as crashed and should be repaired,    kohteessa MySql.Data.MySqlClient.MySqlStream.OpenPacket()

   kohteessa MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)

   kohteessa MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()

   kohteessa MySql.Data.MySqlClient.MySqlDataReader.NextResult()

   kohteessa MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

   kohteessa MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

   kohteessa System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

   kohteessa System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   kohteessa System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   kohteessa System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

   kohteessa TvDatabase.TvBusinessLayer.GetProgramsForAllChannels(DateTime startTime, DateTime endTime, List`1 channelList)

Where that database is, can I fix it?

What happens if I delete it, what is lost?

Thanks,

Sohvaperuna

Fixed

mysql -u root -p

use mptvdb;

repair table program;