Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I've installed Portable Xampp on my flashdrive.

Here is what I'm getting when I try to start MySQL on portable XAMPP server. (Apache starts without any fail)

enter image description here And log looks like that

121003 22:07:31 [Note] Plugin 'FEDERATED' is disabled.
121003 22:07:31 InnoDB: The InnoDB memory heap is disabled
121003 22:07:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121003 22:07:31 InnoDB: Compressed tables use zlib 1.2.3
121003 22:07:31 InnoDB: Initializing buffer pool, size = 16.0M
121003 22:07:31 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file \xampp\mysql\data\ib_logfile1 is of different size 0 0 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
121003 22:07:31 [ERROR] Plugin 'InnoDB' init function returned error.
121003 22:07:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
121003 22:07:31 [ERROR] Unknown/unsupported storage engine: InnoDB
121003 22:07:31 [ERROR] Aborting

121003 22:07:31 [Note] e:\xampp\mysql\bin\mysqld.exe: Shutdown complete

What am I missing? HOW to fix this issue?

share|improve this question

migrated from stackoverflow.com Oct 4 '12 at 5:37

This question came from our site for professional and enthusiast programmers.

    
Did you changed any parameter in php.ini or any core files before mysql shutdown –  gowri Oct 3 '12 at 17:17
    
@gowri it happens in 1 sec. I can't even see mysql running indicator. No, I haven't change anything –  user978733 Oct 3 '12 at 17:18
1  
I plugged in your error message to google and the first result? serverfault.com/questions/379714/… –  BryanH Oct 3 '12 at 17:21
    
@BryanH I agree with you, but then again I must admin that it is a development tool in this context... –  ixe013 Oct 3 '12 at 17:21

1 Answer 1

up vote 1 down vote accepted
  1. Stop MySQL

  2. Make the configuration change to the log file size.

  3. Delete both log files.

  4. Start MySQL. It will complain about the lack of log files, but it'll create them and all will be well.

    innodb_buffer_pool_size = 2560M
    innodb_log_file_size    = 256M
    innodb_log_buffer_size  = 8M
    innodb_flush_log_at_trx_commit  = 2
    innodb_thread_concurrency   = 16
    innodb_flush_method = O_DIRECT

move innodb old log files and restart the Mysql Server

mv ib<filenames> ib<filenames>.old 
share|improve this answer
    
doesn't help. same errors. no success –  user978733 Oct 3 '12 at 18:05
    
move innodb old log files and restart the Mysql Server mv ib<filenames> ib<filenames>.old –  Rush Oct 3 '12 at 18:07
    
Paste here your innodb configuration! –  Rush Oct 3 '12 at 18:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.