Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Q&A
[HELP] MySQL Error [HELP]
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Protas" data-source="post: 211540" data-attributes="member: 34350"><p>My xamp doesnt want to host it or my local host and this is what comes up:</p><p> </p><p>Error: MySQL shutdown unexpectedly.</p><p>6:01:54 AM [mysql] This may be due to a blocked port, missing dependencies, </p><p>6:01:54 AM [mysql] improper privileges, a crash, or a shutdown by another method.</p><p>6:01:54 AM [mysql] Check the "/xampp/mysql/data/mysql_error.log" file</p><p>6:01:54 AM [mysql] and the Windows Event Viewer for more clues</p><p> </p><p>and then this:</p><p> </p><p>121228 20:21:38 [Note] Plugin 'FEDERATED' is disabled.</p><p>121228 20:21:38 InnoDB: The InnoDB memory heap is disabled</p><p>121228 20:21:38 InnoDB: Mutexes and rw_locks use Windows interlocked functions</p><p>121228 20:21:38 InnoDB: Compressed tables use zlib 1.2.3</p><p>121228 20:21:38 InnoDB: Initializing buffer pool, size = 16.0M</p><p>121228 20:21:38 InnoDB: Completed initialization of buffer pool</p><p>InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:</p><p>InnoDB: a new database to be created!</p><p>121228 20:21:38 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB</p><p>InnoDB: Database physically writes the file full: wait...</p><p>121228 20:21:39 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created</p><p>InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB</p><p>InnoDB: Database physically writes the file full: wait...</p><p>121228 20:21:41 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created</p><p>InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB</p><p>InnoDB: Database physically writes the file full: wait...</p><p>InnoDB: Doublewrite buffer not found: creating new</p><p>InnoDB: Doublewrite buffer created</p><p>InnoDB: 127 rollback segment(s) active.</p><p>InnoDB: Creating foreign key constraint system tables</p><p>InnoDB: Foreign key constraint system tables created</p><p>121228 20:21:43 InnoDB: Waiting for the background threads to start</p><p>121228 20:21:44 InnoDB: 1.1.8 started; log sequence number 0</p><p>121228 20:21:44 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306</p><p>121228 20:21:44 [Note] - '0.0.0.0' resolves to '0.0.0.0';</p><p>121228 20:21:44 [Note] Server socket created on IP: '0.0.0.0'.</p><p>121228 20:21:47 [Note] Event Scheduler: Loaded 0 events</p><p>121228 20:21:47 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.</p><p>Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)</p><p>121228 23:27:58 [Warning] IP address '125.132.136.163' could not be resolved: No such host is known. </p><p>121230 1:55:34 [Note] Plugin 'FEDERATED' is disabled.</p><p>121230 1:55:34 InnoDB: The InnoDB memory heap is disabled</p><p>121230 1:55:34 InnoDB: Mutexes and rw_locks use Windows interlocked functions</p><p>121230 1:55:34 InnoDB: Compressed tables use zlib 1.2.3</p><p>121230 1:55:35 InnoDB: Initializing buffer pool, size = 16.0M</p><p>121230 1:55:35 InnoDB: Completed initialization of buffer pool</p><p>121230 1:55:35 InnoDB: highest supported file format is Barracuda.</p><p>InnoDB: The log sequence number in ibdata files does not match</p><p>InnoDB: the log sequence number in the ib_logfiles!</p><p>121230 1:55:35 InnoDB: Database was not shut down normally!</p><p>InnoDB: Starting crash recovery.</p><p>InnoDB: Reading tablespace information from the .ibd files...</p><p>InnoDB: Restoring possible half-written data pages from the doublewrite</p><p>InnoDB: buffer...</p><p>121230 1:55:38 InnoDB: Waiting for the background threads to start</p><p>121230 1:55:39 InnoDB: 1.1.8 started; log sequence number 1595675</p><p>121230 1:55:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306</p><p>121230 1:55:39 [Note] - '0.0.0.0' resolves to '0.0.0.0';</p><p>121230 1:55:39 [Note] Server socket created on IP: '0.0.0.0'.</p><p>121230 1:55:40 [Note] Event Scheduler: Loaded 0 events</p><p>121230 1:55:40 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.</p><p>Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)</p><p>130621 18:13:34 [Note] Plugin 'FEDERATED' is disabled.</p><p>130621 18:13:35 InnoDB: The InnoDB memory heap is disabled</p><p>130621 18:13:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions</p><p>130621 18:13:35 InnoDB: Compressed tables use zlib 1.2.3</p><p>130621 18:13:35 InnoDB: Initializing buffer pool, size = 16.0M</p><p>130621 18:13:35 InnoDB: Completed initialization of buffer pool</p><p>130621 18:13:35 InnoDB: highest supported file format is Barracuda.</p><p>InnoDB: The log sequence number in ibdata files does not match</p><p>InnoDB: the log sequence number in the ib_logfiles!</p><p>130621 18:13:35 InnoDB: Database was not shut down normally!</p><p>InnoDB: Starting crash recovery.</p><p>InnoDB: Reading tablespace information from the .ibd files...</p><p>InnoDB: Restoring possible half-written data pages from the doublewrite</p><p>InnoDB: buffer...</p><p>130621 18:13:36 InnoDB: Waiting for the background threads to start</p><p>130621 18:13:37 InnoDB: 1.1.8 started; log sequence number 1595675</p><p>130621 18:13:37 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306</p><p>130621 18:13:37 [Note] - '0.0.0.0' resolves to '0.0.0.0';</p><p>130621 18:13:37 [Note] Server socket created on IP: '0.0.0.0'.</p><p>130621 18:13:38 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)</p><p>130621 18:14:10 [Note] Plugin 'FEDERATED' is disabled.</p><p>130621 18:14:10 InnoDB: The InnoDB memory heap is disabled</p><p>130621 18:14:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions</p><p>130621 18:14:10 InnoDB: Compressed tables use zlib 1.2.3</p><p>130621 18:14:10 InnoDB: Initializing buffer pool, size = 16.0M</p><p>130621 18:14:10 InnoDB: Completed initialization of buffer pool</p><p>130621 18:14:10 InnoDB: highest supported file format is Barracuda.</p><p>InnoDB: The log sequence number in ibdata files does not match</p><p>InnoDB: the log sequence number in the ib_logfiles!</p><p>130621 18:14:10 InnoDB: Database was not shut down normally!</p><p>InnoDB: Starting crash recovery.</p><p>InnoDB: Reading tablespace information from the .ibd files...</p><p>InnoDB: Restoring possible half-written data pages from the doublewrite</p><p>InnoDB: buffer...</p><p>130621 18:14:11 InnoDB: Waiting for the background threads to start</p><p>130621 18:14:12 InnoDB: 1.1.8 started; log sequence number 1595675</p><p>130621 18:14:12 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306</p><p>130621 18:14:12 [Note] - '0.0.0.0' resolves to '0.0.0.0';</p><p>130621 18:14:12 [Note] Server socket created on IP: '0.0.0.0'.</p><p>130621 18:14:12 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)</p><p>130621 18:14:12 [Note] Plugin 'FEDERATED' is disabled.</p><p>130621 18:14:12 InnoDB: The InnoDB memory heap is disabled</p><p>130621 18:14:12 InnoDB: Mutexes and rw_locks use Windows interlocked functions</p><p>130621 18:14:12 InnoDB: Compressed tables use zlib 1.2.3</p><p>130621 18:14:12 InnoDB: Initializing buffer pool, size = 16.0M</p><p>130621 18:14:12 InnoDB: Completed initialization of buffer pool</p><p>130621 18:14:13 InnoDB: highest supported file format is Barracuda.</p><p>InnoDB: The log sequence number in ibdata files does not match</p><p>InnoDB: the log sequence number in the ib_logfiles!</p><p>130621 18:14:13 InnoDB: Database was not shut down normally!</p><p>InnoDB: Starting crash recovery.</p><p>InnoDB: Reading tablespace information from the .ibd files...</p><p>InnoDB: Restoring possible half-written data pages from the doublewrite</p><p>InnoDB: buffer...</p><p>130621 18:14:13 InnoDB: Waiting for the background threads to start</p><p>130621 18:14:14 InnoDB: 1.1.8 started; log sequence number 1595675</p><p>130621 18:14:14 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306</p><p>130621 18:14:14 [Note] - '0.0.0.0' resolves to '0.0.0.0';</p><p>130621 18:14:14 [Note] Server socket created on IP: '0.0.0.0'.</p><p>130621 18:14:14 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)</p><p>130621 18:14:18 [Note] Plugin 'FEDERATED' is disabled.</p><p>130621 18:14:18 InnoDB: The InnoDB memory heap is disabled</p><p>130621 18:14:18 InnoDB: Mutexes and rw_locks use Windows interlocked functions</p><p>130621 18:14:18 InnoDB: Compressed tables use zlib 1.2.3</p><p>130621 18:14:18 InnoDB: Initializing buffer pool, size = 16.0M</p><p>130621 18:14:18 InnoDB: Completed initialization of buffer pool</p><p>130621 18:14:18 InnoDB: highest supported file format is Barracuda.</p><p>InnoDB: The log sequence number in ibdata files does not match</p><p>InnoDB: the log sequence number in the ib_logfiles!</p><p>130621 18:14:18 InnoDB: Database was not shut down normally!</p><p>InnoDB: Starting crash recovery.</p><p>InnoDB: Reading tablespace information from the .ibd files...</p><p>InnoDB: Restoring possible half-written data pages from the doublewrite</p><p>InnoDB: buffer......</p><p> </p><p>It waits or five seconds and then it just stops. Help please?</p></blockquote><p></p>
[QUOTE="Protas, post: 211540, member: 34350"] My xamp doesnt want to host it or my local host and this is what comes up: Error: MySQL shutdown unexpectedly. 6:01:54 AM [mysql] This may be due to a blocked port, missing dependencies, 6:01:54 AM [mysql] improper privileges, a crash, or a shutdown by another method. 6:01:54 AM [mysql] Check the "/xampp/mysql/data/mysql_error.log" file 6:01:54 AM [mysql] and the Windows Event Viewer for more clues and then this: 121228 20:21:38 [Note] Plugin 'FEDERATED' is disabled. 121228 20:21:38 InnoDB: The InnoDB memory heap is disabled 121228 20:21:38 InnoDB: Mutexes and rw_locks use Windows interlocked functions 121228 20:21:38 InnoDB: Compressed tables use zlib 1.2.3 121228 20:21:38 InnoDB: Initializing buffer pool, size = 16.0M 121228 20:21:38 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: InnoDB: a new database to be created! 121228 20:21:38 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 121228 20:21:39 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 121228 20:21:41 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created InnoDB: Setting log file C:\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 121228 20:21:43 InnoDB: Waiting for the background threads to start 121228 20:21:44 InnoDB: 1.1.8 started; log sequence number 0 121228 20:21:44 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 121228 20:21:44 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 121228 20:21:44 [Note] Server socket created on IP: '0.0.0.0'. 121228 20:21:47 [Note] Event Scheduler: Loaded 0 events 121228 20:21:47 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections. Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL) 121228 23:27:58 [Warning] IP address '125.132.136.163' could not be resolved: No such host is known. 121230 1:55:34 [Note] Plugin 'FEDERATED' is disabled. 121230 1:55:34 InnoDB: The InnoDB memory heap is disabled 121230 1:55:34 InnoDB: Mutexes and rw_locks use Windows interlocked functions 121230 1:55:34 InnoDB: Compressed tables use zlib 1.2.3 121230 1:55:35 InnoDB: Initializing buffer pool, size = 16.0M 121230 1:55:35 InnoDB: Completed initialization of buffer pool 121230 1:55:35 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 121230 1:55:35 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 121230 1:55:38 InnoDB: Waiting for the background threads to start 121230 1:55:39 InnoDB: 1.1.8 started; log sequence number 1595675 121230 1:55:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 121230 1:55:39 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 121230 1:55:39 [Note] Server socket created on IP: '0.0.0.0'. 121230 1:55:40 [Note] Event Scheduler: Loaded 0 events 121230 1:55:40 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections. Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL) 130621 18:13:34 [Note] Plugin 'FEDERATED' is disabled. 130621 18:13:35 InnoDB: The InnoDB memory heap is disabled 130621 18:13:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130621 18:13:35 InnoDB: Compressed tables use zlib 1.2.3 130621 18:13:35 InnoDB: Initializing buffer pool, size = 16.0M 130621 18:13:35 InnoDB: Completed initialization of buffer pool 130621 18:13:35 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130621 18:13:35 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 130621 18:13:36 InnoDB: Waiting for the background threads to start 130621 18:13:37 InnoDB: 1.1.8 started; log sequence number 1595675 130621 18:13:37 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130621 18:13:37 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130621 18:13:37 [Note] Server socket created on IP: '0.0.0.0'. 130621 18:13:38 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130621 18:14:10 [Note] Plugin 'FEDERATED' is disabled. 130621 18:14:10 InnoDB: The InnoDB memory heap is disabled 130621 18:14:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130621 18:14:10 InnoDB: Compressed tables use zlib 1.2.3 130621 18:14:10 InnoDB: Initializing buffer pool, size = 16.0M 130621 18:14:10 InnoDB: Completed initialization of buffer pool 130621 18:14:10 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130621 18:14:10 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 130621 18:14:11 InnoDB: Waiting for the background threads to start 130621 18:14:12 InnoDB: 1.1.8 started; log sequence number 1595675 130621 18:14:12 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130621 18:14:12 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130621 18:14:12 [Note] Server socket created on IP: '0.0.0.0'. 130621 18:14:12 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130621 18:14:12 [Note] Plugin 'FEDERATED' is disabled. 130621 18:14:12 InnoDB: The InnoDB memory heap is disabled 130621 18:14:12 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130621 18:14:12 InnoDB: Compressed tables use zlib 1.2.3 130621 18:14:12 InnoDB: Initializing buffer pool, size = 16.0M 130621 18:14:12 InnoDB: Completed initialization of buffer pool 130621 18:14:13 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130621 18:14:13 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 130621 18:14:13 InnoDB: Waiting for the background threads to start 130621 18:14:14 InnoDB: 1.1.8 started; log sequence number 1595675 130621 18:14:14 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130621 18:14:14 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130621 18:14:14 [Note] Server socket created on IP: '0.0.0.0'. 130621 18:14:14 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) 130621 18:14:18 [Note] Plugin 'FEDERATED' is disabled. 130621 18:14:18 InnoDB: The InnoDB memory heap is disabled 130621 18:14:18 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130621 18:14:18 InnoDB: Compressed tables use zlib 1.2.3 130621 18:14:18 InnoDB: Initializing buffer pool, size = 16.0M 130621 18:14:18 InnoDB: Completed initialization of buffer pool 130621 18:14:18 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130621 18:14:18 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer...... It waits or five seconds and then it just stops. Help please? [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
[HELP] MySQL Error [HELP]
Top