MySQL Forums
Forum List  »  Install & Repo

how do I restarting mysql server using windows 8.1
Posted by: C I
Date: June 01, 2014 07:24PM

hi there
I've been using mysql server and sql workbench for about 6 months now and not had any issues with the server until now. I upgraded to windows 8.1 yesterday and now I can't get mysql server to start.

I've included a copy of whats in my .err file also I tried running
"C:\program files\mysql\mysql server 5.6\bin\mysqld" at the command line - have also included the output from that.

Cant seem to get the server running again - any help would be v gratefully received as have read lots on the mysql reference pages but seem to be goimg round in circles.

Many thanks
Caroline

below is the content of my error file in \data directory

2014-06-02 01:47:38 1320 [Note] Plugin 'FEDERATED' is disabled.
2014-06-02 01:47:38 1320 [Note] InnoDB: The InnoDB memory heap is disabled
2014-06-02 01:47:38 1320 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-06-02 01:47:38 1320 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-06-02 01:47:38 1320 [Note] InnoDB: Not using CPU crc32 instructions
2014-06-02 01:47:38 1320 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-06-02 01:47:38 1320 [Note] InnoDB: Completed initialization of buffer pool
2014-06-02 01:47:38 1320 [Note] InnoDB: Highest supported file format is Barracuda.
2014-06-02 01:47:38 1320 [Note] InnoDB: 128 rollback segment(s) are active.
2014-06-02 01:47:38 1320 [Note] InnoDB: Waiting for purge to start
2014-06-02 01:47:38 1320 [Note] InnoDB: 5.6.14 started; log sequence number 1625977
2014-06-02 01:47:38 1320 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 7efcb3b8-e9ef-11e3-b84f-681729ce6039.
2014-06-02 01:47:38 1320 [Note] Server hostname (bind-address): '*'; port: 3306
2014-06-02 01:47:38 1320 [Note] IPv6 is available.
2014-06-02 01:47:38 1320 [Note] - '::' resolves to '::';
2014-06-02 01:47:38 1320 [Note] Server socket created on IP: '::'.
2014-06-02 01:47:39 1320 [Note] Event Scheduler: Loaded 0 events
2014-06-02 01:47:39 1320 [Note] c:\program files\mysql\mysql server 5.6\bin\mysqld: ready for connections.
Version: '5.6.14' socket: '' port: 3306 MySQL Community Server (GPL)


Here is the output from running the command on the command line:

C:\Users\C11RVV>"c:\program files\mysql\mysql server 5.6\bin\mysqld"
2014-06-02 01:56:58 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).
2014-06-02 01:56:58 5028 [Warning] Can't create test file c:\program files\mysql
\mysql server 5.6\data\KCADI.lower-test
2014-06-02 01:56:58 5028 [Warning] Can't create test file c:\program files\mysql
\mysql server 5.6\data\KCADI.lower-test
2014-06-02 01:56:58 5028 [Note] Plugin 'FEDERATED' is disabled.
2014-06-02 01:56:58 5028 [Note] InnoDB: The InnoDB memory heap is disabled
2014-06-02 01:56:58 5028 [Note] InnoDB: Mutexes and rw_locks use Windows interlo
cked functions
2014-06-02 01:56:58 5028 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-06-02 01:56:58 5028 [Note] InnoDB: Not using CPU crc32 instructions
2014-06-02 01:56:58 5028 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-06-02 01:56:58 5028 [Note] InnoDB: Completed initialization of buffer pool
2014-06-02 01:56:58 5028 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write
mode
2014-06-02 01:56:58 5028 [ERROR] InnoDB: The system tablespace must be writable!

2014-06-02 01:56:58 5028 [ERROR] Plugin 'InnoDB' init function returned error.
2014-06-02 01:56:58 5028 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGIN
E failed.
2014-06-02 01:56:58 5028 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-06-02 01:56:58 5028 [ERROR] Aborting

2014-06-02 01:56:58 5028 [Note] Binlog end
2014-06-02 01:56:58 5028 [Note] Shutting down plugin 'partition'
2014-06-02 01:56:58 5028 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-06-02 01:56:58 5028 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
etc etc

Options: ReplyQuote


Subject
Written By
Posted
how do I restarting mysql server using windows 8.1
C I
June 01, 2014 07:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.