Backup db with dbforgemysql.com tool

[n.osennij]

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

Code: Select all

"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.

[n.osennij]

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.

[alexa]

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

[n.osennij]

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!