ALTER TABLE scripts

[jazcyk]

hi

.. was it possible to provide a SQL script that ALTERS an exisiting PMF 2.0.x database to work with 2.5. (whatever ALTER/CREATE/DROP/INSERT/UPDATE statements are necessary to dump and import a database from our live 2.06 installation and use with this 2.5?)

[jazcyk]

once imported a dump with data (not only structure) most seems to work OK though!

[Thorsten]

Hi,

The update script does that.

bye
Thorsten

[jazcyk]

.. I know!

but then I would have to isntall 2.0x on this test machine import the dump from the live server and upgrade.

I hoped to make it easier getting started on the test machine


Anyway the update.php has this only for MySQL I think:

Code: Select all

case 'mysql'
case 'mysqli':
            // Get all table names
            $db->getTableNames(SQLPREFIX);
            foreach ($db->tableNames as $tableName) {
                $query[] = 'OPTIMIZE TABLE '.$tableName;
            }
            break;

so it seems that there are no Schema changes with MySQL at all! Correct ?

[Thorsten]

Hi,

in 2.5.0-alpha we don't have a schema change... we do have one in 2.5.0-alpha2, but it's not released yet.

phpMyFAQ 2.5.0 is more a minor upgrade due to the end of support of PHP 4.

bye
Thorsten