Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 15 of 15
  1. #1
    New Coder
    Join Date
    Jan 2004
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question MySQL don't start even manually

    I can't start MySQL 5.5 server even manually from cmd prompt, when I go to /bin folder and run "mysqld.exe --console"

    The paths in my.ini file are all correct.

    What could be the problem...?

    Thanks

  • #2
    Senior Coder djm0219's Avatar
    Join Date
    Aug 2003
    Location
    Wake Forest, North Carolina
    Posts
    1,307
    Thanks
    4
    Thanked 205 Times in 202 Posts
    What error are you getting? Have you checked the .err file?
    Dave .... HostMonster for all of your hosting needs

  • #3
    New Coder
    Join Date
    Jan 2004
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    OK, I'm not sure which is the error log file (I'm on win XP).

    In case it's "mysqld_error.h", I posted it's content here:

    www.worldsupport.jp/MySQL-error.txt


    So, does this help to figure out where the problem is..?

    Thanks.

  • #4
    Senior Coder djm0219's Avatar
    Join Date
    Aug 2003
    Location
    Wake Forest, North Carolina
    Posts
    1,307
    Thanks
    4
    Thanked 205 Times in 202 Posts
    That's not it, that's a header file for compiling C programs. The error file should have a file extension of err and be in the MySQL data directory.
    Dave .... HostMonster for all of your hosting needs

  • #5
    New Coder
    Join Date
    Jan 2004
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It seems there's no such a file. I did a *err* search in the mysql directory; the printscreen is here:

    www.worldsupport.jp/MySQL.gif
    (zoom in to see 100% size)


    I don't know if it helps with anything, but I posted the content of the errmsg.sys file here:

    www.worldsupport.jp/errmsg.txt


    If the error log file should be somewhere (while it doesn't exist now), should the location, etc. be specified in the configuration file or somewhere..?

    Thanks

  • #6
    New Coder
    Join Date
    Jan 2004
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi again,
    Here's the print screen- I'm sorry it's in Japanese.
    http://www.worldsupport.jp/MySQL-err_mess.gif

    The first error message says that the service mysqld.exe will be terminated, sorry for the inconvenience, send or not the report to Microsoft, bla bla..

    It says to press the blue link which I do, then I get the second error message, which is below in the print-screen image.

    Then it says to press the first blue link, for technical information; so then I get the window in the third print-screen.

    It's a long text but unfortunately it can't be copied in the clipboard.
    It's made a reference to the 'errmsg-utf8.txt' file.

    I uploaded the content of this file:
    www.worldsupport.jp/errmsg-utf8.txt


    Could you think of a solution for this..?
    Any hints appreciated.
    Thanks.

  • #7
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,992
    Thanks
    120
    Thanked 76 Times in 76 Posts
    first error message says that the service mysqld.exe will be terminated
    http://dev.mysql.com/downloads/mysql/5.5.html#downloads


    do you have right 32/64 version installed ?
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search

  • #8
    New Coder
    Join Date
    Jan 2004
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That's one thing that puzzles me. How come it terminates it, when the service isn't even running....?
    I have the 32 version.

  • #9
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,992
    Thanks
    120
    Thanked 76 Times in 76 Posts
    so, I remember troubles like this last time I installed mysql on win.

    The thing is, you have to remove all previous instalations COMPLETELY !
    Even if this, that you have now, got corrupted it goes the same as in previous statement.

    Completely means, everything relevant from registry, data folder, program folder, user folder ,...
    Windows built in uninstall will not do that.

    Use some of uninstalers that are plenty outthere.

    Reboot, repeat upper instructions, Reinstall.

    Repeat upper instructions severel times, if not working first time, until you succeed.

    Unfortunately I don't have bulletproof recipe to do all that.
    Last edited by BubikolRamios; 02-13-2013 at 11:30 PM.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search

  • #10
    New Coder
    Join Date
    Jan 2004
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    it's not running, it doesn't appear in the task manager

  • #11
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,992
    Thanks
    120
    Thanked 76 Times in 76 Posts
    The point is, it will not run for whatewer reason, you are not geting anywhere (error message are sometimes totaly obscure, as in your case), finding the reason is futile & pointless.
    And yeah, check the folders where it is installed, if they are mybe read only.

    Remove, reinstall.

    This is the quickest way.
    Last edited by BubikolRamios; 02-14-2013 at 05:37 PM.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search

  • #12
    New Coder
    Join Date
    Jan 2004
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    OK, then, so I'll do.
    As I understand, I have to remove everything completely before a new reinstall, including some files and registry keys that the uninstaller doesn't remove.
    What exactly are these files/keys...?

  • #13
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,992
    Thanks
    120
    Thanked 76 Times in 76 Posts
    What exactly are these files/keys...?
    Do you realy expect me to know ?

    As I said before , get a decent uninstaler.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search

  • #14
    New Coder
    Join Date
    Jan 2004
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I reinstalled from scratch MySQL server and after the fresh reinstallation I still can't start it.

    When I try to start it from the Services, the error is now: "Error 1067 the process terminated unexpectedly"

    I don't understand what the cause may be...

  • #15
    New Coder
    Join Date
    Jan 2004
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    OK, I did the following command from the Command prompt

    C:\>"Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\my.ini" --console

    and here's the result:

    130227 20:15:41 [Note] Plugin 'FEDERATED' is disabled.
    130227 20:15:41 InnoDB: The InnoDB memory heap is disabled
    130227 20:15:41 InnoDB: Mutexes and rw_locks use Windows interlocked functions
    130227 20:15:41 InnoDB: Compressed tables use zlib 1.2.3
    130227 20:15:41 InnoDB: Initializing buffer pool, size = 42.0M
    130227 20:15:41 InnoDB: Completed initialization of buffer pool
    InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
    InnoDB: than specified in the .cnf file 0 10485760 bytes!
    130227 20:15:41 [ERROR] Plugin 'InnoDB' init function returned error.
    130227 20:15:41 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

    130227 20:15:41 [ERROR] Unknown/unsupported storage engine: INNODB
    130227 20:15:41 [ERROR] Aborting

    130227 20:15:41 [Note] Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete


    I don't understand where the problem is.. and what I should do...


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •