Archive for January, 2007

Running PERL scripts on Linux authored on Windows

Friday, January 12th, 2007

BEWARE: Running PERL scripts on Linux that have been authored on windows boxes is dangerous unless you run:

 perl -pi -e ‘tr/\cM//d;’ /usr/local/scripts/dbi_variables.pl

String Matching with a Perl Module::String Approx

Thursday, January 11th, 2007

http://search.cpan.org/~jhi/String-Approx-3.26/Approx.pm

Install it using: perl -MCPAN -e ‘install “Text::CSV_XS”‘

Sorted.

Run sql file from Shell

Monday, January 8th, 2007

mysql -u##### -p####### moodle < base_install_moodle.sql

Log MySQL Transactions

Friday, January 5th, 2007

edit /etc/my.cnf

type log=/var/log/mysql-querylog.log

RESTART mysql