.fc11.x86_64.rpm) but after doing this it
still errors out.
Thanks,
Seth
if the server/client authentication (validating the
certificate against given authorities) failed? Do I just get a vague
"SSL connection error" back from MySQL and that's it?
I think that's mostly it.
Thanks,
--
Seth Willits
--
MySQL General Mailing List
For lis
On Jun 21, 2007, at 12:21 PM, Gerald L. Clark wrote:
Seth Seeger wrote:
Hello,
I'm having trouble copying a database from MySQL 4.1.22 to 5.1.19-
beta. Both are FreeBSD i386-based machines. I have run the
following commands:
mysqlcheck --check-upgrade --all-databases --auto-r
tried it with all different combinations for the two directory
options with no luck. All tables are MyISAM.
Can anyone shed some light on what I'm supposed to do?
Thanks,
Seth
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
)
fldRegulation_7_Updated (date)
How would I write such a query? Am I trying to do the impossible? I
want only one fulltext index but it seems like I can only get the
summary results if I design my table as in example 2.
I will greatly appreciate any advice.
Best regards,
Seth
--
MySQL General Mailing List
For list
| 2005-06-27
Ann | Toast | 2005-06-13
Jim | Pizza | 2005-06-28
Anyone have ideas of how to do this in one query?
Thanks,
Seth
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sqlbinlog --database=backuptest
--start-datetime="2005-03-30 15:00:00" /data/mysql/logs/dbne1-bin.173 |
/usr/local/mysql/bin/mysql -u seth -p backuptest
Enter password:
ERROR 1050 at line 10046: Table 'foo' already exists
thanks.
-seth
--
Seth Itschner
SparkNotes
[EMAIL PROTEC
the oldest review from
the unique movies_id.
Does anyone have an idea where I can take the most recent 4 rows that
have a different movies_id without doing extra processing work in PHP?
Thanks,
Seth
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
n you telnet to localhost:3306?
Seth
On Sun, 10 Oct 2004 17:33:18 -0500, Carl Karsten <[EMAIL PROTECTED]> wrote:
> I am trying to connect to MySql with an SSH tunnel that terminates on the same
> box MySqld is running on. I would expect that I do L3306:localhost:3306 and
> gr
Could this be a 'register_globals' issue? (Check your php.ini file.)
Are you sure that the queries you're sending are correct? Is
mysql_query() returning any errors?
Some more information, please!
Seth
On Fri, 1 Oct 2004 23:35:09 -0500, tom miller <[EMAIL PROTECTED]> w
e 700
permissions (owned my the mysql user) and everything within those
directories should be 660 (owned by the mysql user and mysql group).
(This was on a FreeBSD 4.8 server running MySQL Server 3.23.58)
Hope this helps,
Seth
On Wed, 22 Sep 2004 08:36:21 +0800, æé <[EMAIL PROTECTED]> wrote:
>
to
0 as a number on all rows.
If anyone could email me at [EMAIL PROTECTED] and assist me or for a better
explanation if not understood, it will be greatly appreciated.
-Seth
www.SocomZone.com
The manual describes wait_timeout thusly:
"The number of seconds the server waits for activity on a non-interactive connection
before closing it. On thread startup, the session wait_timeout value is initialized
from the global wait_timeout value or from the global interactive_timeout value,
dep
I have been maintaining a mod-perl/MySQL4 web search engine with about 3M records,
which gains and drops about 100k records daily.
It runs on a dual-Opteron 242 system with 8GB RAM, 15k SCSI driv, SUSE Professional
for AMD64.
It recently grew to this size (from about 1M records), and I am encoun
ut I would really rather not.)
Thanks you,
Seth
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> If you are using MySQL 4.x, using a RAM disk isn't going to speed
> up similar Selects very much because it caches them. If you are doing a
lot
> of different Selects then it will help.
Its a web search engine with 10-15 search options, so yes the selects will
vary and very often every row will
- Original Message -
From: "Seth Brundle" <[EMAIL PROTECTED]>
To: "Eric" <[EMAIL PROTECTED]>
Sent: Wednesday, January 28, 2004 5:50 PM
Subject: Re: 64-bit Linux MySQL and ramdisks
> > I am curious, is there really that big of a benefit to using a
reccommendations for dual-opteron 64-bit Linux distributions or any
experience or tips on running MySQL on a ramdrive I'd like to hear them.
Thanks
Seth
e no idea where 'quote_names' is or where it's
supposed to be.
any suggestions would be lovely...
thanks
-s
--
__
Seth Redmond
DNA resource and Database Curator
Wellcome Trust Laboratories for Molecular Parasitology
Department of B
ing on the same machine, so I
shouldn't be having any problems from the server.
-s
On Friday, June 27, 2003, at 02:06 PM,
[EMAIL PROTECTED] wrote:
Seth Redmond <[EMAIL PROTECTED]> wrote:
I've been having a few problems loading blobs via the LOAD_FILE
function
I've trie
been able to load smaller files no problem but can't do anything with
files of around 4mb.
I'm using mediumblob (and have tried long), max allowed packet is set
at 16mb. The files are readable by all, and I have file permission.
I'm basically out of ideas...
-s
--
___
PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> In the last episode (Mar 31), Seth Brundle said:
> > First people, please dont get all angry about my suggestion...please
> > hear me out...
> >
> > > I really hate on-line forums. They're difficult
> No but those in need of help does. And those ppl who are capable of
helping
> them are usually busy. Do they keep a browser open and refresh the forum
> frequently? I'll answer that question: no.
Many forums packages have the ability to distribute the discussion as a
mailing list as well (Yahoo!
> Most ppl don't like forums.
I disagee with that, but then again I probably dont have any more idea then
you do.
> Do you know even one serious project which uses
> a forum? I know Slackware did and it really was a PAIN.
All of the projects on SourceForge.net?
Also, by forum I also mean usenet
> It's much more convenient than a web forum, and much
> faster too, because I don't have to wait for some remote, overloaded
server
> to respond.
This makes no sense as message I post to a Yahoo! Group get emailed to
opt-in members and appears on the group within seconds, while I may not
receive
> > I really hate on-line forums. They're difficult to track because I
> > must remember visit them daily.
>
> Agreed. I don't need yet another web page to keep track of. I prefer to
> let my mail reader thread up the messages on this list, then I browse
> through every now and then and delete e
First people, please dont get all angry about my suggestion...please hear me
out...
> I really hate on-line forums. They're difficult to track because I
> must remember visit them daily.
OK this is the first issue - 95% of people who need MySQL info do not need
it daily. Mailing lists are a poor
I really hate mailing lists - they are dinosaurs for this type of thing.
A web discussion board is a much more powerful and flexible tool for this
type of community. Thread tracking, archiving, searching, dont have to
download 50 emails a day just to monitor a couple threads...cmon its 2003!
Cant
Is it possible to place MySQL data directories on a Linux ramdisk mount?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this th
I just built a P4 3.06 1GB DDR 333 15k U160 SCSI MySQL Linux server.
I was dissapointed because I couldnt get the dual-channel DDR 400 MB I tried
first to run stable :(
dual-channel memory controllers definitely made a slight difference on the
benchmarks with the same ram.
alter-table 2
I attempted to optimize a table last night, which usually takes about 5
minutes but I expected to take longer as I had done a slew of deletes.
Well, it took over an hour, and from the last modified dates on the table
and temp files, it looked like they hadnt been updated in 10-15 minutes.
Eventua
er chunk. I am
trying to design it well enough though that we could in the future use
all of the Landsat imagery for the entire U.S. (also 6km x 6km chunks
at 30m resolution). There are about 90 different possible statistics
per landscape.
Thx,
Seth
On Sunday, March 2, 2003, at 06:31 PM, Bruce Feist
) SELECT AVG(column1), FROM table1 LEFT
JOIN temp ON temp.xy=table1.xy WHERE AND
temp.xy IS NOT NULL; (maximum of 20k rows, less after both WHERE
statements tho)
Does this sound like the best way to accomplish this? Any suggestions?
Thx,
Seth
On Sunday, March 2, 2003, at 03:41 PM, Seth Price
COUNT, STD,
MIN, and MAX) in my script? I was hoping to do this in a less time
consuming fashion.
I can calculate all of this in a timely manner when I am only using
values from table1.
~Seth
-
Before posting, please chec
I have a MySQL database I will be launching soon which has a search engine
database accesable over DBI/mod_perl/Apace. It has about 2M records, and is
a 4GB table with 1GB index.
Every day I insert 76k records all at once and delete about another 76k.
While these inserts are happening, the select
nough for now, but in the future I may have
approx. 3,500k rows, so I am a little more worried about my SELECT
performance then.
~Seth
On Tuesday, February 11, 2003, at 12:54 PM, Peter Grigor wrote:
- Original Message -
From: "Seth Price" <[EMAIL PROTECTED]>
To: <
Has the maximum number of keys in a MyISAM table been tested more since
this post? Is it possible to get above 64 keys? (I'm going for 90, btw)
~Seth
to get past spam filter: MySQL sql query
Subject: Re: Maximum of 16 indexes per table
From: Michael Widenius
Date: Fri, 30 Jul 1999 23:
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
I would buy a book called PHP Essentials. www.thickbook.com
I used it to learn how to write an html/php interface to my databases and i
use it all the time now. It takes a bit of work to get the interfaces built
but the book is really easy to follow and understand.
seth
-Original Message
In SuSE you should be able to start the MySQL server by:
rcmysql start
or
rcmysql restart
rcmysql is a symlink to the /etc/init.d directory
-Original Message-
From: John Macloy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 2:26 AM
To: [EMAIL PROTECTED]
Subject: AW: AW: mysql
analysis similar to this using MySQL as their backend.
The environment is R&D so queries will be fairly limited. We obviously
don't want queries to take down the DB server, but, at the same time this
isn't the backend data to Yahoo! serving millions of re
u
http://www.mysql.com/doc/m/y/mysqldump.html
> can I transfer information to a dummy table while
> I create the table I want?
Yep!
Just do a select into outfile
http://www.mysql.com/doc/S/E/SELECT.html
then a load data infile
http://www.mysql.com/doc/L/O/LOAD_DATA.html
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
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
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?
-
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
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
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
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
veral MB large.
Or... are we just having a huge disconnect here?
Thanks!
Seth
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reques
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
> 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
>
> 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
gone away" errors.
- Box is a 1Ghz XEON /w Redhat 7.2 and 1GB RAM
- MySQL version is: 3.23.35
- Query is a fairly straight forward insert or replace into and is
verified as clean.
Am I missing a configuration directive? Is something else up?
Thanks!
Seth
> 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 c
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 :>
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,
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
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
ver two
individual keys.
Take care,
seth
On Fri, 22 Jun 2001, Jaime Teng wrote:
> >> whats the difference between:
> >> alter table tablename add index (name);
> >> alter table tablename add index (age);
> >> alter table tablename add index (birthdate);
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
> 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-
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
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
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
,
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
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
XEON /w Redhat 7.2 and 1GB RAM
- MySQL version is: 3.23.35
- Query is a fairly straight forward insert or replace into and is
verified as clean.
Am I missing a configuration directive? Is something else up?
Thanks!
Seth
-
Before
Just wondering if there is a way to limit the number of connections to a
particular database without starting up another server to run that database
specifically.
-
Before posting, please check:
http://www.mysql.com/manual.ph
element in row under Borland (various other
functions as well) whereas the exact code (in all instances) works fine
when compiled with gcc. Again though, any WRITES to the database work
great under Borland (so I don't think it's a conne
What if the queries were updates instead of inserts? Would I need or be
able to lock the tables then?
Can I go without locking the bdb tables and not worry about the data
integrity on those tables during updates and inserts?
-Seth Hall
Student Programmer
Ohio State University Main Library
Is locking not necessary on BDB tables? Does transaction support get rid of
the need for table locking?
thanks,
-Seth
>On Thu, May 17, 2001 at 12:35:09PM -0400, Seth Hall wrote:
>>
>> Hi, could someone point me to a tutorial on when to do table locking
>> with th
he mysql connection
mysql_close(connection);
printf("Done.\n");
}
Ny guess is that if I just see a couple of examples which mimic some of
the functionality of the above PHP function in C I'll be able to write
them without a problem.
Any pointers on where to look?
Thanks!
Seth
t into Table (field1, field2) VALUES (2,'hi');
rollback;
this doesn'tit's committed anyway
begin work;
lock tables Table write;
insert into Table (field1, field2) VALUES (2,'hi');
unlock tables;
rollback;
Thanks,
Seth Hall
Stu
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/
--
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
76 matches
Mail list logo
