Solved

My SQL 5.5 is not starting; Getting Error#1607

Posted on 2014-10-01
3
415 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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Creating and Managing Databases with phpMyAdmin in cPanel.
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

820 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