MySQL/MariaDB dump for every database variantes

MariaDB and MySQL sometimes realy strange. The last time I had offen dumps between sql server versions. you must not use my pipe for compression this is optional.

mysqldump –events –routines –triggers –single-transaction –default-character-set=utf8mb4 –opt database.dump | gzip > database.sql.gz

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s