Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > Bugs > Topic : MYSQL starts then stops ver 3.9


Poll
Poll Question : Anybody else having this issue?
Yes (1) (100%)
No (0) (0%)

Total Votes : 1




Threaded Mode | Print  

 MYSQL starts then stops ver 3.9, When I open AMPPS and try to start MYSQL it starts then 2 minutes later it stops. (1 Replies, Read 25509 times)
aldridgeb
Group: Member
Post Group: Newbie
Posts: 2
Status:
When I open AMPPS and try to start MYSQL it starts then 2 minutes later it stops.

LOG FILES:

2020-06-16T04:38:54.029773Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe (mysqld 8.0.18) starting as process 3084
2020-06-16T04:39:32.178171Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1').
2020-06-16T04:39:32.182563Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-06-16T04:39:32.185413Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-06-16T04:39:32.796042Z 0 [System] [MY-010910] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.
2020-06-16T04:43:52.791509Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe (mysqld 8.0.18) starting as process 3640
2020-06-16T04:44:34.238213Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1').
2020-06-16T04:44:34.253800Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-06-16T04:44:34.255135Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-06-16T04:44:34.953925Z 0 [System] [MY-010910] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.
2020-06-16T04:47:05.619467Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe (mysqld 8.0.18) starting as process 1348
2020-06-16T04:47:20.732323Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1').
2020-06-16T04:47:20.734411Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-06-16T04:47:20.735686Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-06-16T04:47:21.366901Z 0 [System] [MY-010910] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.
2020-06-16T04:47:57.251765Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe (mysqld 8.0.18) starting as process 1804
2020-06-16T04:48:07.890688Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1').
2020-06-16T04:48:07.892847Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-06-16T04:48:07.894139Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-06-16T04:48:08.438205Z 0 [System] [MY-010910] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.
2020-06-16T04:48:18.342913Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe (mysqld 8.0.18) starting as process 5528
2020-06-16T04:48:28.099683Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1').
2020-06-16T04:48:28.101792Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-06-16T04:48:28.103065Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-06-16T04:48:28.692026Z 0 [System] [MY-010910] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.
IP: --   

MYSQL starts then stops ver 3.9
aldridgeb
Group: Member
Post Group: Newbie
Posts: 2
Status:
And FYI I have already tried the innodb_force_recovery = 1
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is November 10, 2024, 6:04 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.115