((https://github.com/techouse/mysql-to-sqlite3 mysql-to-sqlite3)) - Transfer data from MySQL to SQLite
Import your database
%%
mysql2sqlite -f /home/user/Download/wacko.sqlite -d db_name -u root -p -K
%%
config.php
%%
'db_charset' => '',
'db_collation' => '',
'db_driver' => 'sqlite',
'db_engine' => 'SQLite3',
'db_vendor' => '',
'db_host' => '',
'db_port' => '',
'db_name' => 'file/data/db.sqlite',
'db_user' => '',
'db_password' => '',
'sql_mode' => '0',
'table_prefix' => '',
%%
Add the table for the search index (change the table prefix if different) or use the ##~{{adminupdate}}## action to create the missing table.
%%(hl sql)
CREATE VIRTUAL TABLE wacko_page_fts USING fts5(
title,
body,
content='{$pref}page',
content_rowid='page_id'
);
%%
If you have a local installation all should work as expected.