Ed, thanks for reporting these problems. As the proxy is an ALPHA version there may be serveral problems. But mysqldump and mysqlimport are supposed to work with the proxy! I planned to release the next version of the proxy next week and I will attemp to fix your problems by then.
Regards, Dirk -----Original Message----- From: Ed Bagdonas [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 29. Januar 2004 09:00 To: [EMAIL PROTECTED] Subject: maxdbproxy bug #2? 1) Using MySql 4.0 database, mysqldump was used to produce a 'load file' for MaxDB 7.5 creates lines like INSERT INTO DBA.FOO VALUES (40358,131,11,7349,44211,NULL,NULL,'2003-10-17','2003-10-18',1,6); 2) Using MaxDb 7.5, maxdbproxy and mysql to load the database creates the row but inserts the text NULL instead of a null value. I have to post process the 'load file' to add the user, public synonyms, address case issues, etc - so removing these with a macro is relatively easy. -----Original Message----- From: Ed Bagdonas [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 29. Januar 2004 08:28 To: [EMAIL PROTECTED] Subject: maxdbproxy bug? It was relatively easy to create and load a MySql 4.0 database with MaxDb (the biggest issue was dealing with table / column name cases); however, mysqldump does not work. Is it / will it be supported, or do I need to do something different? Note that I am running the command as the DBA / owner of the tables and they all have public synonyms. The following command, mysqldump -hServer1 -uDBA -pGOOD4U foo produces the following output: -- MySQL dump 8.22 -- -- Host: localhost Database: foo --------------------------------------------------------- -- Server version 4.0.14 -- -- Table structure for table 'ACTION ' -- CREATE TABLE `ACTION` ( `PKEY` INT (10) NOT NULL DEFAULT DEFAULT SERIAL (1), `ACTION` VARCHAR (32), PRIMARY KEY (`PKEY`) ) TYPE=innoDB; -- -- Dumping data for table 'ACTION ' -- mysqldump: Got error: 1105: MaxDB [-4004] Unknown table name:ACTION when retrieving data from server -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
