|
Explain the tools that are available for managing MySQL Server.Following are the tools to manage MySQL server:
mysqld - MySQL server daemon. It is used to start the mysql server.
mysqladmin – Used to perform administrative tasks.
Example:
Mysqladmin shutdown – Used to shut down mysql server.
Mysqladmin ping – check the alive status of the server.
Mysqladmin version – to check version of mysql server.
mysql - A command-line interface for end users to manage user data objects.
mysqlcheck - A command-line interface for administrators to check and repair tables.
mysqlshow - A command-line interface for end users to see information on tables and columns.
mysqldump - A command-line interface for administrators or end users to export data from the server to files.
mysqlimport - A command-line interface for administrators or end users to load data files into tables program tool to load data into tables.
|
