MySQL not working

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

MySQL not working

Postby CameraOff » 04. July 2020 21:52

Installed XAMPP this week. v3.2.4 on windows 10.
Began using yesterday during a school course. created a small db by creating a user account first. During the process there was an error.
Teacher went in and applied all priviledges to user and said everything was ok. The database showed up, and all seemed ok.
I went back in to finish assignment and access the db using php. Received an error saying user was not allowed access to the db (I did not keep the message).
After much research I decided to create new db and use that instead. Received this error number #1034 - Index for table 'db' is corrupt; try to repair it. There was a suggestion
to run as administrator. So I stopped XAMPP and signed out, rerun XAMPP as administrator and that made XAMPP only appear in the task bar (I found article how to run from this state)
so I restarted XAMP but now I am receiving this error in the log upon starting XAMPP. I have a rather large assignment due Monday, and would really appreciate any help asap.
I have several print screens of some of the errors but I don't know how to use the Img button to post the pictures to this forum.

InnoDB: using atomic writes.
2020-07-02 10:01:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-02 10:01:42 0 [Note] InnoDB: Uses event mutexes
2020-07-02 10:01:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-02 10:01:42 0 [Note] InnoDB: Number of pools: 1
2020-07-02 10:01:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-02 10:01:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-02 10:01:42 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-02 10:01:42 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2020-07-02 10:01:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-02 10:01:42 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-02 10:01:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-02 10:01:42 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-02 10:01:42 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-02 10:01:42 0 [Note] InnoDB: Waiting for purge to start
2020-07-02 10:01:42 0 [Note] InnoDB: 10.4.13 started; log sequence number 300297; transaction id 171
2020-07-02 10:01:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-02 10:01:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-02 10:01:42 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-02 10:47:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-02 10:47:42 0 [Note] InnoDB: Uses event mutexes
2020-07-02 10:47:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-02 10:47:42 0 [Note] InnoDB: Number of pools: 1
2020-07-02 10:47:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-02 10:47:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-02 10:47:42 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-02 10:47:42 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300306
2020-07-02 10:47:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-02 10:47:42 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-02 10:47:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-02 10:47:42 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-02 10:47:42 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-02 10:47:42 0 [Note] InnoDB: Waiting for purge to start
2020-07-02 10:47:42 0 [Note] InnoDB: 10.4.13 started; log sequence number 300315; transaction id 171
2020-07-02 10:47:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-02 10:47:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-02 10:47:42 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-03 10:02:46 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-03 10:02:46 0 [Note] InnoDB: Uses event mutexes
2020-07-03 10:02:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-03 10:02:46 0 [Note] InnoDB: Number of pools: 1
2020-07-03 10:02:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-03 10:02:46 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-03 10:02:46 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-03 10:02:46 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300324
2020-07-03 10:02:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-03 10:02:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-03 10:02:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-03 10:02:47 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-03 10:02:47 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-03 10:02:47 0 [Note] InnoDB: Waiting for purge to start
2020-07-03 10:02:47 0 [Note] InnoDB: 10.4.13 started; log sequence number 300333; transaction id 171
2020-07-03 10:02:47 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-03 10:02:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-03 10:02:47 0 [Note] Server socket created on IP: '::'.
2020-07-03 18:37:52 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 22% 32% 42% 53% 66% 83% 93% 100% (0.0 seconds); tables to flush: 2 1 0
(0.5 seconds);
2020-07-03 18:37:52 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2020-07-03 18:37:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-03 18:37:52 0 [Note] InnoDB: Uses event mutexes
2020-07-03 18:37:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-03 18:37:52 0 [Note] InnoDB: Number of pools: 1
2020-07-03 18:37:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-03 18:37:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-03 18:37:52 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-03 18:37:52 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=330357
2020-07-03 18:37:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-03 18:37:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-03 18:37:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-03 18:37:52 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-03 18:37:52 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-03 18:37:52 0 [Note] InnoDB: Waiting for purge to start
2020-07-03 18:37:53 0 [Note] InnoDB: 10.4.13 started; log sequence number 330366; transaction id 220
2020-07-03 18:37:53 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-03 18:37:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-03 18:37:53 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-04 5:52:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-04 5:52:33 0 [Note] InnoDB: Uses event mutexes
2020-07-04 5:52:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04 5:52:33 0 [Note] InnoDB: Number of pools: 1
2020-07-04 5:52:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-04 5:52:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-04 5:52:33 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-04 5:52:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=330375
2020-07-04 5:52:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-04 5:52:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-04 5:52:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-04 5:52:33 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-04 5:52:33 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-04 5:52:33 0 [Note] InnoDB: Waiting for purge to start
2020-07-04 5:52:34 0 [Note] InnoDB: 10.4.13 started; log sequence number 330384; transaction id 220
2020-07-04 5:52:34 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-04 5:52:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-04 5:52:34 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-04 15:34:16 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-04 15:34:16 0 [Note] InnoDB: Uses event mutexes
2020-07-04 15:34:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04 15:34:16 0 [Note] InnoDB: Number of pools: 1
2020-07-04 15:34:16 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-04 15:34:16 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-04 15:34:16 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-04 15:34:16 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=330393
2020-07-04 15:34:17 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-04 15:34:17 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-04 15:34:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-04 15:34:17 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-04 15:34:17 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-04 15:34:17 0 [Note] InnoDB: Waiting for purge to start
2020-07-04 15:34:17 0 [Note] InnoDB: 10.4.13 started; log sequence number 330402; transaction id 220
2020-07-04 15:34:17 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-04 15:34:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-04 15:34:17 0 [Note] InnoDB: Buffer pool(s) load completed at 200704 15:34:17
2020-07-04 15:34:17 0 [Note] Server socket created on IP: '::'.
2020-07-04 16:06:54 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 17% 69% 100% (0.0 seconds); tables to flush: 1 0
(0.0 seconds);
2020-07-04 16:06:54 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2020-07-04 16:06:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-04 16:06:54 0 [Note] InnoDB: Uses event mutexes
2020-07-04 16:06:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04 16:06:54 0 [Note] InnoDB: Number of pools: 1
2020-07-04 16:06:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-04 16:06:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-04 16:06:54 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-04 16:06:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=330411
2020-07-04 16:06:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-04 16:06:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-04 16:06:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-04 16:06:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-04 16:06:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-04 16:06:55 0 [Note] InnoDB: Waiting for purge to start
2020-07-04 16:06:55 0 [Note] InnoDB: 10.4.13 started; log sequence number 330420; transaction id 220
2020-07-04 16:06:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-04 16:06:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-04 16:06:55 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-04 16:08:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-04 16:08:05 0 [Note] InnoDB: Uses event mutexes
2020-07-04 16:08:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04 16:08:05 0 [Note] InnoDB: Number of pools: 1
2020-07-04 16:08:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-04 16:08:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-04 16:08:05 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-04 16:08:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-04 16:08:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-04 16:08:05 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-04 16:08:05 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-04 16:08:05 0 [Note] InnoDB: Waiting for purge to start
2020-07-04 16:08:05 0 [Note] InnoDB: 10.4.13 started; log sequence number 330438; transaction id 220
2020-07-04 16:08:05 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-04 16:08:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-04 16:08:05 0 [Note] Server socket created on IP: '::'.
CameraOff
 
Posts: 2
Joined: 04. July 2020 21:22
XAMPP version: v3.2.4
Operating System: windows 10

MySQL not working - addition to recent post

Postby CameraOff » 04. July 2020 21:58

Here is the log from the logs button:
This is in the logs button
2020-07-03 18:37:52 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 22% 32% 42% 53% 66% 83% 93% 100% (0.0 seconds); tables to flush: 2 1 0
(0.5 seconds);
2020-07-03 18:37:52 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2020-07-03 18:37:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-03 18:37:52 0 [Note] InnoDB: Uses event mutexes
2020-07-03 18:37:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-03 18:37:52 0 [Note] InnoDB: Number of pools: 1
2020-07-03 18:37:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-03 18:37:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-03 18:37:52 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-03 18:37:52 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=330357
2020-07-03 18:37:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-03 18:37:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-03 18:37:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-03 18:37:52 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-03 18:37:52 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-03 18:37:52 0 [Note] InnoDB: Waiting for purge to start
2020-07-03 18:37:53 0 [Note] InnoDB: 10.4.13 started; log sequence number 330366; transaction id 220
2020-07-03 18:37:53 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-03 18:37:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-03 18:37:53 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-04 5:52:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-04 5:52:33 0 [Note] InnoDB: Uses event mutexes
2020-07-04 5:52:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04 5:52:33 0 [Note] InnoDB: Number of pools: 1
2020-07-04 5:52:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-04 5:52:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-04 5:52:33 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-04 5:52:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=330375
2020-07-04 5:52:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-04 5:52:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-04 5:52:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-04 5:52:33 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-04 5:52:33 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-04 5:52:33 0 [Note] InnoDB: Waiting for purge to start
2020-07-04 5:52:34 0 [Note] InnoDB: 10.4.13 started; log sequence number 330384; transaction id 220
2020-07-04 5:52:34 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-04 5:52:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-04 5:52:34 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-04 15:34:16 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-04 15:34:16 0 [Note] InnoDB: Uses event mutexes
2020-07-04 15:34:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04 15:34:16 0 [Note] InnoDB: Number of pools: 1
2020-07-04 15:34:16 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-04 15:34:16 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-04 15:34:16 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-04 15:34:16 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=330393
2020-07-04 15:34:17 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-04 15:34:17 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-04 15:34:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-04 15:34:17 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-04 15:34:17 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-04 15:34:17 0 [Note] InnoDB: Waiting for purge to start
2020-07-04 15:34:17 0 [Note] InnoDB: 10.4.13 started; log sequence number 330402; transaction id 220
2020-07-04 15:34:17 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-04 15:34:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-04 15:34:17 0 [Note] InnoDB: Buffer pool(s) load completed at 200704 15:34:17
2020-07-04 15:34:17 0 [Note] Server socket created on IP: '::'.
2020-07-04 16:06:54 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 17% 69% 100% (0.0 seconds); tables to flush: 1 0
(0.0 seconds);
2020-07-04 16:06:54 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2020-07-04 16:06:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-04 16:06:54 0 [Note] InnoDB: Uses event mutexes
2020-07-04 16:06:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04 16:06:54 0 [Note] InnoDB: Number of pools: 1
2020-07-04 16:06:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-04 16:06:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-04 16:06:54 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-04 16:06:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=330411
2020-07-04 16:06:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-04 16:06:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-04 16:06:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-04 16:06:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-04 16:06:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-04 16:06:55 0 [Note] InnoDB: Waiting for purge to start
2020-07-04 16:06:55 0 [Note] InnoDB: 10.4.13 started; log sequence number 330420; transaction id 220
2020-07-04 16:06:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-04 16:06:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-04 16:06:55 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-04 16:08:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-04 16:08:05 0 [Note] InnoDB: Uses event mutexes
2020-07-04 16:08:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04 16:08:05 0 [Note] InnoDB: Number of pools: 1
2020-07-04 16:08:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-04 16:08:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-04 16:08:05 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-04 16:08:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-04 16:08:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-04 16:08:05 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-04 16:08:05 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-04 16:08:05 0 [Note] InnoDB: Waiting for purge to start
2020-07-04 16:08:05 0 [Note] InnoDB: 10.4.13 started; log sequence number 330438; transaction id 220
2020-07-04 16:08:05 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-04 16:08:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-04 16:08:05 0 [Note] Server socket created on IP: '::'.


InnoDB: using atomic writes.
2020-07-02 10:01:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-02 10:01:42 0 [Note] InnoDB: Uses event mutexes
2020-07-02 10:01:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-02 10:01:42 0 [Note] InnoDB: Number of pools: 1
2020-07-02 10:01:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-02 10:01:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-02 10:01:42 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-02 10:01:42 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2020-07-02 10:01:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-02 10:01:42 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-02 10:01:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-02 10:01:42 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-02 10:01:42 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-02 10:01:42 0 [Note] InnoDB: Waiting for purge to start
2020-07-02 10:01:42 0 [Note] InnoDB: 10.4.13 started; log sequence number 300297; transaction id 171
2020-07-02 10:01:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-02 10:01:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-02 10:01:42 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-02 10:47:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-02 10:47:42 0 [Note] InnoDB: Uses event mutexes
2020-07-02 10:47:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-02 10:47:42 0 [Note] InnoDB: Number of pools: 1
2020-07-02 10:47:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-02 10:47:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-02 10:47:42 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-02 10:47:42 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300306
2020-07-02 10:47:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-02 10:47:42 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-02 10:47:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-02 10:47:42 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-02 10:47:42 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-02 10:47:42 0 [Note] InnoDB: Waiting for purge to start
2020-07-02 10:47:42 0 [Note] InnoDB: 10.4.13 started; log sequence number 300315; transaction id 171
2020-07-02 10:47:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-02 10:47:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-02 10:47:42 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-03 10:02:46 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-03 10:02:46 0 [Note] InnoDB: Uses event mutexes
2020-07-03 10:02:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-03 10:02:46 0 [Note] InnoDB: Number of pools: 1
2020-07-03 10:02:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-03 10:02:46 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-03 10:02:46 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-03 10:02:46 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300324
2020-07-03 10:02:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-03 10:02:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-03 10:02:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-03 10:02:47 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-03 10:02:47 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-03 10:02:47 0 [Note] InnoDB: Waiting for purge to start
2020-07-03 10:02:47 0 [Note] InnoDB: 10.4.13 started; log sequence number 300333; transaction id 171
2020-07-03 10:02:47 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-03 10:02:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-03 10:02:47 0 [Note] Server socket created on IP: '::'.
2020-07-03 18:37:52 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 22% 32% 42% 53% 66% 83% 93% 100% (0.0 seconds); tables to flush: 2 1 0
(0.5 seconds);
2020-07-03 18:37:52 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2020-07-03 18:37:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-03 18:37:52 0 [Note] InnoDB: Uses event mutexes
2020-07-03 18:37:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-03 18:37:52 0 [Note] InnoDB: Number of pools: 1
2020-07-03 18:37:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-03 18:37:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-03 18:37:52 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-03 18:37:52 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=330357
2020-07-03 18:37:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-03 18:37:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-03 18:37:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-03 18:37:52 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-03 18:37:52 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-03 18:37:52 0 [Note] InnoDB: Waiting for purge to start
2020-07-03 18:37:53 0 [Note] InnoDB: 10.4.13 started; log sequence number 330366; transaction id 220
2020-07-03 18:37:53 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-03 18:37:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-03 18:37:53 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-04 5:52:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-04 5:52:33 0 [Note] InnoDB: Uses event mutexes
2020-07-04 5:52:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04 5:52:33 0 [Note] InnoDB: Number of pools: 1
2020-07-04 5:52:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-04 5:52:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-04 5:52:33 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-04 5:52:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=330375
2020-07-04 5:52:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-04 5:52:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-04 5:52:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-04 5:52:33 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-04 5:52:33 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-04 5:52:33 0 [Note] InnoDB: Waiting for purge to start
2020-07-04 5:52:34 0 [Note] InnoDB: 10.4.13 started; log sequence number 330384; transaction id 220
2020-07-04 5:52:34 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-04 5:52:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-04 5:52:34 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-04 15:34:16 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-04 15:34:16 0 [Note] InnoDB: Uses event mutexes
2020-07-04 15:34:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04 15:34:16 0 [Note] InnoDB: Number of pools: 1
2020-07-04 15:34:16 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-04 15:34:16 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-04 15:34:16 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-04 15:34:16 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=330393
2020-07-04 15:34:17 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-04 15:34:17 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-04 15:34:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-04 15:34:17 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-04 15:34:17 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-04 15:34:17 0 [Note] InnoDB: Waiting for purge to start
2020-07-04 15:34:17 0 [Note] InnoDB: 10.4.13 started; log sequence number 330402; transaction id 220
2020-07-04 15:34:17 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-04 15:34:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-04 15:34:17 0 [Note] InnoDB: Buffer pool(s) load completed at 200704 15:34:17
2020-07-04 15:34:17 0 [Note] Server socket created on IP: '::'.
2020-07-04 16:06:54 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 17% 69% 100% (0.0 seconds); tables to flush: 1 0
(0.0 seconds);
2020-07-04 16:06:54 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2020-07-04 16:06:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-04 16:06:54 0 [Note] InnoDB: Uses event mutexes
2020-07-04 16:06:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04 16:06:54 0 [Note] InnoDB: Number of pools: 1
2020-07-04 16:06:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-04 16:06:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-04 16:06:54 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-04 16:06:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=330411
2020-07-04 16:06:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-04 16:06:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-04 16:06:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-04 16:06:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-04 16:06:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-04 16:06:55 0 [Note] InnoDB: Waiting for purge to start
2020-07-04 16:06:55 0 [Note] InnoDB: 10.4.13 started; log sequence number 330420; transaction id 220
2020-07-04 16:06:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-04 16:06:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-04 16:06:55 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-04 16:08:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-04 16:08:05 0 [Note] InnoDB: Uses event mutexes
2020-07-04 16:08:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04 16:08:05 0 [Note] InnoDB: Number of pools: 1
2020-07-04 16:08:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-04 16:08:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-04 16:08:05 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-04 16:08:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-04 16:08:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-04 16:08:05 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-04 16:08:05 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-04 16:08:05 0 [Note] InnoDB: Waiting for purge to start
2020-07-04 16:08:05 0 [Note] InnoDB: 10.4.13 started; log sequence number 330438; transaction id 220
2020-07-04 16:08:05 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-04 16:08:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-04 16:08:05 0 [Note] Server socket created on IP: '::'.
CameraOff
 
Posts: 2
Joined: 04. July 2020 21:22
XAMPP version: v3.2.4
Operating System: windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 75 guests