Hello all, I'm trying to 'source' a mysql script file from inside of perl and I'm having problems. The mysql script file is called load.sql.20011231, and it's full of insert statements. Here a small sample:
insert into crontabs values (' ', 'dev2', 'asn', '00', '19', 'ALL', 'ALL', '1'); insert into crontabs values (' ', 'dev2', 'asn', '00', '19', 'ALL', 'ALL', '2'); Here is the perl code that I'm using to try to execute the sourcing of this file: $connection2 = DBI->connect("DBI:mysql:$database", $user, $message) || die "Cannot connect to $database"; $load_sql = "source ${CRONLIST_SQL}/load.sql.${file_date}"; $cursor2 = $connection2->prepare($load_sql) or die "Can't prepare $load_sql: $connection2->errstr\n"; $cursor2->execute; $rc2 = $cursor2->finish; $rc2 = $connection2->disconnect; Here is the error that I'm getting when trying to run this: DBD::mysql::st execute failed: You have an error in your SQL syntax near 'source /home/cronlist/sql/load.sql.20011231' at line 1 at /home/cronlist/bin/crontab_load.pl line 74. Any ideas as to how to get around this? Thanks! -Stephen Spalding _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx _______________________________________________ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list