Announcement

Announcement Module
Collapse
No announcement yet.

mysql restart problems....please help!!!

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql restart problems....please help!!!

    Hi guys,

    Got some problem with mysql startup. I apologize for mistakes but i'm new of mysql.. so i need some help.

    My machine:

    P4 3.0 ghz
    1024 mb ram
    1tb hdd
    windows server 2003
    Myisam

    I tried to configure the startup variables renaming my-huge.ini in my.ini.

    But when i restart the service from Mysql administrator i get an error like : could not reconnect... or restart, or something like tht.

    in the log the error is identified like this:

    InnoDB: Error: Log file .\ib_logfile0 is of different size 0 87031808 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    Cant initiate database.
    Aborting.

    When i start with the my.ini file tht was created after the first (default) installation mysql starts without problems.


    whats wrong with it.

    some help??

    thks

  • #2
    sounds like you have permission / filespace issues.

    Comment


    • #3
      Hi JGilbert,

      thks for your answer, i solved the matter erasing log file 0 and 1 from mysql folder.

      The biggest problem now is tht (like before) mysql takes my cpu to 99% of utilization even for just one simple query.

      I don't know how to optimize it...the system seems to hog!!

      some help please?

      thanks

      Comment

      Working...
      X