Hello Simon, The MySQL Proxy will not work with databases < 7.5, as the MySQL authentication (a challenge/response method plus special hashing) is implemented in 7.5 only (and this is the only method an unmodified mysql client program is able to do).
BTW, you assumption is right, it does some SQL translation between the dialects. Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Simon Matter [mailto:[EMAIL PROTECTED] > Sent: Friday, January 02, 2004 11:26 PM > To: blackDoggy > Cc: [EMAIL PROTECTED] > Subject: Re: Problems with MaxDBProxy > > > > Hello, > > > > I have some problems understanding how exactly MaxDB proxy works (or > > should > > work). I have a small MySQL database, which I would like to > import into > > MaxDB. I thought that I should just start MaxDBProxy, use > mysqldump to > > dump > > the database to a file, and then use mysql client to load it back to > > MaxDB. > > I assume that MaxDBProxy would even translate SQL of some > queries, like in > > those where mysql-specific data types are used. > > > > However, when I tried to connect to MaxDBProxy using mysql > command-line > > client, it complained that 'No database is selected'. > > > > Any help or suggestions would be greatly appreciated! > > Hi, > > I just had exactly the same problem. I tried to make our SAPDB 7.4 > database accessible for a webapplication which relies on > MySQL. I could > start the MaxDBProxy but then couldn't connect with 'mysql > --user="DBA" > --password="DBA" --socket="/tmp/mysql.sock" TST74'. Also > mysqldump doesn't > work. > > Simon > > > > > Best regards, > > Andris Spruds > > [EMAIL PROTECTED] > > > > > > I am using MaxDB 7.5.00.05 > > The MaxDBProxy was from MaxDB 7.5.00.08 Alpha > > I used MySQL client from 3.23.54, with the following > command 'mysql -u > > dba -p mydatabasename' > > > > > > > > > > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
