XAMPP 1.7.4 - MySQL problems after computer crash

Problems with the Windows version of XAMPP, questions, comments, and anything related.

XAMPP 1.7.4 - MySQL problems after computer crash

Postby Iblis » 23. February 2011 04:10

After a reboot, preceded by my computer crashing, I was no longer able to start the XAMPP MySQL service, leaving my development platform inoperable.

After starting the MySQL service through the XAMPP Control Panel, the mysql_error log file will report something like this:

110222 22:06:16 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110222 22:06:16 InnoDB: Initializing buffer pool, size = 16.0M
110222 22:06:16 InnoDB: Completed initialization of buffer pool
110222 22:06:16 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110222 22:06: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...
110222 22:06:16 InnoDB: 1.1.4 started; log sequence number 1601216
110222 22:06:16 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)


Apache has continued to work, but I cannot access any XAMPP tools, such as phpMyAdmin. My web development platform is Joomla 1.5.22, if that matters. Does anyone have any idea how to fix this? I'm somewhat scared, as I have no backup MySQL tables, and have put considerably hours into development in the past several days. I would love a solution to either export what I have to a new XAMPP installation, or to simply fix what I have now, if possible.
Iblis
 
Posts: 1
Joined: 23. February 2011 04:00

Re: XAMPP 1.7.4 - MySQL problems after computer crash

Postby cchamusi » 27. February 2011 11:09

I am also facing the same problem. mine was not after a computer crash though. It started after I reinstalled Xampp 1.7.4. the error shown in mysql_error log is:

    110227 9:30:01 [Note] Plugin 'FEDERATED' is disabled.
    InnoDB: The InnoDB memory heap is disabled
    InnoDB: Mutexes and rw_locks use Windows interlocked functions
    InnoDB: Compressed tables use zlib 1.2.3
    110227 9:30:01 InnoDB: Initializing buffer pool, size = 16.0M
    110227 9:30:01 InnoDB: Completed initialization of buffer pool
    110227 9:30:01 InnoDB: highest supported file format is Barracuda.
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    110227 9:30:01 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...
    110227 9:30:02 InnoDB: 1.1.4 started; log sequence number 8140664
    110227 9:30:02 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
Please help on this, the site am developing is now overdue.

The other problem I am facing is that after i installed Xampp on a diferent computer mysql is working just fine, but when installing Joomla 1.6 am getting an error (at sate 4: Database) saying:

Could not connect to the database. Connector returned number: Unable to connect to the Database: Could not connect to MySQL.


I dont knw what to do know. i have run out of ideas. Please help.
cchamusi
 
Posts: 2
Joined: 27. February 2011 10:51


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 151 guests