Re: Upgrade 7.3 -> 7.5 using data Backups ?

[Erik Myllymaki]

Stefan Schl�sser wrote:

Hi,

how do I upgrade a 7.3 version to 7.5 version ?

Where do I find documentation on this ?

I tried making a cold complete data backup of 7.3 and then restore it 
into the 7.5 db. It gives me a -111: Incompatible incremental backup 
Error. What's the quickest way to do this ?

Thanks,
  S.Schl�sser
I used this script to move from SapDB v7.4 on linux to MaxDB v7.5 on 
windows. Use at your own risk, it was designed for my limited use only. 
This also works well for making copies of databases on the same server - 
just change the name of the database used in the import bit below(the 
database will need to be created beforehand):

#!/usr/local/zope2-5-1/bin/python
##/usr/bin/python
import sapdb.loader, sys, os

#change these to suit your needs
base_export_dir = "/dbdump/"
base_import_dir = "C:\sapdbimport\\"
export = 0
iimport = 1
tables = 
['customers','employees','inventory','inventory_detail','payments','sales','sales_items']

if export:

   print "Starting export..."
   session1 = sapdb.loader.Loader('', '')
   session1.cmd('USE SERVERDB OBB')
   session1.cmd('USE USER DBA DBA')
   for table in tables:
       cmd_str = "DATAEXTRACT FOR DATALOAD TABLE %s \
       OUTFILE '%s%s.command' \
       OUTFILE '%s%s.data'  \
       " % (table,base_export_dir,table,base_export_dir,table)
       print cmd_str
       session1.cmd(cmd_str)
   print "...finished export"
#if you are migrating between machines, copy everything form one machien 
to the other
#scp base_export_dir/*.* anothermachine:base_import_dir

if iimport:

   print "Starting import..."
# no need to drop the whole DB...
#    cmd3 = "/opt/sapdb/depend74/bin/dbmcli -d tst74 -u DBA,DBA db_drop"
#    print cmd3
#    print os.system(cmd3)
   session2 = sapdb.loader.Loader('', '')
   session2.cmd('USE SERVERDB TESTER')
   session2.cmd('USE USER DBA DBA')
  
   for table in tables:
       sql = "drop table %s" % table
       fname = "%s%s.command" % (base_import_dir,table)
       print "Dropping table:%s" % table
       try: session2.sql(sql)
       except:
           print "ERROR: table probably does not exist"
       print "Importing table:%s" % table
   #you might need to be a little more specific about where your 
loadercli command is here
       cmd2 = "loadercli.exe -u DBA,DBA -d TESTER -b %s" % fname
       print cmd2
       os.system(cmd2)
   print "...finished Import"

print "All Done!"





--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]