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 »
Ubuntu is a very nice linux distribution and I use it on most of my systems, desktop or server. Ubuntu is a Debian derivative. It could not exist if Debian was not there. Ubuntu is maintained by Canonical Ltd. Ubuntu has put great effort in making a operating system that can be installed and used
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 »
Raw material General ORA-01653: unable to extend table <table> by 128 in tablespace EVENTLOG sqlplus> ALTER TABLESPACE EVENTLOG ADD DATAFILE `ORACLE_HOMEDATABASEEVENT.ORA’ SIZE 30M REUSE; SQLplus Commands end with ; > sqlplus <name>/<password> inloggen in de SQL+ omgeving Noot: host string = nummer van de in te loggen database C:/plus33w.exe <name>/<password>@<Oracleserver> inloggen in de SQL+ omgeving
BOINC Computer spare time is offered to the world through BOINC. For some time we were only able to run SetiAtHome. In the debian client the platform has to be added manually to client_state.xml. You have to do this while the client is not running. We now can run medical and other projects too.
IP (Internet Protocol) The defacto standard does not fully comply to the OSI model IP package Version Header length Type of Service Total length Identification Flags Fragment offset Time To Live (TTL) Protocol Header checksum Destination IP Source IP Options Data 4 bits 4 bits 8 bits 16 bits 16 bits 3 bits 13 bits
Ethernet is a protocol on OSI level 2, the data-link layer. An ethernet package is typically 1500Bytes large(MTU, Maximum Transfer Unit), this has its root in the bus-shaped networks it was designed for. Ethernet uses CSMA/CD (Carrier Sense Multiple Access with Collision Detect) this means all hosts on the bus listen if the line is
IP addresses have a network part and a host-part, hosts in the same subnet can reach each other directly. To reach a host on another subnet you need a gateway (router) to the other network. IPv4 Address classes Class Address starting bits First Byte less than Comment A 0 127 B 10 192 127 is