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
after the lines
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.