Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : New install of AMPPS and MySQL will not start



Threaded Mode | Print  

 New install of AMPPS and MySQL will not start, New install of AMPPS and MySQL will not start (4 Replies, Read 39974 times)
plusco
Group: Member
Post Group: Newbie
Posts: 3
Status:
Please help. New install of AMPPS and MySQL will not start.  Error in error log below.  Not sure how to proceed.  Any help would be appreciated.  Thanks.

2014-03-08 16:40:07 7260 [Warning] You need to use --log-bin to make --binlog-format work.
2014-03-08 16:40:07 7260 [Note] Plugin 'FEDERATED' is disabled.
2014-03-08 16:40:07 7260 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-03-08 16:40:07 7260 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-08 16:40:07 7260 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-08 16:40:07 7260 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-08 16:40:07 7260 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-08 16:40:07 7260 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-08 16:40:07 7260 [Note] InnoDB: Completed initialization of buffer pool
2014-03-08 16:40:07 7260 [Note] InnoDB: The first specified data file .\ibdata1 did not exist: a new database to be created!
2014-03-08 16:40:07 7260 [Note] InnoDB: Setting file .\ibdata1 size to 12 MB
2014-03-08 16:40:07 7260 [Note] InnoDB: Database physically writes the file full: wait...
2014-03-08 16:40:08 7260 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB
2014-03-08 16:40:11 7260 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB
2014-03-08 16:40:13 1c60  InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: ht*p://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html

2014-03-08 16:40:13 7260 [ERROR] InnoDB: File .\ib_logfile101: 'aio write' returned OS error 187. Cannot continue operation
2014-03-08 19:01:15 3732 [Warning] You need to use --log-bin to make --binlog-format work.
2014-03-08 19:01:15 3732 [Note] Plugin 'FEDERATED' is disabled.
2014-03-08 19:01:15 3732 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-03-08 19:01:15 3732 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-08 19:01:15 3732 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-08 19:01:15 3732 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-08 19:01:15 3732 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-08 19:01:15 3732 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-08 19:01:15 3732 [Note] InnoDB: Completed initialization of buffer pool
2014-03-08 19:01:15 3732 [ERROR] InnoDB: space header page consists of zero bytes in data file .\ibdata1
2014-03-08 19:01:15 3732 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2014-03-08 19:01:15 3732 [ERROR] Plugin 'InnoDB' init function returned error.
2014-03-08 19:01:15 3732 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-03-08 19:01:15 3732 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-03-08 19:01:15 3732 [ERROR] Aborting2014-03-08 19:01:15 3732 [Note] Binlog end
IP: --   

New install of AMPPS and MySQL will not start
tidus
Group: Member
Post Group: Super Member
Posts: 1121
Status:
Hi,

Open MySQL Tab in AMPPS Application -> Configuration. Search for line:
Code

#log-bin=mysql-bin


uncomment it. Save it and try starting mysql server then.


-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook :  http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack
IP: --   

New install of AMPPS and MySQL will not start
plusco
Group: Member
Post Group: Newbie
Posts: 3
Status:
Changes made as directed; in two places.  Tried to restart without success.  New error log posted below.  Please advise.  Thanks.

2014-03-10 00:03:31 10152 [Note] Plugin 'FEDERATED' is disabled.
2014-03-10 00:03:31 10152 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-03-10 00:03:31 10152 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-10 00:03:31 10152 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-10 00:03:31 10152 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-10 00:03:31 10152 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-10 00:03:31 10152 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-10 00:03:31 10152 [Note] InnoDB: Completed initialization of buffer pool
2014-03-10 00:03:31 10152 [ERROR] InnoDB: space header page consists of zero bytes in data file .\ibdata1
2014-03-10 00:03:31 10152 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2014-03-10 00:03:31 10152 [ERROR] Plugin 'InnoDB' init function returned error.
2014-03-10 00:03:31 10152 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-03-10 00:03:31 10152 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-03-10 00:03:31 10152 [ERROR] Aborting

2014-03-10 00:03:31 10152 [Note] Binlog end
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'partition'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_METRICS'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_CMP'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'INNODB_TRX'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'BLACKHOLE'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'ARCHIVE'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'MRG_MYISAM'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'MyISAM'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'MEMORY'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'CSV'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'sha256_password'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'mysql_old_password'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'mysql_native_password'
2014-03-10 00:03:31 10152 [Note] Shutting down plugin 'binlog'
2014-03-10 00:03:31 10152 [Note] mysql\bin\mysqld.exe: Shutdown complete
IP: --   

New install of AMPPS and MySQL will not start
plusco
Group: Member
Post Group: Newbie
Posts: 3
Status:
:??: Anything?  Anybody??  Should I just give up on this?
IP: --   

New install of AMPPS and MySQL will not start
tidus
Group: Member
Post Group: Super Member
Posts: 1121
Status:
Hi,

First take a copy of your your data directory. Then in data directory delete the files mysql-bin.*, ibdata* , ib_logfile*.

DO NOT DELETE ANY FOLDER IN IT.

In Mac, Data Directory is /Applications/AMPPS/var

In Windows, Data Directory is path/to/Ampps/mysql/data

Try Starting MySQL server then.

Please open a ticket if you are still facing any issues.


-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook :  http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is August 6, 2020, 12:33 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 10  |  Page Created In:0.295