WordPress SQLite PDO — An Alternative to MySQL

The following notes detail installation of the PDO (SQLite) plugin for WordPress. SQLite must be present on your (web hosting) server. The following has been tested with WordPress Version 3.1.2.

Note that if the steps outlined below fail to work with more recent versions of WordPress, try installing version 3.1.2 first, run through the steps below, and then UPGRADE your WordPress to the latest version.

1. Download WordPress 3.1.2 and PDO (SQLite) Plugin 2.7.0 from wordpress.org

2. Extract/uncompress the two downloads. You should now have a 'wordpress' folder and a 'pdo-for-wordpress' folder

3. Place the 'pdo' folder and 'db.php' file, located in the 'pdo-for-wordpress' folder, in the 'wp-content' folder located in the 'wordpress' folder

4. Create a folder named 'database' in the 'wp-content' folder of the 'wordpress' folder

5. Rename the 'wp-config-sample.php' file located in the 'wordpress' folder to 'wp-config.php'

6. Open the 'wp-config.php' file renamed above in a text editor (e.g. gedit, vim, notepad, etc.)

7. Add the following line

define('DB_TYPE', 'sqlite'); // use SQLite

after the lines

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

to give

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');
define('DB_TYPE', 'sqlite'); // use sqlite

8. Replace the lines

with your own randomly-generated keys to give something like the following:

Save the file

The random keys can be generated online by visiting https://api.wordpress.org/secret-key/1.1/salt/

9. Open the 'wp_install.php' file located in the 'wordpress/wp-content/pdo' folder in a text editor and replace the line

with the line

Save the file and shutdown your editor

10. Upload all the folders and files located WITHIN the 'wordpress' folder to your (web hosting) server

11. Set the file permissions of the 'database' folder created above (Step 4.) to 777

12. Navigate your web browser to http://yourdomain/wp-admin/install.php to initiate the WordPress install process

13. Enter a username and password and then click the 'install' button

14. You might see PHP code being printed to your browser - ignore this and scroll to the bottom of the page

15. Note your password and then click the 'login' link located at the bottom of the page

16. Enter your username and password. You should then be taken to the WordPress Configuration Panel

Remember that you need to have SQLite installed on your (web hosting) server for this to work.

Note that if this steps outlined above fail to work with more recent versions of WordPress, try installing version 3.1.2 first, run through the steps outlined above, and then UPGRADE your WordPress to the latest version. Worth the effort if you need or want to use SQLite.

Good luck.

WordPress AlphaOmega Captcha & Anti-Spam Filter Plugin