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 second

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 support

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: 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

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: 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, The MySQL

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: 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: 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 have

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. I

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: 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.22 but

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:

Re: Retrieving field characteristics

2004-09-28 Thread Ian Gibbons
On 27 Sep 2004 at 11:36, Rhino wrote: snip 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: 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: 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 change

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 student

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 COM to

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

[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

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: [EMAIL PROTECTED] Sent

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 the

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',