Search found 1042 matches: InnoDB

Searched query: +InnoDB

Return to advanced search

How to Activate innodb_file_per_table Issue?!

Hello to everyone,
These days I have encountered an issue that I can't solve. My database uses innodb and now its size is going very "big" and foreign keys relationships are very much in numbers. When I backup it, the process is very fast about 5seconds, but the nightmares comes when I try to import/restore the .sql file. It can take up to 5 minutes and this is not normal because the database that I have created now is in the starting point of entering data. After many searches over internet I found a handy solution for my problem, that was a feature of mysql innodb_file_per_table. This feature as many of you may know puts all database information in one directory, so the backup/restore can be done just by copy/paste the database directory. My problem is that after many tries I can't activate this mysql feature on xampp.

Could someone help me with some advices how to enable innodb_file_per_table on XAMPP?
Thank you in advance! :)
by klausveliu
22. January 2015 11:08
 
Forum: XAMPP for Windows
Topic: How to Activate innodb_file_per_table Issue?!
Replies: 2
Views: 160

Mysql startet und stoppt dann wieder

Guten Abend!

Mein Problem: Mysql startet, stoppt danach aber wieder und zeigt eine Fehlermeldung an. Bitte dringend um hilfe!!




2015-01-10 19:29:10 4496 [Note] Plugin 'FEDERATED' is disabled.
2015-01-10 19:29:10 1494 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-01-10 19:29:10 4496 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-10 19:29:10 4496 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-01-10 19:29:10 4496 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-10 19:29:10 4496 [Note] InnoDB: Not using CPU crc32 instructions
2015-01-10 19:29:10 4496 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-01-10 19:29:10 4496 [Note] InnoDB: Completed initialization of buffer pool
2015-01-10 19:29:10 4496 [ERROR] InnoDB: Cannot create log files because data files are corrupt or the database was not shut down cleanly after creating the data files.
2015-01-10 19:29:10 4496 [ERROR] Plugin 'InnoDB' init function returned error.
2015-01-10 19:29:10 4496 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-01-10 19:29:10 4496 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-01-10 19:29:10 4496 [ERROR] Aborting

2015-01-10 19:29:10 4496 [Note] Binlog end
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'partition'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_METRICS'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_CMP'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'INNODB_TRX'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'BLACKHOLE'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'ARCHIVE'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'MRG_MYISAM'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'MyISAM'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'MEMORY'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'CSV'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'sha256_password'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'mysql_old_password'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'mysql_native_password'
2015-01-10 19:29:10 4496 [Note] Shutting down plugin 'binlog'
2015-01-10 19:29:10 4496 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-01-10 19:38:24 5884 [Note] Plugin 'FEDERATED' is disabled.
2015-01-10 19:38:24 15e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-01-10 19:38:24 5884 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-10 19:38:24 5884 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-01-10 19:38:24 5884 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-10 19:38:24 5884 [Note] InnoDB: Not using CPU crc32 instructions
2015-01-10 19:38:24 5884 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-01-10 19:38:24 5884 [Note] InnoDB: Completed initialization of buffer pool
2015-01-10 19:38:24 5884 [ERROR] InnoDB: Cannot create log files because data files are corrupt or the database was not shut down cleanly after creating the data files.
2015-01-10 19:38:24 5884 [ERROR] Plugin 'InnoDB' init function returned error.
2015-01-10 19:38:24 5884 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-01-10 19:38:24 5884 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-01-10 19:38:24 5884 [ERROR] Aborting

2015-01-10 19:38:24 5884 [Note] Binlog end
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'partition'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_METRICS'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_CMP'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'INNODB_TRX'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'BLACKHOLE'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'ARCHIVE'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'MRG_MYISAM'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'MyISAM'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'MEMORY'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'CSV'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'sha256_password'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'mysql_old_password'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'mysql_native_password'
2015-01-10 19:38:24 5884 [Note] Shutting down plugin 'binlog'
2015-01-10 19:38:24 5884 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-01-10 19:38:31 8300 [Note] Plugin 'FEDERATED' is disabled.
2015-01-10 19:38:31 1c0c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-01-10 19:38:31 8300 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-10 19:38:31 8300 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-01-10 19:38:31 8300 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-10 19:38:31 8300 [Note] InnoDB: Not using CPU crc32 instructions
2015-01-10 19:38:31 8300 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-01-10 19:38:31 8300 [Note] InnoDB: Completed initialization of buffer pool
2015-01-10 19:38:31 8300 [ERROR] InnoDB: Cannot create log files because data files are corrupt or the database was not shut down cleanly after creating the data files.
2015-01-10 19:38:31 8300 [ERROR] Plugin 'InnoDB' init function returned error.
2015-01-10 19:38:31 8300 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-01-10 19:38:31 8300 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-01-10 19:38:31 8300 [ERROR] Aborting

2015-01-10 19:38:31 8300 [Note] Binlog end
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'partition'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_METRICS'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_CMP'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'INNODB_TRX'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'BLACKHOLE'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'ARCHIVE'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'MRG_MYISAM'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'MyISAM'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'MEMORY'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'CSV'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'sha256_password'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'mysql_old_password'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'mysql_native_password'
2015-01-10 19:38:31 8300 [Note] Shutting down plugin 'binlog'
2015-01-10 19:38:31 8300 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-01-10 19:38:46 8380 [Note] Plugin 'FEDERATED' is disabled.
2015-01-10 19:38:46 2188 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-01-10 19:38:46 8380 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-10 19:38:46 8380 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-01-10 19:38:46 8380 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-10 19:38:46 8380 [Note] InnoDB: Not using CPU crc32 instructions
2015-01-10 19:38:46 8380 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-01-10 19:38:46 8380 [Note] InnoDB: Completed initialization of buffer pool
2015-01-10 19:38:46 8380 [ERROR] InnoDB: Cannot create log files because data files are corrupt or the database was not shut down cleanly after creating the data files.
2015-01-10 19:38:46 8380 [ERROR] Plugin 'InnoDB' init function returned error.
2015-01-10 19:38:46 8380 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-01-10 19:38:46 8380 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-01-10 19:38:46 8380 [ERROR] Aborting

2015-01-10 19:38:46 8380 [Note] Binlog end
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'partition'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_METRICS'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_CMP'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'INNODB_TRX'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'BLACKHOLE'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'ARCHIVE'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'MRG_MYISAM'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'MyISAM'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'MEMORY'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'CSV'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'sha256_password'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'mysql_old_password'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'mysql_native_password'
2015-01-10 19:38:46 8380 [Note] Shutting down plugin 'binlog'
2015-01-10 19:38:46 8380 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete



Danke schon mal. :D
by joomlanutzer
10. January 2015 19:43
 
Forum: XAMPP für Windows
Topic: Mysql startet und stoppt dann wieder
Replies: 0
Views: 252

MySQL don't start

Hi,

I recently update my xampp to the latest version, and, MySQL don't start. Here you can see the log error;
Code: Select all
2015-01-02 11:15:27 9184 [Note] Plugin 'FEDERATED' is disabled.
2015-01-02 11:15:27 2f9c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-01-02 11:15:27 9184 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-02 11:15:27 9184 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-02 11:15:27 9184 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-01-02 11:15:27 9184 [Note] InnoDB: Memory barrier is not used
2015-01-02 11:15:27 9184 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-02 11:15:27 9184 [Note] InnoDB: Not using CPU crc32 instructions
2015-01-02 11:15:27 9184 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-01-02 11:15:27 9184 [Note] InnoDB: Completed initialization of buffer pool
2015-01-02 11:15:27 9184 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-02 11:15:28 9184 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665264 in the ib_logfiles!
2015-01-02 11:15:28 9184 [Note] InnoDB: Database was not shutdown normally!
2015-01-02 11:15:28 9184 [Note] InnoDB: Starting crash recovery.
2015-01-02 11:15:28 9184 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-01-02 11:15:28 9184 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace cadeaux/carolyne uses space ID: 8 at filepath: .\cadeaux\carolyne.ibd. Cannot open tablespace phpmyadmin/pma_navigationhiding which uses space ID: 8 at filepath: .\phpmyadmin\pma_navigationhiding.ibd
InnoDB: Error: could not open single-table tablespace file .\phpmyadmin\pma_navigationhiding.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.


Note that I copy the
Code: Select all
C:\xampp_oldbkp\mysql\data
to
Code: Select all
C:\xampp\mysql\data
for duplicate the database. I think this is the error but i don't know how to do it because my oldmysql don't start (and my new too now). Tank you!
by felixinx
02. January 2015 17:23
 
Forum: XAMPP for Windows
Topic: MySQL don't start
Replies: 2
Views: 531

Re: Datenbank übertragen?

Hallo Peter,

Peter Blaumeier wrote:Empfiehlt es sich hier ein Backup über MySQL Dumper zu machen oder besser die Ordner der Datenbank kopieren?

Der empfohlene Weg ist es die zu übertragenden Datenbanken über mysqldump (das Kommandozeilentool welches schon mit MySQL ausgeliefert wird) zu exportieren und in der neuen Umgebung wieder zu importieren.
=> viewtopic.php?f=16&t=56104&p=220404&hilit=mysqldump#p220404 (englisch)

Peter Blaumeier wrote:Wenn die Wahl auf die Ordner fällt, welche soll man da kopieren oder reichen nur ein paar Dateien?

Es hängt ganz von dem Speichersubsystem ab, wie die Daten Dateitechnisch abgelegt werden. Bei MyISAM könnte es reichen, den Ordner im \mysql\data\ Ordner der betreffenden Datenbank zu kopieren. InnoDB kann schwierig bis unmöglich werden.
Aber wie gesagt, ich würde zu den Kommandozeilentools raten
by Altrea
30. December 2014 15:22
 
Forum: XAMPP für Windows
Topic: Datenbank übertragen?
Replies: 1
Views: 262

Re: Need help for MySQL

It appears that some other process already has port 3306, and MySQL does not find the port free for its use. See the below for a successful start-up.

*** Start of Log ***

2014-12-08 09:20:00 4268 [Note] Plugin 'FEDERATED' is disabled.
2014-12-08 09:20:00 1224 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-12-08 09:20:00 4268 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-12-08 09:20:00 4268 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-08 09:20:00 4268 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-12-08 09:20:00 4268 [Note] InnoDB: Memory barrier is not used
2014-12-08 09:20:00 4268 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-08 09:20:00 4268 [Note] InnoDB: Not using CPU crc32 instructions
2014-12-08 09:20:00 4268 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-12-08 09:20:00 4268 [Note] InnoDB: Completed initialization of buffer pool
2014-12-08 09:20:01 4268 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-08 09:20:01 4268 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 3119580 in the ib_logfiles!
2014-12-08 09:20:01 4268 [Note] InnoDB: Database was not shutdown normally!
2014-12-08 09:20:01 4268 [Note] InnoDB: Starting crash recovery.
2014-12-08 09:20:01 4268 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-12-08 09:20:02 4268 [Note] InnoDB: Restoring possible half-written data pages
2014-12-08 09:20:02 4268 [Note] InnoDB: from the doublewrite buffer...
2014-12-08 09:20:03 4268 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-08 09:20:03 4268 [Note] InnoDB: Waiting for purge to start
2014-12-08 09:20:03 4268 [Note] InnoDB: 5.6.21 started; log sequence number 3119580
2014-12-08 09:20:03 4268 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-08 09:20:03 4268 [Note] IPv6 is available.
2014-12-08 09:20:03 4268 [Note] - '::' resolves to '::';
2014-12-08 09:20:03 4268 [Note] Server socket created on IP: '::'.
2014-12-08 09:20:06 4268 [Note] Event Scheduler: Loaded 0 events
2014-12-08 09:20:06 4268 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.21' socket: '' port: 3306 MySQL Community Server (GPL)

*** End of log ***
by Harry Hobbes
08. December 2014 17:50
 
Forum: XAMPP for Windows
Topic: Need help for MySQL
Replies: 1
Views: 558

Need help for MySQL

Hi,
I downloaded xampp to my computer and I have a problem with starting mysql. Here is the log;

2014-12-08 07:47:17 4176 [Note] Plugin 'FEDERATED' is disabled.
2014-12-08 07:47:17 1054 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-12-08 07:47:17 4176 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-12-08 07:47:17 4176 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-08 07:47:17 4176 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-12-08 07:47:17 4176 [Note] InnoDB: Memory barrier is not used
2014-12-08 07:47:17 4176 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-08 07:47:17 4176 [Note] InnoDB: Not using CPU crc32 instructions
2014-12-08 07:47:17 4176 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-12-08 07:47:17 4176 [Note] InnoDB: Completed initialization of buffer pool
2014-12-08 07:47:17 4176 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-08 07:47:18 4176 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-08 07:47:18 4176 [Note] InnoDB: Waiting for purge to start
2014-12-08 07:47:18 4176 [Note] InnoDB: 5.6.21 started; log sequence number 1665234
2014-12-08 07:47:19 4176 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-08 07:47:19 4176 [Note] IPv6 is available.
2014-12-08 07:47:19 4176 [Note] - '::' resolves to '::';
2014-12-08 07:47:19 4176 [Note] Server socket created on IP: '::'.
2014-12-08 07:47:19 4176 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2014-12-08 07:47:19 4176 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-12-08 07:47:19 4176 [ERROR] Aborting

2014-12-08 07:47:19 4176 [Note] Binlog end
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'partition'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_METRICS'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_CMP'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'INNODB_TRX'
2014-12-08 07:47:19 4176 [Note] Shutting down plugin 'InnoDB'
2014-12-08 07:47:19 4176 [Note] InnoDB: FTS optimize thread exiting.
2014-12-08 07:47:19 4176 [Note] InnoDB: Starting shutdown...
2014-12-08 07:47:20 4176 [Note] InnoDB: Shutdown completed; log sequence number 1665244
2014-12-08 07:47:20 4176 [Note] Shutting down plugin 'BLACKHOLE'
2014-12-08 07:47:20 4176 [Note] Shutting down plugin 'ARCHIVE'
2014-12-08 07:47:20 4176 [Note] Shutting down plugin 'MRG_MYISAM'
2014-12-08 07:47:20 4176 [Note] Shutting down plugin 'MyISAM'
2014-12-08 07:47:20 4176 [Note] Shutting down plugin 'MEMORY'
2014-12-08 07:47:20 4176 [Note] Shutting down plugin 'CSV'
2014-12-08 07:47:20 4176 [Note] Shutting down plugin 'sha256_password'
2014-12-08 07:47:20 4176 [Note] Shutting down plugin 'mysql_old_password'
2014-12-08 07:47:20 4176 [Note] Shutting down plugin 'mysql_native_password'
2014-12-08 07:47:20 4176 [Note] Shutting down plugin 'binlog'
2014-12-08 07:47:20 4176 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-12-08 07:47:30 4308 [Note] Plugin 'FEDERATED' is disabled.
2014-12-08 07:47:30 10d8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-12-08 07:47:30 4308 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-12-08 07:47:30 4308 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-08 07:47:30 4308 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-12-08 07:47:30 4308 [Note] InnoDB: Memory barrier is not used
2014-12-08 07:47:30 4308 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-08 07:47:30 4308 [Note] InnoDB: Not using CPU crc32 instructions
2014-12-08 07:47:30 4308 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-12-08 07:47:30 4308 [Note] InnoDB: Completed initialization of buffer pool
2014-12-08 07:47:31 4308 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-08 07:47:31 4308 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-08 07:47:31 4308 [Note] InnoDB: Waiting for purge to start
2014-12-08 07:47:32 4308 [Note] InnoDB: 5.6.21 started; log sequence number 1665244
2014-12-08 07:47:32 4308 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-08 07:47:32 4308 [Note] IPv6 is available.
2014-12-08 07:47:32 4308 [Note] - '::' resolves to '::';
2014-12-08 07:47:32 4308 [Note] Server socket created on IP: '::'.
2014-12-08 07:47:32 4308 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2014-12-08 07:47:32 4308 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-12-08 07:47:32 4308 [ERROR] Aborting

2014-12-08 07:47:32 4308 [Note] Binlog end
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'partition'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_METRICS'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_CMP'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'INNODB_TRX'
2014-12-08 07:47:32 4308 [Note] Shutting down plugin 'InnoDB'
2014-12-08 07:47:32 4308 [Note] InnoDB: FTS optimize thread exiting.
2014-12-08 07:47:32 4308 [Note] InnoDB: Starting shutdown...
2014-12-08 07:47:33 4308 [Note] InnoDB: Shutdown completed; log sequence number 1665254
2014-12-08 07:47:33 4308 [Note] Shutting down plugin 'BLACKHOLE'
2014-12-08 07:47:33 4308 [Note] Shutting down plugin 'ARCHIVE'
2014-12-08 07:47:33 4308 [Note] Shutting down plugin 'MRG_MYISAM'
2014-12-08 07:47:33 4308 [Note] Shutting down plugin 'MyISAM'
2014-12-08 07:47:33 4308 [Note] Shutting down plugin 'MEMORY'
2014-12-08 07:47:33 4308 [Note] Shutting down plugin 'CSV'
2014-12-08 07:47:33 4308 [Note] Shutting down plugin 'sha256_password'
2014-12-08 07:47:33 4308 [Note] Shutting down plugin 'mysql_old_password'
2014-12-08 07:47:33 4308 [Note] Shutting down plugin 'mysql_native_password'
2014-12-08 07:47:33 4308 [Note] Shutting down plugin 'binlog'
2014-12-08 07:47:33 4308 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-12-08 07:47:35 4428 [Note] Plugin 'FEDERATED' is disabled.
2014-12-08 07:47:35 1150 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-12-08 07:47:35 4428 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-12-08 07:47:35 4428 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-08 07:47:35 4428 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-12-08 07:47:35 4428 [Note] InnoDB: Memory barrier is not used
2014-12-08 07:47:35 4428 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-08 07:47:35 4428 [Note] InnoDB: Not using CPU crc32 instructions
2014-12-08 07:47:35 4428 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-12-08 07:47:35 4428 [Note] InnoDB: Completed initialization of buffer pool
2014-12-08 07:47:35 4428 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-08 07:47:36 4428 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-08 07:47:36 4428 [Note] InnoDB: Waiting for purge to start
2014-12-08 07:47:36 4428 [Note] InnoDB: 5.6.21 started; log sequence number 1665254
2014-12-08 07:47:36 4428 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-08 07:47:36 4428 [Note] IPv6 is available.
2014-12-08 07:47:36 4428 [Note] - '::' resolves to '::';
2014-12-08 07:47:36 4428 [Note] Server socket created on IP: '::'.
2014-12-08 07:47:36 4428 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2014-12-08 07:47:36 4428 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-12-08 07:47:36 4428 [ERROR] Aborting

2014-12-08 07:47:36 4428 [Note] Binlog end
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'partition'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_METRICS'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_CMP'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'INNODB_TRX'
2014-12-08 07:47:36 4428 [Note] Shutting down plugin 'InnoDB'
2014-12-08 07:47:36 4428 [Note] InnoDB: FTS optimize thread exiting.
2014-12-08 07:47:36 4428 [Note] InnoDB: Starting shutdown...
2014-12-08 07:47:37 4428 [Note] InnoDB: Shutdown completed; log sequence number 1665264
2014-12-08 07:47:37 4428 [Note] Shutting down plugin 'BLACKHOLE'
2014-12-08 07:47:37 4428 [Note] Shutting down plugin 'ARCHIVE'
2014-12-08 07:47:37 4428 [Note] Shutting down plugin 'MRG_MYISAM'
2014-12-08 07:47:37 4428 [Note] Shutting down plugin 'MyISAM'
2014-12-08 07:47:37 4428 [Note] Shutting down plugin 'MEMORY'
2014-12-08 07:47:37 4428 [Note] Shutting down plugin 'CSV'
2014-12-08 07:47:37 4428 [Note] Shutting down plugin 'sha256_password'
2014-12-08 07:47:37 4428 [Note] Shutting down plugin 'mysql_old_password'
2014-12-08 07:47:37 4428 [Note] Shutting down plugin 'mysql_native_password'
2014-12-08 07:47:37 4428 [Note] Shutting down plugin 'binlog'
2014-12-08 07:47:37 4428 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-12-08 07:47:39 4544 [Note] Plugin 'FEDERATED' is disabled.
2014-12-08 07:47:39 11c4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-12-08 07:47:39 4544 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-12-08 07:47:39 4544 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-08 07:47:39 4544 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-12-08 07:47:39 4544 [Note] InnoDB: Memory barrier is not used
2014-12-08 07:47:39 4544 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-08 07:47:39 4544 [Note] InnoDB: Not using CPU crc32 instructions
2014-12-08 07:47:39 4544 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-12-08 07:47:39 4544 [Note] InnoDB: Completed initialization of buffer pool
2014-12-08 07:47:39 4544 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-08 07:47:40 4544 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-08 07:47:40 4544 [Note] InnoDB: Waiting for purge to start
2014-12-08 07:47:40 4544 [Note] InnoDB: 5.6.21 started; log sequence number 1665264
2014-12-08 07:47:40 4544 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-08 07:47:40 4544 [Note] IPv6 is available.
2014-12-08 07:47:40 4544 [Note] - '::' resolves to '::';
2014-12-08 07:47:40 4544 [Note] Server socket created on IP: '::'.
2014-12-08 07:47:40 4544 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2014-12-08 07:47:40 4544 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-12-08 07:47:40 4544 [ERROR] Aborting

2014-12-08 07:47:40 4544 [Note] Binlog end
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'partition'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_METRICS'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_CMP'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'INNODB_TRX'
2014-12-08 07:47:40 4544 [Note] Shutting down plugin 'InnoDB'
2014-12-08 07:47:40 4544 [Note] InnoDB: FTS optimize thread exiting.
2014-12-08 07:47:40 4544 [Note] InnoDB: Starting shutdown...
2014-12-08 07:47:41 4544 [Note] InnoDB: Shutdown completed; log sequence number 1665274
2014-12-08 07:47:41 4544 [Note] Shutting down plugin 'BLACKHOLE'
2014-12-08 07:47:41 4544 [Note] Shutting down plugin 'ARCHIVE'
2014-12-08 07:47:41 4544 [Note] Shutting down plugin 'MRG_MYISAM'
2014-12-08 07:47:41 4544 [Note] Shutting down plugin 'MyISAM'
2014-12-08 07:47:41 4544 [Note] Shutting down plugin 'MEMORY'
2014-12-08 07:47:41 4544 [Note] Shutting down plugin 'CSV'
2014-12-08 07:47:41 4544 [Note] Shutting down plugin 'sha256_password'
2014-12-08 07:47:41 4544 [Note] Shutting down plugin 'mysql_old_password'
2014-12-08 07:47:41 4544 [Note] Shutting down plugin 'mysql_native_password'
2014-12-08 07:47:41 4544 [Note] Shutting down plugin 'binlog'
2014-12-08 07:47:41 4544 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-12-08 07:47:46 4652 [Note] Plugin 'FEDERATED' is disabled.
2014-12-08 07:47:46 1230 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-12-08 07:47:46 4652 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-12-08 07:47:46 4652 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-08 07:47:46 4652 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-12-08 07:47:46 4652 [Note] InnoDB: Memory barrier is not used
2014-12-08 07:47:46 4652 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-08 07:47:46 4652 [Note] InnoDB: Not using CPU crc32 instructions
2014-12-08 07:47:46 4652 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-12-08 07:47:46 4652 [Note] InnoDB: Completed initialization of buffer pool
2014-12-08 07:47:46 4652 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-08 07:47:47 4652 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-08 07:47:47 4652 [Note] InnoDB: Waiting for purge to start
2014-12-08 07:47:47 4652 [Note] InnoDB: 5.6.21 started; log sequence number 1665274
2014-12-08 07:47:47 4652 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-08 07:47:47 4652 [Note] IPv6 is available.
2014-12-08 07:47:47 4652 [Note] - '::' resolves to '::';
2014-12-08 07:47:47 4652 [Note] Server socket created on IP: '::'.
2014-12-08 07:47:47 4652 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2014-12-08 07:47:47 4652 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-12-08 07:47:47 4652 [ERROR] Aborting

2014-12-08 07:47:47 4652 [Note] Binlog end
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'partition'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_METRICS'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_CMP'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'INNODB_TRX'
2014-12-08 07:47:47 4652 [Note] Shutting down plugin 'InnoDB'
2014-12-08 07:47:47 4652 [Note] InnoDB: FTS optimize thread exiting.
2014-12-08 07:47:47 4652 [Note] InnoDB: Starting shutdown...
2014-12-08 07:47:48 4652 [Note] InnoDB: Shutdown completed; log sequence number 1665284
2014-12-08 07:47:48 4652 [Note] Shutting down plugin 'BLACKHOLE'
2014-12-08 07:47:48 4652 [Note] Shutting down plugin 'ARCHIVE'
2014-12-08 07:47:48 4652 [Note] Shutting down plugin 'MRG_MYISAM'
2014-12-08 07:47:48 4652 [Note] Shutting down plugin 'MyISAM'
2014-12-08 07:47:48 4652 [Note] Shutting down plugin 'MEMORY'
2014-12-08 07:47:48 4652 [Note] Shutting down plugin 'CSV'
2014-12-08 07:47:48 4652 [Note] Shutting down plugin 'sha256_password'
2014-12-08 07:47:48 4652 [Note] Shutting down plugin 'mysql_old_password'
2014-12-08 07:47:48 4652 [Note] Shutting down plugin 'mysql_native_password'
2014-12-08 07:47:48 4652 [Note] Shutting down plugin 'binlog'
2014-12-08 07:47:48 4652 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-12-08 07:47:51 4764 [Note] Plugin 'FEDERATED' is disabled.
2014-12-08 07:47:51 12a0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-12-08 07:47:51 4764 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-12-08 07:47:51 4764 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-08 07:47:51 4764 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-12-08 07:47:51 4764 [Note] InnoDB: Memory barrier is not used
2014-12-08 07:47:51 4764 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-08 07:47:51 4764 [Note] InnoDB: Not using CPU crc32 instructions
2014-12-08 07:47:51 4764 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-12-08 07:47:51 4764 [Note] InnoDB: Completed initialization of buffer pool
2014-12-08 07:47:51 4764 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-08 07:47:52 4764 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-08 07:47:52 4764 [Note] InnoDB: Waiting for purge to start
2014-12-08 07:47:52 4764 [Note] InnoDB: 5.6.21 started; log sequence number 1665284
2014-12-08 07:47:52 4764 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-08 07:47:52 4764 [Note] IPv6 is available.
2014-12-08 07:47:52 4764 [Note] - '::' resolves to '::';
2014-12-08 07:47:52 4764 [Note] Server socket created on IP: '::'.
2014-12-08 07:47:52 4764 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2014-12-08 07:47:52 4764 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-12-08 07:47:52 4764 [ERROR] Aborting

2014-12-08 07:47:52 4764 [Note] Binlog end
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'partition'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_METRICS'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_CMP'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'INNODB_TRX'
2014-12-08 07:47:52 4764 [Note] Shutting down plugin 'InnoDB'
2014-12-08 07:47:52 4764 [Note] InnoDB: FTS optimize thread exiting.
2014-12-08 07:47:52 4764 [Note] InnoDB: Starting shutdown...
2014-12-08 07:47:53 4764 [Note] InnoDB: Shutdown completed; log sequence number 1665294
2014-12-08 07:47:53 4764 [Note] Shutting down plugin 'BLACKHOLE'
2014-12-08 07:47:53 4764 [Note] Shutting down plugin 'ARCHIVE'
2014-12-08 07:47:53 4764 [Note] Shutting down plugin 'MRG_MYISAM'
2014-12-08 07:47:53 4764 [Note] Shutting down plugin 'MyISAM'
2014-12-08 07:47:53 4764 [Note] Shutting down plugin 'MEMORY'
2014-12-08 07:47:53 4764 [Note] Shutting down plugin 'CSV'
2014-12-08 07:47:53 4764 [Note] Shutting down plugin 'sha256_password'
2014-12-08 07:47:53 4764 [Note] Shutting down plugin 'mysql_old_password'
2014-12-08 07:47:53 4764 [Note] Shutting down plugin 'mysql_native_password'
2014-12-08 07:47:53 4764 [Note] Shutting down plugin 'binlog'
2014-12-08 07:47:53 4764 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-12-08 07:48:00 4884 [Note] Plugin 'FEDERATED' is disabled.
2014-12-08 07:48:00 1318 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-12-08 07:48:00 4884 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-12-08 07:48:00 4884 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-08 07:48:00 4884 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-12-08 07:48:00 4884 [Note] InnoDB: Memory barrier is not used
2014-12-08 07:48:00 4884 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-08 07:48:00 4884 [Note] InnoDB: Not using CPU crc32 instructions
2014-12-08 07:48:00 4884 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-12-08 07:48:00 4884 [Note] InnoDB: Completed initialization of buffer pool
2014-12-08 07:48:01 4884 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-08 07:48:01 4884 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-08 07:48:01 4884 [Note] InnoDB: Waiting for purge to start
2014-12-08 07:48:01 4884 [Note] InnoDB: 5.6.21 started; log sequence number 1665294
2014-12-08 07:48:01 4884 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-08 07:48:01 4884 [Note] IPv6 is available.
2014-12-08 07:48:01 4884 [Note] - '::' resolves to '::';
2014-12-08 07:48:01 4884 [Note] Server socket created on IP: '::'.
2014-12-08 07:48:01 4884 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2014-12-08 07:48:01 4884 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-12-08 07:48:01 4884 [ERROR] Aborting

2014-12-08 07:48:01 4884 [Note] Binlog end
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'partition'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_METRICS'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_CMP'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'INNODB_TRX'
2014-12-08 07:48:01 4884 [Note] Shutting down plugin 'InnoDB'
2014-12-08 07:48:01 4884 [Note] InnoDB: FTS optimize thread exiting.
2014-12-08 07:48:01 4884 [Note] InnoDB: Starting shutdown...
2014-12-08 07:48:03 4884 [Note] InnoDB: Shutdown completed; log sequence number 1665304
2014-12-08 07:48:03 4884 [Note] Shutting down plugin 'BLACKHOLE'
2014-12-08 07:48:03 4884 [Note] Shutting down plugin 'ARCHIVE'
2014-12-08 07:48:03 4884 [Note] Shutting down plugin 'MRG_MYISAM'
2014-12-08 07:48:03 4884 [Note] Shutting down plugin 'MyISAM'
2014-12-08 07:48:03 4884 [Note] Shutting down plugin 'MEMORY'
2014-12-08 07:48:03 4884 [Note] Shutting down plugin 'CSV'
2014-12-08 07:48:03 4884 [Note] Shutting down plugin 'sha256_password'
2014-12-08 07:48:03 4884 [Note] Shutting down plugin 'mysql_old_password'
2014-12-08 07:48:03 4884 [Note] Shutting down plugin 'mysql_native_password'
2014-12-08 07:48:03 4884 [Note] Shutting down plugin 'binlog'
2014-12-08 07:48:03 4884 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-12-08 07:48:06 4996 [Note] Plugin 'FEDERATED' is disabled.
2014-12-08 07:48:06 1388 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-12-08 07:48:06 4996 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-12-08 07:48:06 4996 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-08 07:48:06 4996 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-12-08 07:48:06 4996 [Note] InnoDB: Memory barrier is not used
2014-12-08 07:48:06 4996 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-08 07:48:06 4996 [Note] InnoDB: Not using CPU crc32 instructions
2014-12-08 07:48:06 4996 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-12-08 07:48:06 4996 [Note] InnoDB: Completed initialization of buffer pool
2014-12-08 07:48:06 4996 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-08 07:48:07 4996 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-08 07:48:07 4996 [Note] InnoDB: Waiting for purge to start
2014-12-08 07:48:07 4996 [Note] InnoDB: 5.6.21 started; log sequence number 1665304
2014-12-08 07:48:07 4996 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-08 07:48:07 4996 [Note] IPv6 is available.
2014-12-08 07:48:07 4996 [Note] - '::' resolves to '::';
2014-12-08 07:48:07 4996 [Note] Server socket created on IP: '::'.
2014-12-08 07:48:07 4996 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2014-12-08 07:48:07 4996 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-12-08 07:48:07 4996 [ERROR] Aborting

2014-12-08 07:48:07 4996 [Note] Binlog end
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'partition'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_METRICS'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_CMP'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'INNODB_TRX'
2014-12-08 07:48:07 4996 [Note] Shutting down plugin 'InnoDB'
2014-12-08 07:48:07 4996 [Note] InnoDB: FTS optimize thread exiting.
2014-12-08 07:48:07 4996 [Note] InnoDB: Starting shutdown...
2014-12-08 07:48:08 4996 [Note] InnoDB: Shutdown completed; log sequence number 1665314
2014-12-08 07:48:08 4996 [Note] Shutting down plugin 'BLACKHOLE'
2014-12-08 07:48:08 4996 [Note] Shutting down plugin 'ARCHIVE'
2014-12-08 07:48:08 4996 [Note] Shutting down plugin 'MRG_MYISAM'
2014-12-08 07:48:08 4996 [Note] Shutting down plugin 'MyISAM'
2014-12-08 07:48:08 4996 [Note] Shutting down plugin 'MEMORY'
2014-12-08 07:48:08 4996 [Note] Shutting down plugin 'CSV'
2014-12-08 07:48:08 4996 [Note] Shutting down plugin 'sha256_password'
2014-12-08 07:48:08 4996 [Note] Shutting down plugin 'mysql_old_password'
2014-12-08 07:48:08 4996 [Note] Shutting down plugin 'mysql_native_password'
2014-12-08 07:48:08 4996 [Note] Shutting down plugin 'binlog'
2014-12-08 07:48:08 4996 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-12-08 07:48:18 5128 [Note] Plugin 'FEDERATED' is disabled.
2014-12-08 07:48:18 140c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-12-08 07:48:18 5128 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-12-08 07:48:18 5128 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-08 07:48:18 5128 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-12-08 07:48:18 5128 [Note] InnoDB: Memory barrier is not used
2014-12-08 07:48:18 5128 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-08 07:48:18 5128 [Note] InnoDB: Not using CPU crc32 instructions
2014-12-08 07:48:18 5128 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-12-08 07:48:18 5128 [Note] InnoDB: Completed initialization of buffer pool
2014-12-08 07:48:19 5128 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-08 07:48:20 5128 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-08 07:48:20 5128 [Note] InnoDB: Waiting for purge to start
2014-12-08 07:48:20 5128 [Note] InnoDB: 5.6.21 started; log sequence number 1665314
2014-12-08 07:48:20 5128 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-08 07:48:20 5128 [Note] IPv6 is available.
2014-12-08 07:48:20 5128 [Note] - '::' resolves to '::';
2014-12-08 07:48:20 5128 [Note] Server socket created on IP: '::'.
2014-12-08 07:48:20 5128 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2014-12-08 07:48:20 5128 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-12-08 07:48:20 5128 [ERROR] Aborting

2014-12-08 07:48:20 5128 [Note] Binlog end
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'partition'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_METRICS'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_CMP'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'INNODB_TRX'
2014-12-08 07:48:20 5128 [Note] Shutting down plugin 'InnoDB'
2014-12-08 07:48:20 5128 [Note] InnoDB: FTS optimize thread exiting.
2014-12-08 07:48:20 5128 [Note] InnoDB: Starting shutdown...
2014-12-08 07:48:21 5128 [Note] InnoDB: Shutdown completed; log sequence number 1665324
2014-12-08 07:48:21 5128 [Note] Shutting down plugin 'BLACKHOLE'
2014-12-08 07:48:21 5128 [Note] Shutting down plugin 'ARCHIVE'
2014-12-08 07:48:21 5128 [Note] Shutting down plugin 'MRG_MYISAM'
2014-12-08 07:48:21 5128 [Note] Shutting down plugin 'MyISAM'
2014-12-08 07:48:21 5128 [Note] Shutting down plugin 'MEMORY'
2014-12-08 07:48:21 5128 [Note] Shutting down plugin 'CSV'
2014-12-08 07:48:21 5128 [Note] Shutting down plugin 'sha256_password'
2014-12-08 07:48:21 5128 [Note] Shutting down plugin 'mysql_old_password'
2014-12-08 07:48:21 5128 [Note] Shutting down plugin 'mysql_native_password'
2014-12-08 07:48:21 5128 [Note] Shutting down plugin 'binlog'
2014-12-08 07:48:21 5128 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Could you please help with this issue.

Thank you,
by cevad
08. December 2014 14:58
 
Forum: XAMPP for Windows
Topic: Need help for MySQL
Replies: 1
Views: 558

Re: MySQL (xampp) not working.

Guys, I am not sure what this means.

2014-11-29 12:46:35 5100 [Note] Plugin 'FEDERATED' is disabled.
2014-11-29 12:46:35 17fc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-11-29 12:46:35 5100 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-29 12:46:35 5100 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-29 12:46:35 5100 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-29 12:46:35 5100 [Note] InnoDB: Memory barrier is not used
2014-11-29 12:46:35 5100 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-29 12:46:35 5100 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-29 12:46:35 5100 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-11-29 12:46:35 5100 [Note] InnoDB: Completed initialization of buffer pool
2014-11-29 12:46:35 5100 [Note] InnoDB: Highest supported file format is Barracuda.
2014-11-29 12:46:36 5100 [Note] InnoDB: 128 rollback segment(s) are active.
2014-11-29 12:46:37 5100 [Note] InnoDB: Waiting for purge to start
2014-11-29 12:46:37 5100 [Note] InnoDB: 5.6.21 started; log sequence number 1665234
2014-11-29 12:46:37 5100 [Note] Server hostname (bind-address): '*'; port: 3306
2014-11-29 12:46:37 5100 [Note] IPv6 is available.
2014-11-29 12:46:37 5100 [Note] - '::' resolves to '::';
2014-11-29 12:46:37 5100 [Note] Server socket created on IP: '::'.
2014-11-29 12:46:37 5100 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2014-11-29 12:46:37 5100 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2014-11-29 12:46:37 5100 [ERROR] Aborting
by 1bava
29. November 2014 16:28
 
Forum: XAMPP for Windows
Topic: MySQL (xampp) not working.
Replies: 2
Views: 1337

Mysqld.exe has stopped working in Xampp

I have Windows server 2008 R2 (VMware) and using Xampp control panel V3.2.1. For some reason mysqld.exe keeps stopping whenever we try to create the database.
Following are mysql log files:


2014-11-14 06:32:54 1680 [Note] Plugin 'FEDERATED' is disabled.
2014-11-14 06:32:54 470 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-11-14 06:32:54 1680 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-14 06:32:54 1680 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-14 06:32:54 1680 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-14 06:32:54 1680 [Note] InnoDB: Memory barrier is not used
2014-11-14 06:32:54 1680 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-14 06:32:54 1680 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-14 06:32:54 1680 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-11-14 06:32:54 1680 [Note] InnoDB: Completed initialization of buffer pool
2014-11-14 06:32:54 1680 [Note] InnoDB: Highest supported file format is Barracuda.
2014-11-14 06:32:54 1680 [Note] InnoDB: 128 rollback segment(s) are active.
2014-11-14 06:32:54 1680 [Note] InnoDB: Waiting for purge to start
2014-11-14 06:32:54 1680 [Note] InnoDB: 5.6.20 started; log sequence number 1665234
2014-11-14 06:32:54 1680 [Note] Server hostname (bind-address): '*'; port: 3306
2014-11-14 06:32:54 1680 [Note] IPv6 is available.
2014-11-14 06:32:54 1680 [Note] - '::' resolves to '::';
2014-11-14 06:32:54 1680 [Note] Server socket created on IP: '::'.
2014-11-14 06:32:55 1680 [Note] Event Scheduler: Loaded 0 events
2014-11-14 06:32:55 1680 [Note] e:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.20' socket: '' port: 3306 MySQL Community Server (GPL)
14:40:21 UTC - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=2
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133778 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x1b3fcdb8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
e49ec2 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
e4aacc mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
e4cf50 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
e4d3be mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
ed7d62 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
e40575 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
bbcdb1 mysqld.exe!?ha_create@handler@@QAEHPBDPAUTABLE@@PAUst_ha_create_information@@@Z()
bc150d mysqld.exe!?ha_create_table@@YAHPAVTHD@@PBD11PAUst_ha_create_information@@_N3@Z()
c9e608 mysqld.exe!?mysql_alter_table@@YA_NPAVTHD@@PAD1PAUst_ha_create_information@@PAUTABLE_LIST@@PAVAlter_info@@IPAUst_order@@_N@Z()
d305ea mysqld.exe!?execute@Sql_cmd_alter_table@@UAE_NPAVTHD@@@Z()
bef1ad mysqld.exe!?mysql_execute_command@@YAHPAVTHD@@@Z()
bef81e mysqld.exe!?mysql_parse@@YAXPAVTHD@@PADIPAVParser_state@@@Z()
bf04e7 mysqld.exe!?dispatch_command@@YA_NW4enum_server_command@@PAVTHD@@PADI@Z()
bf135a mysqld.exe!?do_command@@YA_NPAVTHD@@@Z()
c64e59 mysqld.exe!?do_handle_one_connection@@YAXPAVTHD@@@Z()
c64efd mysqld.exe!handle_one_connection()
fbb8cb mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
e10336 mysqld.exe!win_pthread_mutex_trylock()
1046c00 mysqld.exe!my_mb_ctype_mb()
1046c8a mysqld.exe!my_mb_ctype_mb()
75f2338a kernel32.dll!BaseThreadInitThunk()
77cb9f72 ntdll.dll!RtlInitializeExceptionChain()
77cb9f45 ntdll.dll!RtlInitializeExceptionChain()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (1b4cbc80): alter table ohrm_leave_comment
add constraint foreign key (created_by_emp_number)
references hs_hr_employee(emp_number) on delete cascadeConnection ID (thread ID): 8
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2014-11-14 06:41:14 3228 [Note] Plugin 'FEDERATED' is disabled.
2014-11-14 06:41:14 7f4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-11-14 06:41:14 3228 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-14 06:41:14 3228 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-14 06:41:14 3228 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-14 06:41:14 3228 [Note] InnoDB: Memory barrier is not used
2014-11-14 06:41:14 3228 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-14 06:41:14 3228 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-14 06:41:14 3228 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-11-14 06:41:14 3228 [Note] InnoDB: Completed initialization of buffer pool
2014-11-14 06:41:14 3228 [Note] InnoDB: Highest supported file format is Barracuda.
2014-11-14 06:41:14 3228 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2327450
2014-11-14 06:41:14 3228 [Note] InnoDB: Database was not shutdown normally!
2014-11-14 06:41:14 3228 [Note] InnoDB: Starting crash recovery.
2014-11-14 06:41:14 3228 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-11-14 06:41:14 3228 [Note] InnoDB: Restoring possible half-written data pages
2014-11-14 06:41:14 3228 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 3189600
2014-11-14 06:41:15 3228 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
2014-11-14 06:41:16 3228 [Note] InnoDB: 128 rollback segment(s) are active.
2014-11-14 06:41:16 3228 [Note] InnoDB: Waiting for purge to start
2014-11-14 06:41:16 3228 [Note] InnoDB: 5.6.20 started; log sequence number 3189600
2014-11-14 06:41:16 3228 [Note] Server hostname (bind-address): '*'; port: 3306
2014-11-14 06:41:16 3228 [Note] IPv6 is available.
2014-11-14 06:41:16 3228 [Note] - '::' resolves to '::';
2014-11-14 06:41:16 3228 [Note] Server socket created on IP: '::'.
2014-11-14 06:41:17 3228 [Note] Event Scheduler: Loaded 0 events
2014-11-14 06:41:17 3228 [Note] e:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.20' socket: '' port: 3306 MySQL Community Server (GPL)
2014-11-14 06:42:22 d2c InnoDB: Assertion failure in thread 3372 in file dict0dict.cc line 283
InnoDB: Failing assertion: s
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
14:42:22 UTC - mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=1
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133778 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x1b4cf958
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
145a500 mysqld.exe!my_thread_name()
169392d mysqld.exe!my_mb_ctype_mb()
1490fd7 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
14917e3 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
12ed4bb mysqld.exe!?mysql_prepare_alter_table@@YA_NPAVTHD@@PAUTABLE@@PAUst_ha_create_information@@PAVAlter_info@@PAVAlter_table_ctx@@@Z()
12ee514 mysqld.exe!?mysql_alter_table@@YA_NPAVTHD@@PAD1PAUst_ha_create_information@@PAUTABLE_LIST@@PAVAlter_info@@IPAUst_order@@_N@Z()
13805ea mysqld.exe!?execute@Sql_cmd_alter_table@@UAE_NPAVTHD@@@Z()
123f1ad mysqld.exe!?mysql_execute_command@@YAHPAVTHD@@@Z()
123f81e mysqld.exe!?mysql_parse@@YAXPAVTHD@@PADIPAVParser_state@@@Z()
12404e7 mysqld.exe!?dispatch_command@@YA_NW4enum_server_command@@PAVTHD@@PADI@Z()
124135a mysqld.exe!?do_command@@YA_NPAVTHD@@@Z()
12b4e59 mysqld.exe!?do_handle_one_connection@@YAXPAVTHD@@@Z()
12b4efd mysqld.exe!handle_one_connection()
160b8cb mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
1460336 mysqld.exe!win_pthread_mutex_trylock()
1696c00 mysqld.exe!my_mb_ctype_mb()
1696c8a mysqld.exe!my_mb_ctype_mb()
75f2338a kernel32.dll!BaseThreadInitThunk()
77cb9f72 ntdll.dll!RtlInitializeExceptionChain()
77cb9f45 ntdll.dll!RtlInitializeExceptionChain()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (21095050): alter table ohrm_job_candidate
add constraint foreign key (added_person)
references hs_hr_employee(emp_number) on delete set nullConnection ID (thread ID): 4
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2014-11-14 06:49:16 2532 [Note] Plugin 'FEDERATED' is disabled.
2014-11-14 06:49:16 9e8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-11-14 06:49:16 2532 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-14 06:49:16 2532 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-14 06:49:16 2532 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-14 06:49:16 2532 [Note] InnoDB: Memory barrier is not used
2014-11-14 06:49:16 2532 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-14 06:49:16 2532 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-14 06:49:16 2532 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-11-14 06:49:16 2532 [Note] InnoDB: Completed initialization of buffer pool
2014-11-14 06:49:16 2532 [Note] InnoDB: Highest supported file format is Barracuda.
2014-11-14 06:49:16 2532 [Note] InnoDB: Log scan progressed past the checkpoint lsn 6982361
2014-11-14 06:49:16 2532 [Note] InnoDB: Database was not shutdown normally!
2014-11-14 06:49:16 2532 [Note] InnoDB: Starting crash recovery.
2014-11-14 06:49:16 2532 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-11-14 06:49:17 2532 [Note] InnoDB: Restoring possible half-written data pages
2014-11-14 06:49:17 2532 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 7272884
2014-11-14 06:49:19 2532 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
2014-11-14 06:49:21 2532 [Note] InnoDB: 128 rollback segment(s) are active.
2014-11-14 06:49:21 2532 [Note] InnoDB: Waiting for purge to start
2014-11-14 06:49:21 2532 [Note] InnoDB: 5.6.20 started; log sequence number 7272884
2014-11-14 06:49:21 2532 [Note] Server hostname (bind-address): '*'; port: 3306
2014-11-14 06:49:21 2532 [Note] IPv6 is available.
2014-11-14 06:49:21 2532 [Note] - '::' resolves to '::';
2014-11-14 06:49:21 2532 [Note] Server socket created on IP: '::'.
2014-11-14 06:49:22 2532 [Note] Event Scheduler: Loaded 0 events
2014-11-14 06:49:22 2532 [Note] e:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.20' socket: '' port: 3306 MySQL Community Server (GPL)
14:52:10 UTC - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=1
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133778 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x21284090
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
1019ec2 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
101aacc mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
101cf50 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
101d3be mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
10a7d62 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
1010575 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
d8cdb1 mysqld.exe!?ha_create@handler@@QAEHPBDPAUTABLE@@PAUst_ha_create_information@@@Z()
d9150d mysqld.exe!?ha_create_table@@YAHPAVTHD@@PBD11PAUst_ha_create_information@@_N3@Z()
e6e608 mysqld.exe!?mysql_alter_table@@YA_NPAVTHD@@PAD1PAUst_ha_create_information@@PAUTABLE_LIST@@PAVAlter_info@@IPAUst_order@@_N@Z()
f005ea mysqld.exe!?execute@Sql_cmd_alter_table@@UAE_NPAVTHD@@@Z()
dbf1ad mysqld.exe!?mysql_execute_command@@YAHPAVTHD@@@Z()
dbf81e mysqld.exe!?mysql_parse@@YAXPAVTHD@@PADIPAVParser_state@@@Z()
dc04e7 mysqld.exe!?dispatch_command@@YA_NW4enum_server_command@@PAVTHD@@PADI@Z()
dc135a mysqld.exe!?do_command@@YA_NPAVTHD@@@Z()
e34e59 mysqld.exe!?do_handle_one_connection@@YAXPAVTHD@@@Z()
e34efd mysqld.exe!handle_one_connection()
118b8cb mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
fe0336 mysqld.exe!win_pthread_mutex_trylock()
1216c00 mysqld.exe!my_mb_ctype_mb()
1216c8a mysqld.exe!my_mb_ctype_mb()
7775338a kernel32.dll!BaseThreadInitThunk()
77c89f72 ntdll.dll!RtlInitializeExceptionChain()
77c89f45 ntdll.dll!RtlInitializeExceptionChain()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (213515d0): alter table ohrm_timesheet_action_log
add constraint foreign key (performed_by)
references ohrm_user(id) on delete cascadeConnection ID (thread ID): 4
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2014-11-14 06:52:55 3952 [Note] Plugin 'FEDERATED' is disabled.
2014-11-14 06:52:55 f74 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-11-14 06:52:55 3952 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-14 06:52:55 3952 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-14 06:52:55 3952 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-14 06:52:55 3952 [Note] InnoDB: Memory barrier is not used
2014-11-14 06:52:55 3952 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-14 06:52:55 3952 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-14 06:52:55 3952 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-11-14 06:52:55 3952 [Note] InnoDB: Completed initialization of buffer pool
2014-11-14 06:52:55 3952 [Note] InnoDB: Highest supported file format is Barracuda.
2014-11-14 06:52:55 3952 [Note] InnoDB: Log scan progressed past the checkpoint lsn 9678450
2014-11-14 06:52:55 3952 [Note] InnoDB: Database was not shutdown normally!
2014-11-14 06:52:55 3952 [Note] InnoDB: Starting crash recovery.
2014-11-14 06:52:55 3952 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-11-14 06:52:56 3952 [Note] InnoDB: Restoring possible half-written data pages
2014-11-14 06:52:56 3952 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 9974664
2014-11-14 06:52:57 3952 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
2014-11-14 06:52:57 3952 [Note] InnoDB: 128 rollback segment(s) are active.
2014-11-14 06:52:57 3952 [Note] InnoDB: Waiting for purge to start
2014-11-14 06:52:57 3952 [Note] InnoDB: 5.6.20 started; log sequence number 9974664
2014-11-14 06:52:57 3952 [Note] Server hostname (bind-address): '*'; port: 3306
2014-11-14 06:52:57 3952 [Note] IPv6 is available.
2014-11-14 06:52:57 3952 [Note] - '::' resolves to '::';
2014-11-14 06:52:57 3952 [Note] Server socket created on IP: '::'.
2014-11-14 06:52:58 3952 [Note] Event Scheduler: Loaded 0 events
2014-11-14 06:52:58 3952 [Note] e:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.20' socket: '' port: 3306 MySQL Community Server (GPL)
14:53:51 UTC - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=1
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133778 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x1b364f10
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
14b9ec2 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
14baacc mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
14bcf50 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
14bd3be mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
1547d62 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
14b0575 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
122cdb1 mysqld.exe!?ha_create@handler@@QAEHPBDPAUTABLE@@PAUst_ha_create_information@@@Z()
123150d mysqld.exe!?ha_create_table@@YAHPAVTHD@@PBD11PAUst_ha_create_information@@_N3@Z()
130e608 mysqld.exe!?mysql_alter_table@@YA_NPAVTHD@@PAD1PAUst_ha_create_information@@PAUTABLE_LIST@@PAVAlter_info@@IPAUst_order@@_N@Z()
13a05ea mysqld.exe!?execute@Sql_cmd_alter_table@@UAE_NPAVTHD@@@Z()
125f1ad mysqld.exe!?mysql_execute_command@@YAHPAVTHD@@@Z()
125f81e mysqld.exe!?mysql_parse@@YAXPAVTHD@@PADIPAVParser_state@@@Z()
12604e7 mysqld.exe!?dispatch_command@@YA_NW4enum_server_command@@PAVTHD@@PADI@Z()
126135a mysqld.exe!?do_command@@YA_NPAVTHD@@@Z()
12d4e59 mysqld.exe!?do_handle_one_connection@@YAXPAVTHD@@@Z()
12d4efd mysqld.exe!handle_one_connection()
162b8cb mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
1480336 mysqld.exe!win_pthread_mutex_trylock()
16b6c00 mysqld.exe!my_mb_ctype_mb()
16b6c8a mysqld.exe!my_mb_ctype_mb()
7775338a kernel32.dll!BaseThreadInitThunk()
77c89f72 ntdll.dll!RtlInitializeExceptionChain()
77c89f45 ntdll.dll!RtlInitializeExceptionChain()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (1b3e47e8): alter table ohrm_leave_comment
add constraint foreign key (created_by_emp_number)
references hs_hr_employee(emp_number) on delete cascadeConnection ID (thread ID): 5
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2014-11-14 06:57:16 1348 [Note] Plugin 'FEDERATED' is disabled.
2014-11-14 06:57:16 98c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-11-14 06:57:16 1348 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-14 06:57:16 1348 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-14 06:57:16 1348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-14 06:57:16 1348 [Note] InnoDB: Memory barrier is not used
2014-11-14 06:57:16 1348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-14 06:57:16 1348 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-14 06:57:16 1348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-11-14 06:57:16 1348 [Note] InnoDB: Completed initialization of buffer pool
2014-11-14 06:57:16 1348 [Note] InnoDB: Highest supported file format is Barracuda.
2014-11-14 06:57:16 1348 [Note] InnoDB: Log scan progressed past the checkpoint lsn 11907579
2014-11-14 06:57:16 1348 [Note] InnoDB: Database was not shutdown normally!
2014-11-14 06:57:16 1348 [Note] InnoDB: Starting crash recovery.
2014-11-14 06:57:16 1348 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-11-14 06:57:17 1348 [Note] InnoDB: Restoring possible half-written data pages
2014-11-14 06:57:17 1348 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 12353565
2014-11-14 06:57:19 1348 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
2014-11-14 06:57:19 1348 [Note] InnoDB: 128 rollback segment(s) are active.
2014-11-14 06:57:19 1348 [Note] InnoDB: Waiting for purge to start
2014-11-14 06:57:19 1348 [Note] InnoDB: 5.6.20 started; log sequence number 12353565
2014-11-14 06:57:19 1348 [Note] Server hostname (bind-address): '*'; port: 3306
2014-11-14 06:57:19 1348 [Note] IPv6 is available.
2014-11-14 06:57:19 1348 [Note] - '::' resolves to '::';
2014-11-14 06:57:19 1348 [Note] Server socket created on IP: '::'.
2014-11-14 06:57:20 1348 [Note] Event Scheduler: Loaded 0 events
2014-11-14 06:57:20 1348 [Note] e:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.20' socket: '' port: 3306 MySQL Community Server (GPL)
14:57:52 UTC - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=1
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133778 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x1b36bbd8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
13d9ec2 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
13daacc mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
13dcf50 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
13dd3be mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
1467d62 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
13d0575 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
114cdb1 mysqld.exe!?ha_create@handler@@QAEHPBDPAUTABLE@@PAUst_ha_create_information@@@Z()
115150d mysqld.exe!?ha_create_table@@YAHPAVTHD@@PBD11PAUst_ha_create_information@@_N3@Z()
122e608 mysqld.exe!?mysql_alter_table@@YA_NPAVTHD@@PAD1PAUst_ha_create_information@@PAUTABLE_LIST@@PAVAlter_info@@IPAUst_order@@_N@Z()
12c05ea mysqld.exe!?execute@Sql_cmd_alter_table@@UAE_NPAVTHD@@@Z()
117f1ad mysqld.exe!?mysql_execute_command@@YAHPAVTHD@@@Z()
117f81e mysqld.exe!?mysql_parse@@YAXPAVTHD@@PADIPAVParser_state@@@Z()
11804e7 mysqld.exe!?dispatch_command@@YA_NW4enum_server_command@@PAVTHD@@PADI@Z()
118135a mysqld.exe!?do_command@@YA_NPAVTHD@@@Z()
11f4e59 mysqld.exe!?do_handle_one_connection@@YAXPAVTHD@@@Z()
11f4efd mysqld.exe!handle_one_connection()
154b8cb mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
13a0336 mysqld.exe!win_pthread_mutex_trylock()
15d6c00 mysqld.exe!my_mb_ctype_mb()
15d6c8a mysqld.exe!my_mb_ctype_mb()
7775338a kernel32.dll!BaseThreadInitThunk()
77c89f72 ntdll.dll!RtlInitializeExceptionChain()
77c89f45 ntdll.dll!RtlInitializeExceptionChain()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (1b3dfa38): alter table ohrm_leave_comment
add constraint foreign key (created_by_emp_number)
references hs_hr_employee(emp_number) on delete cascadeConnection ID (thread ID): 3
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2014-11-14 07:20:10 2512 [Note] Plugin 'FEDERATED' is disabled.
2014-11-14 07:20:10 370 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-11-14 07:20:10 2512 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-14 07:20:10 2512 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-14 07:20:10 2512 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-14 07:20:10 2512 [Note] InnoDB: Memory barrier is not used
2014-11-14 07:20:10 2512 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-14 07:20:10 2512 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-14 07:20:10 2512 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-11-14 07:20:10 2512 [Note] InnoDB: Completed initialization of buffer pool
2014-11-14 07:20:10 2512 [Note] InnoDB: Highest supported file format is Barracuda.
2014-11-14 07:20:10 2512 [Note] InnoDB: Log scan progressed past the checkpoint lsn 15321210
2014-11-14 07:20:10 2512 [Note] InnoDB: Database was not shutdown normally!
2014-11-14 07:20:10 2512 [Note] InnoDB: Starting crash recovery.
2014-11-14 07:20:10 2512 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-11-14 07:20:10 2512 [Note] InnoDB: Restoring possible half-written data pages
2014-11-14 07:20:10 2512 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 18039903
2014-11-14 07:20:12 2512 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
2014-11-14 07:20:16 2512 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=18039903
2014-11-14 07:20:16 2512 [Warning] InnoDB: Starting to delete and rewrite log files.
2014-11-14 07:20:16 2512 [Note] InnoDB: Setting log file E:\xampp\mysql\data\ib_logfile101 size to 5 MB
2014-11-14 07:20:16 2512 [Note] InnoDB: Setting log file E:\xampp\mysql\data\ib_logfile1 size to 5 MB
2014-11-14 07:20:16 2512 [Note] InnoDB: Renaming log file E:\xampp\mysql\data\ib_logfile101 to E:\xampp\mysql\data\ib_logfile0
2014-11-14 07:20:16 2512 [Warning] InnoDB: New log files created, LSN=18039903
2014-11-14 07:20:16 2512 [Note] InnoDB: 128 rollback segment(s) are active.
2014-11-14 07:20:16 2512 [Note] InnoDB: Waiting for purge to start
2014-11-14 07:20:16 2512 [Note] InnoDB: 5.6.20 started; log sequence number 18039903
2014-11-14 07:20:16 2512 [Note] Server hostname (bind-address): '*'; port: 3306
2014-11-14 07:20:16 2512 [Note] IPv6 is available.
2014-11-14 07:20:16 2512 [Note] - '::' resolves to '::';
2014-11-14 07:20:16 2512 [Note] Server socket created on IP: '::'.
2014-11-14 07:20:16 2512 [Note] Event Scheduler: Loaded 0 events
2014-11-14 07:20:16 2512 [Note] e:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.20' socket: '' port: 3306 MySQL Community Server (GPL)
15:20:53 UTC - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=1
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133778 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x20cf2bc8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
14e9ec2 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
14eaacc mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
14ecf50 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
14ed3be mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
1577d62 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
14e0575 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
125cdb1 mysqld.exe!?ha_create@handler@@QAEHPBDPAUTABLE@@PAUst_ha_create_information@@@Z()
126150d mysqld.exe!?ha_create_table@@YAHPAVTHD@@PBD11PAUst_ha_create_information@@_N3@Z()
133e608 mysqld.exe!?mysql_alter_table@@YA_NPAVTHD@@PAD1PAUst_ha_create_information@@PAUTABLE_LIST@@PAVAlter_info@@IPAUst_order@@_N@Z()
13d05ea mysqld.exe!?execute@Sql_cmd_alter_table@@UAE_NPAVTHD@@@Z()
128f1ad mysqld.exe!?mysql_execute_command@@YAHPAVTHD@@@Z()
128f81e mysqld.exe!?mysql_parse@@YAXPAVTHD@@PADIPAVParser_state@@@Z()
12904e7 mysqld.exe!?dispatch_command@@YA_NW4enum_server_command@@PAVTHD@@PADI@Z()
129135a mysqld.exe!?do_command@@YA_NPAVTHD@@@Z()
1304e59 mysqld.exe!?do_handle_one_connection@@YAXPAVTHD@@@Z()
1304efd mysqld.exe!handle_one_connection()
165b8cb mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
14b0336 mysqld.exe!win_pthread_mutex_trylock()
16e6c00 mysqld.exe!my_mb_ctype_mb()
16e6c8a mysqld.exe!my_mb_ctype_mb()
7775338a kernel32.dll!BaseThreadInitThunk()
77c89f72 ntdll.dll!RtlInitializeExceptionChain()
77c89f45 ntdll.dll!RtlInitializeExceptionChain()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (21de1fb0): alter table ohrm_leave_comment
add constraint foreign key (created_by_emp_number)
references hs_hr_employee(emp_number) on delete cascadeConnection ID (thread ID): 4
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

================================================================================
There is no mysql in services.msc and following are the screenshots

Image Image

Please help!!

I am new to web development
by piyushupadhyay
14. November 2014 04:00
 
Forum: XAMPP for Windows
Topic: Mysqld.exe has stopped working in Xampp
Replies: 0
Views: 540

Re: MySQL gives FULLTEXT error on exported database

Altrea wrote:
Code: Select all
[...]ADD FULLTEXT KEY `crp_related` (`post_title`,`post_content`),
ADD FULLTEXT KEY `crp_related_title` (`post_title`),
ADD FULLTEXT KEY `crp_related_content` (`post_content`);

This is not possible because it would create multiple FULLTEXT indexes at the same time which is not supported by InnoDB.

Solution: Split your single ALTER TABLE command into multiple ALTER TABLE commands.

I cannot explain it more easy.


Thank you! I did not realise that "statement" means a command to run, now that puts everything in place, thanks a lot :) I Googled the proper syntax and it fixed my problem. Thanks again!

Nobbie wrote:So far the wrong forum here - this is not meant for educational purpose about MySQL, this forum is meant for technical issues on OSX / Xampp issues (installation problems etc.).


I am sorry, but if a build of MySQL included in XAMPP is only being able to export a DB that it can't import even back into itself is a "technical difficulty"? I wouldn't call it "technical easiness" by far :lol:
Anyway, please don't delete this thread, so next time someone as clueless as me can stumble unto it.
by elthar
12. November 2014 22:20
 
Forum: XAMPP for Mac OS X
Topic: MySQL gives FULLTEXT error on exported database
Replies: 3
Views: 488

Re: MySQL gives FULLTEXT error on exported database

Code: Select all
[...]ADD FULLTEXT KEY `crp_related` (`post_title`,`post_content`),
ADD FULLTEXT KEY `crp_related_title` (`post_title`),
ADD FULLTEXT KEY `crp_related_content` (`post_content`);

This is not possible because it would create multiple FULLTEXT indexes at the same time which is not supported by InnoDB.

Solution: Split your single ALTER TABLE command into multiple ALTER TABLE commands.

I cannot explain it more easy.
by Altrea
12. November 2014 20:55
 
Forum: XAMPP for Mac OS X
Topic: MySQL gives FULLTEXT error on exported database
Replies: 3
Views: 488

MySQL gives FULLTEXT error on exported database

Hello, could someone please help me solve this problem? Disclaimer: me here, *complete* MySQL noob :( nothing like relational database theory got anywhere close to my majors in college, I used MySQL only as fas as creating a new DB for a personal blog to run, never further.

I have a XAMPP 1.8.3-5 on OS X Yosemite 10.10, there is a Wordpress site running on it, which I need to copy to a XAMPP 1.8.3 under Windows 7 Professional SP1 64-bit, so I export the Wordpresses' DB to an .sql file (on express settings) and each time I try to import it under Windows, it gets to this part

Code: Select all
Indexes for table wp_posts

ALTER TABLE `wp_posts`
ADD PRIMARY KEY (`ID`), ADD KEY `post_name` (`post_name`),
ADD KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
ADD KEY `post_parent` (`post_parent`), ADD KEY `post_author` (`post_author`),
ADD FULLTEXT KEY `crp_related` (`post_title`,`post_content`),
ADD FULLTEXT KEY `crp_related_title` (`post_title`),
ADD FULLTEXT KEY `crp_related_content` (`post_content`);


with this error message shown then:
Code: Select all
#1795 - InnoDB presently supports one FULLTEXT index creation at a time


Not much on Google on that, so I have asked at StackOverflow first & been told to "run a few separate ALTER statements to add the keys needed" and "maybe add the fulltext index after the table has been created". But I am even below the level of knowledge required to understand what's that about :oops: though it must be something really obvious and simple to anyone working with MySQL :(

I get this is some kind of a bug with InnoDB, so does anyone know what can I do and can explain it to me in simply basic terms what to do, please? Like, go there, open that, type this. I would have read a textbook on MySQL workings if I had free time, but not enought of it right now :(
Any help would be greatly appreciated.
by elthar
12. November 2014 17:23
 
Forum: XAMPP for Mac OS X
Topic: MySQL gives FULLTEXT error on exported database
Replies: 3
Views: 488

Re: Upgraded to 1.8.3-5 - some databases, can't access table

Sounds similar to a issue I had previously when the file /etc/my.cnf had 777 rights.
If this is the case the file is ignored on mysql startup and caused InnoDB issues on my end.

(Check /var/mysql error logs)
by joostplas
03. November 2014 10:54
 
Forum: XAMPP for Mac OS X
Topic: Upgraded to 1.8.3-5 - some databases, can't access tables
Replies: 1
Views: 398

Upgraded to 1.8.3-5 - some databases, can't access tables

So I recently upgraded to XAMPP 1.8.3-5 on Yosemite. Everything was working fine with 1.8.3-4, but just keeping things up to date.

90% of the Databases and tables on my system are working fine. It's like all of the ones added after 1.8.3-4 installation, and using this fix: https://community.apachefriends.org/f/viewtopic.php?f=29&t=69200

more specifically, this fix got 1.8.3-4 working on my Yosemite DP5 installation:
http://www.ordinarycoder.com/xaamp-yosemite-preview-5-mysql-fix/

In MySQL Workbench, it shows the Databases and their applicable Tables if I "show" the tables in the left side bar (click the right pointing arrow next to Tables under a database to view all of its tables), however I can't perform any operations on them, ie Select, Insert, etc.

If I try and use the Schema Inspector in MySQL Workbench and select the Tables tab, it shows a table count of 0 and lists no tables.

Like I said, it seems to only be Databases that were added in 1.8.3-4 only...

I've tried setting permissions to 777 on the database folder and the files in it under /xamppfiles/var/etc/..., but no luck.

Any thoughts?

Edit: I should note, all of these tables I have issues with are InnoDB
by Seus
02. November 2014 14:57
 
Forum: XAMPP for Mac OS X
Topic: Upgraded to 1.8.3-5 - some databases, can't access tables
Replies: 1
Views: 398

Re: Inserting data into MySQL from Arduino

Thanks JJ_Tagy,
I kept the arduino side constant and changed from phpMyAdmin the host for admin user to %. Is this a way to tell that admin can be user from inside and outside? Please verify.
On mysql_error.log I get the following:

141031 23:41:45 [Note] Plugin 'FEDERATED' is disabled.
141031 23:41:45 InnoDB: The InnoDB memory heap is disabled
141031 23:41:45 InnoDB: Mutexes and rw_locks use Windows interlocked functions
141031 23:41:45 InnoDB: Compressed tables use zlib 1.2.3
141031 23:41:45 InnoDB: Initializing buffer pool, size = 16.0M
141031 23:41:45 InnoDB: Completed initialization of buffer pool
141031 23:41:45 InnoDB: highest supported file format is Barracuda.
141031 23:41:47 InnoDB: Waiting for the background threads to start
141031 23:41:48 InnoDB: 5.5.39 started; log sequence number 2885202
141031 23:41:48 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141031 23:41:48 [Note] - '0.0.0.0' resolves to '0.0.0.0';
141031 23:41:48 [Note] Server socket created on IP: '0.0.0.0'.
141031 23:41:48 [Warning] Found invalid password for user: 'mike@localhost'; Ignoring user
141031 23:41:48 [Warning] Found invalid password for user: 'admin@%'; Ignoring user
141031 23:41:48 [Note] Event Scheduler: Loaded 0 events
141031 23:41:48 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.39' socket: '' port: 3306 MySQL Community Server (GPL)

and as I said without changing anything on arduino code now I get Packet error...Error 255.
Am I at the right track?
by thermike
31. October 2014 22:53
 
Forum: MySQL
Topic: Inserting data into MySQL from Arduino
Replies: 7
Views: 947

Re: How to do a full restore of xampp

Did you try all the suggestions from the error message? There are some very good hints at the end, it will qoute them for you:

InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
by Nobbie
31. October 2014 10:54
 
Forum: XAMPP for Windows
Topic: How to do a full restore of xampp
Replies: 7
Views: 1348
PreviousNext

Return to advanced search