471,083 Members | 1,017 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,083 software developers and data experts.

Proper way to start and shutdown database

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
Jul 19 '05 #1
2 20025
"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
Jul 19 '05 #2
"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
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Tim B. | last post: by
3 posts views Thread by geskerrett | last post: by
reply views Thread by rabbit | last post: by
9 posts views Thread by SAL | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.