Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 483
  • Last Modified:

My SQL 5.5 is not starting; Getting Error#1607

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
romeiovasu
Asked:
romeiovasu
  • 2
2 Solutions
 
Berkson WeinTech FreelancerCommented:
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
 
romeiovasuAuthor Commented:
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
 
Berkson WeinTech FreelancerCommented:
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

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now