SQL Tutorial

57 / 60
   

Managing MySQL Database

Database management is done by Database Administrators (DBAs) who:

  • Maintain the infrastructure of the database
  • Maintain the storage of the database
  • Stop and start the database
  • Backup and restore the database
  • Tune the database for optimum performance
  • Grants to and revokes permissions from other users as needed

Database developers and end users don't need to perform these tasks. We will have a brief look at a few of the DBA tasks.

Starting MySQL Server:

  • MySQL Server binary mysqld is used to start the database server.
    root access is required.
    root$ /usr/bin/safe_mysqld &
  • To get database instance started at server boot:
    Edit file /etc/rc.local and add below line in the file:
    /etc/init.d/mysqld start
  • Process mysqld is core process of MySQL Server.

Shutting down MySQL Server:

Done using administrators tasks binary mysqladmin
root$ /usr/bin/mysqladmin -u root -p shutdown
Enter password: **