MYSQL ERROR

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

MYSQL ERROR

Postby SFKandersen » 16. February 2014 00:03

Hello guys when i try to start my mysql it crashes after a couble of seconds please help.

LOG:

Code: Select all
2014-02-15 23:55:25 10992 [Note] Plugin 'FEDERATED' is disabled.
2014-02-15 23:55:25 17b4 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-02-15 23:55:25 10992 [Note] InnoDB: The InnoDB memory heap is disabled
2014-02-15 23:55:25 10992 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-02-15 23:55:25 10992 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-02-15 23:55:25 10992 [Note] InnoDB: Not using CPU crc32 instructions
2014-02-15 23:55:25 10992 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-02-15 23:55:25 10992 [Note] InnoDB: Completed initialization of buffer pool
2014-02-15 23:55:25 10992 [Note] InnoDB: Highest supported file format is Barracuda.
2014-02-15 23:55:27 10992 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=1625987
2014-02-15 23:55:27 10992 [Warning] InnoDB: Starting to delete and rewrite log files.
2014-02-15 23:55:27 10992 [Note] InnoDB: Setting log file C:\Users\Sebastian\Desktop\xampp\mysql\data\ib_logfile101 size to 5 MB
2014-02-15 23:55:27 10992 [Note] InnoDB: Setting log file C:\Users\Sebastian\Desktop\xampp\mysql\data\ib_logfile1 size to 5 MB
2014-02-15 23:55:28 10992 [Note] InnoDB: Renaming log file C:\Users\Sebastian\Desktop\xampp\mysql\data\ib_logfile101 to C:\Users\Sebastian\Desktop\xampp\mysql\data\ib_logfile0
2014-02-15 23:55:28 17b4  InnoDB: Operating system error number 183 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2014-02-15 23:55:28 10992 [ERROR] InnoDB: File C:\Users\Sebastian\Desktop\xampp\mysql\data\ib_logfile101: 'rename' returned OS error 283.
2014-02-15 23:55:28 17b4  InnoDB: Assertion failure in thread 6068 in file srv0start.cc line 705
InnoDB: Failing assertion: success
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.
2014-02-16 00:00:11 10216 [Note] Plugin 'FEDERATED' is disabled.
2014-02-16 00:00:11 1e98 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-02-16 00:00:11 10216 [Note] InnoDB: The InnoDB memory heap is disabled
2014-02-16 00:00:11 10216 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-02-16 00:00:11 10216 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-02-16 00:00:11 10216 [Note] InnoDB: Not using CPU crc32 instructions
2014-02-16 00:00:11 10216 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-02-16 00:00:11 10216 [Note] InnoDB: Completed initialization of buffer pool
2014-02-16 00:00:11 10216 [ERROR] InnoDB: Log file C:\Users\Sebastian\Desktop\xampp\mysql\data\ib_logfile1 is of different size 5242880 bytes than other log files 50331648 bytes!
2014-02-16 00:00:11 10216 [ERROR] Plugin 'InnoDB' init function returned error.
2014-02-16 00:00:11 10216 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-02-16 00:00:11 10216 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-02-16 00:00:11 10216 [ERROR] Aborting

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

2014-02-16 00:00:36 2352 [Note] Plugin 'FEDERATED' is disabled.
2014-02-16 00:00:36 594 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-02-16 00:00:36 2352 [Note] InnoDB: The InnoDB memory heap is disabled
2014-02-16 00:00:36 2352 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-02-16 00:00:36 2352 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-02-16 00:00:36 2352 [Note] InnoDB: Not using CPU crc32 instructions
2014-02-16 00:00:36 2352 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-02-16 00:00:36 2352 [Note] InnoDB: Completed initialization of buffer pool
2014-02-16 00:00:36 2352 [ERROR] InnoDB: Log file C:\Users\Sebastian\Desktop\xampp\mysql\data\ib_logfile1 is of different size 5242880 bytes than other log files 50331648 bytes!
2014-02-16 00:00:36 2352 [ERROR] Plugin 'InnoDB' init function returned error.
2014-02-16 00:00:36 2352 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-02-16 00:00:36 2352 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-02-16 00:00:36 2352 [ERROR] Aborting

2014-02-16 00:00:36 2352 [Note] Binlog end
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'partition'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_METRICS'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_CMP'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'INNODB_TRX'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'BLACKHOLE'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'ARCHIVE'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'MRG_MYISAM'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'MyISAM'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'MEMORY'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'CSV'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'sha256_password'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'mysql_old_password'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'mysql_native_password'
2014-02-16 00:00:36 2352 [Note] Shutting down plugin 'binlog'
2014-02-16 00:00:36 2352 [Note] C:\Users\Sebastian\Desktop\xampp\mysql\bin\mysqld.exe: Shutdown complete

SFKandersen
 
Posts: 4
Joined: 16. February 2014 00:01
Operating System: Windows

Re: MYSQL ERROR

Postby Altrea » 16. February 2014 00:09

Hi,

uninstall XAMPP completely and reinstall it to the recommend path C:\xampp\

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

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

Re: MYSQL ERROR

Postby SFKandersen » 16. February 2014 00:10

Already tried that didnt work


Code: Select all
2014-02-16 00:21:54 11068 [Note] Plugin 'FEDERATED' is disabled.
2014-02-16 00:21:54 2bd0 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-02-16 00:21:54 11068 [Note] InnoDB: The InnoDB memory heap is disabled
2014-02-16 00:21:54 11068 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-02-16 00:21:54 11068 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-02-16 00:21:54 11068 [Note] InnoDB: Not using CPU crc32 instructions
2014-02-16 00:21:54 11068 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-02-16 00:21:54 11068 [Note] InnoDB: Completed initialization of buffer pool
2014-02-16 00:21:54 11068 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2014-02-16 00:21:54 11068 [ERROR] InnoDB: The system tablespace must be writable!
2014-02-16 00:21:54 11068 [ERROR] Plugin 'InnoDB' init function returned error.
2014-02-16 00:21:54 11068 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-02-16 00:21:54 11068 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-02-16 00:21:54 11068 [ERROR] Aborting

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

2014-02-16 00:22:46 3716 [Note] Plugin 'FEDERATED' is disabled.
2014-02-16 00:22:46 2634 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-02-16 00:22:46 3716 [Note] InnoDB: The InnoDB memory heap is disabled
2014-02-16 00:22:46 3716 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-02-16 00:22:46 3716 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-02-16 00:22:46 3716 [Note] InnoDB: Not using CPU crc32 instructions
2014-02-16 00:22:46 3716 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-02-16 00:22:46 3716 [Note] InnoDB: Completed initialization of buffer pool
2014-02-16 00:22:46 3716 [Note] InnoDB: Highest supported file format is Barracuda.
2014-02-16 00:22:47 3716 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=1625987
2014-02-16 00:22:47 3716 [Warning] InnoDB: Starting to delete and rewrite log files.
2014-02-16 00:22:47 3716 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2014-02-16 00:22:47 3716 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
2014-02-16 00:22:47 3716 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2014-02-16 00:22:47 2634  InnoDB: Operating system error number 183 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2014-02-16 00:22:47 3716 [ERROR] InnoDB: File C:\xampp\mysql\data\ib_logfile101: 'rename' returned OS error 283.
2014-02-16 00:22:47 2634  InnoDB: Assertion failure in thread 9780 in file srv0start.cc line 705
InnoDB: Failing assertion: success
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.
SFKandersen
 
Posts: 4
Joined: 16. February 2014 00:01
Operating System: Windows

Re: MYSQL ERROR

Postby Altrea » 16. February 2014 00:35

[ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode

That is your initial error which produces aftereffects.
Find out why the user mysql is starting with does not have the permission or possibility to open ibdata1 in read-write mode
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

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

Re: MYSQL ERROR

Postby SFKandersen » 16. February 2014 15:46

And how do i do that? sorry im kinda nobbie to this.
SFKandersen
 
Posts: 4
Joined: 16. February 2014 00:01
Operating System: Windows

Re: MYSQL ERROR

Postby Altrea » 16. February 2014 15:50

I don't know.
You are the one who has the system in front of you.
You are the only one having all information.
We don't know anything about it not even which specific operating system you use.
=> [FGA] Insufficient debug information

Very common this is a security software issue, or a file system permission issue and not a XAMPP issue.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

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

Re: MYSQL ERROR

Postby SFKandersen » 16. February 2014 15:54

The issue have been fixed.


Solution:

xampp -> mysql -> data -> delete ibdata and log files
SFKandersen
 
Posts: 4
Joined: 16. February 2014 00:01
Operating System: Windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 83 guests