Learn how to backup your database and migrate to mariadb

In order to use okokPhone you need to be using mariadb instead of mysql (used by xampp)

Migrating should only take 5 minutes.

1. Backup your database

   Open heidisql, select your database and right click and select ‘export database as SQL’

   

   Check the options CREATE for database and tables and select INSERT for data

   Select output to .sql file.

   

   Export your database and check if everything is correct.

   If all your data is not present, try increasing Max INSERT option.

2. Close XAMPP

3. Download Mariadb https://mariadb.org/download/?t=mariadb&p=mariadb&r=11.5.2&os=windows&cpu=x86_64&pkg=msi&mirror=ptisp

1. Install Mariadb and choose and save your root password.
2. Connect to your new database via Heidisql
3. Paste your backup.sql into the query tab and load your old database

1. Update your server.cfg set mysql_connection_string and add your new password (if its different)set mysql_connection_string "mysql://username:password@localhost/DATABASE_NAME?charset=utf8mb4”

Don’t open XAMPP again!, After you installed mariadb directly, it will always start when your computer/server starts.

After you verified your database was imported without problems, delete XAMPP.