前面我们介绍了Linux 自动备份Mysql Shell 脚本,下面说一下如何解压。
mysqldump导出时加gzip压缩:
mysqldump -hhostname -uusername -ppassword databasename | gzip > backupfile.sql.gz
gunzip解压:
gunzip < backupfile.sql.gz | mysql -uusername -ppassword databasename
');mask-image:url('data:image/svg+xml;utf8,');mask-mode:alpha;-webkit-mask-repeat:no-repeat;mask-repeat:no-repeat;-webkit-mask-size:contain;mask-size:contain;-webkit-mask-position:center;mask-position:center;border-radius:0}}.wp-block-image :where(.has-border-color){border-style:solid}.wp-block-image :where([style*=border-top-color]){border-top-style:solid}.wp-block-image :where([style*=border-right-color]){border-right-style:solid}.wp-block-image :where([style*=border-bottom-color]){border-bottom-style:solid}.wp-block-image :where([style*=border-left-color]){border-left-style:solid}.wp-block-image :where([style*=border-width]){border-style:solid}.wp-block-image :where([style*=border-top-width]){border-top-style:solid}.wp-block-image :where([style*=border-right-width]){border-right-style:solid}.wp-block-image :where([style*=border-bottom-width]){border-bottom-style:solid}.wp-block-image :where([style*=border-left-width]){border-left-style:solid}.wp-block-image figure{margin:0}/*]]>*/
前面我们介绍了Linux 自动备份Mysql Shell 脚本,下面说一下如何解压。
mysqldump导出时加gzip压缩:
mysqldump -hhostname -uusername -ppassword databasename | gzip > backupfile.sql.gz
gunzip解压:
gunzip < backupfile.sql.gz | mysql -uusername -ppassword databasename