Devart Forums

Posted: **Wed 05 Oct 2016 14:30**

I backup my db with cmd and project file *.backup:

"C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql.com" /backup /connection:"User Id=mysql_dump;password=pass_here;Host=localhost;Port=3306;Database=lg4;Character Set=utf8;" /projectfile:"C:\xampp\htdocs\system\backup_db\lg4.backup"

I run this cmd file automaticly (WIndows).

I compress my file. So im my backup project I have:

Code: Select all

 <Compression>
<CompressLevel>BestCompression</CompressLevel>
<CompressComment xml:space="preserve" />
</Compression>

But how can I add a password to this zip file, AES-256? I can't find any options and solutions to do this.

Posted: **Wed 05 Oct 2016 15:08**

Solution:
use *.backup without compression and Timestamp and save to d:\mysql\
So old files will by replacaed by new files.

Use 7zip cmd:

Code: Select all

set now=%TIME:~0,-3%
set now=%now::=.%
set now=%now: =0%
set now=%DATE:~-4%.%DATE:~3,2%.%DATE:~0,2%_%now% 
"C:\Program Files\7-Zip\7z.exe" a -ssw -mx7 -p12345678 "d:\dump\lg4_%now%.7z" "d:\mysql\*.*"

So, we create 7zip archive with AES256 and timestamp in it name.

Posted: **Fri 07 Oct 2016 08:47**

We will support it in one of the next product versions and will notify you once it's available for downloading.

Posted: **Fri 07 Oct 2016 08:52**

alexa wrote:We will support it in one of the next product versions and will notify you once it's available for downloading.

It will by grate! it's great when developers listen to the users
Big thanks!

Devart Forums

Backup db with dbforgemysql.com tool

Backup db with dbforgemysql.com tool

Re: Backup db with dbforgemysql.com tool

Re: Backup db with dbforgemysql.com tool

Re: Backup db with dbforgemysql.com tool