登陆linux vps.先安装nginx(或apache)和php.然后,
apt-get install -y php7.3-mysql php7.3-sqlite3
(安装这2个包,分别解决“Your PHP installation appears to be missing the MySQL extension which is required by WordPress.”问题 和 "PDO Driver for SQLite is missing"问题)
然后下载wordpress的源码包latest.zip到你指定的网站的根目录,比如/usr/local/nginx/html :
cd /usr/local/nginx/html
wget https://wordpress.org/latest.zip
unzip latest.zip
mv wordpress/* ./
rm -rf wordpress latest.zip
cp wp-config-sample.php wp-config.php
打开wp-config.php,修改以下配置
原始文件:
/** WordPress数据库的名称 */
define('DB_NAME', 'database_name_here');
/** MySQL数据库用户名 */
define('DB_USER', 'username_here');
/** MySQL数据库密码 */
define('DB_PASSWORD', 'password_here');
/** MySQL主机 */
define('DB_HOST', 'localhost');
/** 创建数据表时默认的文字编码 */
define('DB_CHARSET', 'utf8');
/** 数据库整理类型。如不确定请勿更改 */
define('DB_COLLATE', '');
修改为:
/** WordPress数据库的名称 */
define('DB_NAME', 'MyBlog');//MyBlog是数据库名,可以自定义
/** MySQL数据库用户名 */
define('DB_USER', '');
/** MySQL数据库密码 */
define('DB_PASSWORD', '');
/** MySQL主机 */
define('DB_HOST', 'localhost');
/** 创建数据表时默认的文字编码 */
define('DB_CHARSET', 'utf8');
/** 数据库整理类型。如不确定请勿更改 */
define('DB_COLLATE', '');
//define('WP_ALLOW_REPAIR', 'true'); //数据库修复时使用
define('DB_TYPE', 'sqlite');
WordPress with SQLite
Officially, WordPress only supports MySQL, but with this plugin created by kjmtsh you can use SQLite instead.
The plugin was created a long time ago, but still works like a charm on the current latest WP version (v5.2 – Jun 2019).
This solution is not meant to be used in production for large websites, but it can be an interesting option if you have a small blog with few visitors. An SQLite version works better than MySQL on a server with very limited resources.
By the way, this blog runs on SQLite
UPDATE Nov 2020: This blog used to run on WordPress and SQLite, but I have migrated it to VuePress.
TIP
To migrate an existing site, see instructions at the end.
Step by Step
1. Download WordPress and SQLite Integration Plugin.
wget https://wordpress.org/latest.tar.gz
wget https://downloads.wordpress.org/plugin/sqlite-integration.1.8.1.zip
(如果哪天wordpress.org官方删除了sqlite-integration.1.8.1.zip文件,那么
git clone https://github.com/aaemnnosttv/wp-sqlite-integration sqlite-integration)
2. Extract files
tar xvf latest.tar.gz
unzip sqlite-integration.1.8.1.zip
3. Remove zip files (optional, for cleanup)
rm latest.tar.gz
rm sqlite-integration.1.8.1.zip
4. Move plugin to wp-content/plugins/:
mv wordpress/* ./
rm -rf wordpress
mv sqlite-integration wp-content/plugins/
5. Move db.php to wp-content:
mv wp-content/plugins/sqlite-integration/db.php wp-content/
6. cp wp-config-sample.php wp-config.php
7. Run the WP installer as usual.
Start webserver:
php -S 0.0.0.0:3000
PHP Development Server started.
Listening on http://0.0.0.0:3000
Press Ctrl-C to quit.
Open the page (http://vps-public-ip:3000/) and proceed with the installation:
No need to provide database information (the step will be skipped) :
Migrating an existing website:
NO NEED to convert MySQL to SQLite. Just use Duplicator (or any other migration plugin).
Install a brand new copy of WordPress with SQLite, then:
Install Duplicator (https://wordpress.org/plugins/duplicator/)plugin on both websites (existing and brand new copy instances);
Do a backup of your existing website using Duplicator;
Restore the backup on the brand new instance using Duplicator’s "restore";
Done!
This tutorial on video (3 min, no sound):
No comments:
Post a Comment