upgrade to 0.9.6 doesn't create new database

[RussH]

see https://forums.opencats.org/viewtopic.php?f=4&t=1724

[RussH]

see here https://github.com/opencats/OpenCATS/commits/c68de3a312bebc9b3c230d8107eb671a3157f93d/modules/install/Schema.php

[RussH]

should already be present
https://github.com/opencats/OpenCATS/blob/2764566bcb37ebde9e87f9106e9defed3d7d7c0c/db/upgrade-0.9.4-0.9.5.sql

[xalt7x]

Version 0.9.6 still has issue with empty candidate lists even after "upgrade" with "installation wizard"

Manual upgrade:

1. Just in case backup your current database
   ("cats_dev" is a database name)
   sudo mysqldump -u root cats_dev > cats_dev__backup.sql
2. Upgrade your current database using a file mentioned above
   sudo mysql -u root cats_dev < /var/www/html/opencats/db/upgrade-0.9.4-0.9.5.sql

[sshheerr]

try selecting traditional instead of sql from the drop-down menu when your dumping a sql data.