Documentation Home
MySQL Internals Manual
Download this Manual
EPUB - 0.8Mb


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
Sign Up Login You must be logged in to post a comment.