How do I migrate my database to a newer version?

  • MariaDB 10.6 to 10.11
  • MySQL 8.0 to 8.4

I currently upgaded all instances to a new database version, using the Admin panel backup and restore mechanism. As this affects all WackoWiki users sooner or later, we should perhaps share our HowTo's. The SSH as well the phpMyAdmin part might be differ slightly from provider to provider.

Comments

  1. Re: Migrate database to newer version

    [work in progress, create an extra guide along with “Migrating WackoWiki to another server”]



    You've three options
    1. via Admin panel
    2. phpMyAdmin
    3. Command line

    The available options may depend on the services your hosting provider supports. Usually your hosting providers has also good HowTo's and FAQ to each topic.

    Export your old DB.

    Create a backup of your DB.

    Create new DB you want upgrade to.

    Update your config.php.
    • new DB name
    • new DB password
    • new DB host

        'db_vendor' => 'mariadb',
    'db_host' => 'localhost',
    'db_port' => '3306',
    'db_name' => 'wiki',
    'db_user' => 'db_user_name',
    'db_password' => 'db_password',


    Import your backup into new DB.

    Check your application if all works fine.

    Delete your old DB.

    Admin panel

    After creating a backup in the Admin panel, the new database and updating the config.php with the new db settings, delete the config cache, change the value for RECOVERY_MODE to 1 in your constants.php and go again to the Admin panel to restore your backup (usually takes between 2 minutes up to half an hour, depending on the hardware and the size of your backup, your local PC is probably less powerful than the server of your hosting provider).

    Reset value for RECOVERY_MODE again to 0 in your constants.php and you're ready to go with your new database.
    const RECOVERY_MODE			= 0;


    Go again to the Admin Panel -> Synchronizing data -> Wiki-links and re-synchronize all data.
    tune the re-rendering settings to avoid timeouts or reaching the memory limit

    Check again if all works as expected. Dont forget to delete your old database.

    phpMyAdmin

    ...

    Command line / SSH

    ...
    • WikiAdmin
    • 11.12.2024 09:40 edited
Log in or create an account to post a comment.