Database Backup on push

[namuit]

It can be a useful feature a new cli option that offer a copy of the dump of the database before the push of it.
The problem is pretty simple: the files are often in a repo or in a compressed file somewhere (email, dropbox, filesystem, etc.), so if you made an error, you can revert everything, but if there are errors on the database, you can't.

It can be nice a new option that doesn't delete the dump of the database (and set it a new name like YYYYMMDDHHMMSS.sql in a htaccess protected folder) or save it in a dump.

[stefanoverna]

I like it!

[matjack1]

thumbs up!

[stefanoverna]

#bd0e1016f219be0a3 implements DB backups, they are stored in wp-content dir and follow this format:

remote-dump-TIMESTAMP.sql
local-dump-TIMESTAMP.sql

[morrislaptop]

Should this be re-opened?

[alessandro-fazzi]

Why are you saying that @morrislaptop ? Both remote and local dump should be found in wp-content/ after every db push/pull operations

[morrislaptop]

Ah I was looking on the server for the backup when pushing.

[alessandro-fazzi]

Oh no, they are all saved locally for security reasons :)