raditha.com, The Site With The LAMP was first created in December 2001 as a site dedicated to Linux, Apache, Mysql and PHP. It's the work of Raditha Dissanayake, who has an affinity for these technologies plus many more particularly those that can be found on linux.
In recent years the site has fallen into neglect and many of the blog posts and pages are from a time long past
These photos are from my infrequently updated photo blog

Restoring a database on ms sql server for linux (docker)

May 22, 2019, 8:14 a.m. sql-server , docker , northwind , linux

Right-O Jeeves, I downloaded the Northwind backup for sql server, but how do I restore it with sqlcmd?  RESTORE DATABASE Northwind FROM DISK='/tmp/Northwind.bak' But that produced Msg 3201, Level 16, State 2, Server 61ea3d23c7fb, Line 1 Cannot open backup device '/tmp/Northwind.bak'. Op ...

Why you shouldn't use PHP + MySql + Apache bundles

May 21, 2019, 2:31 a.m. php , mysql , apache

Ancient history. These things are known by many different names, XAMPP, WAMPP, LAMPP etc. They all contain a bundle of PHP, MySql and Apache webserver often bundled with a bunch of other stuff like Wordpress, Joomla and phpmyadmin. They were very popular a decade ago and sadly even today they are us ...

Changing the backend db for a live django app.

Dec. 22, 2016, 8:37 a.m. odo , python , django , sqlite , mysql

In theory if you use django, changing your RDBS from say sqlite to mysql is a breeze. All you need is generate a dump of your existing data with ./manage.py dumpdata, change settings.py and do ./manage.py migrate on the new server. Then you can import the previously exported data through ./manage.py ...

Database clients for Microsft SQL server on linux.

Dec. 17, 2016, 1:03 a.m. heidisql , sql-server , winetricks , wine , DBeaver , sqlcmd

sqlcmd sucks, so I thought to try out VS Code to connect to the sql server. Unfortunately I had to upgrade my Linux Mint Version due partly to inistallation conflicts with sqlcmd on it. But what do I get when I try to run the sql-server extension on VS Code? Failed to load sql tools service Thi ...