[2.1.1 CE] Backup of database (--db) does not gzip file.
Feature request from azeemism, posted on GitHub Sep 02, 2016
Running php bin/magento setup:backup --code --media --db
as www-data
creates a *_db.sql
file instead of a *_db.gz
file as indicated in http://devdocs.magento.com/guides/v2.1/install-gde/install/cli/install-cli-backup.html
. The backup was run while in developer mode. I have not tested under production mode, but I expect the same result.
Obviously as the database sizes grows this will become a major space concern. The Restore/Rollback seems to work, but there is another major issue refer to #6460 .
Preconditions:
- Magento 2.1.1 CE (Composer install)
- php bin/magento deploy:mode:set developer
- Mariadb
root@skynet:/# dpkg -l | grep mariadb ii libmariadbclient18 10.1.16+maria-1~jessie amd64 MariaDB database client library ii mariadb-client 10.1.16+maria-1~jessie all MariaDB database client (metapackage depending on the latest version) ii mariadb-client-10.1 10.1.16+maria-1~jessie amd64 MariaDB database client binaries ii mariadb-client-core-10.1 10.1.16+maria-1~jessie amd64 MariaDB database core client binaries ii mariadb-common 10.1.16+maria-1~jessie all MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf) ii mariadb-server 10.1.16+maria-1~jessie all MariaDB database server (metapackage depending on the latest version) ii mariadb-server-10.1 10.1.16+maria-1~jessie amd64 MariaDB database server binaries ii mariadb-server-core-10.1 10.1.16+maria-1~jessie amd64 MariaDB database core server files
- PHP 7.0:
root@skynet:/# dpkg -l | grep php7 ii libapache2-mod-php7.0 7.0.9-1~dotdeb+8.1 amd64 server-side, HTML-embedded scripting language (Apache 2 module) ii php7.0 7.0.9-1~dotdeb+8.1 all server-side, HTML-embedded scripting language (metapackage) ii php7.0-cli 7.0.9-1~dotdeb+8.1 amd64 command-line interpreter for the PHP scripting language ii php7.0-common 7.0.9-1~dotdeb+8.1 amd64 documentation, examples and common module for PHP ii php7.0-curl 7.0.9-1~dotdeb+8.1 amd64 CURL module for PHP ii php7.0-fpm 7.0.9-1~dotdeb+8.1 amd64 server-side, HTML-embedded scripting language (FPM-CGI binary) ii php7.0-gd 7.0.9-1~dotdeb+8.1 amd64 GD module for PHP ii php7.0-igbinary 1.2.1-1~2b7c703-1~dotdeb+8.2 amd64 igbinary serializer for PHP ii php7.0-imagick 3.4.2-1~dotdeb+8.2 amd64 Provides a wrapper to the ImageMagick library ii php7.0-intl 7.0.9-1~dotdeb+8.1 amd64 Internationalisation module for PHP ii php7.0-json 7.0.9-1~dotdeb+8.1 amd64 JSON module for PHP ii php7.0-mbstring 7.0.9-1~dotdeb+8.1 amd64 MBSTRING module for PHP ii php7.0-mcrypt 7.0.9-1~dotdeb+8.1 amd64 libmcrypt module for PHP ii php7.0-mysql 7.0.9-1~dotdeb+8.1 amd64 MySQL module for PHP ii php7.0-opcache 7.0.9-1~dotdeb+8.1 amd64 Zend OpCache module for PHP ii php7.0-pspell 7.0.9-1~dotdeb+8.1 amd64 pspell module for PHP ii php7.0-readline 7.0.9-1~dotdeb+8.1 amd64 readline module for PHP ii php7.0-redis 3.0.0~rc1-1~dotdeb+8.2 amd64 PHP extension for interfacing with Redis ii php7.0-soap 7.0.9-1~dotdeb+8.1 amd64 SOAP module for PHP ii php7.0-xml 7.0.9-1~dotdeb+8.1 amd64 DOM, SimpleXML, WDDX, XML, and XSL module for PHP ii php7.0-xsl 7.0.9-1~dotdeb+8.1 all XSL module for PHP (dummy) ii php7.0-zip 7.0.9-1~dotdeb+8.1 amd64 Zip module for PHP
- Debian
root@skynet:/# cat /proc/version Linux version 3.16.0-4-amd64 (debian-kernel@lists.debian.org) (gcc version 4.8.4 (Debian 4.8.4-1) ) #1 SMP Debian 3.16.7-ckt25-2+deb8u3 (2016-07-02)
root@skynet:/# lsb_release -a No LSB modules are available. Distributor ID: Debian Description: Debian GNU/Linux 8.5 (jessie) Release: 8.5 Codename: jessie
Steps to reproduce
- Install magento 2.1.0 with composer
- Upgrade to 2.1.1 (while in developer mode)
"require": { "magento/product-community-edition": "2.1.1", "composer/composer": "@beta" },
"minimum-stability": "stable", "prefer-stable": true, "repositories": [ { "type": "composer", "url": "https://repo.magento.com/" }
composer update php bin/magento setup:upgrade php bin/magento setup:di:compile php bin/magento --ansi setup:static-content:deploy en_CA
www-data@skynet:~/example.com/magento/2.x/2.x$ php bin/magento setup:db:status All modules are up to date.
www-data@skynet:~/example.com/magento/2.x/2.x$ php bin/magento -V Magento CLI version 2.1.1
- Switch to or stay in developer mode
php bin/magento deploy:mode:set developer
- Create a backup
php bin/magento setup:backup --code --media --db
aswww-data
NOTE: Steps 1 (install 2.1.0) & 2 (upgrade) may not be required to reproduce the issue, and I also expect the same issue if a backup is run in production mode (but I have not tested with production mode).
Expected results
- Database file created with format
*_db.gz
as indicated inhttp://devdocs.magento.com/guides/v2.1/install-gde/install/cli/install-cli-backup.html
Actual results
- Database file creates with format
*_db.sql
-
Enabling maintenance mode Code backup is starting... Code backup filename: 1472779824_filesystem_code.tgz (The archive can be uncompressed with 7-Zip on Windows systems) Code backup path: /var/www/example.com/magento/2.x/2.x/var/backups/1472779824_filesystem_code.tgz [SUCCESS]: Code backup completed successfully. Media backup is starting... Media backup filename: 1472779824_filesystem_media.tgz (The archive can be uncompressed with 7-Zip on Windows systems) Media backup path: /var/www/example.com/magento/2.x/2.x/var/backups/1472779824_filesystem_media.tgz [SUCCESS]: Media backup completed successfully. DB backup is starting... DB backup filename: 1472779824_db.sql DB backup path: /var/www/example.com/magento/2.x/2.x/var/backups/1472779824_db.sql [SUCCESS]: DB backup completed successfully. Disabling maintenance mode
www-data@skynet:~/example.com/magento/2.x/2.x$ ls -lht var/backups/
total 43M
-rw-rw-r-- 1 www-data www-data 547K Sep 1 18:31 1472779824_db.sql
-rw-rw-r-- 1 www-data www-data 60K Sep 1 18:31 1472779824_filesystem_media.tgz
-rw-rw-r-- 1 www-data www-data 43M Sep 1 18:31 1472779824_filesystem_code.tgz
3. I do not see any errors showing up in ${webroot}/var/log/system.log.
Thanks.