This blog is my memo for collecting IT stuffs. And some my free softwares.Please use facebook to leave comments.

To run Wordpress with SQLite

Last update 2009-09-10 23:03:22 (More than 1 year old)

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?

Last update 2009-09-10 23:03:22

Comment Delicious

todo
facebook support
Page transaction
RSS feed
Search
Auth
Last update
Category
Multi-language
User
Open source
Environment
php-5.1.6 with PDO
SQLite-3.3
IE6
FireFox-1.5
RSS
Unauthorized

Search
Google