Hello list, I am attempting to export the data and catalog for a user in a 7.4.03.27 instance and import them into a 7.6.00.34 instance. The procedure I follow is this, using the database tools on the server running the 7.6 instance for all operations:
1. I have ensured that the 7.6 instance has COLUMNCOMPRESSION set to NO, and that it is an ASCII instance, just like the source 7.4 instance. 2. I export the catalog and data for a user from the source instance with this loader command: EXPORT USER CATALOG OUTSTREAM '1altwebcat.txt' DATA OUTSTREAM '1altweb.txt' This seems to complete successfully. 3. I then import the catalog into the target instance with this command. The catalog import works with no errors: IMPORT USER CATALOG INSTREAM '1altwebcat.txt' 4. Using the sqlcli I then drop all foreign keys from the just imported catalog, to remove the chance of integrity violations during data import. This also works fine. 5. I then try and import the user data using this command: IMPORT USER DATA INSTREAM '1altweb.txt' PAGES This populates a few tables with data, but then stops with "Segmentation fault" being displayed in the console, with not error code of any kind. The loader log file simply contains these lines for the import: IMPORT USER DATA INSTREAM '1altweb.txt' PAGES // * // M Import PACKAGE x'01000000A3AD4C46EE230000D1F9FA1A04C4AC1200000000' // * // M Execute PACKAGE to transform DATA // * // M Number of TABLES to transform: 0 // * There is no ending error or anything. I have tried the same procedure for other users in the same instance, and in those cases all data can be successfully imported. Further, in checking the data in the source instance for the first table whose data fails to be imported, nothing there looks out of the ordinary. Any insight on what could possibly be wrong would be most appreciated! Thanks, Johan Hallgren -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
