seit heute startet bei mir nur noch Apache und MySQL leider nicht mehr. Davor lief es wochenlang ohne Probleme.
Folgendes wird in Xampp (Version 7.4.1) angezeigt:
- Code: Select all
17:20:58 [mysql] Versuche MySQL zu starten...
17:20:58 [mysql] Statusänderung erkannt: gestartet
17:21:01 [mysql] Statusänderung erkannt: gestoppt
17:21:01 [mysql] Fehler: MySQL wurde unerwartet beendet
17:21:01 [mysql] Ursache könnte ein geblockter Port, fehlende Abhängigkeiten,
17:21:01 [mysql] fehlende Berechtigungen, ein Absturz oder ein Abbruch einer anderen Methode sein.
17:21:01 [mysql] Drücke den Logs Button um error logs zu sehen und prüfe
17:21:01 [mysql] im Windows Event Viewer für weitere Hinweise
17:21:01 [mysql] Wenn du weitere Hilfe benötigst, kopiere den kompletten Inhalt des Log Fensters
17:21:01 [mysql] und füge ihn als Ergänzung in einem neuen Forum Eintrag hinzu.
Im Error Log ist das der letzte Eintrag:
- Code: Select all
2020-03-02 17:20:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-02 17:20:58 0 [Note] InnoDB: Uses event mutexes
2020-03-02 17:20:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-02 17:20:58 0 [Note] InnoDB: Number of pools: 1
2020-03-02 17:20:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-02 17:20:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-02 17:20:58 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-02 17:20:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-02 17:20:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-02 17:20:58 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-02 17:20:58 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-02 17:20:58 0 [Note] InnoDB: Waiting for purge to start
2020-03-02 17:20:58 0 [Note] InnoDB: 10.4.11 started; log sequence number 81258890; transaction id 91454
2020-03-02 17:20:58 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2020-03-02 17:20:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-02 17:20:58 0 [Note] Server socket created on IP: '::'.
2020-03-02 17:20:58 0 [Note] InnoDB: Buffer pool(s) load completed at 200302 17:20:58
Dazu wurden viele Master Dateien im MySQL Data Ordner angelegt. Ich glaube weil ich versucht habe den Port zu ändern, hier ein vorheriger Eintrag aus der Log Datei:
- Code: Select all
2020-03-02 16:48:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-02 16:48:53 0 [Note] InnoDB: Uses event mutexes
2020-03-02 16:48:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-02 16:48:53 0 [Note] InnoDB: Number of pools: 1
2020-03-02 16:48:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-02 16:48:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-02 16:48:53 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-02 16:48:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-02 16:48:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-02 16:48:53 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-02 16:48:53 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-02 16:48:53 0 [Note] InnoDB: Waiting for purge to start
2020-03-02 16:48:53 0 [Note] InnoDB: 10.4.11 started; log sequence number 81258728; transaction id 91454
2020-03-02 16:48:53 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2020-03-02 16:48:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-02 16:48:53 0 [Note] Server socket created on IP: '::'.
2020-03-02 16:48:53 0 [Note] InnoDB: Buffer pool(s) load completed at 200302 16:48:53
2020-03-02 16:48:53 7 [Note] Reading Master_info: 'master-2020@002d02@002d20@0020@00208@003a50@003a13@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2020@002d02@002d20@0020@00208@003a50@003a13@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-03-02 16:48:53 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2020-03-02 16:48:54 7 [Note] Initialized Master_info from 'master-2020@002d02@002d20@0020@00208@003a50@003a13@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-03-02 16:48:54 7 [Note] Added new Master_info '2020-02-20 8:50:13 0 [Note] Reading of all Master_info entries succeeded
' to hash table
2020-03-02 16:48:54 8 [Note] Master '2020-02-20 8:50:13 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-03-02 16:48:54 7 [Note] Started replication for '2020-02-20 8:50:13 0 [Note] Reading of all Master_info entries succeeded
Ich kann damit leider nichts anfangen.
Über die mysql_start.bat wird keine Fehlermeldung ausgegeben.
Kann mir jemand bitte helfen?
Vielen Dank vorab
Kamir