This script converts each table in each mySQL database found into a .csv-file. #!/usr/bin/perl -w #—————————————————————————– # # Name mySQL2csv.pl # # Description : # Convert database tables to csv files # # Limitations: # It doesn’t look very efficient looping over a hash for each row # usage: # mySQL2csv.pl # #—————————————————————————– ##### Standard […]
Dump mySQL databases to .csv Read More »
Scripting is for lazy people. To avoid thinking it over again and again I created some templates for a perl environment. The templates provide logging, a configuration file, a library for function availabillity in different scripts, strict code and some examples. The environment variable PERLHOME is used to have a basedir anyone can adapt to
A perl template environment Read More »
A library of database functions, using just DBI ########################################################################### # # Name dbfunctions.pm # Description : # Perl library for database functions # ########################################################################### sub dbFunctions { print “Functions in dbfunctions.pmn”; print “====================n”; print “openDBn”; print ” Open the mysql database.n”; print “doDBI (<SQL>) n”; print ” Execute <SQL> on database opened on dbhn”; print
Perl database functions Read More »
XML-files can be delivered without any formatting, just everyting in one row. No problem for an XML-parser but very inconvinient for humans. This script converts any XML-file to a better readble format with indent and newlines where you want them. This script does not use the template-environment I use for applications as it is to
Make any XML readable Read More »