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
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter