Proper way to start and shutdown database

[Asad Khan]

What is the proper way to start and shutdown a database? I'm asking this
because of the following:

C:\Program Files\MySQL\afterinstall\bin>mysqld --console
031028 12:25:25 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 176672
InnoDB: Doing recovery: scanned up to log sequence number 0 176672
031028 12:25:26 InnoDB: Flushing modified pages from the buffer pool...
031028 12:25:26 InnoDB: Started
mysqld: ready for connections.
Version: '4.0.14-max-debug' socket: '' port: 3306

[Benoit St-Jean]

"Asad Khan" <ai****@hotmail.com> wrote in message news:<tI*******************@news04.bloor.is.net.ca ble.rogers.com>...

What is the proper way to start and shutdown a database? I'm asking this
because of the following:

C:\Program Files\MySQL\afterinstall\bin>mysqld --console
031028 12:25:25 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 176672
InnoDB: Doing recovery: scanned up to log sequence number 0 176672
031028 12:25:26 InnoDB: Flushing modified pages from the buffer pool...
031028 12:25:26 InnoDB: Started
mysqld: ready for connections.
Version: '4.0.14-max-debug' socket: '' port: 3306

Well, either stop the service or use :
mysqladmin shutdown

See: http://www.mysql.com/doc/en/mysqladmin.html

Hope this helps

[Benoit St-Jean]

"Asad Khan" <ai****@hotmail.com> wrote in message news:<tI*******************@news04.bloor.is.net.ca ble.rogers.com>...

What is the proper way to start and shutdown a database? I'm asking this
because of the following:

C:\Program Files\MySQL\afterinstall\bin>mysqld --console
031028 12:25:25 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 176672
InnoDB: Doing recovery: scanned up to log sequence number 0 176672
031028 12:25:26 InnoDB: Flushing modified pages from the buffer pool...
031028 12:25:26 InnoDB: Started
mysqld: ready for connections.
Version: '4.0.14-max-debug' socket: '' port: 3306

Well, either stop the service or use :
mysqladmin shutdown

See: http://www.mysql.com/doc/en/mysqladmin.html

Hope this helps