Mac Crashed. Mysql broken

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

Mac Crashed. Mysql broken

Postby dagger2002 » 20. May 2014 01:40

Hey All

My mac crashed, like a windows blue screen of death. Now I can't get my mysql server to come back online. or find the DB files.

I am running Xampp 1.8.3-4


Any ideas?

Log entries
Code: Select all
Timestamp, Thread, Type, Details
, , , 2014-05-19 17:20:42 8330 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/deathRay.local.pid ended
, , , 2014-05-19 17:36:47 9338 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
2014-05-19 17:36:48, 0, Warning, Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2014-05-19 17:36:48, 0, Warning, TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-05-19 17:36:48, 9709, Warning, Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
2014-05-19 17:36:48, 9709, Note, Plugin 'FEDERATED' is disabled.
2014-05-19 17:36:48, 9709, Note, InnoDB: Using atomics to ref count buffer pool pages
2014-05-19 17:36:48, 9709, Note, InnoDB: The InnoDB memory heap is disabled
2014-05-19 17:36:48, 9709, Note, InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-05-19 17:36:48, 9709, Note, InnoDB: Compressed tables use zlib 1.2.8
2014-05-19 17:36:48, 9709, Note, InnoDB: Using CPU crc32 instructions
2014-05-19 17:36:48, 9709, Note, InnoDB: Initializing buffer pool, size = 16.0M
2014-05-19 17:36:48, 9709, Note, InnoDB: Completed initialization of buffer pool
2014-05-19 17:36:48, 9709, ERROR, InnoDB: /Applications/XAMPP/xamppfiles/var/mysql/ibdata1 can't be opened in read-write mode
2014-05-19 17:36:48, 9709, ERROR, InnoDB: The system tablespace must be writable!
2014-05-19 17:36:48, 9709, ERROR, Plugin 'InnoDB' init function returned error.
2014-05-19 17:36:48, 9709, ERROR, Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-05-19 17:36:48, 9709, ERROR, Unknown/unsupported storage engine: InnoDB
2014-05-19 17:36:48, 9709, ERROR, Aborting
dagger2002
 
Posts: 1
Joined: 20. May 2014 01:33
Operating System: OSX 10.9

Re: Mac Crashed. Mysql broken

Postby Nobbie » 20. May 2014 16:41

>/Applications/XAMPP/xamppfiles/var/mysql/ibdata1 can't be opened in read-write mode

This is the main data file of your Xampp installation - seems that it has been destroyed (hardware/harddisc failuer?).
Nobbie
 
Posts: 13183
Joined: 09. March 2008 13:04


Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 43 guests