Common maintenance management tools for MySQL

MySQL is a very popular small relational database management system. Currently, MySQL is widely used in small and medium Web sites on the Internet. Because of its small size, speed, the total cost of ownership is low, especially the characteristics of open source, many small and medium-sized Web sites in order to reduce the total cost of ownership of the site to choose MySQL as a Web site database.

MySQL Management maintenance tools are very many, in addition to the system with the command line management tools, there are many other graphical management tools, here I introduce five I often use the MySQL graphical management tools for your reference.

1, phpMyAdmin

phpMyAdmin is the most common MySQL maintenance tool, is a PHP development based on the web-style architecture on the Web site MySQL management tools, support Chinese, management database is very convenient. The disadvantage is that it is inconvenient to backup and restore large databases.

2, Mysqldumper

Mysqldumper use PHP to develop the MySQL database backup recovery program, to solve the use of PHP for large database backup and recovery problem, hundreds of trillion database can be convenient backup recovery, do not worry about slow speed caused intermediate interruption of the problem, very user-friendly. The software is developed by the Germans and has no Chinese language packs.