WackoWiki: Convert your WackoWiki database from MySQL To SQLite

https://wackowiki.org/doc     Version: 2 (11/17/2025 15:00)

Convert your WackoWiki database from MySQL To SQLite

mysql-to-sqlite3[link1] – 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.
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.