Connecting to MySQL Port in mysqldump

The mysqldump command is used in MySQL to create backups of databases. It allows you to dump a MySQL database into a file, which can later be used to restore the database if needed. One of the options available is -P (or --port=), which specifies the port number to connect to when performing the dump operation.

Connecting to MySQL Port in mysqldump: The -P option in mysqldump allows you to specify the port number of the MySQL server. This is particularly useful when your MySQL server is running on a non-default port, such as when you have multiple MySQL instances on the same machine.

Example 1: Dump a database from a MySQL server running on port 3307.
mysqldump -P 3307 -u root -p mydatabase > mydatabase_backup.sql
This command connects to the MySQL server running on port 3307 with the username ‘root’, prompts for the password, and dumps the ‘mydatabase’ database into a file named ‘mydatabase_backup.sql’.

Example 2: Dump a database from a MySQL server running on a custom port 8888.
mysqldump --port=8888 -u user -p password mydatabase > mydatabase_backup.sql
Here, the --port=8888 option specifies that the MySQL server is running on port 8888. Replace ‘user’ and ‘password’ with your MySQL username and password, respectively.

Example 3: Dump a database using an environment variable for the port.
export MYSQL_TCP_PORT=3306; mysqldump -u user -p password mydatabase > mydatabase_backup.sql
This command sets the port using the MYSQL_TCP_PORT environment variable (in this case, port 3306) and then performs the database dump.

Verification: To verify that the example commands executed successfully, check the generated backup file (e.g., mydatabase_backup.sql) for its size and content. You can also try importing the backup file into another MySQL instance to ensure it contains the expected data.

Also check similar articles.

Providing Password for mysqldump Connection
Sorting Rows by Primary Key in mysqldump Output
Enabling Optimization Options in mysqldump
Skipping SET NAMES Statement in mysqldump Output
Not Including Data Rows in mysqldump Output