bonjour,
Le mardi 11 octobre 2005, José Manuel Galván Labrador a écrit...
> It occurs that I have upgraded my installation of MaxDB, but I don't know
> how I can
> upgrade my database instance of MaxDB.
> How I can upgraded my database instance 7.5.0.15 to 7.6.0.12? Please, could
> you explain to me all step by step?
> When I upgrade my database instance, can I upgrade system tables with no
> errors?
> I have SUSE Linux 8.2. Please, it's very urgent!!
<my life>
I decided to upgrade from 7.5 to 7.6 with new paths for MaxDB (from
/usr/local/sapdb to /usr/local/maxdb) and for instances's data (new ext2
partition).
I backuped data and log and dropped every files of the previous
installation (/usr/local/sapdb, /usr/spool/sql, /etc/opt/sdb)
I installed version 7.6
I created the new instances, param_put instances parameters, param_put
restore media from old backuped instances
Then I restored data with `db_activate RECOVER`, then all logs with
recover_start, recover_replace and finished by recover_ignore
Then I loaded system tables, added the new backup media, backuped data,
and set autolog on (autolog_on)
</my life>
Same thing can be done with an upgrade (runtime and server), dropped and
recreated instance (I suppose...)
Use at your own risk...I tested the backup-recovery on a test machine
first.
--
jm
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
