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 .
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 filesroot@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 PHProot@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"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_CAwww-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.1php bin/magento deploy:mode:set developerphp bin/magento setup:backup --code --media --db as www-dataNOTE: 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).
*_db.gz as indicated in http://devdocs.magento.com/guides/v2.1/install-gde/install/cli/install-cli-backup.html*_db.sqlEnabling 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 modewww-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.tgz3. I do not see any errors showing up in ${webroot}/var/log/system.log.
Thanks.