Documentation Home
MySQL Internals Manual


MySQL Internals Manual  /  ...  /  The scripts Directory

A.1.26 The scripts Directory

SQL batches, for example, mysqlbug and mysql_install_db.

The *.sh filename extension stands for "shell script". Linux programmers use it where Windows programmers would use a *.bat (batch filename extension).

Some of the *.sh files on this directory are:

  • fill_help_tables.sh --- Create help-information tables and insert

  • make_binary_distribution.sh --- Get configure information, make, produce tar

  • msql2mysql.sh --- Convert (partly) mSQL programs and scripts to MySQL

  • mysqlbug.sh --- Create a bug report and mail it

  • mysqld_multi.sh --- Start/stop any number of mysqld instances

  • mysqld_safe-watch.sh --- Start/restart in safe mode

  • mysqld_safe.sh --- Start/restart in safe mode

  • mysqldumpslow.sh --- Parse and summarize the slow query log

  • mysqlhotcopy.sh --- Hot backup

  • mysql_config.sh --- Get configuration information that might be needed to compile a client

  • mysql_convert_table_format.sh --- Conversion, for example, from ISAM to MyISAM

  • mysql_explain_log.sh --- Put a log (made with --log) into a MySQL table

  • mysql_find_rows.sh --- Search for queries containing <regexp>

  • mysql_fix_extensions.sh --- Renames some file extensions, not recommended

  • mysql_fix_privilege_tables.sh --- Fix mysql.user etc. when upgrading. Can be safely run during any upgrade to get the newest MySQL privilege tables

  • mysql_install_db.sh --- Create privilege tables and func table

  • mysql_secure_installation.sh --- Disallow remote root login, eliminate test, etc.

  • mysql_setpermission.sh --- Aid to add users or databases, sets privileges

  • mysql_tableinfo.sh --- Puts info re MySQL tables into a MySQL table

  • mysql_zap.sh --- Kill processes that match pattern


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.