Linux
Read More
mySQL search and replace
UPDATE ´tablename´ set field = replace(field, ’searchString’, ‘replaceString’);
Author: Hans-Henry Jakobsen
Curious IT geek and dad.
Linux
Read More
Howto duplicate a Debian setup
This post describes howto reinstall or duplicate a Debian or Debian based distribution like Ubuntu. First we need to extract the installed packages on the source server and save them in a file debian:~# dpkg –get-selections >> packages Now we move to the target server and set the package selections according to the package file […]
Linux
Read More
Howto install Fedora Core 5 (FC5) from a USB stick
Download the Fedora disk image from a mirror: # wget http://mirrors.dotsrc.org/fedora/5/i386/os/images/diskboot.img Make sure that the USB device is unmounted: # sudo umount /dev/sda1 Copy the img to the usb key device: # dd if=diskboot.img of=/dev/sda Reboot and then select a network based install by typing: linux askmethod
Scripting
Read More
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, […]