Solved

My SQL 5.5 is not starting; Getting Error#1607

Posted on 2014-10-01
3
403 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:
weinberk earned 500 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:weinberk
weinberk earned 500 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Redirected folders in a windows domain can be quite useful for a number of reasons, one of them being that with redirected application data, you can give users more seamless experience when logging into different workstations.  For example, if a use…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

760 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

26 Experts available now in Live!

Get 1:1 Help Now