Import / export mysql databases via bash
I’m looking for this commands regularly so that’s why i’m posting them here… export database: mysqldump –user=[Username] –password=[password] –all-databases | gzip -9 > db.sql.gz import the database again: mysql -u[Username] -p[Password] [Database] < db.sql.gz