mysqldump

Updated: 04 December 2024

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 statements. No CREATE TABLE statements

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