MySQL-Datenbank schließt sich gleich wieder

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MySQL-Datenbank schließt sich gleich wieder

Postby User246 » 01. November 2013 10:03

Windows Version: Windows 7 Enterprise SP1 32-bit
XAMPP Version: 1.8.2
Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]

Ich möchte XAMPP gerne nutzen um lokal Wordpress-Webseiten zu testen. Habe dazu gestern XAMPP 1.8.2. direkt ins Root-Verzeichnis eines an meinen Laptop angeschlossenen externen USB-Laufwerks installiert (E:\) [ursprünglich habe ich dort XAMP-Lite installiert, aber als ich dann feststellte, dass ich damit kein FileZilla habe, habe ich es wieder glöscht und XAMP 1.8.2. aufgespielt].

Der Start von Apache via Control Panel (Version 3.2.1.) klappte problemlos. Ich habe, bevor ich versucht habe MySQL zu aktivieren, auch ein paar mal FileZilla an- und ausgeschaltet, was funktionierte.

Als ich dann meine MYSQL-Datenbank öffnen wollte, leuchtete der Button kurz grün auf und erlosch dann wieder, und ich erhielt folgende Meldung im Control-Panel:

Control-Panel / xampp-control.txt
----------------------------------------
03:13:38 [main] Initializing Control Panel
03:13:38 [main] Windows Version: Windows 7 Enterprise SP1 32-bit
03:13:38 [main] XAMPP Version: 1.8.2
03:13:38 [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
03:13:38 [main] You are not running with administrator rights! This will work for
03:13:38 [main] most application stuff but whenever you do something with services
03:13:38 [main] there will be a security dialogue or things will break! So think
03:13:38 [main] about running this application with administrator rights!
03:13:38 [main] XAMPP Installation Directory: "e:\xampp\"
03:13:38 [main] Checking for prerequisites
03:13:38 [main] All prerequisites found
03:13:38 [main] Initializing Modules
03:13:38 [main] Starting Check-Timer
03:13:38 [main] Control Panel Ready
03:13:57 [Apache] Attempting to start Apache app...
03:13:58 [Apache] Status change detected: running
03:14:08 [filezilla] Attempting to start FileZilla app...
03:14:08 [filezilla] Status change detected: running
03:27:25 [filezilla] Attempting to stop FileZilla app...
03:27:26 [filezilla] Status change detected: stopped
03:28:02 [filezilla] Attempting to start FileZilla app...
03:28:02 [filezilla] Status change detected: running
03:28:10 [mysql] Attempting to start MySQL app...
03:28:10 [mysql] Status change detected: running
03:28:15 [mysql] Status change detected: stopped
03:28:15 [mysql] Error: MySQL shutdown unexpectedly.
03:28:15 [mysql] This may be due to a blocked port, missing dependencies,
03:28:15 [mysql] improper privileges, a crash, or a shutdown by another method.
03:28:15 [mysql] Press the Logs button to view error logs and check
03:28:15 [mysql] the Windows Event Viewer for more clues
03:28:15 [mysql] If you need more help, copy and post this
03:28:15 [mysql] entire log window on the forums

Vorab: die anderen Threads zu MYSQL-Problemen hier im Forum scheinen auf mein Problem nicht zu passen, zumindest sind die Angaben in den jeweils zitierten mysql-error.logs andere.
Es gibt einen Post der ein ähnliches Problem zu haben scheint, aber dort gibt es noch keine Antworten: http://community.apachefriends.org/f/viewtopic.php?f=16&t=60898&p=219580&hilit=+apache+can&sid=fdf0d4e7ce514339dfa95556ea60c249

Die Ausgabe im mysql-error.text logfile:
----------------------------------------------

131101 3:28:10 [Note] Plugin 'FEDERATED' is disabled.
131101 3:28:10 InnoDB: The InnoDB memory heap is disabled
131101 3:28:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131101 3:28:10 InnoDB: Compressed tables use zlib 1.2.3
131101 3:28:10 InnoDB: Initializing buffer pool, size = 16.0M
131101 3:28:10 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file E:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
131101 3:28:10 InnoDB: Setting file E:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
131101 3:28:11 InnoDB: Log file E:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file E:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
131101 3:28:11 InnoDB: Log file E:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file E:\xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
131101 3:28:12 InnoDB: Waiting for the background threads to start
131101 3:28:13 InnoDB: 5.5.32 started; log sequence number 0
131101 3:28:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131101 3:28:13 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131101 3:28:13 [Note] Server socket created on IP: '0.0.0.0'.
131101 3:28:14 [ERROR] Event Scheduler: Failed to open table mysql.event
131101 3:28:14 [ERROR] Event Scheduler: Error while loading from disk.
131101 3:28:14 [Note] Event Scheduler: Purging the queue. 0 events
131101 3:28:14 [ERROR] Aborting

131101 3:28:14 InnoDB: Starting shutdown...
131101 3:28:14 InnoDB: Shutdown completed; log sequence number 1595675
131101 3:28:14 [Note] e:\xampp\mysql\bin\mysqld.exe: Shutdown complete

DANKE FÜR EURE HILFE!
User246
 
Posts: 1
Joined: 01. November 2013 09:26
Operating System: Windows 7 Enterprise SP1 32-bi

Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 4 guests