4.1.7 Character set problem ( Ithink?)

2005-02-11 Thread Ian Gibbons
Hi List, I am having a strange problem on Linux Fedora Core 3 with MySQL 4.1.7 ( offical mysql rpms). The data was originally stored in MySQL 3.something and was placed into the database via a MySQLDump file. It is too late to reload the data. I have a table called fees: CREATE TABLE `fees` (

Re: 4.1.7 Character set problem ( Ithink?)

2005-02-14 Thread Ian Gibbons
On 12 Feb 2005 at 14:09, Gleb Paharenko wrote: > Hello. > > Please tell us, what output the following statement produces: > SHOW VARIABLES LIKE '%char%'; Hi Gleb, mysql> SHOW VARIABLES LIKE '%char%'; +--++ | Variable_name| Value

Error compiling from source rpm 4.1.10 on Cobalt raq4i

2005-02-22 Thread Ian Gibbons
Hi, I am trying to compile the official source rpm on a Cobalt Raq4i using the command: rpm --rebuild --clean MySQL-4.1.10-0.src.rpm But I get the follwing error: examples/ha_tina.cc: In method `int ha_tina::rnd_init(bool = 1)': examples/ha_tina.cc:612: `MADV_SEQUENTIAL' undeclared (first use

RE: where mysql_config?

2005-02-24 Thread Ian Gibbons
On 24 Feb 2005 at 12:50, schlubediwup wrote: > Hi > > this is the error message you get when trying to access mysql from php > using a userid which has been created under mysql 4.1 whithout taking > the precaution to apply the old_password function to create the password: > > Client does not s

Re: Computer reboots during long table join

2005-04-15 Thread Ian Gibbons
On 15 Apr 2005 at 9:47, mos wrote: > I'm running MySQL 4.1.10 on XP and I was doing a 2 table equi join join on > a date field that was indexed. There are It was taking quite a long time so > I let it run overnight. There are 200 million rows in the first table, but > a Where clause on the sec

Re: Problem searching table

2004-01-15 Thread Ian Gibbons
On 15 Jan 2004 at 12:33, Matthew Stuart wrote: > ASP and VB > > I have created a search web page searching a MySQL table with the > following code: > > CREATE TABLE tbl_allarticles ( > fld_ID mediumint(8) unsigned NOT NULL auto_increment, > fld_category tinyint(2) unsigned NOT NULL default '0'

Re: Retrieving field characteristics

2004-09-28 Thread Ian Gibbons
On 27 Sep 2004 at 11:36, Rhino wrote: > I really have no idea how Java is getting the information. I haven't tried > very many of the metadata methods yet so I don't know how much Java can > actually see and what is hidden. But I do know that it can see the > descriptions of the columns. > > I

Re: tree structure

2004-10-18 Thread Ian Gibbons
On 18 Oct 2004 at 15:27, Melanie wrote: > Hi, > Does anybody has a simple idea to store a tree structure under mySQL 4.1.5? > I have one table with id, familyType,superFamily,family, for example: Hi, This tutorial (PHP + MySQL) shows a few different methods: http://www.sitepoint.com/article/hie

Re: Upgrade - Downgrade problems

2004-11-04 Thread Ian Gibbons
On 4 Nov 2004 at 0:59, Schalk Neethling wrote: > Since installing the latest 4.1 version of MySQL I have not been able to > run phpMyAdmin. > > I have since gathered that the current version of phpMyAdmin is not > compatible. I therefore ran Add/Remove programs on Windows and installed > 4.0.2

Re: ODBC Initial Setup Problems

2004-11-05 Thread Ian Gibbons
On 5 Nov 2004 at 10:01, Rick Dwyer wrote: > Hello All: > > I am trying to configure ODBC for MySQL but have been unable to make > a connection. Hi, I have no experience of Mac OS X, but I believe it is linux-ish which means case- sensetive path names. The line below shows library with a lower

Re: Starting mysql as a service once installed

2004-11-22 Thread Ian Gibbons
On 22 Nov 2004 at 9:34, James Sherwood wrote: > Hello, > > I have installed mysql but did not install it as a service. > > All I do is runmysqld-max-nt.exe > > Now I need it to run as a service. It is on a win2003 machine. > > Can I make it run as a service once I already have it installed.

Re: Reset permissions

2004-11-24 Thread Ian Gibbons
On 23 Nov 2004 at 22:36, Tim Trice wrote: > How can I reset the permissions on my database? I have no clue when I did > it (at least several months ago), haven't used it until today but I cannot > for the life of me figure out how I can create a new user with all > permissions. The only user I h

Re: MySQL DBD not following my.cnf for socket file

2005-01-13 Thread Ian Gibbons
On 13 Jan 2005 at 10:47, Sid Lane wrote: > hope this isn't considered too off-topic but... > > I have been working on standardizing the directory trees on our MySQL > servers (a la OFA for those who speak Oracle) but when I repoint the > socket parameter in my.cnf all my perl scripts barf w/: >

Re: Embedding MySQL in application, probably developed in C#

2005-01-24 Thread Ian Gibbons
On 19 Jan 2005 at 21:28, elizabeth baker wrote: > We are building an application for myths of the world. It started out in > Access, but when we decided to distribute it via CD to attendees at an > art retrospective (about myths of the world), we began looking for an > alternative db, since not

RE: Where can I download The MySQL C API??

2005-01-25 Thread Ian Gibbons
On 25 Jan 2005 at 16:07, Shuva, Judith wrote: > Hi J.R. > > Thanks for your answer. > > I saw that the API suppose to be in the MySQL server, so I downloaded > mysql-essential-4.1.9-win32.msi, but after the installation, I can't > find the API in the MySQL folder... > > Please, HELP! Hi, Th

4.1.3-beta-nt-log Select Count(1) returns as unknown type in ASP/vbscript

2004-07-08 Thread Ian Gibbons
Hi, Whilst testing some asp websites with Mysql Beta 4.1.3-nt-log I have noticed that doing a Select Count(1) as var FROM tableName returns as an unknown variable type in vbscript. Previously with the 3 / 4.0 version it returned as a long. I am using the latest MyODBC 3.51.08.00 Is

RE: 4.1.3-beta-nt-log Select Count(1) returns as unknown type in

2004-07-08 Thread Ian Gibbons
On 8 Jul 2004 at 7:28, Victor Pendleton wrote: > Does the older MyODBC version properly work? I have run into some oddities > with the latest MyODBC driver. Forgot to mention... Same result with 2.50.33.00 Ian -- > > -Original Message----- > From: Ian Gibbons > To

[OT] Email addresses shown in archive at lists.mysql.com

2004-07-12 Thread Ian Gibbons
Dear list, After posting a question last week from an email address I only use for this list, I have already started to receive spam and virus reports. Looking at the archives at lists.mysql.com I notice that the from address is not shown, just the name. But... If someone else quotes your mes

Re: "proxy" a connection to remote host?

2004-08-09 Thread Ian Gibbons
On 8 Aug 2004 at 20:04, Steve Leibel wrote: > What I'm wondering is if there is a cleaner and simpler way, for > example to set up some sort of proxy server on host X that will > establish a connection with the mysql database and then relay > requests and responses back and forth to my code on

RE: excel

2004-08-20 Thread Ian Gibbons
On 20 Aug 2004 at 10:09, [EMAIL PROTECTED] wrote: > >>> Hmm... I use ASP.net, is there any instruction that I can use to use > ASP.net > >>> to export into excel or is there another way? > > Well, I know nothing of ASP.net, but you should be able to select from > mysql, then instantiate excel via

Re: Crash on Windows XP SP2 when not run as an administrator

2004-09-01 Thread Ian Gibbons
On 31 Aug 2004 at 17:33, Todd O'Bryan wrote: > I've tested mysql in my high school lab running from an administrator > and from a student account, both from within the Cygwin terminal, and > at the Windows command prompt. From the administrator account, it runs > fine for hours. From the studen

RE: 4.1.4 still reports itself as 4.1.3b-beta

2004-09-02 Thread Ian Gibbons
On 2 Sep 2004 at 16:01, Terry Riley wrote: > Victor > > C:\MYSQL\BIN\mysqld-opt --defaults-file="C:\WINDOWS\my.ini" MySql > > is what the path-to-executable states. If I remember rightly, the new > version should be mysqld, period. Is that what's wrong? > > Will I have to tweak the registry to

Re: Secure logon from VB.net

2004-09-22 Thread Ian Gibbons
On 21 Sep 2004 at 10:14, Thomas Trutt wrote: > Hello all, > > Ok i know this may be a simple question but i need a little help. > I am writing a program in VB.net that uses MySQL as a backend. My net admin > wants the log on to be encrypted?? > > This is currently how i am connecting:

Re: MySQL Website

2004-04-21 Thread Ian Gibbons
On 21 Apr 2004 at 9:14, Lou Olsten wrote: > I have not been able to access the mysql.com server for about a day and a > half now from my office. From home, it's fine. There have been rare > occasions in the past when our provider had dropped (or very slow) > connectivity with certain nodes on th