Re: [refbase-talk] Upgrading from 0.8.0 to 0.9.5

[Matthias S. <mst...@re...>]

Hi Jan,

On Fri, 12-Feb-2010 14:02 +0100, Jan Schulze wrote:

> I have inherited a refBase 0.8.0 installation, that I want to
> upgrade and move to a new server. 

For a regular update (on the same server), you can follow the advice
given here:

 <http://update.refbase.net/>

> I have 
> - installed 0.9.5 on the new server.
> - imported the old database on the new server.
> - changed initialize/db.inc.php to point to the old database. 

After calling 'update.php', this should indeed upgrade the database as
required.

> When calling update.php on the new server, I get the message "Nothing 
> was changed! Your refbase installation is up-to-date."
> This can not be right, because I can see that 0.9.5 uses 16 tables, 
> whereas the old database has only 15 tables.

Can you execute this MySQL command on both databases (factory
refbase-0.9.5 and upgraded refbase-0.8.0):

 SHOW tables FROM literature;

and report which table is missing after you've applied 'update.php' on
your original refbase-0.8.0 database.

> Any suggestions, how to properly upgrade the database?

If you want to move refbase to a new server, and upgrade it as well,
you could do the following (which is more laborious than your method)
but should definitely work:

Either move the entire refbase-0.8.0 installation (database & scripts)
to the new server, or re-install refbase-0.8.0 on the new server using
a MySQL dump file:

1. Make a backup (i.e. MySQL dump) of your old refbase database. This
   is described here:
   
   <http://backup.refbase.net/>

2. Install refbase-0.8.0 on your new server using 'install.php'. In
   the 'install.php' form, make sure that the correct path to your
   MySQL dump file is given in the field labelled "Path to the
   database structure file", and that the chosen character set is
   identical to your refbase database on the old server.

Then you can (again) follow the steps given at:

 <http://backup.refbase.net/>

In short:

3. Replace all your old refbase-0.8.5 scripts on the new server with
   the updated ones from refbase-0.9.5.

4. Re-enter your custom settings in files 'db.inc.php' and
   'ini.inc.php'.

5. Execute 'update.php' in your browser to update your refbase MySQL
   database.

This should work. But, as mentioned above, I would have thought that
your above given method would have worked as well.

HTH, Matthias