SQL DUMP CLI |||

Rupak Basnet — Mon, 23 Feb 2026 11:12:37 +0000

Showing how to use the SQL CLI to dump, backup, and restore a MySQL database, including tables, triggers, stored procedures, and events. This is perfect for developers who want a complete mysqldump workflow.

Dump Only Tables + Data

mysqldump -u root -p capital_test_db > backup_tables.sql

backup_tables.sql → contains tables and their data only

Dump Full Database (Tables + Data + Triggers + Procedures + Events)

mysqldump -u root -p \
  --routines \
  --triggers \
  --events \
  capital_test_db > backup_full.sql

backup_full.sql → contains everything

Verify Dump Contents

Check triggers, procedures, events (for full dump only)

grep -E "CREATE TRIGGER|CREATE PROCEDURE|CREATE EVENT" backup_full.sql

Create Target Database

mysql -u root -p
CREATE DATABASE capital_clone;
exit;

Import Dump into Target Database

For tables + data only

mysql -u root -p capital_clone < backup_tables.sql

For full database

mysql -u root -p capital_clone < backup_full.sql

Optional: Enable Event Scheduler

mysql -u root -p
SET GLOBAL event_scheduler = ON;
exit;

capital_clone now has tables + data, or full database depending on which dump you imported.

DEV Community: Rupak Basnet

SQL DUMP CLI |||

Check triggers, procedures, events (for full dump only)

For tables + data only

For full database