How to use gzip or gunzip with mysqldump/mysql to import/export
The syntax is fairly easy and it is a common practice to use gzip specially when you transfer your backup files over two or more different servers so here is the syntax.
mysqldump -u user -p database | gzip > database.sql.gz
© Heshan Wanigasooriya.RSS
gunzip < database.sql.gz | mysql -u user -p database
🍪 This site does not track you.