Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorials - Administrator Tools for Managing MySQL Server

By: FYIcenter.com

A collection of 16 FAQs on MySQL administration tools. Clear answers are provided with tutorial exercises on server daemon; administrator and end user interfaces; checking and repairing tables; dumping and importing tables. Topics included in this collection are:

  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"?

Please note that all answers and tutorials are based on MySQL 5.0.

(Continued on next topic...)

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...