Problem description
In an RDS for MySQL instance, the mysql.help_topic table schema exists but contains no data. This causes commands such as HELP 'SELECT' to return an empty result.
This issue occurs in specific instances of MySQL 5.6 and 5.7. It does not affect database functionality. Only the built-in help system is unavailable.
Cause
mysql.help_topic is a core table for the MySQL built-in help system. It works with `help_category`, `help_keyword`, and `help_relation` to support the query capabilities of the `HELP` command. The table is used only for developer assistance. It is not involved in business SQL execution, transaction processing, or the high-availability mechanism. An empty table does not affect instance stability. For a more efficient instance initialization, the help data loading process might be skipped when some instances are created. Therefore, the table is empty by default.
If older instances contain data, it might be from an early image or a manual import by a user. This is not the standard behavior.
Solution
To enable the `HELP` command, you can manually import a script to populate the help tables.
Download and decompress the attachment fill_help_tables.sql.zip. This file contains the complete standard data for four tables, including
help_topic.Log on to the RDS for MySQL instance with a privileged account and import the attached SQL file into the database.
WarningThis script does not include a TRUNCATE operation. A privileged account cannot delete data from the `help_topic`, `help_category`, `help_keyword`, or `help_relation` tables in the MySQL metadatabase. Ensure that these four tables are empty. Otherwise, a primary key conflict will occur.
-- Switch to the mysql database USE mysql; -- Execute the script to import data (replace the path with the actual local path) SOURCE /path/to/fill_help_tables.sql;
Applies to
RDS for MySQL