NaNs

Greetings. If I have a key on a float and attempt to insert a NaN I get ERROR 1034: Incorrect key file for table: 'foo'. Try to repair it if I attempt to update/delete that row. If I remove the key from the float it seems to behave when I try to update/delete the row. Is this a bug / known l

Massive Research Data

Some background... We have Objects r1, r2 ... r1600 Which each have (~1600) regions d1, d2 ... d500 Which each have (~500) datapoints So, roughly we have around 786,000 datapoints on a given object. Typically, we might take 15 or so regions and take data from each of their d

Re: columns no more

> is there a way to delete a column from a table, without droping the > whole table? Yep! ALTER TABLE DROP [COLUMN] col_name http://www.mysql.com/doc/A/L/ALTER_TABLE.html > If not is can I get sql to replicate the command to re create the table? Yep! mysqldump -qd -u http://www.mysql.com

Storing Raster Data

I'm curious if anyone has any recommendations for storing large multi-layered raster data within mysql beyond simply using blobs or text fields. Although not a GIS application; the idea is similar. We are simply modeling 3D surfaces. Queries on the actual mapping structure stored within the ra

Representing Object Oriented Data in a RDBMS

Greetings! I've been using MySQL for years now and love it's flexibility, scaleability, and general useability. However, I think I might be beginning to bump into a wall in cleanly and efficiently representing some data structures within merely a relational system. My hope is that someone on t

Project + MyODBC

Has anyone successfully saved Microsoft Projects within MySQL? When I attempt to save a project I get a MyODBC error on the syntax, on, what I presume is one of their table creation SQL statements. Anyone have any insight? -

Re: Uploading files using PHP to database.

e with tons of data which doesn't add to the queryability of the data while limiting your database's ability to scale. Regards, seth --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle, Suite 103 Santa Clara, CA 95054 voice: 408-970-8881 x147 f

sql/table structure question.

tely, show me the widgets that closest resemble this widget. Meaning it should be smart enough to know that 100 C is close to 90 C then is 110 C in process step 5 of two compared flows. This is why chars become difficult to deal with. Sounds like the job of a recursive select.. but, perhaps

Re: Got timeout reading communication packets

unsigned NOT NULL default '0', data text NOT NULL, PRIMARY KEY (content_typeID,contentID,arrayID,positionID,testID,iteration), KEY test_locationID (test_locationID), KEY testID (testID) ) TYPE=MyISAM; Update log attached in seperate email. Take care, seth --- Seth Northrop Manag

Re: Got timeout reading communication packets

wait_timeout=300 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [myisamchk] set-variable= key_buffer=32M set-variable= sort_buffer_size=48M Any new ideas? Seth > Seth Northrop writes: > > > > > > 010624 19:44:23 Aborted connecti

Re: Got timeout reading communication packets

> The above only implies that your program exited without calling > mysql_close(). Nothing to do with your problem. > But.. why would the console be reporting this? Ie, I'm getting the same result (same error in the error log, same truncation) when I manually pipe the query to the mysql console.

Re: Got timeout reading communication packets

by = 18, > data = '396 601 12011801,0 191 191 191 > 191 190 189 188 188 188 188 188 187 > 191 191 191 191 192 ' -- --- Seth Northrop Manager of I

Re: Got timeout reading communication packets

> At a small glance, your code looks OK. Try looking at resulting string > sql in gdb or just print it out to stdout. That might catch your bug. > Thanks again for the reply. The query looks sane.. As I mentioned, I spit it out to a file and piped it directly to mysql (after inspecting it). At

Re: Got timeout reading communication packets

> > You are possibly not escaping binary fields. You should use > mysql_escape_string() function on binary objects prior to inserting it > in the INSERT command, or use load_file() function. > Thanks Sinisa for the reply! There really isn't any binary data.. and, we are calling mysql_escape_stri

Got timeout reading communication packets

Hi! I posted this last week, but, haven't seen any replies yet, and, generally, there seems to be a lack of replies in the archives on the "Got timeout reading communication packets" related issues. Here is the issue again: We have started doing some rather large replace intos and inserts (~3M

Re: how to prevent inserting duplicate rows?

> how do I OVERWRITE the previous entry in the > table? ie. is there a SQL command to do like INSERT, but if duplicate > found, overwrite with the new value. See REPLACE into http://www.mysql.com/doc/R/E/REPLACE.html Take care, seth ---

Re: RAID advice :> (fwd)

Sorry for the delayed reply.. the list marked my reply as spam ! ;) -- Forwarded message -- Date: Fri, 22 Jun 2001 02:48:14 -0700 (PDT) From: Seth Northrop <[EMAIL PROTECTED]> To: Wouter de Jong <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] Subject: Re: RAID advice :>

Re: what does this mean please?

t running to begin with. Try to connect with the -host flag to connect (so it won't use the socket) and shutdown and try to restart the mysqld - hopefully this will recreate mysql.sock Take care, seth --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle,

Re: Knowing if a table exits

our script to have. --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle, Suite 103 Santa Clara, CA 95054 voice: 408-970-8881 x147 fax:408-970-8840 http://www.reflectivity.com/ - Befo

Re: Database MySQL: myisamchk and isamchk error message

running on tables that are being used/open and not flushed and locked. --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle, Suite 103 Santa Clara, CA 95054 voice: 408-970-8881 x147 fax:408

Re: help with index

x? > alter table tablename add index (name,city); > alter table tablename add index (age,city); > alter table tablename add index (age,name); > etc... > > thanks > Jaime > > > > database,mysql > > --- Seth Northrop Manager of Information Technology Reflectivity, Inc.

Re: Repairing Tables

tery supply which you can monitor on the serial port - then you can safely shut down mysql and shut down the server before you run out of battery power. This of course assumes you can get a hold of a good quality UPS there at a reasonable price. --- Seth Northrop Manager of Information Technology R

Re: change table name?

> how do i change a table's name without recreating it? See: http://www.mysql.com/doc/A/L/ALTER_TABLE.html ALTER TABLE RENAME TO Take care, seth --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle, Suite 103 Santa Clara, CA 95054 voice: 408-

Re: help with index

from tablename where age > 30; > select * from tablename where city = 'new york'; You would thus want the prior, individual keys. Take care, seth --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circl

Re: passing variables to/from flash to/from php

but, alas, I would recommend checking out the "Ming" swf functions in PHP. http://www.php.net/manual/en/ref.ming.php Take care, seth --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle, Suite 103 Santa Clara, CA 95054 voice: 408-970-8881 x147 fax

Re: Startup Question

whole lot less of a pain to manage then the source distro. Just untar and go. --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle, Suite 103 Santa Clara, CA 95054 voice: 408-970-8881 x147 fax:4

Re: Is there any file .frm, .MYD, .MID on mySQL in HPUX Plateform?

, seth --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle, Suite 103 Santa Clara, CA 95054 voice: 408-970-8881 x147 fax:408-970-8840 http://www.reflectivity.com/ - Before posting

Re: Help me HOw to load Images or pictures into MYSQL database

les to minimize DB I/O and storage requirements. But, if you must, just write the data to a blob field. Take care, seth --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle, Suite 103 Santa Clara, CA 95054 voice: 408-970-8881 x147 fax:408-970-884

Large Replace/Inserts Truncating.

Hi! We have started doing some rather large replace intos and inserts (~3MB) using a client written in C. However, these queries are truncating at around 100k. There is no error returend by the connection, but, the error log does have errors such as these: 010323 11:15:19 Aborted connection

Borland C++ Builder (reading data).

Caveat: I'm not a seasoned Borland C++ builder programmer so this may very well be just plain stupidity on my part (I'm not even a really good C programmer either !). However, givem some code that looks similar to this: int state; MYSQL_RES *result; MYSQL_ROW row; char sql[250]; spr

C API; queries within functions.

Hi! This is probably more of a C inadequacy than a MySQL problem. I'm playing around with C with MySQL (I have to date only interfaced with it in PHP) and I was curious if anyone had any example code which illustrates how you would write functions which return mysql data. For example, in PHP I

Large scale statistical analysis

abases to handle large quantities of raw data like this. Thanks for any help! Seth --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle, Suite 103 Santa Clara, CA 95054 http://www.reflectivity.com/ --

getting rows with max values.

This may have been covered in the past; but, marc.theaimsgroup isn't responding so I can't run my normal search. I'm trying to extract rows with max values within unique groups - NOT just the max values. In very watered down terms: Given: CREATE TABLE test_table ( number tinyint(1) unsigned