[Opensim-users] Database issues after server crash

[Ben Faust]

  My server crashed (ran out of disk space), and it took awhile to 
figure out how to get innoDB running again with MySQL... The database 
appears to be in tact, except the `migrations` table is missing... Now, 
when trying to start OpenSim, the following is part of the startup logs. 
Anyone know how to fix this, or perhaps have the mysql for recreating 
that table?

Exception: System.Exception: Table 'migrations' already exists in SQL: 
create table migrations(name varchar(100), version int)
   at OpenSim.Data.Migration.ExecuteScript 
(System.Data.Common.DbConnection conn, System.String[] script) [0x00000] 
in <filename unknown>:0
   at OpenSim.Data.Migration.ExecuteScript 
(System.Data.Common.DbConnection conn, System.String sql) [0x00000] in 
<filename unknown>:0
   at OpenSim.Data.Migration.ExecuteScript (System.String sql) [0x00000] 
in <filename unknown>:0
   at OpenSim.Data.Migration.InitMigrationsTable () [0x00000] in 
<filename unknown>:0
   at OpenSim.Data.Migration.Update () [0x00000] in <filename unknown>:0
   at OpenSim.Data.MySQL.MySQLEstateStore.Initialise (System.String 
connectionString) [0x00000] in <filename unknown>:0
   at OpenSim.Region.Framework.StorageManager..ctor (System.String 
dllName, System.String connectionstring, System.String 
estateconnectionstring) [0x00000] in <filename unknown>:0
   at OpenSim.OpenSimBase.CreateStorageManager (System.String 
connectionstring, System.String estateconnectionstring) [0x00000] in 
<filename unknown>:0
   at OpenSim.OpenSimBase.CreateStorageManager () [0x00000] in <filename 
unknown>:0
   at OpenSim.Region.ClientStack.RegionApplicationBase.StartupSpecific 
() [0x00000] in <filename unknown>:0
   at OpenSim.OpenSimBase.StartupSpecific () [0x00000] in <filename 
unknown>:0
   at OpenSim.OpenSim.StartupSpecific () [0x00000] in <filename unknown>:0
   at OpenSim.Framework.Servers.BaseOpenSimServer.Startup () [0x00000] 
in <filename unknown>:0
   at OpenSim.Application.Main (System.String[] args) [0x00000] in 
<filename unknown>:0