Re: changing ip addresses

2008-04-26 Thread Norbert Tretkowski
Am Freitag, den 25.04.2008, 12:25 -0500 schrieb James Sheffer: Hi all, I've got a problem. A client of ours changed ip addresses on their mysql server, and I believe MySL was set up to listen on the old ip address. How can I see what ip address mysql is set to listen on, and how can I

Odd Results on Mysql LIMIT and ORDER BY

2008-04-26 Thread j's mysql general
Hi Guys, Firstly, this is the only time I have ever encountered this problem and searching archives or google shed no luck since yesterday so here I am . I have a table described below: mysql describe containers;

Re: Migration from 32-bit to 64-bit MySQL

2008-04-26 Thread Glyn Astill
another option is to do a mysqldump and pipe it over to the new server, e.g: mysqldump --opt 32bitserver | mysql --host=64bithost -C 64bitserver - Original Message From: Mike To: B. Keith Murphy Cc: mysql list Sent: Friday, 25 April, 2008 5:33:49 PM Subject: Re:

Re: Odd Results on Mysql LIMIT and ORDER BY

2008-04-26 Thread Brent Baisley
You may want to check on the version you are running. There have been a few odd bugs in various MySQL versions in regards to limits and order by filtering. Although it usually involved joins and/or unions. If you can't or don't want to upgrade your MySQL version, you can try restructuring