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