mysqldump

Updated: 25 February 2026

Backup database via a non-standard port

mysqldump -u root -h 127.0.0.1 -P 3318 -pRootPassword the_database > the_backup.sql

Backup a single table

mysqldump -u the_user -h localhost -pThePassWord db_name_here table_name_here > table_name.sql

Backup data only (no CREATE DATABASE or CREATE TABLE statements)

mysqldump --no-create-db --no-create-info db_name > db_name.sql