Hi Tilo: Good news, would it be possible to obtain the script for DBMCLI commands to achieve a recover with initialization?. I tested the scripts contained in the MaxDB 7.6 docs and the Backup/Restore PDF, but could not achieve success, an error arises, describing a problem with backup media. I will try to post the exact error message later, but in the meantime it would be great to have a script that actually works. I could not test the Recovery + Initializaton using DBMGUI (did not have a client winXP machine).
Regards, Martin > Hello Martin, > > You should be able to restore a 7.4 backup into a 7.6 database. > > Best regards, > Tilo Heinrich > SAP Labs Berlin > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 21, 2005 11:27 PM > To: MaxDB MaxDB > Subject: Bug exporting data from 7.4 using loader v7.6 > > Hi, I need to restore a database instance from 7.4 into 7.6.0.16, since > I > could not restore the instance from a 7.4 backup (is this possible?), I > am > trying to export data from 7.4 to re-import it into 7.6, using loader > v7.6, but while running the export script, the following error appears: > > 5424 Segmentation fault > > All files from export are created, but I suspect they may be corrupt. > > I am using the following script to export a user's objects: > > TABLEEXTRACT USER > CATALOG OUTSTREAM '/opt/maxdb/cativen-catalog.dat' > DATA OUTSTREAM '/opt/maxdb/cativen-data.dat' > > My environment... > > Linux version 2.6.13-15-default ([EMAIL PROTECTED]) (gcc version 4.0.2 > 20050901 (prerelease) (SUSE Linux)) #1 Tue Sep 13 14:56:15 UTC 2005 > > MAXDB version: > Kernel = Kernel 7.6.00 Build 016-121-109-428 > Runtime Environment = X32/LINUX 7.6.00 Build 016-121-109-428 > > SAPDB Version: 7.4.3.30 > > Loader protocol log: > > // M Loader 7.6.00 Build 016-121-109-428 > // * > // M Loader instance started at linux105 for database PLA > // * > // M Starting protocol at 2005122100180014 > // * > // M START 20051221 00180014 > // * > SET > // * > // M START 20051221 00180014 > // * > USE USER "SA" * SCHEMA SA SERVERDB "PLA" ON 180.184.200.103 > // * > // M USER: 'SA' on DB: 'PLA' ISOLATION LEVEL: 3 > // * > // M START 20051221 00180015 > // * > TABLEEXTRACT USER > CATALOG OUTSTREAM '/opt/maxdb/cativen-catalog.dat' > DATA OUTSTREAM '/opt/maxdb/cativen-data.dat' > // * > // M Import PACKAGE > x'010000006FD0A94330150000AE76E543C869B4B8FFFFFFFF' > // * > // M Execute PACKAGE to transform CATALOG > / * > // M Number of TABLES to transform: 141 > // * > // M Number of VIEWS to transform: 0 > // * > // M Number of SYNONYMS to transform: 0 > // * > // M Number of TABLES transformed : 141 > // * > // M Execute PACKAGE to transform DATA > // * > // M Number of TABLES to transform: 141 > // * > // M Number of TABLES transformed : 141 > // * > // M Execute PACKAGE to transform CATALOG > / * > // M Number of VIEWS transformed : 0 > // * > // M Number of SYNONYMS transformed : 0 > // * > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
