Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Tools to Manage MySQL Server

By: FYIcenter.com

(Continued from previous topic...)

What Tools Available for Managing MySQL Server?

MySQL comes with the following programs as administration tools for you to manage your MySQL server:

  • mysqld - MySQL server daemon. You can use "mysqld" to start your MySQL server.
  • mysqladmin - A command-line interface for administrators to perform server administration tasks.
  • 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.

(Continued on next topic...)

  1. What Tools Available for Managing MySQL Server?
  2. What Is "mysqld"?
  3. What Is "mysqladmin"?
  4. How To Check Server Status with "mysqladmin"?
  5. How To Shut Down the Server with "mysqladmin"?
  6. What Is "mysql"?
  7. How To Use "mysql" to Run SQL Statements?
  8. How To Show All Tables with "mysql"?
  9. What Is "mysqlcheck"?
  10. How To Analyze Tables with "mysqlcheck"?
  11. What Is "mysqlshow"?
  12. How To Show Table Names with "mysqlshow"?
  13. What Is "mysqldump"?
  14. How To Dump a Table to a File with "mysqldump"?
  15. What Is "mysqlimport"?
  16. How To Load Data Files into Tables with "mysqlimport"?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...