?
Solved

My SQL 5.5 is not starting; Getting Error#1607

Posted on 2014-10-01
3
Medium Priority
?
502 Views
Last Modified: 2014-10-16
Hi
i have a windows 2008 server R2 running MYSQL Server 5.5.
MYSQL was running perfectly fine but suddenly it stopped working and i am not able to restart the service.
Now when i go and try to restart the service i am getting an error #1607.

my windows application logs is showing the following
Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

MYSQL error file is showing this


141001 19:17:17 [Note] Plugin 'FEDERATED' is disabled.
141001 19:17:17 InnoDB: The InnoDB memory heap is disabled
141001 19:17:17 InnoDB: Mutexes and rw_locks use Windows interlocked functions
141001 19:17:17 InnoDB: Compressed tables use zlib 1.2.3
141001 19:17:17 InnoDB: Initializing buffer pool, size = 100.0M
141001 19:17:17 InnoDB: Completed initialization of buffer pool
141001 19:17:17 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 49439
141001 19:17:17  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...
InnoDB: Doing recovery: scanned up to log sequence number 1595675
141001 19:17:17  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
141001 19:17:18  InnoDB: Waiting for the background threads to start
141001 19:17:19 InnoDB: 5.5.38 started; log sequence number 1595675
141001 19:17:19 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141001 19:17:19 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141001 19:17:19 [Note] Server socket created on IP: '0.0.0.0'.
141001 19:17:19 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist




Attached is my.ini file in RTF format.

Any Help on this is appreciated.

Thanks
Raghu
my.ini.rtf
0
Comment
Question by:romeiovasu
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
Berkson Wein earned 2000 total points
ID: 40355502
Did this machine crash at some point?

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

It looks like it can't access part of the database.

Before we start trying to repair/reinstall/debug, do you have a recent backup of the mysql data folder that you could restore from?  I'm not talking about replacing any database other than the system database.   Of course, before you try to restore, make sure you make a backup of the system as it currently exists so we'll be no worse off if the restore fails.

Hope this helps.
0
 

Author Comment

by:romeiovasu
ID: 40355537
No i dont have a mysql data folder.
what should i do to take a backup of the exising database? i made a copy of the mysql folder now. Is that enough?

Thnx
Raghu
0
 
LVL 15

Assisted Solution

by:Berkson Wein
Berkson Wein earned 2000 total points
ID: 40355576
unless you have a very non-standard installation you should have a folder named "mysql" inside of a folder named "data."  After looking at your config file, the mysql folder should be in:

C:/mysqldata/data/

Do you see it there?  

Or, is your data folder elsewhere?  (if so, update the cnf file)



I would start by backing up the entire c:\mysqldata folder as it exists now, and then restore just the data\mysql folder from a backup that worked before this error.

If you don't have a backup that was taken when all was well, you might be easiest to delete the mysql folder from C:/mysqldata/data/ and reinstall mysql (again taking a full backup first so you could roll back).
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

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

This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
In this article, we’ll look at how to deploy ProxySQL.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

598 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