Solved

mysql 5.1 not starting

Posted on 2014-11-12
1
532 Views
Last Modified: 2014-11-13
I have a Windows 2003 server running MySQL 5.1 that I inherited.

Things have been great for months and today mySQL will not start.

I have rebooted, moved the VM to another host and even restored the VM from a backup with no luck.

I'm not sure where to start.


All I get on the screen the the Instance Configuration when i try to start SQL is:

Trying to start the server ...
Server could not be started.


Then in the Server Logs, I have this:


140520 13:49:54 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:50:30 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:51:38 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:51:57 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:52:40 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:53:10 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:53:21 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:54:28 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:54:43 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:55:50 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:56:16 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:56:20 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:56:20 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:56:35 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:56:50 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:56:50 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:56:57 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:56:57 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:57:08 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:57:23 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:57:23 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:57:36 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:57:50 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:57:51 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:58:01 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:58:15 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:58:15 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:58:25 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:58:39 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:58:39 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:59:10 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:59:22 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 13:59:22 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 16:26:43 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 16:27:31 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 16:27:50 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 16:28:21 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 16:28:25 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 16:28:25 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 16:28:54 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 16:29:09 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 16:29:09 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 16:29:24 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 16:29:41 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140520 16:30:25 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140522 14:33:11 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140522 14:43:13 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140522 15:01:31 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140522 15:57:46 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140522 16:04:33 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140522 16:08:19 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140522 16:08:34 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140527 16:42:19 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140528 12:37:25 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140529 11:36:10 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140602 14:47:45 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140602 14:47:45 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140603 16:58:58 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140603 17:09:58 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140604 11:56:20 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140605 13:33:23 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140605 16:15:34 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140606  8:47:53 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140606 13:36:22 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140606 13:52:45 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140606 14:15:11 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140609 11:34:09 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140609 13:05:30 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140610 12:45:19 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140610 12:58:18 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140612  9:30:16 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140612  9:30:16  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...
140612  9:30:18  InnoDB: Started; log sequence number 0 1993950321
140612 10:10:12 [Note] Event Scheduler: Loaded 0 events
140612 10:10:12 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.49-community'  socket: ''  port: 3306  MySQL Community Server (GPL)
140612 10:42:56 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140613  3:21:49 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown

140613  3:21:50 [Note] Event Scheduler: Purging the queue. 0 events
140613  3:21:50  InnoDB: Starting shutdown...
140613  3:21:54  InnoDB: Shutdown completed; log sequence number 0 1996102023
140613  3:21:55 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete

140613  3:23:34 [Note] Plugin 'FEDERATED' is disabled.
140613  3:23:36  InnoDB: Started; log sequence number 0 1996102023
140613  4:03:26 [Note] Event Scheduler: Loaded 0 events
140613  4:03:26 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.49-community'  socket: ''  port: 3306  MySQL Community Server (GPL)
140613 13:54:28 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140613 13:54:57 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140613 14:43:47 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140614  3:03:51 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown

140614  3:03:53 [Note] Event Scheduler: Purging the queue. 0 events
140614  3:03:54  InnoDB: Starting shutdown...
140614  3:03:58  InnoDB: Shutdown completed; log sequence number 0 2000735175
140614  3:03:58 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete

140614  3:06:12 [Note] Plugin 'FEDERATED' is disabled.
140614  3:06:14  InnoDB: Started; log sequence number 0 2000735175
140614  3:45:49 [Note] Event Scheduler: Loaded 0 events
140614  3:45:49 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.49-community'  socket: ''  port: 3306  MySQL Community Server (GPL)
140617 16:03:14 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140618  9:25:27 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140625 14:31:25 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140625 14:35:14 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140627  8:32:08 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140630 16:30:56 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140702 16:52:45 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140702 16:52:49 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140707 14:43:31 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140707 16:27:52 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140709 18:41:48 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140709 18:41:52 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140709 18:44:56 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140710  3:19:35 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown

140710  3:19:35 [Note] Event Scheduler: Purging the queue. 0 events
140710  3:19:35  InnoDB: Starting shutdown...
140710  3:19:40  InnoDB: Shutdown completed; log sequence number 0 2040284497
140710  3:19:40 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete

140710  3:21:40 [Note] Plugin 'FEDERATED' is disabled.
140710  3:21:43  InnoDB: Started; log sequence number 0 2040284497
140710  4:10:47 [Note] Event Scheduler: Loaded 0 events
140710  4:10:47 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.49-community'  socket: ''  port: 3306  MySQL Community Server (GPL)
140716 13:21:43 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140716 16:27:45 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140717  9:31:25 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140717  9:33:42 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140724 10:30:20 C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Can't find file: '.\modbuilderdata\over@002014@0027@00204@0022@0020height@0020load.frm' (errno: 22)
140727 10:25:36 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown

140727 10:25:37 [Note] Event Scheduler: Purging the queue. 0 events
140727 10:25:37  InnoDB: Starting shutdown...
140727 10:25:41  InnoDB: Shutdown completed; log sequence number 0 2077468595
140727 10:25:41 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete

141112 15:54:30 [Note] Plugin 'FEDERATED' is disabled.
141112 15:54:48  InnoDB: Started; log sequence number 0 2077468595
141112 16:05:04 [Note] Plugin 'FEDERATED' is disabled.
141112 16:05:13  InnoDB: Started; log sequence number 0 2077468595
141112 16:08:37 [Note] Plugin 'FEDERATED' is disabled.
141112 16:08:38  InnoDB: Started; log sequence number 0 2077468595
141112 23:20:50 [Note] Plugin 'FEDERATED' is disabled.
141112 23:20:51  InnoDB: Started; log sequence number 0 2077468595
141112 18:25:43 [Note] Plugin 'FEDERATED' is disabled.
141112 18:25:43  InnoDB: Started; log sequence number 0 2077468595
141112 18:29:01 [Note] Plugin 'FEDERATED' is disabled.
141112 18:29:01  InnoDB: Started; log sequence number 0 2077468595
141112 18:29:57 [Note] Plugin 'FEDERATED' is disabled.
141112 18:29:58  InnoDB: Started; log sequence number 0 2077468595
141112 18:32:01 [Note] Plugin 'FEDERATED' is disabled.
141112 18:32:01  InnoDB: Started; log sequence number 0 2077468595


Any help would be greatly appreciated.
0
Comment
Question by:truth_talker
1 Comment
 
LVL 17

Accepted Solution

by:
Chris Harte earned 500 total points
ID: 40439563
The .frm is a table definition file and your mysql server cannot find it (errno 22).

Check the file exists.
Check the permissions on the file AND the directory.

If they pan out, you may have to repair the table. In the format.
REPAIR TABLE <table_name>;
I cannot make out the table name from the log file but I am guessing it is something to do with 'over', 'height' and 'load'. In your my.ini file there is a variable called datadir that will have the path to your databases.

Here is a link to the documentation.
http://dev.mysql.com/doc/refman/5.0/en/repair-table.html


Also, if you have not already done so, download and run the mysql workbench
http://dev.mysql.com/downloads/workbench/
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to dynamically set the form action using jQuery.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question