Hi list, I am trying to export data using the loadercli from an ASCII database instance running on a 7.4.3 BUILD 027-121-048-452 database kernel, to another ASCII database instance running on a 7.6.00 BUILD 034-121-134-685 database kernel. I am using the loadercli that came installed with the 7.6 database, and am specifically trying to do the following:
1. Export the whole schema and data in it for a specific user in the 7.4 database: AUTOCOMMIT ON // SQLMODE INTERNAL // SET DATE INTERNAL // EXPORT USER CATALOG OUTSTREAM 'usercatalog.txt' DATA OUTSTREAM FILE 'userdata.txt' This works without a hitch. 2. Import the same catalog and data into the 7.6 database, using a user with the same user name as the one in the 7.4 database: AUTOCOMMIT ON // SQLMODE INTERNAL // SET DATE USA // SET MAXERRORCOUNT 1 // IMPORT USER CATALOG INSTREAM 'usercatalog.txt' // IMPORT USER DATA INSTREAM 'userdata.txt' This works fine until the last command, which errors out with: Error during execution -->-25342 Error restoring table TABLENAME; table exists but source table schema and target table schema are different At this point, thinking that issue may be that maybe there's a foreign key being applied that makes the import fail due to the tables not being imported in the correct order, I used the exported schema definition to manually create the new schema minus the foreign keys, and then just execute the import data statement. However, this yields the same error. Also, the table on which the first error occurs has no foreign keys defined. Previously, I have been able to make this kind of data migration between these two database versions work for a simpler schema between UNICODE instances, but when I try this larger one, I am stumped. Both databases are ASCII databases, with ASCII as the default code, and further the user name used for both the export and the import is the same. Is there some other setting that needs to be the same between instances, or is there something else to check that may be the cause for the unsuccessfult import of data? Thanks in advance for any insight! Regards, Johan Hallgren -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
