Re: Trouble connecting to 5.0.18

2006-02-07 Thread Brandon Ooi
oh i forgot to mention, the new passwords are stored in the database already. you need to reset the password with the OLD_PASSWORD() function. they detail that in the documentation b Brandon Ooi wrote: this refers to a new password scheme used in mysql 4.1 and above. see here to fix this

Re: Trouble connecting to 5.0.18

2006-02-07 Thread Brandon Ooi
this refers to a new password scheme used in mysql 4.1 and above. see here to fix this... http://dev.mysql.com/doc/refman/5.0/en/old-client.html b John Hoover wrote: I've been running MySQL 4.0.20 on Mac OS 10.3.5 for some months and had been working on a custom client. It was working well

Re: INNODB Questions and Optimization help

2006-02-07 Thread Brandon Ooi
Shaun Adams wrote: 1. The ibdata1 file size is 10GB. Does that sound right? Should this file be this big? That sounds right. Innodb seems to incur large space overheads. but with the cost of diskspace nowadays... 2. Once a week, I have to perform HUGE insert imports into the database.

Re: Spatial Extensions in MySQL: Multidimensional Points?

2006-02-07 Thread Brandon Ooi
Use 3d pythagorean theorem. the distance d between point1 (x1,y1,z1) and point2 (x2,y2,z2) is... d = sqrt((x1-x2)^2 + (y1-y2)^2 + (z1-z2)^2) as for building an index for this? i have no idea. but that is how you find the distance between two 3D points. b Jose Antonio wrote: MySQL offers Sp