Re: to do mysql source command from perl

[Felix Geerinckx]

Rytis Diciunas Wrote:


> $sth = $dbh->prepare ("source /home/user/ids.sql;");
> $sth->execute;
>
> where ids.sql includes other source and load commands....
>
> mysql gives me error:
> DBD::mysql::st execute failed: You have an error in your SQL syntax;

'source' is not an SQL command, but an internal command of the mysql command line client.

You could use Perl's system() function:

system('/path/to/mysql -uuser -ppassword database </home/user/ids.sql');

--
felix
Please use BBCode to format your messages in this forum.