bashANYmysqldumpbackupdatabase
bash
mysqldump -u root -p --databases app_db > app_db.sqlA standard logical backup command for development, migration, and restore workflows.
MySQL Backup, Restore, Import, and Export Cheatsheet
mysqldump, mysql restore, load data infile, select into outfile, mysqlimport, and MySQL Shell dump/load workflows.
Export
Copy the compact sheet, download it, or print it.
Download
`D` dense toggle · `C` copy all
mysqldump and restore
Portable logical backups with mysqldump and reload patterns.
bashANYmysqldumptable
bash
mysqldump -u root -p app_db users > users.sqlUseful for debugging, selective migrations, or sharing one dataset slice.
bashANYmysqldumpschema-only
bash
mysqldump -u root -p --no-data app_db > app_db-schema.sqlCommon when you want table definitions for code review or environment bootstrapping.
bashANYmysqldumpdata-only
bash
mysqldump -u root -p --no-create-info app_db > app_db-data.sqlHandy when the schema already exists and you only need data.
bashANYrestoresqlimport
bash
mysql -u root -p app_db < app_db.sqlThis replays the SQL statements in the dump file against the target database.
imports, exports, and mysql shell utilities
CSV import/export and higher-throughput dump tooling patterns.
sqlANYoutfilecsvexport
sql
SELECT id, email
INTO OUTFILE '/var/lib/mysql-files/users.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '
'
FROM users;Requires file privileges and uses a path writable by the server.
sqlANYload-datacsvimport
sql
LOAD DATA INFILE '/var/lib/mysql-files/users.csv'
INTO TABLE users_staging
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '
'
IGNORE 1 LINES
(email, full_name);Much faster than many single-row inserts for bulk imports.
bashANYmysqlimportcsv
bash
mysqlimport -u root -p --local --fields-terminated-by=, app_db users.csv`mysqlimport` is a wrapper around `LOAD DATA` semantics.
bashANYmysqlshdump-instancebackup
bash
mysqlsh root@localhost -- util dump-instance /backups/mysql-instanceMySQL Shell dump utilities support advanced dump and load workflows beyond classic mysqldump.
bashANYmysqlshload-dumprestore
bash
mysqlsh root@localhost -- util load-dump /backups/mysql-instanceUseful for parallelized and more automation-friendly restore workflows.
More in MySQL
MySQL Procedures, Triggers, and Events Cheatsheet
stored procedures, stored functions, delimiters, call, triggers, and scheduled events in MySQL.
MySQL Functions, JSON, and Date Cheatsheet
now, date_add, date_sub, date_format, timestampdiff, json_extract, json_set, json_object, concat, coalesce, and case in MySQL.
MySQL Users, Grants, and Privileges Cheatsheet
create users, alter passwords, grant privileges, show grants, revoke access, and manage MySQL accounts safely.
MySQL Transactions and Locking Cheatsheet
start transaction, commit, rollback, savepoints, select for update, isolation levels, and InnoDB lock troubleshooting.
MySQL Indexes, EXPLAIN, and Performance Cheatsheet
index design, show index, explain, explain analyze, analyze table, and practical performance tuning workflows in MySQL.
MySQL Aggregation and Window Functions Cheatsheet
group by, having, count, sum, avg, row_number, lag, running totals, and analytical query patterns in MySQL.