windows 7 - php mysqldump and zip 7z -
i have line of php backing databases, work's charm (windows 7): $exec_str = "{$real_path}bin\mysqldump -h {$mysql_db_host} -u {$mysql_db_user} -p{$mysql_db_pasw} {$db_name} > {$backupdir}\\{$db_name}.sql"; but rather prefer have .sql files compressed 7zip (as 7z) this 1 not work (path 7za.exe correct) instead generates empty 7z files: $exec_str = "{$real_path}bin\mysqldump -h {$mysql_db_host} -u {$mysql_db_user} -p{$mysql_db_pasw} {$db_name} | {$real_path}7za > {$backupdir}\\{$db_name}.sql.7z"; what doing wrong? i used 7z compress output mysqldump (windows server 2008 r2), used command line batch files , automated tasks instead. also, used 7z.exe, not 7za. note following commands executed windows command terminal, i.e start->run-> cmd i created batch file automated task run contents: mysqldump -u<mysqlusername> -p<mysqlpassword> <schemaname>|7z.exe -si<nameinzip> <zippedpathandname.7z> thi...