Re: What Is This Error & How Can I Correct It & Start MYSQL Server???

Steve,

it is working ok now. The program mysqld is the SERVER and it is ready to
serve your SQL connections from clients.

Now you can try connecting to mysqld with the interactive mysql client:

C:\mysql\bin>mysql test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.12-max-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table stevestable (a int) type = innodb;
Query OK, 0 rows affected (0.06 sec)

mysql> insert into stevestable values (100);
Query OK, 1 row affected (0.00 sec)

mysql> select * from stevestable;
+------+
| a    |
+------+
|  100 |
+------+
1 row in set (0.03 sec)

mysql>

Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and InnoDB Hot Backup: a non-free hot backup
tool for MySQL
Order MySQL technical support from https://order.mysql.com/



----- Original Message ----- 
From: "Thatguy Steve" <thatguy_steve@xxxxxxxxxxx>
Newsgroups: mailing.database.mysql-win32
Sent: Sunday, August 24, 2003 6:59 AM
Subject: Re: What Is This Error & How Can I Correct It & Start MYSQL
Server???


> Heikki,
>
> Thanks for the quick reply.
>
> I found mysqld running in the task list so I killed it and re-ran with
> the --console command and got the following messages returned.  It just
sits
> there noot doing anything.  When I press the enter key, nothing happes,
like
> it's hung.  Any ideas?
>
> ******************************************
> Microsoft Windows 2000 [Version 5.00.2195]
> (C) Copyright 1985-2000 Microsoft Corp.
>
> C:\mysql\bin>mysqld --console
> 030823 23:54:17  InnoDB: Database was not shut down normally.
> InnoDB: Starting recovery from log files...
> InnoDB: Starting log scan based on checkpoint at
> InnoDB: log sequence number 0 43892
> InnoDB: Doing recovery: scanned up to log sequence number 0 43892
> 030823 23:54:18  InnoDB: Flushing modified pages from the buffer pool...
> 030823 23:54:18  InnoDB: Started
> mysqld: ready for connections.
> Version: '4.0.14-max-debug'  socket: ''  port: 3306
>
>
>
> ""Heikki Tuuri"" <Heikki.Tuuri@xxxxxxxxxx> wrote in message
> news:bi93bg$2m8j$1@xxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Steve,
> >
> > I realize strerror() does not return the right error string for Windows
> > error codes. That is why it below claims the error is 'Broken pipe'. I
> have
> > now corrected this to 4.0.15.
> >
> > http://www.innodb.com/ibman.html#OS_Error_codes says:
> >
> > 32 The process cannot access the file because it is being used by
another
> > process. ERROR_SHARING_VIOLATION
> >
> > You probably still have the mysqld process running in your computer and
> that
> > has opened the ibdata1 file. You can try killing the mysqld process with
> the
> > Task Manager and then run
> >
> > mysqld --console
> >
> > to see what mysqld prints.
> >
> > If mysqld works, shut it down:
> >
> > mysqladmin shutdown
> >
> > and retry making mysqld a service.
> >
> > Heikki Tuuri
> > Innobase Oy
> > http://www.innodb.com
> > Transactions, foreign keys, and a hot backup tool for MySQL
> >
> > ----- Original Message ----- 
> > From: "Thatguy Steve" <thatguy_steve@xxxxxxxxxxx>
> > Newsgroups: mailing.database.mysql-win32
> > Sent: Sunday, August 24, 2003 12:05 AM
> > Subject: Re: What Is This Error & How Can I Correct It & Start MYSQL
> > Server???
> >
> >
> > > I also found this additional information in my mysql\data\ibdata1 file
> > >
> > > *******************************************
> > > 030823 16:35:48  InnoDB: Database was not shut down normally.
> > > InnoDB: Starting recovery from log files...
> > > InnoDB: Starting log scan based on checkpoint at
> > > InnoDB: log sequence number 0 43892
> > > InnoDB: Doing recovery: scanned up to log sequence number 0 43892
> > > 030823 16:35:48  InnoDB: Flushing modified pages from the buffer
pool...
> > > 030823 16:35:48  InnoDB: Started
> > > mysqld: ready for connections.
> > > Version: '4.0.14-max-debug'  socket: ''  port: 3306
> > > 030823 16:38:43  InnoDB: Operating system error number 32 in a file
> > > operation.
> > > InnoDB: See http://www.innodb.com/ibman.html for installation help.
> > > InnoDB: Error number 32 means 'Broken pipe'.
> > > InnoDB: See also section 13.2 at http://www.innodb.com/ibman.html
> > > InnoDB: about operating system error numbers.
> > > InnoDB: File name .\ibdata1
> > > InnoDB: File operation call: 'open'.
> > > InnoDB: Cannot continue operation.
> > >
> > >
> > >
> > > "Thatguy Steve" <thatguy_steve@xxxxxxxxxxx> wrote in message
> > > news:lY-dnTKylNZbSNqiU-KYgw@xxxxxxxxxxxxxx
> > > > I installed the latest verion of MYSQL, installed the server as a
> > service,
> > > > but it failed to start.
> > > >
> > > > I  then ran the --console option to get some additional information
> (see
> > > > below).  I went to the innodb site but got nowhere.
> > > >
> > > > Any and all help would be greatly appreciated.
> > > >
> > > > Thanks,
> > > >
> > > > Steve
> > > >
> > > > ***********************************
> > > >
> > > > Microsoft Windows 2000 [Version 5.00.2195]
> > > > (C) Copyright 1985-2000 Microsoft Corp.
> > > >
> > > > C:\mysql\bin>mysqld --install
> > > > Service successfully installed.
> > > >
> > > > C:\mysql\bin>mysqld --remove
> > > > Service successfully removed.
> > > >
> > > > C:\mysql\bin>mysqld --console
> > > > 030823 16:40:09  InnoDB: Operating system error number 32 in a file
> > > > operation.
> > > > InnoDB: See http://www.innodb.com/ibman.html for installation help.
> > > > InnoDB: Error number 32 means 'Broken pipe'.
> > > > InnoDB: See also section 13.2 at http://www.innodb.com/ibman.html
> > > > InnoDB: about operating system error numbers.
> > > > InnoDB: File name .\ibdata1
> > > > InnoDB: File operation call: 'open'.
> > > > InnoDB: Cannot continue operation.
> > > >
> > > > C:\mysql\bin>
> > > >
> > > >
> > >
> > >
> >
> >
> >
> > -- 
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> http://lists.mysql.com/win32?unsub=mysql-win32@xxxxxxxxxxxxxxxxxxxxxxxx
> >
>
>



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=gcdmw-win32@xxxxxxxxxxx