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 ...

Getting back to SQL Server

Dec. 24, 2016, 3:02 p.m. sql , partition , microsoft

 I have forgotten almost everything I ever knew about it. So this is sort of like learning everything from the beginning. Heck it is learning everything from the beginning, if nothing else the server version would have changed many times during that time. I thought I would go through the much c ...

Changing the backend db of 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 ...