ALTER TABLE scripts

Please report bugs here!

Moderator: Thorsten

Post Reply
jazcyk
Posts: 385
Joined: Wed Sep 07, 2005 1:32 pm

ALTER TABLE scripts

Post by jazcyk » Sat Jun 07, 2008 6:55 pm

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
Posts: 385
Joined: Wed Sep 07, 2005 1:32 pm

not so bad ..

Post by jazcyk » Sat Jun 07, 2008 7:15 pm

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

Thorsten
Posts: 15051
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten » Sun Jun 08, 2008 6:34 am

Hi,

The update script does that. ;-)

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

jazcyk
Posts: 385
Joined: Wed Sep 07, 2005 1:32 pm

yeah ...

Post by jazcyk » Sun Jun 08, 2008 9:20 am

.. 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 :idea:


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
Posts: 15051
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten » Sun Jun 08, 2008 9:22 am

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
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Post Reply