Amit Dhamu

Software Engineer

Helpful mysqldump Commands

# Dump a database
➜ mysqldump -u amit -p db1 > /tmp/db1.sql

# Dump multiple databases
➜ mysqldump -u amit -p --databases db1 db2 > /tmp/db1_db2.sql

# Dump all databases
➜ mysqldump -u amit -p --all-databases > /tmp/all_databases.sql

# Dump a table
➜ mysqldump -u amit -p db1 table1 > /tmp/db1.table1.sql

# Dump multiple tables
➜ mysqldump -u amit -p db1 table1 table2 > /tmp/db1.table1_table2.sql

# Dump structure only
➜ mysqldump -u amit -d -p db1 table1 > /tmp/db1_structure.sql

# Dump table data without create table syntax
➜ mysqldump -u amit -p --no-create-info db1 table1 > /tmp/db1.table1.sql

# Dump table data with query and without create table syntax
➜ mysqldump -u amit -p --no-create-info --where=gender='female' db1 table1 > /tmp/db1.table1.sql

# Dump with gzip
➜ mysqldump -u amit -p db1 table1 | gzip > /tmp/db1.table1.sql.gz

# Dump from remote database
➜ mysqldump -u amit -h 192.168.100.99 -p db1 table1 > /tmp/db1.table1.sql

# Restoring from a SQL file
➜ mysql -u amit -p db1 < /tmp/db1.table1.sql

# Restoring from gzip
➜ gunzip < /tmp/db1.table1.sql.gz | mysql -u amit -p db1

# Output a single table to CSV
➜ mysqldump -u amit -p -t --fields-terminated-by=, -T/tmp db1 table1

 mysql / mysqldump

Handy Docker CommandsmacOS - Get Serial Number

Show Comments

Made with by Amit Dhamu.
© MMXX. All rights reserved.