I noticed the MySQL Intel 3.23 stable binary has changed its name on the
download page from pc-i686 to libc6.
Is this just different terminology or is something else different?
Helpful souls cautioned me against running the i686 binary on a i586
machine--would this be the same deal?
I'm trying
I need a little help getting Basilix to run. The one part I can't get is
the db connection. Somehow username and password are placed in the
basilix.sql file with the command >mysql -u "username" -p "password" <
/usr/local/basilix/db/mysql/basilix.sql
This command (I assume) works fine IF both
Hi All,
How can I create InnoDB table. If I tried create a InnoDB Table on my RedHat
Linux MySQL 3.23.26 . Can any body give details that how can I create InnoDB
table.
Thanks in advance,
sreedhar
-
Before posting, please chec
Using Perl:
my $GMTdate = gmtime(time);
this will give you the GMT time.
>>On Tue, 05 Feb 2002 15:27:18 +1100, Oliver Mannion <[EMAIL PROTECTED]> wrote:
>>Right.
>>
>>Perl seems to work with daylight savings, how is this?
>>
>>At 08:03 PM 4/02/2002 -0800, James Montebello wrote:
>>>
>>>UTC
Right.
Perl seems to work with daylight savings, how is this?
At 08:03 PM 4/02/2002 -0800, James Montebello wrote:
>
>UTC doesn't do daylight savings. One reason is that different places
>do daylight savings at different times. We here in the Western US, for
>example, are in standard time righ
I ended up using head and tail to split it into 2 files, so that I
didn't have to edit it. See, it was the output of a mysqldump from two
databases, and I needed to make sure each part went where it needed to
go.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
If you need to update an old record in unique key, try to use REPLACE
function. REPLACE could add if there has not existing record and update
when it found a same unique key.
Sommai,
At 19:01 5/2/2002 +, DL Neil wrote:
>HelloErik,
>
> > I have a slight dilemma, and was wondering what the
On Monday 04 February 2002 07:33 pm, [EMAIL PROTECTED] wrote:
> Version: 4.0.1 binary distro(I have gcc 2.96, so I'm using your prebuilt
one)
> Synopsis: Upon executing a query using the MATCH() clause with FULLTEXT
indicies,
> it will crash the mysqld daemon.
Thanks for the
UTC doesn't do daylight savings. One reason is that different places
do daylight savings at different times. We here in the Western US, for
example, are in standard time right now. In Arizona, they don't do
daylight savings at all.
james montebello
On Tue, 5 Feb 2002, Oliver Mannion wrote:
I am close to a solution:
select FROM_UNIXTIME(UNIX_TIMESTAMP(),
'%Y %D %M %h:%i:%s %x');
UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01 00:00:00' GMT
Convert this to a date format and you have a GMT date.
Thanks to Chris Land for pointing the UNIX_TIMEST
Hi Kinney,
On Mon, 2002-02-04 at 12:06, Kinney Baughman wrote:
> Hi,
>
> I'm playing with PHP/MySQL for the first time having used Perl and MySQL
> for years.
>
> In one of my first update scripts, PHP is automatically escaping quotes and
> such, which I assumed was a good thing.
PHP has a
At 0:35 + 2/5/02, David Ayliffe wrote:
>Hello,
>
>Thanks for your time. I'm having some problems loading images into a
>table. I'm using the statement:
>
>INSERT INTO BLOBTEST set b1=load_file<'c:\1.jpg');
You'll probably need to double the '\' character. Or perhaps use
a '/' instead. (Th
I need to find a text editor for Linux that doesnt load the whole file
into memory. I need to edit a 1.5 gig text flatfile to add two lines.
But I dont have enough ram to open it in most programs. Can anyone
recommend something?
Filter: sql,query
Matthew Walker
Ecommerce Project Manager
Mounta
many thanks brothers
Now, my query fastest again with limit 1, because query count(*) just result
1 row
=-hery-=
- Original Message -
From: "BD" <[EMAIL PROTECTED]>
To: "Hery Yulianto" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 10:34 PM
Subject: Re: How
I'm hoping I can get some help here, I'm trying to get MySQL running
on YellowDog Linux 2.4.17 kernel. I've installed the mysql,
mysql-server and mysql-devel-3.23.32-1.7a rpms from my install CD.
Ran mysql_install_db then changed the group and owner on
/var/lib/mysql to root.
This is what sho
Version: 4.0.1 binary distro(I have gcc 2.96, so I'm using your prebuilt one)
Synopsis: Upon executing a query using the MATCH() clause with FULLTEXT indicies,
it will crash the mysqld daemon.
The query that does this is a "multi table" query, as such..
MATCH(table1.col1, tabl
Hi all,
A couple of weeks back you may remember that I was asking about
setting up a new client on our server that ran around 35GB in bandwidth
per month mostly from MySQL queries. Well, we have put them on our
server and have good and bad news. The good news is that they are now
pull
You *could* use UNIX_TIMESTAMP(NOW()), which will return an integer
timestamp from the server in standard Unix time, which is the number of
seconds since 00h00 1 Jan 1970 UTC. However, there is no easy way to
get this to display in -MM-DD HH:MM:SS format w/o the conversion to
local time taki
The boxes running the MySQL were isolated from other users so there was no
activity on them while I was performing the benchmark tests.
There was no tuning - I just installed the MySQL from their binary
packages, that is I was using the default config files (hoping that they are
the same - I w
Nesh,
> With all of the benchmark test I have used the same DB structure, same
> TABLE structure, and finally same iterations.
>
> This probably means that Solaris I/O is really poor, or there is some other
> explanation (like changing some kernel parameters to get Solaris working
> well with
Hi folks -
I am having 2 related problems with the timezone setting for mysqld & was
hoping to get some help.
Basically my squestions are as follows:
a) the documentation says to set timezone by simply using --timezone=# when
starting mysqld - but WHAT are the valid number values & which time z
Hi dn,
Right. Having said that tho, is there a function
in mysql that will return the GMT time from the operating
system, that I can subsequently use in a query.
I could use the GMT time from the db client but I
would prefer to use the GMT time from the operating
system mySQL is running on.
Than
Hmmm - pardon me for jumping in in a conversation in progress - but
according to the manual* you should be able to set the TZ variable to your
timezone - which sounds like what has happened on your machine.
If you can figure out how to put the right code in, your SQL queries will
purportedly be i
With all of the benchmark test I have used the same DB structure, same
TABLE structure, and finally same iterations.
This probably means that Solaris I/O is really poor, or there is some other
explanation (like changing some kernel parameters to get Solaris working
well with DB kind of stuff).
Hi Oliver,
> I would like to obtain the time in GMT in mySQL.
>
> CURRENT_TIMESTAMP returns the local time
> SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on
> my system
>
> But how can I get the time in GMT???
MySQL is time-neutral, that is to say, if you ask it the t
Hello,
Thanks for your time. I'm having some problems loading images into a
table. I'm using the statement:
INSERT INTO BLOBTEST set b1=load_file<'c:\1.jpg');
The table (blobtest) is made up of 2 columns : id1 (auto counter) and b1
(BLOB)
When I try and run this statement (above) I get a rec
* Christopher Bell
> Hello everyone, Im running MySQL version 11.15 Distribution 3.23.47 on
> Windows 2000. I'm having issues with the CAST command, for example, if
> I execute:
>
> CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE);
>
> I receive the error:
>
> ERROR 1064: You have an erro
: after timing the program that was targeting MySQL on different platforms
: the results are (client program running always from the same box that is not
: hosting MySQL):
:
: Windows NT - 25 sec (Intel P-III)
: Linux - 27 sec (Intel P-III)
: Solaris 2.7 - 1 min 40 sec (Ul
From
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#Default_privileges
The MySQL root user is created as a superuser who can do anything.
Connections must be made from the local host. Note: The initial root
password is empty, so anyone can connect as
Hi,
I would like to obtain the time in GMT in mySQL.
CURRENT_TIMESTAMP returns the local time
SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on
my system
But how can I get the time in GMT???
Thanks for your time,
Oliver
Hi,
Your problem is that your query uses all of the rows in the table. That
means that the indexes on the table are incorrect.
You should try putting a single index on prev_e3_id and a single index on
the other table. It'll probably improve your performance a lot.
BTW. Schedule some time for ma
On Mon, 4 Feb 2002, Manuel Bouyer wrote:
> What a minute ... you're loading the tables to a 'mysqld' process, using
> the 'mysql' command, rigth ?
> Maybe it's just the mysql command which runs out of files descriptors ?
> Did you try to raise the limit of the shell before starting it ?
Right.
>From time to time I seem to see error messages in my database.err log file
for MySQL.
020130 11:19:10 Aborted connection 40437 to db: 'xyz' user: 'abc' host:
`localhost' (Got an error reading communication packets)
I've been reading about the Morning Bug and here's what I extracted about it:
Hi All,
I have tried out some performance testing with some heavy SELECT and
UPDATES. The database in question has only 500 records but there are lots of
SELECTs and UPDATEs and the results are:
after timing the program that was targeting MySQL on different platforms
the results are (client
On Monday 04 February 2002 01:12 pm, Greg Bailey wrote:
> What is the real "production" version? ?If 4.0.2 can be called a
> production version, I'd gladly use it on my web site; however, it
> doesn't seem to indicate that on the MySQL home page. ?So if I find a
> bug in 3.23.47 that was fixed a "
Hi All,
Does anyone knows how to change my mysqladmin password or how to find out
what the password it, I installed the rpm package, didn't setup any
password, however when I setup a tool to use it with, the tool is asking me
to produce the mysqladmin password.
Thanx
On Mon, Feb 04, 2002 at 05:41:46PM -, Robin Keech wrote:
> (Please reply directly, I am only on the digest list, thanks)
>
> I have an SQL statement that is taking far too long to run, around
> 11 minutes (while locking inserts/updates).
>
> We have installed some more RAM, and I need help w
Oganes,
> I have the following create table, and I get the following error when I create it.
> It used to work before. Can anyone help?
>
> CREATE TABLE PROTOCOL_GROUPING(
> PROTOCOL_GROUPING_ID MEDIUMINT(20),
> GROUP_NAMEVARCHAR(50)NOT NULL,
> PROTOCOL_ID
I have an application that stores a large (up to 6gb) database in an
InnoDB table. I'm using an InnoDB table to have concurrent inserts and
selects and to get beyond the 2gb limitation.
I have to allow read-only remote database connections and cannot enforce
that users use any kind of special qu
On Mon, Feb 04, 2002 at 11:55:57AM +0100, Daniel Backhausen wrote:
>
> Hi.
>
> Does somebody know which server hardware I have to buy to realize my following
>problem ?
>
> I have 3 tables. They are all connected to each other with some queries.
>
> 1st table has momentary 10.000 and shou
On Mon, Feb 04, 2002 at 02:33:40PM -0700, Sasha Pachev wrote:
> On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote:
> > >?This does look like a libc bug. How did you build either one of the
> binaries?
> >
> > They're your binaries. ?I don't buld my own binaries on Linux to save
> > the h
On Mon, Feb 04, 2002 at 03:43:40PM -0700, Randy Arabie wrote:
> On Mon, 4 Feb 2002, William R. Mussatto wrote:
>
> > Have you checked on the ulimit for the user that is mysql?
>
> I did, but had only set it "dynamically". I did raise it quite high,
> 5000 I believe. After that I initiated the
On Mon, 4 Feb 2002, William R. Mussatto wrote:
> Have you checked on the ulimit for the user that is mysql?
I did, but had only set it "dynamically". I did raise it quite high,
5000 I believe. After that I initiated the load, but from a "normal"
user shell which had the default proc.[shell_p
On Mon, Feb 04, 2002 at 04:37:33PM -0600, Erin Lilly wrote:
> Hi, this is Erin Lilly, I've used support before with you all for
> bodyconsultant.com and you were extremely helpful. I'm installing mysql on
> erinlilly.net and have run into that common /tmp/mysql.sock (111) error
>
Hi, you just m
Hi, this is Erin Lilly, I've used support before with you all for
bodyconsultant.com and you were extremely helpful. I'm installing mysql on
erinlilly.net and have run into that common /tmp/mysql.sock (111) error
version: 3.23.45-pc-linux
To telnet in as root:
erinlilly.net
log-admin
pw-paws
y
At 01:19 PM 2/4/2002 , you wrote:
>2) I use MySQLfront just for a couple of days. I find it very usefull (has
>to be written in Delphi) Is this the best freeware for this job or is there
>a better one ?
Makis,
MySQLFront is pretty good considering the price. :)
There is
Hello everyone, Im running MySQL version 11.15 Distribution 3.23.47 on
Windows 2000. I'm having issues with the CAST command, for example, if
I execute:
CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE);
I receive the error:
ERROR 1064: You have an error in your SQL syntax near '('20
In my experience, this happens when the version of mysql you're running is
newer then the version of libraries that something on your system was
compiled with, typically, installing the new libs on your system and
recompiling php or whatever you're using to connect to the mysql server
through,
On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote:
> >?This does look like a libc bug. How did you build either one of the
binaries?
>
> They're your binaries. ?I don't buld my own binaries on Linux to save
> the hassle of using libraries that are different from what you folks
> use. :-)
Anyone know what this means? I'm getting A LOT of them in my MySQL server
log.
Thanks,
-Ed
ps... any idea on how to troubleshoot something like this?
Error Message:
020204 8:20:54 Aborted connection 22 to db: 'AtFantasy2' user: 'apache'
host: `localhost' (Got an error reading communicatio
Thanks, I think that maybe the cause, I was using a single MYSQL structure
for mutiple calls with diffrent MYSQL_RES pointers.
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 7:51 PM
Subj
If you are using tables of the MyISAM type, the auto-increment goes up every time you
insert,
regardless of any deletes. The only way to reset it is to drop and re-create the table
or do a
"delete from table" command with no where clause. ISAM tables do not do this. Read up
in the manual
on tab
Hi,
> -Original Message-
> From: Jens Collin [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 04, 2002 5:42 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: MyODBC leaking handles...
>
>
> Hi again Venu,
>
> I tried the latest one. I'm sorry to say that the error p
I guess I'm a little confused about the MySQL versions.
What is the real "production" version? If 4.0.2 can be called a
production version, I'd gladly use it on my web site; however, it
doesn't seem to indicate that on the MySQL home page. So if I find a
bug in 3.23.47 that was fixed a "long ti
On Mon, Feb 04, 2002 at 12:01:11PM -0700, Randy Arabie wrote:
> On Mon, 4 Feb 2002, William R. Mussatto wrote:
>
> > Have you checked on the ulimit for the user that is mysql?
>
> I've checked a lot of things.
>
> Which would apply:
>
> kern.maxfiles
> proc.[mysqld_pid].rlimit.de
What does this have to do with mysql?
Please try a PHP mailing list
ps: database, sql, mysql
savaidis wrote:
>
> Hello again!
>
> I see many people works here with php and that's natural, as php is
> connected with MySQL.
> In php graphics, I found that printing with a TTF font has no possib
Hi Makis,
There are separate PHP mailing lists - you can find them at www.php.net
- Jonathan
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2002 11:29 AM
To: MySQL list (E-mail)
Subject: PHP with TTF fonts
Hello again!
I see many people works
I'm currently trying to install MySQL in my home directory on a server which
I do have root access to. I follow the steps outlined in O'Reilly's
'MySQL&mSQL' book and I get through the first several steps before problems
occure. To set the stage, I'm using mysql-3.23.47. I'm able to 'configure',
'
Kinney,
I did the following and it worked.
$text="Adding FAQ\'s";
$query="Update faqs SET subject='$text' WHERE id='110'";
mysql_query($query);
Good luck.
--
-
Before posting, please check:
http://www.mysql.com/manual.php
iain furneaux writes:
> yes after every call, that was the first thing I tried, it made the
> situation better but not cured it. Are there any circumstances where
> mysql_free_result() will not free the result ? does it have to be called
> before any further mysql_real_query() calls are made even
hello list,
I'm having trouble with an INSERT command based on a select
Is what I want is in my contacts table I'm selected certain criteria and
then inserting a note into my contactnotes table certain values
Here's what I have so far
contactnotes mysql table headers:
On Mon, 4 Feb 2002, Randy Arabie wrote:
> Date: Mon, 4 Feb 2002 12:01:11 -0700 (MST)
> From: Randy Arabie <[EMAIL PROTECTED]>
> To: "William R. Mussatto" <[EMAIL PROTECTED]>
> Cc: Dan Nelson <[EMAIL PROTECTED]>,
> Manuel Bouyer <[EMAIL PROTECTED]>, [EMAIL PROTECTED],
> [EMAIL PROTECTED]
>
Marcus Collins chortled:
> (sorry; missed the original post)
>
> If you have admin access to both machines, then how about using stunnel
> http://www.stunnel.org/> to set up an SSL-encrypted connection
> between both machines on the ports on which mysqld communicates?
>
> There's an example for
yes after every call, that was the first thing I tried, it made the
situation better but not cured it. Are there any circumstances where
mysql_free_result() will not free the result ? does it have to be called
before any further mysql_real_query() calls are made even on a diffrent
MYSQL_RES pointe
Andreas Schoelver chortled:
> How about using a VPN (virtual private network) ?
>
> regards
> Andreas
>
> sql,select,mysql
I want to minimize the network structure on their part because they will
have a minimal DSL system as they are on the outskirts of town. As well, I
don't want the bulk of
iain furneaux writes:
> Im afraid I do not know where the possible leaks are as I only have the
> mtrace dump which I included a section of in my first posting, I have
> included the whole dump. As the current code runs into several hundred lines
> I do not think it would be helpful
>
> mtrace du
Im afraid I do not know where the possible leaks are as I only have the
mtrace dump which I included a section of in my first posting, I have
included the whole dump. As the current code runs into several hundred lines
I do not think it would be helpful
mtrace dump
Memory not freed:
---
Hello again!
I see many people works here with php and that's natural, as php is
connected with MySQL.
In php graphics, I found that printing with a TTF font has no possibility
to set the font high. Is this true?
Also is not possible to open only once one font file and not as many times
as text
iain furneaux writes:
> I have just tried the 3.23.47 release and the same problem seems to be
> occuring, is there anything I could be doing in my code that would make it
> look like the problem is coming from libmysqlclient.so.10 ?
>
Post your code to the list and pinpoint where is memory lea
Hello all !
I see it's a very busy list so I will try to by short to my first question:
1) Is there a way to put the REAL numbers of rec in the ID=auto-increment? I
made some tests so this number is higher than total recs of the
table.(export/import to text doesn't help)
The Rec_num is stored s
On Tuesday, February 5, 2002, at 02:01 PM, DL Neil wrote:
> =option 2: whilst native-MySQL will give an errmsg in response to an
> attempt to INSERT duplicates, PHP doesn't
> have to pay attention! Check out MySQL_affected_rows().
David,
I see... that's a good debugging tool, mysql_affected_r
I have just tried the 3.23.47 release and the same problem seems to be
occuring, is there anything I could be doing in my code that would make it
look like the problem is coming from libmysqlclient.so.10 ?
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PR
I have the following create table, and I get the following error when I create it.
It used to work before. Can anyone help?
CREATE TABLE PROTOCOL_GROUPING(
PROTOCOL_GROUPING_ID MEDIUMINT(20),
GROUP_NAMEVARCHAR(50)NOT NULL,
PROTOCOL_ID MEDIUMINT(20)
On Mon, 4 Feb 2002, William R. Mussatto wrote:
> Have you checked on the ulimit for the user that is mysql?
I've checked a lot of things.
Which would apply:
kern.maxfiles
proc.[mysqld_pid].rlimit.descriptors.soft
proc.[shell_pid].rlimit.descriptors.soft
Obviously, th
Hi,
I'm playing with PHP/MySQL for the first time having used Perl and MySQL
for years.
In one of my first update scripts, PHP is automatically escaping quotes and
such, which I assumed was a good thing.
However, I'm noticing that MySQL is rejecting statements like:
Update faqs SET sub
On Mon, Feb 04, 2002 at 10:08:37AM -0700, Sasha Pachev wrote:
> On Monday 04 February 2002 02:30 am, Jeremy Zawodny wrote:
> > 0x807bb5f handle_segfault__Fi + 383
> > 0x82a94aa pthread_sighandler + 154
> > 0x7cb80076 __evoke_link_warning_llseek + 1954074198
> > 0x7cb7fe19 __evoke_link_warning_llse
HelloErik,
> I have a slight dilemma, and was wondering what the standard workaround
> is. I have three tables: owners (auto_increment primary key is
> "owners_id"), objects (auto_increment primary key is "objects_id"), and
> owners_objects (which is a foreign key table that I created, under
> a
On Monday, February 4, 2002, at 01:48 PM, Marcus Collins wrote:
> You can use REPLACE instead of INSERT -- see the manual entry:
>
>
> http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.
> html#REPLACE>
>
Thanks Marcus! My knowledge of MySQL is pretty basic. It has also b
iain furneaux writes:
> appologies the MySQL version is 3.22.32 (sorry fat fingers! :-) )
>
Just try our latest 3.23 C API
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Develo
On Mon, 4 Feb 2002 at 13:10:29 -0500, Erik Price wrote:
[ snip background ]
> I am sure that many people have done this sort of setup. But what do
> you do to get around the problem of INSERTing a pair of values that
> already exist? Because the combinations in "owners_objects" are UNIQUE
At 13:10 -0500 2/4/02, Erik Price wrote:
>Hello, everyone.
>
>I have a slight dilemma, and was wondering what the standard
>workaround is. I have three tables: owners (auto_increment primary
>key is "owners_id"), objects (auto_increment primary key is
>"objects_id"), and owners_objects (which
S TO MAKE TO ADD SITES FOR ORDER ALFABETICA. USING MYSQL 3,23
www.buscapopular.com.br
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Have you checked on the ulimit for the user that is mysql?
On Sat, 2 Feb 2002, Dan Nelson wrote:
> Date: Sat, 2 Feb 2002 20:58:07 -0600
> From: Dan Nelson <[EMAIL PROTECTED]>
> To: Randy Arabie <[EMAIL PROTECTED]>
> Cc: Manuel Bouyer <[EMAIL PROTECTED]>, [EMAIL PROTECTED],
> [EMAIL PROTECTED
Please help me.
I'm installing mysql-3.23.45 on Sparc 20 with Solaris 2.5 and when
i give the comand make...i have this problem.
..
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/usr/local/mysql-3.23.45/libmysql'
make[1]: Leaving directory `/usr/local/mysql-
On Mon, 4 Feb 2002 at 18:06:34 +0100, Andreas Schoelver wrote:
>
> 04.02.02 15:11:30, Rich Fortnum <[EMAIL PROTECTED]> wrote:
>
> >Hi there. I have a need to reach into a remote database and write to their
> >tables from my tables. Or have them reach into my tables and read from
> >mine. Eit
On Sat, 2002-02-02 at 20:22, Egor Egorov wrote:
> Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
Hi,
Would the REPLACE .. SELECT be faster if i use LOCK TABLES as it says in
the manual for the INSERT command ?
It's a REPLACE .. SELECT for thousands of rows.
Thanx,
--
Dia
appologies the MySQL version is 3.22.32 (sorry fat fingers! :-) )
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 12:15 PM
Subject: Re: Memory Leaks ?
> iain furneaux writes:
> > HI,
> >
Hi, I have posted a question here previously regarding the query of
talbles that contain duplicate entries in rows with only the id being
different. My question was how to display or abtain ONLY the row with
the highest id value in the result set along with all the other destinct
rows in the t
Hello, everyone.
I have a slight dilemma, and was wondering what the standard workaround
is. I have three tables: owners (auto_increment primary key is
"owners_id"), objects (auto_increment primary key is "objects_id"), and
owners_objects (which is a foreign key table that I created, under
a
hi there,
some stupid fool has deleted the mysql.sock file from our redhat server
system. (me!)
How do I regenerate one?
thanks a mil
StuartO
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
(Please reply directly, I am only on the digest list, thanks)
I have an SQL statement that is taking far too long to run, around 11
minutes (while locking inserts/updates).
We have installed some more RAM, and I need help with my.cnf and the
troublesome SQL.
Can anyone suggest some config value
Rich,
Sunday, February 03, 2002, 3:03:23 PM, you wrote:
RF> Hey there. Wanted to know what security is built
RF> into MySQL with respect to writing SQL to remote
RF> tables. I have clients that want reads and writes to
RF> their tables, but I don't want to share their information.
RF> Any id
Neil,
Monday, February 04, 2002, 6:00:18 PM, you wrote:
NF> Hi,
NF> Ideally I wish to keep all of my database files on a network drive
NF> (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which
NF> resides in my WINNT directory.
NF> my.ini contents...
NF> [mysqld]
NF> basedir=C:/mysq
Daniel,
Monday, February 04, 2002, 12:55:57 PM, you wrote:
DB> Does somebody know which server hardware I have
DB> to buy to realize my following problem ?
DB> I have 3 tables. They are all connected to each other
DB> with some queries.
DB> 1st table has momentary 10.000 and should be upgrad
Joey,
Saturday, February 02, 2002, 8:16:21 PM, you wrote:
JF> Dear all,
JF> I am running MySQL 3.22.xx at Mandrake 8.1, how can I
JF> grade my MySQL??
Please, find your answers at:
http://www.mysql.com/doc/U/p/Upgrade.html
JF> Thanks
--
For technical support contracts, goto https://ord
Neeraj,
Monday, February 04, 2002, 7:55:15 AM, you wrote:
NA> Just a simple question. I am using perl DBI to connect to
NA> mysql. Its like a daemon, so its always running. But
NA> whenever i get a signal it connects to a database
NA> (different database each time). So there are 2 ways
NA> to
On Mon, Feb 04, 2002 at 07:15:33PM +0200, Sinisa Milivojevic wrote:
>
> Yes, this is troubling ...
>
> It could be hardware, though ...
>
> Can you find anything in MySQL log and especially in /var/log/dmesg
> or /var/log/messages.
Nope.
> Sometimes, not often, Linux kernel is capable of not
Jeremy Zawodny writes:
> On Mon, Feb 04, 2002 at 02:27:01PM +0200, Sinisa Milivojevic wrote:
>
> That was your binary on Linux.
>
> Strangely, I just started up that exact same copy of 3.23.47-max and
> it worked fine after a machine reboot.
>
> That's most unusual (and troubling).
>
> Thanks,
Hello all,
i am experiencing the odd problem of 'lost connection
to MySQL server during query'. This is happening because my
mysqld server (for some reason) restarts while i am accesing it.
I am using 2 SQL queries to reproduce the problem i have and decouple
it from my C++ application.
On Monday 04 February 2002 02:30 am, Jeremy Zawodny wrote:
> 0x807bb5f handle_segfault__Fi + 383
> 0x82a94aa pthread_sighandler + 154
> 0x7cb80076 __evoke_link_warning_llseek + 1954074198
> 0x7cb7fe19 __evoke_link_warning_llseek + 1954073593
> 0x7cb713e6 __evoke_link_warning_llseek + 1954013638
>
1 - 100 of 143 matches
Mail list logo
