WackoWiki

View source for Re: Migrate database to newer version

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

{{toc}}

You've three options
  1. via Admin panel
  1. phpMyAdmin
  1. 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.
file:/ap_rerender_links_en.png

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

====phpMyAdmin====
...
====Command line / SSH====
...