On Mar 12, 1:37 pm, Luuk <L...@invalid.lan> wrote:
> newbie schreef:
>
>
>
> > On Mar 12, 12:07 pm, Luuk <L...@invalid.lan> wrote:
> >> newbie schreef:
>
> >>> On Mar 12, 11:50 am, Luuk <L...@invalid.lan> wrote:
> >>>> newbie schreef:
> >>>>> On Mar 12, 11:18 am, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
> >>>>>> On Wed, 12 Mar 2008 19:09:42 +0100, newbie <nordies_1...@yahoo.com> wrote:
> >>>>>>> On Mar 12, 10:50 am, Luuk <L...@invalid.lan> wrote:
> >>>>>>>> newbie schreef:
> >>>>>>>>> I wonder if someone can lend me a hand here? I dont have any database
> >>>>>>>>> experience.
> >>>>>>>>> I used this
> >>>>>>>> link=http://dev.mysql.com/doc/refman/5.0/en/windows-server-
> >>>>>>>>> first-start.html
> >>>>>>>>> I used this command:
> >>>>>>>>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console
> >>>>>>>>> I got this error, and i dont know how to respond to fix it. I do use
> >>>>>>>>> anti virus.
> >>>>>>>>> InnoDB operating system error number 32 in a file operation
> >>>>>>>>> InnoDB the error meabs that another program is using InnoDB s file
> >>>>>>>>> name
> >>>>>>>>> InnoDB of mysql please close it to get rid of this error
> >>>>>>>>> This might be a back or antivirus software or another instance
> >>>>>>>>> Can anyone please help me?
> >>>>>>>>> Andrew
> >>>>>>>> try:
> >>>>>>>> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql"
> >>>>>>>> probabley MySQL is already running
> >>>>>>>> at the end of the error-message is "or another instance"....
> >>>>>>> hmm i typed in mysql and it said it wanted switches...
> >>>>>>> i typed in mysql \h and i got all the switches for other parameters.
> >>>>>>> ok now i did this sounds like it s running? but what can i give as a
> >>>>>>> command to see the server is running?
> >>>>>> Usually it's registered as a service, and you can see it running there.
> >>>>>> Just try a 'mysql' (without any switches), if you get a response,
> >>>>>> especially something about missing or wrong credentials, the mysql deamon
> >>>>>> is definitely running :P
> >>>>>> Most common switches would be -u for username, -p for password, -h for
> >>>>>> host.
> >>>>>> --
> >>>>>> Rik Wasmus
> >>>>> Thank you for your post.
> >>>>> I looked in the control panel for installed software and the mysql
> >>>>> server is there.
> >>>>> When i loaded the software i noticed it was loading the server,
> >>>>> command shell, command utils and server instance config
> >>>>> When i go into control panel and go into services i see that there is
> >>>>> no mysql service listed there.
> >>>>> Now i am REALLY confused. Everything seems to logical and up front but
> >>>>> its not working as expected?
> >>>>> Now i am thinking now what? I dont any idea of what to do next?...help!
> >>>> try running:
> >>>> mysqladmin version
> >>>> if you see this:
> >>>> mysqladmin: connect to server at 'localhost' failed
> >>>> error: 'Access denied for user 'ODBC'@'localhost' (using password:
> >>>> NO)'
> >>>> this will mean MySQL is running, even if it does not show in SERVICES.
> >>>> if it is running type:
> >>>> mysql -u root
> >>>> you should get the mysql-prompt.
> >>>> (unless there is a default password in a Windows config... )
> >>>> --
> >>>> Luuk
> >>> Say, that was really helpful! thanks
> >>> I got error, cant connect to mysql server on local host 10061
> >>> check that mysql is running on local host and that the port is 3306.
> >>> It says that you can check this by doing a telnet local host 3306.
> >>> May i ask what to do now that we know the server isnt running?
> >> this:
> >> netstat -anb | findstr /i "mysql"
>
> >> should show something like:
> >> TCP 127.0.0.1:3306 127.0.0.1:3595 TIME_WAIT 0
> >> [mysqld.exe]
> >> (especially the ":3306" is important here ...)
>
> >> if this line does not show,( or no lines shows), than MySQL is not running.
>
> >> --
> >> Luuk
>
> > Luuk,
> > You are correct! using that cool netstat command resulted in no mysql
> > running!
> > Well i thought that if i ran the download to install the db then
> > everything would be present.
> > I know there is software installed on the hard drive. In the pc OS
> > registry, i see software from mysql.....
> > So could i ask ? now that we know its not running? how do we get the
> > server up and running?
>
> i googled the error message:http://www.google.com/search?source=...oDB+operating+...
> (or this one:http://tinyurl.com/29gk44)
>
> the first link is this:http://bugs.mysql.com/bug.php?id=9709
>
> its a long story, so i did not read the entire story ;-)
>
> --
> Luuk

Luuk,
Thank you for your help. Ok, i finally figured it out. But i dont have
an answer yet.
I learned that the anti virus is stopping the server. It will start
according to the event viewer then shut down.
The solution is to kill the processes then go into services in control
panel and stop the services related to the anti virus.
Then go back to the database and it will run normally if you run
this=> C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt --
console

Now i just go to figure out how to tell the anti virus to let this one
run.....

Thank you too all who posted. I hope others reading this will use this
information.

Andrew