To run Wordpress with SQLite

In order to run Wordpress on my low spec VPS, I needed to find out a way to run it without MySQL so I try to install PDO plug in to Wordpress.

It is very easy step to set up since there is a plug in to make it come true. Personally it is not nice to have MySQL daemon running for just Blog used for personal web page or even corporate site. Besides SQLite is faster.

First of all, download Wordpress and unzip it to directory where you want to have it run.

Next, download the plug in from here and unzip it to wp-content directory (well.. I guess you can just take a look at the page in English) This plugin requires version 2.3.

Then create directly named database in wp-content and set permission to 777.

At last, copy wp-config-sample.php and make wp-config.php, insert a following line into the file as it is described in its instruction page.

$ vi wp-config.php

...
define('DB_COLLATE', '');

define('DB_TYPE', 'sqlite');
...

That's it. You can run install script and should be working with SQLite. Easy?

Comment