hi tilo, sorry, the mail before was sent directly to you, instead of ml
there comes several problems up: 1. i logged on with user from usergroup assist with loadercli and run CATALOGEXTRACT USER OUTSTREAM FILE '/tmp/catalog.sql' TABLEEXTRACT USER DATA OUTSTREAM FILE '/tmp/thomas.bin' 2. i edit /tmp/catalog.sql and replace ASSIST. with ASSISTTEST. 3. i logon with loadercli with a user from assisttest and run: SET MAXERRORCOUNT 999 CATALOGLOAD USER INSTREAM FILE '/tmp/catalog.sql' CATALOGLOAD USER INSTREAM FILE '/tmp/catalog.sql' CATALOGLOAD USER INSTREAM FILE '/tmp/catalog.sql' cause in the catalog exist's trigger's which references tables, that arent yet there but when running: TABLELOAD USER DATA INSTREAM FILE '/tmp/thomas.bin' i get in loader.prt // E -25011: Error executing internal SQL statement 'DROP INDEX "I_EINHEIT" ON "EINHEITEN"': 'SQL error -7066 = Unique index referenced by foreign key not allowed (error position: 1)'. // E -25329: The given data file '/tmp/thomas.bin0001' was not generated using TABLEEXTRACT (wrong identifier). // E -25329: The given data file '/tmp/thomas.bin0001' was not generated using TABLEEXTRACT (wrong identifier). // E -25329: The given data file '/tmp/thomas.bin0001' was not generated using TABLEEXTRACT (wrong identifier). // E -25451: Integrity violation (SQL Error 350) // E -25329: The given data file '/tmp/thomas.bin0001' was not generated using TABLEEXTRACT (wrong identifier). // E -25329: The given data file '/tmp/thomas.bin0001' was not generated using TABLEEXTRACT (wrong identifier). // E -25801: Internal error [vls28_TLTable.cpp, 3458, -9053]; contact technical support // E -25801: Internal error [vls28_TLTable.cpp, 2866, -25801]; contact technical support // E -25801: Internal error [vls28_TLoad.cpp, 1551, -25801]; contact technical support // M UNLOAD TRANSFORMATIONPACKAGE x'020000003DB90443A004000033A01612000FD94A00000000' // * imho it would be better to write with the catalogextract also two files (like done on tableextract) one only with table-definition a second one with all the trigger's references, views and so on. so the import can run in three steps: or missed i something? greetings thomas Heinrich, Tilo schrieb: >Hello Thomas, > >Partial backups containing the data of just one user can only be created >with the help of MaxDB's loader >(http://dev.mysql.com/doc/maxdb/en/2d/c6c63522b8057ce10000009b38f889/fra >meset.htm). > >Best regards, >Tilo Heinrich >SAP Labs Berlin > >-----Original Message----- >From: Thomas Stegbauer [mailto:[EMAIL PROTECTED] >Sent: Wednesday, August 17, 2005 6:49 PM >To: maxdb@lists.mysql.com >Subject: backup from only one usergroup > >hi ml, > >i make some experiments with maxdb 7.5.00.24 from debian sarge. > >i try to convert a software from sybase to maxdb and want several states >saved in the maxdb. > >to archive this i would use usergroups like this >---snip--- >create usergroup assist resource not exclusive >// >create user ts password hidden usergroup assist >// >create usergroup assisttest resource not exclusive >// >create user tstest password hidden usergroup assisttest >// >---snip--- > >depending on the user-logon, we are playing in the test or work with the >productive-system. > >my question: >1. currently i made backups only from dbmgui, afterwards this should be >done by >dbmcli -d database -u dbm,hidden -uUTL -c backup_start assist-backup >MIGRATION > >but this make's a backup from both, assist and assisttest. >how can i make only a backup from data belonging to assist and not >assisttest? > >2. how can i restore such a backup to the usergroup assisttest? > >greetings >thomas > > > -- # Thomas Stegbauer # Tronicplanet Datendienst GmbH # http://www.keyserver.de:11371/pks/lookup?op=get&search=0x275931BF # Key fingerprint = 984E D4B1 E91E F349 5057 B6AC 65CE C0FC 2759 31BF -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
