Solved

mysql 5.1 not starting

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Learn about cloud computing and its benefits for small business owners.
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

816 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

8 Experts available now in Live!

Get 1:1 Help Now