All Products
Search
Document Center

ApsaraDB RDS:The mysql.help_topic table in RDS for MySQL has no data

Last Updated:Nov 04, 2025

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.

  1. Download and decompress the attachment fill_help_tables.sql.zip. This file contains the complete standard data for four tables, including help_topic.

  2. Log on to the RDS for MySQL instance with a privileged account and import the attached SQL file into the database.

    Warning

    This 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