Convert your WackoWiki database from MySQL To SQLite
mysql-to-sqlite3[link1] – Transfer data from MySQL to SQLiteImport 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.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.
- [link1] https://github.com/techouse/mysql-to-sqlite3