MySQL Forums
Forum List  »  Install & Repo

Re: Deleting Server Instance Fails
Posted by: Patrick Skelton
Date: March 08, 2012 07:14AM

Hi,

I spoke too soon about this. I have rebooted my machine this morning and now the database is not running. If I go to a command prompt and type the command you give above, I get the following, which looks like a lot of failure to me:

C:\Documents and Settings\Patrick>mysqld --defaults-file="C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\my.ini
" --console --skip-grant-tables
120308 13:10:09 [Warning] option 'read_buffer_size': unsigned value 4096 adjusted to 8192
120308 13:10:09 [Note] Plugin 'FEDERATED' is disabled.
120308 13:10:09 InnoDB: The InnoDB memory heap is disabled
120308 13:10:09 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120308 13:10:09 InnoDB: Compressed tables use zlib 1.2.3
120308 13:10:09 InnoDB: Initializing buffer pool, size = 8.0M
120308 13:10:09 InnoDB: Completed initialization of buffer pool
120308 13:10:09 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!
120308 13:10:09 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...
120308 13:10:09 InnoDB: Waiting for the background threads to start
120308 13:10:10 InnoDB: 1.1.8 started; log sequence number 1595675
120308 13:10:10 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them

120308 13:10:10 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
120308 13:10:10 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
120308 13:10:10 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
120308 13:10:10 [Note] mysqld: ready for connections.
Version: '5.5.21' socket: '' port: 3306 MySQL Community Server (GPL)

Any help deciphering what is going wrong here would be very much appreciated.

Kind wishes, Patrick

Options: ReplyQuote




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.