RE: Help! Can't get my MySQL service started!

2009-10-22 Thread Gavin Towey
Do you have a program called mysql_install_db? It looks like you need that to create the initial mysql system database in your data directory. Regards, Gavin Towey -Original Message- From: Matthew Laurence [mailto:mattlaure...@gmail.com] Sent: Thursday, October 22, 2009 10:24 AM To: mys

MySQL Community Server 5.1.40 has been released

2009-10-22 Thread Karen Langford
Dear MySQL users, MySQL Community Server 5.1.40, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.40 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/mys

Help! Can't get my MySQL service started!

2009-10-22 Thread Matthew Laurence
I'm trying to configure and start a MySQL 5.1 service for the first time, and I'm having trouble. The MySQL Server 5.1 system was installed on a separate drive from the system drive (if that's an issue). My GUI tools are on the C: drive, and the server installation is on the E: drive. Anyway, I'm

Re: Passwords not working

2009-10-22 Thread John Oliver
On Mon, Oct 19, 2009 at 07:45:11PM -0400, Michael Dykman wrote: > The type of password instability you are talking about is pretty much > unheard of in MySQL.. Yeah, well, I can have a real black thumb for this sort of thing :-) I'm sure I read about at least two different ways to add passwords.

Re: Bug? Distinct AS with Order By

2009-10-22 Thread Glyn Astill
> From: Glyn Astill > > Doesn't look crazy to me, and it works in 5.0.32 > > http://www.privatepaste.com/50RvhihKKm > > Perhaps time to patch that server ... > I've guessed at the table def there, obviously your def may be different and that would surely affect the palanners choice. Perhaps

Re: Bug? Distinct AS with Order By

2009-10-22 Thread Glyn Astill
> From: Matt Neimeyer > > Generic code to draw a SELECT element on the screen > sometimes it ends > up like such... > > SELECT DISTINCT name AS myvalue,name AS mydisp FROM names > WHERE > name!="" ORDER BY myvalue > > On 4.1.22 this returns > > A A > B B > C C > D D > > On 5.0.22 this returns

Bug? Distinct AS with Order By

2009-10-22 Thread Matt Neimeyer
I'm not sure what to search on to see if someone has reported this as a bug or if I'm doing something wrong... Generic code to draw a SELECT element on the screen sometimes it ends up like such... SELECT DISTINCT name AS myvalue,name AS mydisp FROM names WHERE name!="" ORDER BY myvalue On 4.1.22

Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

2009-10-22 Thread Tompkins Neil
Hi, We are currently running a early version of MySQL and are looking to upgrade to the latest version 5. However, we have a number of external applications which use the MySQL Connector/ODBC 3.51. What are the differences between ODBC 3.51 and ODBC 5.1. For example do I need to use ODBC 5.1 if

Re: ad hoc replication for 3 X 40 000 rows

2009-10-22 Thread Sydney Puente
> However sync's from MS SQL to MYSQL are required every 24 hours after the > initial > dataload. > And this has me puzzled. > Advice anyone? > Please ;-) If there's a auto-inc key, you can find the last one from the MySQL_table then SELECT ... from MSSQL_table where key > found_key. Otherwise