Hello,
We've been running an instance of Moodle 2.5 (build 20130621) on a Windows Server2008R2 (w/ PHP 5.5.0) connected to a PostgreSQL 9.2.3 database for a few years. We'd like to both upgrade to Moodle 3.0 and move the db to MySQL 5.6.21
On Moodle 2.5 I ran the *experimental* "Database Migration" tool and according to that script, it successfully completed the copying/migrating of files from the current connected PostgreSQL database to the MySQL db I set up. I then edited the config.php to reflect the MySQL db connection details
$CFG->dbtype = 'mysqli';
$CFG->dblibrary = 'native';
$CFG->dbhost = '12.34.56.78';
$CFG->dbname = 'moodletest';
$CFG->dbuser = 'moodletest_user';
$CFG->dbpass = 'Apassword';
$CFG->prefix = 'mdl_';
$CFG->dboptions = array (
'dbpersist' => 0,
'dbsocket' => '',
);
------
After changing the config.php settings, loading the Moodle instance takes me to the Installation prompt; following through with that overwrites the migrated MySQL database with a fresh Moodle installation db.
I'm not sure if I'm missing a step, or what exactly is index.php checking for when it decides to send me to the Installation process. Fortunately I'm trying this on a development instance; also, changing the config.php connection details back to the PostgreSQL db is seamless, everything comes back to normal. Or is it possible that PostgreSQL->MySQL won't work with the 2.5 transfer script? Should I first upgrade from 2.5 to 3.0 with current PostgreSQL db, and THEN try migrating to MySQL db?
Any insight into this would be greatly appreciated, thank you!