I have a 7.6 database on windows and now I am trying to migrate to linux. I have an OpenSuse 10.0 linux machine and I have installed maxdb 7.6 on it without problems. But when I try to load the catalog and data on my new database server I have several problems.
loadercli gives me problems with foreign keys, so I split the catalog file in the table creation section file and the create foreing keys section file (these are files named abril.catalog and abril.catalog0001). Then and I load the table creation file, then load the data file then I back up the database (this is needed to clear the read only mode from my tables) and finally when the tables are writable I load the foreign keys catalog file. Now the database has its tables and its data. I can modify the rows in any table without problems but IT DOES NOT ALLOW ME INSERT NEW ROWS. Every time I try to insert any row it returns a DUPLICATE KEY ERROR. Can somebody help me? Thanks in advance. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
