Solved

mysql 5.1 not starting

Posted on 2014-11-12
1
508 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 16

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now