Hi, I want to import a user's objects and data using a different user, because I need to create a copy of the same schema on the same instance, with the same data.
First problem I found is that I have some grants on my original schema, and this causes the loader to fail when importing into a new USER or schema. GRANT SELECT ON SECURITY.S_USER TO SOPORTE // * // E -25392: '[MySQL MaxDB][SQLOD32 DLL][MaxDB] General error;-4030 POS(17) Unknown schema:SECURITY' Original user: security - New user: security2 Looks like a limitation for the import process when grants are being used. It would be nice if the loadercli could prepend the schema name on runtime to this kind of statements. Next problem I found: I tried to change (in Windows) the text of the catalog script generated by the loadercli during the export, using WordPad, changing the name of the schema in the 2 lines that contained the GRANT instruction, but when trying to run the loadercli to import again this error gets displayed: // E -25501: Error opening file 'C:\servers\maxdb\luis-cat.dat': File not encoded as encodingUTF8. What should I use to edit my catalog?? it was generated on Linux Intel 32bit. Best regards, Martin Cordova -- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
