I am attempting to upgrade Mediawiki 1.5.2 to 1.6.5 but am hitting some
issues in the upgrade.php step. Below is the steps I followed:
1.) Backup EVERYTHING
2.) Copy new Mediwiki 1.6.5 on top of Mediawiki 1.5.2 (preserving
LocalSettings.php, AdminSettings.php, images, and extensions.
3.) Ensure AdminSettings.php file is set correctly
4.) cd in maintenance directory
5.) run php update.php
It starts out okay, sees all my wiki tables, and then gives this error and
dies:
ERROR 1005 (HY000): Can't create table 'wiki_transcache' (errno: 13)
I set my AdminSettings.php to be the MySQL admin login. If I run the same
SQL from mysql> prompt (not via the script) it also gives the same error.
Not being very fluent in MySQL, this tells me that somehow both my MySQL
admin account, and the account that Mediawiki logs in MySQL as lost CREATE
privilleges on my databse. Can someone confirm? If so, how do I put them
back? Thanks in advance!!