MySQL stops

[XCalibre3]

It keeps  stopping even though I have it as a service.  Apache is working, but I get this error when starting MySQL

 

2023-04-21 13:44:02 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 10328
Cannot find checkpoint record at LSN (1,0x5556)
2023-04-21 13:44:02 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2023-04-21 13:44:02 0 [ERROR] Plugin 'Aria' init function returned error.
2023-04-21 13:44:02 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2023-04-21 13:44:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-04-21 13:44:02 0 [Note] InnoDB: Uses event mutexes
2023-04-21 13:44:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-04-21 13:44:02 0 [Note] InnoDB: Number of pools: 1
2023-04-21 13:44:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-04-21 13:44:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-04-21 13:44:02 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-21 13:44:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-04-21 13:44:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-21 13:44:02 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-21 13:44:02 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-04-21 13:44:02 0 [Note] InnoDB: Waiting for purge to start
2023-04-21 13:44:03 0 [Note] InnoDB: 10.4.28 started; log sequence number 328146; transaction id 309
2023-04-21 13:44:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-04-21 13:44:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-04-21 13:44:03 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2023-04-21 13:44:03 0 [ERROR] Failed to initialize plugins.
2023-04-21 13:44:03 0 [ERROR] Aborting

 

And this is the error I get:

1:44:09 PM  [mysql]     Error: MySQL shutdown unexpectedly.
1:44:09 PM  [mysql]     This may be due to a blocked port, missing dependencies, 
1:44:09 PM  [mysql]     improper privileges, a crash, or a shutdown by another method.
1:44:09 PM  [mysql]     Press the Logs button to view error logs and check
1:44:09 PM  [mysql]     the Windows Event Viewer for more clues
1:44:09 PM  [mysql]     If you need more help, copy and post this
1:44:09 PM  [mysql]     entire log window on the forums

[XCalibre3]

I got it to work by doing.... BUT.... lol, always a but...

Step 1: Moved(cut/paste) all the files in C:\xampp\mysql\data to desired backup location.
Step 2: After that copied all the files from C:\xampp\mysql\backup to C:\xampp\mysql\data
Step 3: Restarted mysql and checked the phpmyadmin url, it worked.
Step 4: After that stopped mysql that copied ibdata1 file from backup location to C:\xampp\mysql\data
Step 5: Restarted mysql
Step 6: After that copied all database folders and checked all the tables, It worked.

 

Now I get this error, and even though it's started, I cannot access anything but phpmyadmin, my localhost htm file, and that's it.

 

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated.

 

Makes no sense that I can access localhost/index.html but nothing else in any of the directories.

 

Also when I click anything in the phpmyadmin database I get this:

 

 

Edited April 21, 2023 by XCalibre3

[XCalibre3]

I just reinstalled everything since there was a billion errors.  Sorry for the post, but it might help somsone maybe lol.