From: Frédéric Demilly (f.demillypacificpeche.fr)
Date: Thu Apr 01 2004 - 01:03:27 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi Everyone,
I've used loadercli to extract my database catalogue to a flat file, so
i can recreate a new database with the same schema on another server.
I've used this line to extract the database catalog:
loadercli -u dba,dba -d test_sap -n srv-test -b schemaextract.cmd

schemaextract.cmd contains only one line:
CATALOGEXTRACT ALL OUTSTREAM 'u:\sapdb\schema.data'

Now if i take a look at schema.data, i have:
SQLMODE INTERNAL
//
USE USER ADMIN initial
//
CREATE USERGROUP ACHATS STANDARD EXCLUSIVE
//
CREATE USER CBONNAFOUX PASSWORD initial USERGROUP ACHATS
//
CREATE USER CMERVANT PASSWORD initial USERGROUP ACHATS
//
CREATE USER SCONDARCURI PASSWORD initial USERGROUP ACHATS
//
CREATE USERGROUP MAGASINS STANDARD EXCLUSIVE
//
CREATE USERGROUP MARKETING STANDARD EXCLUSIVE
//
CREATE USER ANUNEZ PASSWORD initial USERGROUP MARKETING
//
CREATE USER APILAS PASSWORD initial USERGROUP MARKETING
//
CREATE USER GMONTEIL PASSWORD initial USERGROUP MARKETING
//
CREATE USER LVIGNELLES PASSWORD initial USERGROUP MARKETING
//
CREATE USER PGALLOU PASSWORD initial USERGROUP MARKETING
//
CREATE USER PLEONET PASSWORD initial USERGROUP MARKETING
//
USE USER DBA DBA
//
CREATE USER ADMIN PASSWORD initial DBA NOT EXCLUSIVE
//
CREATE USER SYSINFO PASSWORD initial RESOURCE EXCLUSIVE
//
USE USER ADMIN initial
//
....

Now you can see that loadercli try to use the user admin BEFORE it is
created ! Of course if i try to use this file "as is" to load the
catalog to a fresh database, i get errors messages ( can't remember
which ones, sorry ).
If i put the lines
USE USER DBA DBA
//
CREATE USER ADMIN PASSWORD initial DBA NOT EXCLUSIVE
//
CREATE USER SYSINFO PASSWORD initial RESOURCE EXCLUSIVE
just after "SQLMODE INTERNAL", everythings run fine.
Is it a bug in loadercli, or do i missed something ?

TIA
Frédéric DEMILLY.

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]