I can't start my sql - error: Plugin 'InnoDB' init function

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

I can't start my sql - error: Plugin 'InnoDB' init function

Postby danpetruk » 25. October 2012 12:19

Hello, I installed xampp on my linux mint 13. All works well, apart from mysql. I can't run it. I input this in console as a root:
Code: Select all
/opt/lampp/lampp startmysql

I see this answer:
Code: Select all
XAMPP: Starting MySQL...
XAMPP: Couldn't start MySQL!

In error log (/opt/lampp/var/mysql/documputer.err)
Code: Select all
121025 15:18:54 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
121025 15:18:54 [Note] Plugin 'FEDERATED' is disabled.
121025 15:18:54 InnoDB: The InnoDB memory heap is disabled
121025 15:18:54 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
121025 15:18:54 InnoDB: Compressed tables use zlib 1.2.3
121025 15:18:54 InnoDB: Initializing buffer pool, size = 16.0M
121025 15:18:54 InnoDB: Completed initialization of buffer pool
InnoDB: Error: auto-extending data file /opt/lampp/var/mysql/ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
121025 15:18:54 InnoDB: Could not open or create data files.
121025 15:18:54 InnoDB: If you tried to add new data files, and it failed here,
121025 15:18:54 InnoDB: you should now edit innodb_data_file_path in my.cnf back
121025 15:18:54 InnoDB: to what it was, and remove the new ibdata files InnoDB created
121025 15:18:54 InnoDB: in this failed attempt. InnoDB only wrote those files full of
121025 15:18:54 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
121025 15:18:54 InnoDB: remove old data files which contain your precious data!
121025 15:18:54 [ERROR] Plugin 'InnoDB' init function returned error.
121025 15:18:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
121025 15:18:54 [ERROR] Unknown/unsupported storage engine: InnoDB
121025 15:18:54 [ERROR] Aborting

121025 15:18:54 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

121025 15:18:54 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/dcomputer.pid ended

How can I fix this?
danpetruk
 
Posts: 2
Joined: 25. October 2012 12:11
Operating System: Linux mint 13

Re: I can't start my sql - error: Plugin 'InnoDB' init funct

Postby JonB » 30. October 2012 00:14

What happened when you ran 'opt/lampp/lampp start' (via su or sudo) ???

:?:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 76 guests