...

View Full Version : MySQL don't start even manually



ranger
02-03-2013, 01:17 PM
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

djm0219
02-03-2013, 02:48 PM
What error are you getting? Have you checked the .err file?

ranger
02-07-2013, 08:32 AM
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 (http://www.worldsupport.jp/MySQL-error.txt)


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

Thanks.

djm0219
02-07-2013, 12:40 PM
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.

ranger
02-08-2013, 04:18 AM
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 (http://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 (http://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

ranger
02-12-2013, 10:07 AM
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 (http://www.worldsupport.jp/errmsg-utf8.txt)


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

BubikolRamios
02-12-2013, 11:08 AM
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 ?

ranger
02-13-2013, 01:02 PM
That's one thing that puzzles me. How come it terminates it, when the service isn't even running....?
I have the 32 version.

BubikolRamios
02-13-2013, 10:27 PM
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.

ranger
02-14-2013, 10:05 AM
it's not running, it doesn't appear in the task manager

BubikolRamios
02-14-2013, 04:28 PM
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.

ranger
02-15-2013, 05:06 AM
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...?

BubikolRamios
02-15-2013, 10:42 AM
What exactly are these files/keys...?

Do you realy expect me to know ?

As I said before , get a decent uninstaler.

ranger
02-23-2013, 03:46 AM
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...

ranger
02-27-2013, 01:18 PM
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...



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum