http://qs321.pair.com?node_id=908359


in reply to Re^4: System command using array and pipe
in thread System command using array and pipe

The only issue that cannot be resolved by single quoting relevant parts of the command line is of escaping single quotes. Either do this manually, or do something simple like this:

s#'#'\\''#g for ($password, $path);
system("mysqldump --add-drop-table -uroot -p'$password' mydatabase | g
+zip -9c > '$path'");

[download]

Update: s/// command corrected as per ikegami.

Replies are listed 'Best First'.
Re^6: System command using array and pipe
by ikegami (Patriarch) on Jun 06, 2011 at 20:17 UTC
    I prefer 
    my ($passwd_lit, $path_lit) = map text_to_shell_lit, $passwd, $path;
system("mysqldump --add-drop-table -uroot -p$passwd_lit mydatabase | g
+zip -9c > $path_lit");

    [download]
    to 
    my $passwd_lit = $passwd;
my $path_lit   = $path;
s#'#'\\''#g for $passwd_lit, $path_lit;
system("mysqldump --add-drop-table -uroot -p'$passwd_lit' mydatabase |
+ gzip -9c > '$path_lit'");

    [download]

    but to each his own.

    By the way, your quoting was buggy. "\" is not special in sh single-quoted literals.

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom