April 2007 – Page 4 – Pario TechnoBlob

Linux

Set mySQL Auto Increment manually

ALTER TABLE table_name AUTO_INCREMENT = 100000

Scripting

MDB tools to export (migrate) from mdb (Microsoft Access format) to mySQL

This convertion could be obtained by first converting the tables in the mdb-file into CSV-files (Comma Separated Values) using MDB Tools and then by importing the csv-files into MySQL using phpMyAdmin. To export a given table from a mdb-file, we type: mdb-export db.mdb customers >> customers.csv In my case, since I got some danish characters, […]

Linux

Howto Convert Text File From UTF-8 to ISO-8859-1 Encoding

Convert a iso-8859-1 charset file into a utf-8 charset file. # iconv –-from-code=ISO-8859-1 –-to-code=UTF-8 iso.txt > utf.txt You can also use the console command recode # recode UTF-8 filename.txt Remember to make a backup of the file, because the changes are being done in the target file.

Linux

Howto install Sun Java on Debian Etch

The original Sun Java 2 is available in the ‘non-free’ section of the Debian repositories. To enable this section first add the non-free repository to the apt sources file – the /etc/apt/sources.list should look like, – important parts are in bold:

Linux

Linux på HP Compac nc8430

Her er ei samling av tips for å få min bærbare PC til å fungere tilfredsstillende i Linux, oppdateres fortløpende. The solution is editing xorg.conf and adding “HorizSync 36-52” and “VertRefresh 36-60” in “Section Monitor”. Giving a startx, the desktop appears with normal resolution for the vesa driver (cannot use radeon driver on this machine). […]