My SQL startet nicht!

Irgendwelche Probleme mit XAMPP für Windows? Dann ist hier genau der richtige Ort um nachzufragen.

My SQL startet nicht!

Postby Scheuermann » 20. February 2021 20:06

Hallo!

Habe das gleiche Problem. Vor einigen Tagen habe ich noch mit Xampp gearbeitet und alles lief ohnr Probleme. Wollte heute wieder an der Seite arbeiten und nun das.
Leider habe ich auch kein Akeeba Backup durchgeführt (nicht in letzter Zeit). Kann ich die Seite dennoch retten und hochladen? Dann würde ich sie auf dem Server weiter bearbeiten.
Scheuermann
 
Posts: 3
Joined: 20. February 2021 20:03
XAMPP version: 3.2.4
Operating System: Windows 10

Re: My SQL startet nicht!

Postby Altrea » 21. February 2021 01:07

Scheuermann wrote:Kann ich die Seite dennoch retten und hochladen? Dann würde ich sie auf dem Server weiter bearbeiten.

Das kommt immer auf die genaue Ursache an.

Starte MariaDB mal als Konsolenanwendung und sage uns, welche Meldungen bei dir genau ausgegeben werden:
  • Starte die XAMPP Shell über den Shell Button im XAMPP control panel
  • führe dort folgenden Befehl aus
    Code: Select all
    mysqld --defaults-file=mysql\bin\my.ini --standalone --console
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 10727
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: My SQL startet nicht!

Postby Scheuermann » 21. February 2021 09:33

Hallo Altrea!

Danke für die Antwort!

Habe getan was du verlang hast. Das Ergebnis ist jedoch mehrere Seiten lang und ich kann es hier nicht posten.
Als Anfang werde ich dir die ersten Zeilen hier reinstellen und wenn du noch mehr Infos brauchst dann kommt der Rest einzeln.

2021-02-21 9:21:29 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-02-21 9:21:29 0 [Note] mysqld (mysqld 10.4.14-MariaDB) starting as process 13096 ...
InnoDB: using atomic writes.
2021-02-21 9:21:29 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-02-21 9:21:29 0 [Note] InnoDB: Uses event mutexes
2021-02-21 9:21:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-21 9:21:29 0 [Note] InnoDB: Number of pools: 1
2021-02-21 9:21:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-02-21 9:21:29 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-02-21 9:21:29 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-21 9:21:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-21 9:21:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-21 9:21:29 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-21 9:21:29 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-02-21 9:21:29 0 [Note] InnoDB: Waiting for purge to start
2021-02-21 9:21:29 0 [Note] InnoDB: 10.4.14 started; log sequence number 790344797; transaction id 230108
2021-02-21 9:21:29 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-02-21 9:21:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-21 9:21:29 0 [Note] Server socket created on IP: '::'.
2021-02-21 9:21:29 0 [Note] InnoDB: Buffer pool(s) load completed at 210221 9:21:29
2021-02-21 9:21:29 7 [Note] Reading Master_info: 'master-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-02-21 9:21:29 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.
2021-02-21 9:21:29 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000006' (relay_log_pos 4)
2021-02-21 9:21:29 7 [ERROR] Binlog has bad magic number; It's not a binary log file that can be used by this version of MySQL
2021-02-21 9:21:29 7 [ERROR] Initialized Master_info from 'master-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2021-02-21 9:21:29 7 [Note] Added new Master_info '2021-02-14 16:18:00 0 [Note] Reading of all Master_info entries succ' to hash table
2021-02-21 9:21:29 7 [Note] Reading Master_info: 'master-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2021-02-21 9:21:29 7 [Note] Initialized Master_info from 'master-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table1:29 7 [Note] Added new Master_info '2021-02-14 16:18:00 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4hash table
2021-02-21 9:21:29 7 [Note] Started replication for '2021-02-14 16:18:00 0 [Note] Added new Master_info '' to hash tabl'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000027' position: 4
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-02-21 9:21:29 7 [Note] Reading Master_info: 'master-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread killed while connecting to master:00 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Added new Master_info '' to hash table
2021-02-21 9:21:29 7 [Note] Initialized Master_info from 'master-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-02-21 9:21:29 7 [Note] Added new Master_info '2021-02-14 16:18:00 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready fo' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4xe: ready for connections.
2021-02-21 9:21:29 7 [Note] Started replication for '2021-02-14 16:18:00 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready 'or connections.
2021-02-21 9:21:29 10 [ERROR] Master '2021-02-14 16:18:00 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-02-21 9:21:29 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e14@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' Relay_info:'relay-log-version@003a@0020@002710@002e4@002e14@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000027' position: 4
': Slave I/O thread killed while connecting to master8:00 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
2021-02-21 9:21:29 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e14@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2021-02-21 9:21:29 7 [Note] Added new Master_info 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org bina' to hash table
2021-02-21 9:21:29 12 [Note] Master 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2021-02-21 9:21:29 12 [ERROR] Master 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org binary distributi': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-02-21 9:21:29 7 [Note] Started replication for 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org bi'ary distribution
2021-02-21 9:21:29 13 [Note] Master 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e14@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000027' position: 4
2021-02-21 9:21:29 12 [Note] Master 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread killed while connecting to master
2021-02-21 9:21:29 7 [Note] Reading Master_info: 'master-2021@002d02@002d14@002016@003a18@003a20@00209@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cmhf@005czxmcw_content@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' Relay_info:'relay-log-2021@002d02@002d14@002016@003a18@003a20@00209@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cmhf@005czxmcw_content@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'
2021-02-21 9:21:29 12 [Note] Master 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread exiting, read up to log 'FIRST', position 4
2021-02-21 9:21:29 7 [ERROR] Error reading master configuration
Scheuermann
 
Posts: 3
Joined: 20. February 2021 20:03
XAMPP version: 3.2.4
Operating System: Windows 10

Re: My SQL startet nicht!

Postby Altrea » 21. February 2021 11:18

Hi,

Ich habe deine Beiträge mal separiert vom Ursprungsthema, weil die Ursache grundverschieden ist.

Probiere bitte mal folgendes, das hat bei anderen schon zum Erfolg geführt :

Öffne den Ordner "\xampp\mysql\data\"
Lösche die Datei "multi-master.info"
Lösche alle Dateien deren Dateiname beginnt mit: "master-"
Lösche alle Dateien deren Dateiname beginnt mit: "mysql_relay-bin-"
Lösche alle Dateien deren Dateiname beginnt mit: "relay-log-"
Lösche alle Dateien deren Dateiname beginnt mit: "ib_logfile"
Lösche alle Dateien deren Dateiname beginnt mit: "aria_log."

Versuche nun MariaDB zu starten.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 10727
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: My SQL startet nicht!

Postby Scheuermann » 21. February 2021 12:56

Es hat funktioniert. Ich bin dir so dankbar!
Hab auch gleich n Backup gemacht! 8)

Tausenddank!!
Scheuermann
 
Posts: 3
Joined: 20. February 2021 20:03
XAMPP version: 3.2.4
Operating System: Windows 10

Re: My SQL startet nicht!

Postby Altrea » 21. February 2021 13:49

Freut mich, dass ich dir helfen konnte.
Man kann nie genug Backups haben :wink:
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 10727
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 15 guests