mysqldump: how to use a specific port

The default port of MySQL and MariaDB is 3306. Because of that, mysqldump also uses 3306 as default port.

In case you want to use a different port when running mysqldump, all you need to do is include the --port flag (or -P) in the command.

# Using the --port flag
mysqldump my_database --port=12345 > my_backup.sql

# Using the -P flag
mysqldump my_database -P 12345 > my_backup.sql

After running the command from the example above, mysqldump will try to connect using the port 12345 instead of the default one.

In case you want to use -P instead of --port, remember to use a capital P because -p means password, not port.

In case you want to backup a remote database, here we have a full article about that.