On Sat, Mar 02, 2002 at 09:57:58PM -0800, Jeremy Zawodny wrote:
Murphy's law strikes! Just a few hours ago I blasted the relay logs
on my 4.0.2 slave. It ran out of disk space!
I'll rsync the slave and build a fresh MySQL from the bitkeeper tree
and let you know.
Sasha,
I re-synced my
Hi
First of all this question belongs on the [EMAIL PROTECTED] mailing
list.
Secondly, you should not be sending this kind of a question to the MySQL
developers
Thirdly, the QMYSQL3 driver is part of the QtV3.0.x distribution. I presume
you have the X-11 Free Edition of Qt, so run ./configure
Hi,
Newbie here, so please be kind...
I decided to try out the foreign keys (REFERENCES tabel(column) in CREATE
TABLE) and I hit two problems. Maybe it's my clumsiness with search
specification, but I couldn't find answers in the archive. Oh, I tried it
on InnoDB tables created just for this
Description:
2.23.49 can not set local_infile to enable.
We can not use LOAD DATA LOCAL INFILE ... ;
configure script is almost strange '$enablewal'
not '$enableval'.
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:Yukihiro KAWADA
Organization:
FUJI PHOTO
Tomasz,
are you running on Windows?
Please use innodb_table_monitor as explained in section 9.1 of
http://www.innodb.com/ibman.html, and also look into section 15.1.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up adding of
Hello ... Is there anybody out there..,
who can tell me how to create the parameteres for the mi_rkey function in
the myisam library.
I've tried to create the key by concatenating the key segments.
Apparently that dosn't work. I get errcode 120,(Key not found ??).
I'm trying to migrate from
Just use delimiters in Oracle... then use same delimiters on the import...
simple any lines or blank spaces etc would be ignored.
Also turn feedback off in Oracle so you don't get all the headers etc...
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: 04 March 2002
At 04:18 2002-03-05, you wrote:
Tomasz,
are you running on Windows?
No, Linux 2.2.17
Please use innodb_table_monitor as explained in section 9.1 of
http://www.innodb.com/ibman.html, and also look into section 15.1.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB
Hi,
My opinion:
You can create char field type on table (i.e. char(10)) and when you wish to
do some date comparison you can use the next mySQL
functions:LEFT,MID,RIGHT,TRIM (is not only in VB)
I.E:
mydate-field in a_table:char(10);
date on this field: '10.01.2001','30.01.2000',...etc.
select *
At 04:18 2002-03-05, you wrote:
Tomasz,
are you running on Windows?
Please use innodb_table_monitor as explained in section 9.1 of
http://www.innodb.com/ibman.html, and also look into section 15.1.
Best regards,
Re: 9.1: Well, can't find innodb* anywhere on the system
Re: 15.1: The second
Didn't see anything on this specific question in a quick search of the
database. If I just missed it, I apologize.
What I have in mind is being able to read the Japanese error messages on an
MSWindows box.
So I wanted to make a mysql\share\japanese_sjis directory and save the two
errmsg files in
Hi
What is the number max of fields in a table in mysql database ?
Samuel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi!
On Mar 05, Klaus Weyhe wrote:
Hello ... Is there anybody out there..,
who can tell me how to create the parameteres for the mi_rkey function in
the myisam library.
I've tried to create the key by concatenating the key segments.
Apparently that dosn't work. I get errcode 120,(Key not
Why not rather have pointers to the files on a directory and store this
in a db field ? Saves you a lot of DB space ?
Ant
-Original Message-
From: Dang Nguyen [mailto:[EMAIL PROTECTED]]
Sent: 04 March 2002 09:05
To: Mysql List (E-mail)
Subject: storing files in mySQL
Hi everyone,
I'd
Hi,
I have a form with two fields surname_from and surname_to, I want to be able
to do a select query where the results will lie between these to values.
That's easy enough but I also want to include all results where the record
field (surname) matches the first part of the fields - in effect a
Hi!
Richard == Richard Clarke [EMAIL PROTECTED] writes:
Richard Because that wouldn't give the correct results.
Richard I want the top 5 rows for EACH id.
Richard A short example would be,
Richard mytable:
Richard IdValHits
Richard 1 a 10
Richard 1 b 15
Richard 1
* Craig Shepherd
select * from consumers surname BETWEEN '$surname_from' AND '$surname_to'
assume $surname_from = A and $surname_to = B
would only return results where the surname is A or greater but
less than B, but I would like to include all records where records
also start with B.
So if I did something like
$temp = $surname_from.{;
select * from consumers surname BETWEEN '$surname_from' AND '$temp'
it should do the trick?
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2002 11:49
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Dear sir,
I use MySQL-3.23.35 before that running on FreeBSD-4.2.
Now I use MySQL-4.0.1 running on FreeBSD-4.5.
I want to convert Database ...
from
MySQL-3.23.35 that store at /usr/local/mysql/data
to
MySQL-4.0.1 that store at /usr/local/mysql/var.
Why you don't try:
BETWEEN '$surname_from' AND concat($surname_to,'z') ?
Makis
-Original Message-
From: Craig Shepherd [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 1:30 PM
To: [EMAIL PROTECTED]
Subject: BETWEEN... LIKE query
Hi,
I have a form with two fields
Hi!
Tobias Hi!
Tobias I'm in the same position as Steve: Considering switching from MyISAM to InnoDB
because of the
Tobias row-level locking capabilities. My application has quite a lot of
updates/inserts mixed with
Tobias selects, and is starting to suffer from the table-locking policy...
[EMAIL PROTECTED] writes:
Description:
*** against BK as of set 1.1144 ***
It appears that putting SQL_BUFFER_RESULT and SQL_CALC_FOUND_ROWS
in the same SELECT statement is a really bad idea!
SELECT FOUND_ROWS() after SELECT SQL_BUFFER_RESULT
I think I did something wrong. It was working OK (not great, but OK). Now
I can't start mysqld. (Error 2002 can't connect to MySQL server through
socket /var/lib...). I don't know if this matters, but for some reason I
deleted a .pid file that I thought was making me not able to start mysqld
Thanks - that would be great!
I'm sure a lot of people will find this very helpful.
Regards,
Tobias
- Original Message -
From: Michael Widenius [EMAIL PROTECTED]
To: Tobias Lind - Telia Internet [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, March 05, 2002 12:36 PM
Subject: Re:
Thomas Birchmire writes:
I have the same problem using Linux RedHat 7.2. Just what do I have to
configure my binary MySQL : Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu on
i686?
The rest of MySQL works as advertised.
Regards Tom Birchmire
loca-infile is not a variable.
That works fine, but I was wondering if there was another way to do it
because I receive one text file everyday and the are always duplicate
records. We just change to MySQL and I have to load this text file everyday
to the database.
Thanks again!!
Nato
-Original Message-
From: Paul
Hi!
I played with the locales, and mysql console # mysql
returns with:
mysql: relocation error: mysql: undefined symbol: ctype_latin1
What did I miss?
I'm in need of resolving this problem fast, a whole site depends on it!
asd
Hi everybody...
I've searched thrugh the lists (IMHO the search engine is
slow and the output sucks: what about a date column at the
beginning of each row in the post list and in search results?)
and the manual. This is the 3rd time I post about this
problems but it looks like nobody can give me
Hello,
I noticed a bug today in multi-table delete which corrupts my tables and
indices. In the 4.0.2 changelog in the online-manual I saw a reference to a
bugfix for multi-table deletes, but since I can't yet download a binary of
4.0.2 for windows I can't yet check if this is the fix for 'my'
The following form was submitted via MySQL.com feedback engine:
Name: Alexandre Adam
E-mail address: [EMAIL PROTECTED]
Company: sansoft informatica
Position/Title: user
Type of interest: for personal use
State or province: SP
Country: Brazil
Support contract: no
Enter Your
[EMAIL PROTECTED] writes:
Description:
2.23.49 can not set local_infile to enable.
We can not use LOAD DATA LOCAL INFILE ... ;
configure script is almost strange '$enablewal'
not '$enableval'.
How-To-Repeat:
Hi!
Thank you for your report. We have fixed a bug and fix will
Hi
I have recently had some problems with web forms not updating the
website ( use PHP and the insert page should first enter the form data
into a table and then update the status field in a second table
correlating to the entry just made), hoever, only the first sql seemed
to go through and
Hello all,
I have a weird request.
Having lots of servers (with many MySQL ones), I try to centralize most
of all authentication processes by using LDAP.
This is possible with Apache, ProFTPd and such but I was wondering if we
could do this with MySQL.
I know this is special because this is
No quite the same thing but
We use Radius Radiator with MySQL and it works very well.
Hope to have all the Cisco stuff getting its password from hear to soon...
No direct connect but close?
Simon
-Original Message-
From: Yann Michaud [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2002
This is how we did it with PHP
Remove the mysql packet size limitation. By default, mysql only accepts
packets that are smaller than 1 MB.
You have to restart your database with some parameters, which will
remove the limitations.
/usr/local/bin/safe_mysqld -O key_buffer=16M -O table_cache=128
hi,
the source rpm for mysql 3.23.49 contains build instructions for gnu
compilers 2.95 or newer.
redhat 6.2 comes with a compiler that cannot handle the permissive
flag (i think its ecgs-2.91).
therefore the build fails.
one solution could be to install a more recent compiler version and try
I'm retrieving data from a data service.
This is the ENTIRE source code of the URL they let me receive:
symbolRHAT/symbol
price6.82/price
date3/4/2002/date
time3:59pm/time
change0.32/change
change_percent/change_percent
open6.59/open
high6.99/high
low6.53/low
volume932400/volume
How can I
On Mon, 4 Mar 2002, Dang Nguyen wrote:
I'd like to know how to load files, such as MS-Word documents or PDF
documents, in a mySQL database. I've setup a blob type in a table, but
where do I go from there?
The purpose of this is to store files uploaded from a web page and processed
with
Leeuw van der, Tim writes:
Hello,
I noticed a bug today in multi-table delete which corrupts my tables and
indices. In the 4.0.2 changelog in the online-manual I saw a reference to a
bugfix for multi-table deletes, but since I can't yet download a binary of
4.0.2 for windows I can't yet
ok, here are the 3 tables i have that are related:
mysql desc poll_questions;
++-+--+-++--
--+
| Field | Type| Null | Key | Default| Extra
|
At 10:24 PM 3/4/2002 , you wrote:
On Mon, Mar 04, 2002 at 01:47:42PM -0600, BD wrote:
Jeremy,
PMFJI, but has anyone done any testing to see if persistent
connections with MySQL and PHP is actually faster in practice?
What's PMFJU?
Pardon me for jumping in
Without testing, I
The best book for c programming I found is the O'Reilly book, MySQL mSQL
. It has a good example of using the C API and even builds some simple C++
classes.
The book, MySQL by Paul DuBois is the best overall MySQL book I found.
Plus, Paul is a regular responder to this list, so I would buy
I tried putting --local-infile in my server script and local-infile in the
/etc/my.cnf file. I also placed a number or logging cammands in the startup
script hoping to catch lower level messages. There appears to be little
effect on anything.
Regards, Tom Birchmire
-- script and log stuff
Matthew,
Tuesday, March 05, 2002, 12:05:46 AM, you wrote:
MD a while ago I had problems with users on mysql.
MD I am trying to login as root from the local host using password and I get
MD access denied using password=YES
Usually it means that you are using wrong password for your user.
Take a
dlyles,
Tuesday, March 05, 2002, 4:54:30 AM, you wrote:
d This is the message I am getting. I am currently running MySQL (or trying
d to) on a Cobalt Raq3.
Is your MySQL server running?
d I recently uninstalled and reinstalled, but am unable
d to remove this message. I can't start mysql or
Somsak,
Tuesday, March 05, 2002, 2:03:57 PM, you wrote:
SR Dear sir,
SR I use MySQL-3.23.35 before that running on FreeBSD-4.2.
SR Now I use MySQL-4.0.1 running on FreeBSD-4.5.
SR I want to convert Database ...
SR from
SR MySQL-3.23.35 that store at /usr/local/mysql/data
razvan,
Tuesday, March 05, 2002, 7:46:31 AM, you wrote:
r Hi, please help me with this one!
r I now the date_format function, it converts the standard format sql
r (-mm-dd)
r to any format, but my problem is that i want to convert from another format
r (eg. dd/mm/) to the
I just discovered that @lists.mysql.com accepts no attachments...
Please disregard the comments below regarding the code being attached, and
instead please find it at this URL:
http://www.10east.com/~hightowe/mysqld_udf_zlib.cc
--
Lester Hightower [EMAIL PROTECTED]
--
Howdy -
I am using the C API and am returning a result set from a table with a BLOB
type item in it.
When I populate the BLOB fields initially (with all the same data) the
length is returned properly when I issue SELECT * FROM table and decode
the result set column metadata.
Meaning, that if I
Hi,
I tried it too, got the same result. I looked into the setup.iss file
that setup -r created, and found these lines that looked different from
the others:
[SetupType-0]
Result=301
szDir=
The SdAskDestPath dialogs has:
[SdAskDestPath-0]
szDir=C:\mysql
Result=1
So I thought I'd give it a
Funny I still have the same exact problem Egor does. I start mysql with
safe_mysqld, same only server just ends. I do safe_mysqld nothing, I use
mysqld -r root -p password
Nothing I do, that is listed helps. I still have no mysql.sock, and the
server never starts.
Mark
- Original
Thomas Birchmire writes:
I tried putting --local-infile in my server script and local-infile in the
/etc/my.cnf file. I also placed a number or logging cammands in the startup
script hoping to catch lower level messages. There appears to be little
effect on anything.
Regards, Tom Birchmire
I have a table like so :
CREATE TABLE album_rank(
album_id INT NOT NULL,
rank INT NOT NULL,
KEY(album_id)
)
I want to query on the album_id get the results ordered by rank but I
want to avoid doing an ORDER BY in the query because of the filesort
that it usually
On Tuesday 05 March 2002 01:17 am, Jeremy Zawodny wrote:
When the machine is pounding away on updates (over 300/sec), it can
take a long time to get a response to SHOW SLAVE STATUS. ?I get one,
but it can take between 5 and 30 seconds:
My first inclination was to blame FreeBSD threads, but
Hi Darren,
On Tue, 5 Mar 2002 09:42:50 -0800
Daren Cotter [EMAIL PROTECTED] wrote:
mysql desc poll_questions;
++-+--+-++-
---+
| Field | Type| Null | Key | Default| Extra
|
On Tuesday 05 March 2002 10:05, Thomas Spahni wrote:
There are some good reasons for wanting to store data directly in the
database, sometimes.
For instance I built an application recently that used blobs. The reason is
simplicity and security. In a web application it is nice to just dump the
Thanks much for the try, but I get an error:
mysql DELETE
- poll_questions, poll_answers, poll_votes
- FROM
- poll_questions, poll_answers, poll_votes
- WHERE
- (poll_questions.poll_id = poll_answers.poll_id)
- AND (poll_answers.answer_id = poll_votes.answer_id)
Thanks to everyone who responded to my query. Your responses have given
me a bit to think about.
Dang Nguyen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
From: Daren Cotter [EMAIL PROTECTED]
...what happens when I want to delete a poll?
Do it machanically. That is, do a query in advance to find the data that needs to be
deleted, then go through and delete it. The logic for joining a delete can be written,
but MySQL doesn't support it. (Hey
At 8:16 -0800 3/5/02, Sam Lam wrote:
I have a table like so :
CREATE TABLE album_rank(
album_id INT NOT NULL,
rank INT NOT NULL,
KEY(album_id)
)
I want to query on the album_id get the results ordered by rank
but I want to avoid doing an ORDER BY in the query because of
Intrex,
Tuesday, March 05, 2002, 6:09:01 PM, you wrote:
I Funny I still have the same exact problem Egor does. I start mysql with
I safe_mysqld, same only server just ends. I do safe_mysqld nothing, I use
I mysqld -r root -p password
I Nothing I do, that is listed helps. I still have no
Sam,
Tuesday, March 05, 2002, 6:16:17 PM, you wrote:
SL I have a table like so :
SL CREATE TABLE album_rank(
SL album_id INT NOT NULL,
SL rank INT NOT NULL,
SL KEY(album_id)
SL )
SL I want to query on the album_id get the results ordered by rank but I
SL want to avoid
Well after reviewing the DELETE section of the manual, I see nothing to suggest that
it supports
multiple-table deletes...
# Nathan
- Original Message -
From: Daren Cotter [EMAIL PROTECTED]
To: Nathan [EMAIL PROTECTED]; Daren Cotter [EMAIL PROTECTED]
Sent: Tuesday, March 05, 2002 12:37
Is there some way that I can avoid doing an ORDER BY and get my
rows back ordered by album_id, rank they way I inserted them ?
No That is the nature of relational databases
Is this because the index cache in ram may not be loaded in order ?
You might want to consider adding an
Ok,
I'm an idiot. I haddatadir = c:/_data/mysql/
when I should have had datadir = c:/_data/mysql/data/
I had some help though (I can't place all the blame on myself, ego
issues ya know).
I find this paragraph utterly confusing in MySQL Ref. Manual version
4.0.2-alpha See Node Windows
At 9:52 -0800 3/5/02, Sam Iam wrote:
Is there some way that I can avoid doing an ORDER BY and get my
rows back ordered by album_id, rank they way I inserted them ?
No. That is the nature of relational databases.
Is this because the index cache in ram may not be loaded in order ?
No,
I need help writing query that would give me parent categories of catID from
categories table.
For example, if catID=030 then it should give me:
Birthday | Special Birthday | Special Birthday
If catID=028
Birthday | General Birthday | NULL
desc categories
Hi
I installed MySql on Win2k and everything worked fine, than I also installed
Oracel, mysql refused to work, than I deinstalled Oracle and did a new mysql
setup.
But when I try to start mysql, with mysql\binmysql
an error occurs, and mysql can´t connect to localhost.
Where is the problem?
I asked yesterday but got no responses...anyone have any ideas how I can use
one odbc connection but have access to all databases on the MSSQL server???
Thanks,
Eddie
-
Before posting, please check:
Do you have another table with all the birthdates in it?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:05 PM
To: [EMAIL PROTECTED]
Subject: Query help please!
I need help writing query that would give me parent categories of
One more thing... What are you using to pull the data? PHP? Perl?
Etc?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:05 PM
To: [EMAIL PROTECTED]
Subject: Query help please!
I need help writing query that would give me parent
I just installed mysql 3.23.49a on RedHat 7.2 and when I rety to start it it
shows errors like @hostname@ command not found when I start it using
symlink and it won't start at all if I start it from
/etc/init.d/mysql.server start, error about /tmp/mysql.sock.
On the same machine 3.23.47 was
Sam, I am constantly coding with PHP and MySQL. As far as:
Would you agree that sorting small row sets on the client with say PHP
is more efficient than asking a busy MySQL server with many clients to
o ORDER BY so that FILESORT or TEMPORARY can be avoided ?
I have learned to let MySQL do
On Tuesday 05 March 2002 11:11 am, Edward Peloke wrote:
I asked yesterday but got no responses...anyone have any ideas how I can
use one odbc connection but have access to all databases on the MSSQL
server???
I have not tried this but have you considered using the use command? Or even
It won't let you since Windows ODBC only lets you create ONE DSN per
DATABASE
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:11 PM
To: MySql
Subject: connecting to all databases using one odbc connection..PLEASE
HELP
I asked
...and so I'm tempted for the third time to bring up my issue which has to
date resulted in no response: BLOB columns causing various, seemingly random
out of memory errors on FreeBSD. Is this problem too low-level for the
list? I see plenty of responses to questions about simple queries, even
Hi.
I guess your problem comes from the fact that SQL has no concept of
internal order. If you do not specify an ORDER BY clause, the order or
records returned is undefined, i.e. random.
Of course, MySQL has some kind of internal order depending on many
factors, but you may not rely on it. And
I want to select and join data from two tables if the same id exists in both
tables. If the id only exists in one table I want MySQL to return a string
like sorry, no records found. How can I do this?
I'm guessing it's something like:
mysql SELECT tbl1.this, tbl2.that FROM tbl1, tbl2 WHERE IF
Benjamin,
Benjamin Pflugmann wrote:
Hi.
I guess your problem comes from the fact that SQL has no concept of
internal order. If you do not specify an ORDER BY clause, the order or
records returned is undefined, i.e. random.
That's what I was figuring. I asked because I wanted it
oops, good point. thanks.
On Mon, 4 Mar 2002, Roger Baklund wrote:
* Nathan Cowles
$query2 = SELECT SEC_TO_TIME(TIME_TO_SEC('$lastout') -
TIME_TO_SEC('$firstin'));
$result2 = mysql_db_query($database, $query, $connection) or die
(Error in query: $query. . mysql_error());
You are
Description:
mysqld just stops responding. 'mysqladmin ping' hangs without any message
How-To-Repeat:
Cannot reproduce manually, happens during normal operation
Fix:
Asking You :)
Submitter-Id: submitter ID
Originator:ilm.ee
Organization:
MySQL support: [none |
Richard,
I guess your problem comes from the fact that SQL has no concept
of
internal order. If you do not specify an ORDER BY clause, the order
or
records returned is undefined, i.e. random.
That's what I was figuring. I asked because I wanted it confirmed.
Thank
you.
Of course,
You can use logical lock - set a STATUS int 0 (probably the ID of user)
to indicate someone started to edit it interactively to block other user to
edit the same record.
Before you write it back to disk, read it again in a buffer to keep all data
possible changed by batch updates.
Or separate the
Leif,
I want to select and join data from two tables if the same id exists
in both
tables. If the id only exists in one table I want MySQL to return a
string
like sorry, no records found. How can I do this?
I'm guessing it's something like:
mysql SELECT tbl1.this, tbl2.that FROM tbl1,
Hi.
On Tue, Mar 05, 2002 at 12:10:47PM -0700, [EMAIL PROTECTED] wrote:
[...]
Of course, MySQL has some kind of internal order depending on many
factors, but you may not rely on it. And neither you may rely on the
fact that a PRIMARY KEY influences the internal order. You have to use
an
On Tue, Mar 05, 2002 at 09:19:35AM -0700, Sasha Pachev wrote:
On Tuesday 05 March 2002 01:17 am, Jeremy Zawodny wrote:
When the machine is pounding away on updates (over 300/sec), it can
take a long time to get a response to SHOW SLAVE STATUS. ?I get one,
but it can take between 5 and 30
Hello.
I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel
2.4.17, and glibc 2.1.
Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and
headed the warnings and downgraded to 2.95.
Randomly I get the Lost Connection using PHP 4.1.2... Any idea why?
Thanks
Adam
Um, if there aren't any records in tbl1.id that match tbl2.id, it will return zero
records. I am not
away of the ability to output strings as custom errors, but you will get an Empty Set
result. You
can use that result in whatever front-end language you are using to output anything
you like.
I was wondering if Mysql has aliases, that is, a short command
representing a long MySql command. Say I want to do a show
status, so I map an alias to ss and do ss when I want to do
a show status.
-
Before posting, please
Hello.
I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel 2.4.17,
and glibc 2.1.
Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and
headed the warnings and downgraded to 2.95.
Randomly I get the Lost Connection using PHP 4.1.2... Any idea why?
Thanks
Adam
hi!
the source rpm for mysql 3.23.49 contains build
instructions for gnu compilers 2.95 or newer.
redhat 6.2 comes with a compiler that cannot
handle the permissive flag (i think its ecgs-2.91).
A-HA!!! Thanks a lot!
therefore the build fails.
one solution could be to install a more
At 15:34 -0500 3/5/02, Chuck Roberts wrote:
I was wondering if Mysql has aliases, that is, a short command
representing a long MySql command. Say I want to do a show
status, so I map an alias to ss and do ss when I want to do
a show status.
No.
I sure would, thanks Monty and Tobias.
In particular some sample update/insert/delete db code for MyISAM
vs. InnoDB, (especially in the case where you're not adding
transactions, just trying to take advantage of row-locking.)
Assuming something changes, of course.
The other thing is a page on
Happens randomly among all my scripts.
Mysql is being started with:
/usr/sbin/mysqld --basedir=/ --datadir=/usr/local/lib/mysql --user=mysql
--pid-file=/usr/local/lib/mysql/mysqld.pid --skip-locking -O
max_connect_errors=1 -O back_log=30 -O max_connections=580 -O
table_cache=512 -O
Machine
DN-
I'm not sure what you mean by tbl2's population is a sub-set of that
in tbl1. tbl1 contains user id nums and hours each user spent working on a
project. tbl2 contains user id nums and the first and last names that
correspond to each user id. There are user id nums in tbl1 that do not
On Tue, Mar 05, 2002 at 09:58:13PM +0100, Steve Rapaport wrote:
I sure would, thanks Monty and Tobias. In particular some sample
update/insert/delete db code for MyISAM vs. InnoDB, (especially in
the case where you're not adding transactions, just trying to take
advantage of row-locking.)
I have a several Redhat machines with MySQL 3.23.* installed on it.
When I upgrade any of them to MySQL 3.23.49 the timezone stops being
recognized. I have verified that MySQL 3.23.46 and 3.23.47 work properly
by downgrading some of our servers. 3.23.49 always uses UTC according to
'mysqladmin
Couldn't you return the data you need by using an outer join? The rows in
tbl1 that aren't in tbl2 would have null values in the name fields. You
could order by the name fields.
Or, you could migrate the data to Oracle and use DECODE to put No record
in the name fields that are null. :)
Sure seems that way to me. Same SQL engine no matter what table type you
use.
InnoDB didn't scare me. Pretty friendly to use. :)
--Walt
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 2:09 PM
To: [EMAIL PROTECTED]
Cc: Tobias Lind -
Description:
A slave replication only one of many databases from a master
will fail with a error 'Can't read dir of './otherdb/' (Errcode: 2)
on query 'DROP DATABASE otherdb' if the slave was not replicating
that database.
How-To-Repeat:
Create a master
1 - 100 of 144 matches
Mail list logo