Save database dump

PHOTO EMBED

Mon Oct 04 2021 14:33:05 GMT+0000 (Coordinated Universal Time)

Saved by @dphillips #mysql

mysqldump --opt --no-tablespaces --compress -u <username> -p [-h <hostname>] -r <file.sql> <database>
                                                              
mysqldump --opt --no-tablespaces --compress -u <username> -p [-h <hostname>] <database> | gzip > <file.sql.gz>

# To ignore tables like fe_users and sys_redirects
# mysqldump --opt --no-tablespaces --compress [--ignore-tables <database>.<table>] [--ignore-tables <database>.<table>] -u <username> -p [-h <hostname>] -r <file> <database>


# mysqldump [--no-tablespaces] --default-character-set=utf8 -e -u $USER -p $DBNAME > /path/to/file.sql
content_copyCOPY