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

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

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

Re: columns no more

is there a way to delete a column from a table, without droping the whole table? Yep! ALTER TABLE tablename 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 user database

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

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.

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 fax:408-970-8840 http

sql/table structure question.

select.. but, perhaps there exists some additional table hierarchies that I'm not thinking about to easily compare multiple levels of data. Your brilliance is requested and thanked in advance, Seth --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle

Re: Got timeout reading communication packets

test_locationID (test_locationID), KEY testID (testID) ) TYPE=MyISAM; Update log attached in seperate email. 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-8840

Re: Got timeout reading communication packets

ideas? Seth Seth Northrop writes: 010624 19:44:23 Aborted connection 231 to db: 'unconnected' user: 'root' host: `localhost' (Got timeout reading communication packets) The above only implies that your program exited without calling mysql_close(). Nothing to do with your problem

Re: Got timeout reading communication packets

601 12011801,0 191 191 191 191 190 189 188 188 188 188 188 187 191 191 191 191 192 snip/snip' -- --- Seth Northrop Manager of Information Technology Reflectivity

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: 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 tablename http://www.mysql.com/doc/R/E/REPLACE.html Take care, seth

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

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

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: Help me HOw to load Images or pictures into MYSQL database

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-8840 http

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

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:408-970-8840 http://www.reflectivity.com

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

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:408-970-8840 http

Re: help with index

, individual keys. 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-8840 http://www.reflectivity.com

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 tbl_name RENAME TO new_tbl_name Take care, seth --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle, Suite 103 Santa Clara, CA 95054

Re: Repairing Tables

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 Reflectivity, Inc

Re: help with index

and name = 'JOHN'; or do you suggest that I add the following on top of the previous index? 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

Re: Database MySQL: myisamchk and isamchk error message

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-970-8840 http://www.reflectivity.com

Re: Knowing if a table exits

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/ - Before

Re: what does this mean please?

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, Suite 103 Santa Clara, CA 95054 voice

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 : Let's say your

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];

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