Xampp lite, Mysql wont start on 3TB xHDD

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

Xampp lite, Mysql wont start on 3TB xHDD

Postby sallyfields » 15. December 2013 23:09

I installed Xampp portable 1.8.2 in 5 minutes on my flash drive but when I went to install it on a 3 terabyte seagate usb drive mysql wont start, 12 hours in and im right where I started! No Clue! Any help appreciated.

I read something about the external hard drive being to big and the sectors are to big for Mysql to handle in the my.ini file.
Heres the error:

Error: MySQL shutdown unexpectedly.
12:52:23 PM [mysql] This may be due to a blocked port, missing dependencies,
12:52:23 PM [mysql] improper privileges, a crash, or a shutdown by another method.
12:52:23 PM [mysql] Press the Logs button to view error logs and check
12:52:23 PM [mysql] the Windows Event Viewer for more clues
12:52:23 PM [mysql] If you need more help, copy and post this
12:52:23 PM [mysql] entire log window on the forums

AND HERES WHAT GETS WRITTEN TO THE LOG FILE:

131215 3:48:07 [Note] Plugin 'FEDERATED' is disabled.
131215 3:48:07 InnoDB: The InnoDB memory heap is disabled
131215 3:48:07 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131215 3:48:07 InnoDB: Compressed tables use zlib 1.2.3
131215 3:48:07 InnoDB: Initializing buffer pool, size = 16.0M
131215 3:48:07 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file H:\WEBSITE\mysql\data\ibdata1
131215 3:48:07 InnoDB: Could not open or create data files.
131215 3:48:07 InnoDB: If you tried to add new data files, and it failed here,
131215 3:48:07 InnoDB: you should now edit innodb_data_file_path in my.cnf back
131215 3:48:07 InnoDB: to what it was, and remove the new ibdata files InnoDB created
131215 3:48:07 InnoDB: in this failed attempt. InnoDB only wrote those files full of
131215 3:48:07 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
131215 3:48:07 InnoDB: remove old data files which contain your precious data!
131215 3:48:07 [ERROR] Plugin 'InnoDB' init function returned error.
131215 3:48:07 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131215 3:48:07 [ERROR] Unknown/unsupported storage engine: InnoDB
131215 3:48:07 [ERROR] Aborting
131215 3:48:07 [Note] h:\website\mysql\bin\mysqld.exe: Shutdown complete

HERES THE MY.INI FILE DEFAULTS AT THE Innodb SECTION:

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = "H:/WEBSITE/mysql/data"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "H:/WEBSITE/mysql/data"
#innodb_log_arch_dir = "H:/WEBSITE/mysql/data"
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

Thanks, -Sally
sallyfields
 
Posts: 1
Joined: 15. December 2013 22:50
Operating System: win7

Re: Xampp lite, Mysql wont start on 3TB xHDD

Postby Altrea » 07. January 2014 08:32

Hi Sally,

Maybe one of these Workaround will work:
viewtopic.php?f=16&t=67577#p232773

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8286
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 25 guests