MySQL Clients:
In MySQL Client programs are programs that can be used for
communicating with the server to manipulate the information in the
databases that the server manages.
- MySQL Query Browser and MySQL Administrator are graphical front ends to the server.
- mysql is a command-line program that acts as a text-based front end for the server. It's used for issuing queries and viewing the results interactively from a terminal window.
- mysqlimport for importing data files.
- mysqldump for making backups.
- mysqladmin for server administration.
- mysqlcheck for checking the integrity of the database files.
MySQL non-clients:
In MySQL non-client utilities are programs that act
independently of the server. They do not operate by first establishing a
connection to the server. myisamchk is an example. It performs table checking and repair operations. Another program in this category is myisampack,
which creates compressed read-only versions of MyISAM tables. Both
utilities operate by accessing MyISAM table files directly, independent
of the mysqld (database server).
