Get rid of MySQL and let WordPress jump to SQLite

WordPress works with MySQL by default. This time, we need to change a database partner for WordPress, but this does not mean that MySQL is not excellent, but it has low-concurrency access at lower than 0.1 million, the lightweight single-file database system such as SQLite features excellent performance, small size, fast reading speed, large capacity, free, open source, in fact, it is more suitable for database applications in scenarios such as blogs or small and medium sites.

If you need to pay for the database service independently or are not satisfied with the complicated Mysql Data Service of the host system, you should try a lightweight database such as SQLite.
SQLite Website: http://www.sqlite.org
System environment dependency requirements:
The host PHP suite must support SQLite and PdO extensions (but rest assured that common systems are perfectly supported). SQLite database information is stored in independent files, and the file and folder must require read and write permissions. These requirements are simple.
Upgrade and replace the WordPress data system:
Here is a simple method: first, use the "tool-export" function in the WordPress background to export the. xml file.
Download the WordPress plug-in "PDO (SQLite) for WordPress" of SQLite and place the DB. php and PdO folders in the compressed package in the WP-content folder.

Then, edit the wp-config.php file and add "define ('db _ type', 'sqlite ');" to the graph position ');".

So far, accessing WordPress again has started a new installation interface, just like installing it. After that, use the previously exported. XML file, return to the WordPress background, and then "import" to restore the original data, and configure the plug-in and topic by yourself. At this time, SQLite is fully in service, and all data reads and writes are handled by SQLite. If an error occurs, check whether the database directory is automatically generated under the WP-content directory, and whether the corresponding database file myblog is generated under the directory. SQLite and. does the htaccess file grant read/write permissions?
SQLite can minimize site construction costs, reduce maintenance difficulty, and avoid the disadvantages of MySQL. SQLite is promising for Small and Medium-sized data applications.