Including Master Host and Port in mysqldump Output (Deprecated)

The mysqldump command in MySQL is used to create a backup of MySQL databases. The option --include-master-host-port, although deprecated, was previously used to include the master host and port information in the output generated by mysqldump. This information was particularly useful for replication setups where it was necessary to know the master’s connection details.

Here are several examples demonstrating the usage of --include-master-host-port in different scenarios:

Example 1: Dump a single database with master host and port information included:
mysqldump --include-master-host-port -u username -p database_name > backup.sql
This command exports database_name including the master host and port details into backup.sql.

Example 2: Dump all databases from the server with master host and port information:
mysqldump --all-databases --include-master-host-port -u username -p > alldatabases_backup.sql
This command backs up all databases on the server along with master host and port details into alldatabases_backup.sql.

Example 3: Export a specific table including master host and port information:
mysqldump --include-master-host-port -u username -p database_name table_name > table_backup.sql
This command dumps table_name from database_name with master host and port details into table_backup.sql.

Example 4: Dump a database excluding master host and port information (for comparison):
mysqldump -u username -p database_name > backup_without_master_info.sql
This command creates a backup of database_name without including master host and port information.

To verify if the --include-master-host-port option has been applied correctly, you can open the generated SQL file (.sql) using a text editor. Look for comments or specific entries that indicate the master host and port details are included in the dump. For example, you might find lines like:

-- Host: 'master_host_name'    Database: 'database_name'
-- MySQL dump 10.18  Distrib 10.3.32-MariaDB, for debian-linux-gnu (x86_64)
-- Host: master_host_name    Database: database_name
-- ------------------------------------------------------
-- Server version 10.3.32-MariaDB
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
        

Also check similar articles.

Including Source Host and Port in mysqldump Output
Ignoring Tables During mysqldump
Ignoring Errors During mysqldump
Connecting to MySQL Host in mysqldump
Dumping BLOBs in Hexadecimal Format with mysqldump