MySQL refuses to start

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

MySQL refuses to start

Postby darpal » 29. January 2016 10:38

Hi, I was just delivered a project via an XAMP Portable installation and I placed the XAMP file directly under D: and apache starts but MySQL not. What can I do?

2016-01-29 09:26:43 589c 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.
2016-01-29 9:26:43 22684 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-29 9:26:43 22684 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-29 9:26:43 22684 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-29 9:26:43 22684 [Note] InnoDB: Memory barrier is not used
2016-01-29 9:26:43 22684 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-29 9:26:43 22684 [Note] InnoDB: Using generic crc32 instructions
2016-01-29 9:26:43 22684 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-29 9:26:43 22684 [Note] InnoDB: Completed initialization of buffer pool
2016-01-29 9:26:43 22684 [Note] InnoDB: The first specified data file \xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-29 9:26:43 22684 [Note] InnoDB: Setting file \xampp\mysql\data\ibdata1 size to 10 MB
2016-01-29 9:26:43 22684 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-29 9:26:43 22684 [Note] InnoDB: Setting log file \xampp\mysql\data\ib_logfile101 size to 5 MB
2016-01-29 9:26:43 22684 [Note] InnoDB: Setting log file \xampp\mysql\data\ib_logfile1 size to 5 MB
2016-01-29 9:26:44 22684 [Note] InnoDB: Renaming log file \xampp\mysql\data\ib_logfile101 to \xampp\mysql\data\ib_logfile0
2016-01-29 9:26:44 22684 [Warning] InnoDB: New log files created, LSN=45883
2016-01-29 9:26:44 22684 [Note] InnoDB: Doublewrite buffer not found: creating new
2016-01-29 9:26:44 22684 [Note] InnoDB: Doublewrite buffer created
2016-01-29 9:26:45 22684 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-29 9:26:45 22684 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-01-29 9:26:45 22684 [Note] InnoDB: Foreign key constraint system tables created
2016-01-29 9:26:45 22684 [Note] InnoDB: Creating tablespace and datafile system tables.
2016-01-29 9:26:45 22684 [Note] InnoDB: Tablespace and datafile system tables created.
2016-01-29 9:26:45 22684 [Note] InnoDB: Waiting for purge to start
2016-01-29 9:26:45 22684 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 0
2016-01-29 9:26:45 27040 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-29 9:26:45 22684 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-29 9:26:45 22684 [ERROR] Can't open and lock privilege tables: Can't find file: '.\mysql\servers.MYI' (errno: 2 "No such file or directory")
2016-01-29 9:26:45 22684 [Note] Server socket created on IP: '::'.
2016-01-29 9:26:45 22684 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: '.\mysql\user.MYI' (errno: 2 "No such file or directory")
2016-01-29 09:26:52 514c 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.
2016-01-29 9:26:52 20812 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-29 9:26:52 20812 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-29 9:26:52 20812 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-29 9:26:52 20812 [Note] InnoDB: Memory barrier is not used
2016-01-29 9:26:52 20812 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-29 9:26:52 20812 [Note] InnoDB: Using generic crc32 instructions
2016-01-29 9:26:52 20812 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-29 9:26:52 20812 [Note] InnoDB: Completed initialization of buffer pool
2016-01-29 9:26:52 20812 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-29 9:26:52 20812 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1600716 in the ib_logfiles!
2016-01-29 9:26:52 20812 [Note] InnoDB: Database was not shutdown normally!
2016-01-29 9:26:52 20812 [Note] InnoDB: Starting crash recovery.
2016-01-29 9:26:52 20812 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-29 9:26:52 20812 [Note] InnoDB: Restoring possible half-written data pages
2016-01-29 9:26:52 20812 [Note] InnoDB: from the doublewrite buffer...
2016-01-29 9:26:52 20812 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-29 9:26:52 20812 [Note] InnoDB: Waiting for purge to start
2016-01-29 9:26:53 20812 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 1600716
2016-01-29 9:26:53 22112 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-29 9:26:53 20812 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-29 9:26:53 20812 [ERROR] Can't open and lock privilege tables: Can't find file: '.\mysql\servers.MYI' (errno: 2 "No such file or directory")
2016-01-29 9:26:53 20812 [Note] Server socket created on IP: '::'.
2016-01-29 9:26:53 20812 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: '.\mysql\user.MYI' (errno: 2 "No such file or directory")
2016-01-29 09:29:22 46b4 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.
2016-01-29 9:29:22 18100 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-29 9:29:22 18100 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-29 9:29:22 18100 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-29 9:29:22 18100 [Note] InnoDB: Memory barrier is not used
2016-01-29 9:29:22 18100 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-29 9:29:22 18100 [Note] InnoDB: Using generic crc32 instructions
2016-01-29 9:29:22 18100 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-29 9:29:22 18100 [Note] InnoDB: Completed initialization of buffer pool
2016-01-29 9:29:22 18100 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-29 9:29:22 18100 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1600726 in the ib_logfiles!
2016-01-29 9:29:22 18100 [Note] InnoDB: Database was not shutdown normally!
2016-01-29 9:29:22 18100 [Note] InnoDB: Starting crash recovery.
2016-01-29 9:29:22 18100 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-29 9:29:22 18100 [Note] InnoDB: Restoring possible half-written data pages
2016-01-29 9:29:22 18100 [Note] InnoDB: from the doublewrite buffer...
2016-01-29 9:29:23 18100 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-29 9:29:23 18100 [Note] InnoDB: Waiting for purge to start
2016-01-29 9:29:23 18100 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 1600726
2016-01-29 9:29:23 21852 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-29 9:29:23 18100 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-29 9:29:23 18100 [ERROR] Can't open and lock privilege tables: Can't find file: '.\mysql\servers.MYI' (errno: 2 "No such file or directory")
2016-01-29 9:29:23 18100 [Note] Server socket created on IP: '::'.
2016-01-29 9:29:23 18100 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: '.\mysql\user.MYI' (errno: 2 "No such file or directory")
darpal
 
Posts: 1
Joined: 29. January 2016 10:34
Operating System: Windows 7

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 65 guests