Monday, January 14, 2013

MySQL Clients and non-clients programs.

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).


No comments:

Post a Comment