Solved

mysql 5.1 not starting

Posted on 2014-11-12
1
498 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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
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 …

762 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

11 Experts available now in Live!

Get 1:1 Help Now