Can't find string terminator

[Alvin Ramos]

Have a simple perl script that will run a mysql dump, but I'm getting

Can't find string terminator '"' anywhere before EOF at ./ssh.pl line 5

My code, I assume the " is throwing it all off, but the / didn't help:

use Net::SSH::Perl;
my $ssh = Net::SSH::Perl->new("heaven.theflux.net");
$ssh->login("root", "temp");
$ssh->cmd("mysqldump -uroot -pnew-password -t -T/var/lib/mysql free
ExData --fields-enclosed-by=\"\ --fields-terminated-by=\|\");

Thank you for any and all assistance!

Regards,
Al

[Michael Brader]

The error is telling you exactly what the problem is, your final terminator
is missing (because you've quoted it). To save you all that backwhacking,
consider using qq:

$ssh->cmd( qq{mysqldump -uroot -pnew-password -t -T/var/lib/mysql free
ExData --fields-enclosed-by=" --fields-terminated-by=|} );

Read 'perldoc perlop' for more information on qq.

Depending on how Net::SSH::Perl handles the argument to cmd, you may still
need to quote the double quote and pipe symbols:

$ssh->cmd( qq{mysqldump -uroot -pnew-password -t -T/var/lib/mysql free
ExData --fields-enclosed-by='"' --fields-terminated-by='|'} );

Cheers,
Michael

--
Michael Brader
Senior Software Engineer - Billing
Techops - Softdev
Internode http://www.internode.on.net/

[Owen]

On Wed, 9 May 2012 22:02:00 -0400
Alvin Ramos <w...@theflux.net> wrote:

> Have a simple perl script that will run a mysql dump, but I'm getting
>
> Can't find string terminator '"' anywhere before EOF at ./ssh.pl line
> 5
>
> My code, I assume the " is throwing it all off, but the / didn't help:
>
> use Net::SSH::Perl;
> my $ssh = Net::SSH::Perl->new("heaven.theflux.net");
> $ssh->login("root", "temp");

Look at this section

> $ssh->cmd("mysqldump -uroot -pnew-password -t -T/var/lib/mysql
> free ExData --fields-enclosed-by=\"\ --fields-terminated-by=\|\");

Count the ". One way or the other, the parser cannot find a matching "



--


Owen

[Alvin Ramos]

Thanks for your help "qq{mysqldump ..." worked perfectly!