Installation of WordPress SQLite PDO

July 30, 2014 | Leave a Comment

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.

 
  Alice  15:05:19 GMT
Thank you so much.
  Thackary  02:38:03 GMT
My WordPress PDO SQLite is now running along smoothly. Thanks heaps.
  George  16:18:37 GMT
Thanks to you that PDO thing was solved PDQ! Well done.
  Dorothy  07:15:28 GMT
It also works with WordPress version 3.2.1.
  Bernard  18:11:29 GMT
It worked!!!! WordPress is a great CMS!!
  Stephen  08:05:21 GMT
... using Wordpress 3.1.2 as you suggest and then upgrading works perfectly.
  Sodit  21:04:47 GMT
Using sqlite is fine, but i recommend mysql if possible.

   Leave a Comment
Name :
Comment :