At 03:29 PM 10/23/02 +0300, Egor Egorov wrote:
Lance,
Wednesday, October 23, 2002, 3:23:10 AM, you wrote:
LU I have /tmp symlinked to /var/tmp, and /var is a writable partition,
while /
LU is readonly. When / is readonly mysqld is not able to run.
LU I've tracked down the problem to the
To recap I am trying to run 3.23.52 on FreeBSD 4.6.
I have /tmp symlinked to /var/tmp, and /var is a writable partition, while /
is readonly. When / is readonly mysqld is not able to run.
I've tracked down the problem to the safe_mysqld script. The problem is it
does:
USER_OPTION=
if
-
From: Lance Uyehara [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 18, 2002 7:30 PM
Subject: problem upgrading
I was running mysql 3.23.26 on freebsd 4.6 without a problem. Then I
had
a
runaway high load cpu event and figured I should at least get later
code
writable and it still
doesn't work.
-Lance
Jerry
- Original Message -
From: Lance Uyehara [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 18, 2002 7:30 PM
Subject: problem upgrading
I was running mysql 3.23.26 on freebsd 4.6 without a problem. Then I had
a
runaway
I was running mysql 3.23.26 on freebsd 4.6 without a problem. Then I had a
runaway high load cpu event and figured I should at least get later code
before complaining. So I grabbed 3.23.52 (the latest freebsd package).
My databases are in /var/db/mysql.
My root partition is mounted readonly.
Is there an easy way to copy/use the structure (not data) of a skeleton
table to a new table?
create table x select * from table y where 1=0;
-Lance
filter: sql
-
Before posting, please check:
[EMAIL PROTECTED] wrote:
As I understand it, the mysql TIMESTAMP type represents the time in your
local timezone (the one your computer is using).
This makes it problematic to use in timezones that have a
summer/daylight
savings time. All of the date arithmetic functions will yield
On 12 Apr 2002, at 13:05, Lance Uyehara wrote:
[EMAIL PROTECTED] wrote:
It might be
worthwile to have some way of retreiving a timestamp as an epoch value
in
addition to other fifty ways you can currently retrieve it. (If there
already is a way, I'd be thrilled to hear about
in perl: [very simple code]
my $stime = time;
prepare();
execute();
fetchall_array_ref();
my $etime = time;
my $ftime = $etime - $stime;
print Your query took $ftime seconds\n;
stupid filter: sql, query, mysql, db, table, select, insert, update,
delete,
join, create, left join,
This will not work for my example. I have a select box that was populated
from the db with firstname lastname. The option tag has the value of
firstname+lastname then. Here lies the problem, when I build the query, I
have no way of distinguishing firstname and lastname.
if you really
At 01:10 PM 3/31/02 -0600, Alex Behrens wrote:
Hey,
I'm trying to insert data into a table with a TEXT field but the data I am
inserting into the table has a ', present in the data and it gives me an
error, the text is as follows:
Of all the motherboard manufacturers in the world, there are
Using apache 1.3.23 for win32
WinXp and Perl 5.6 and Mysql 3.23.44-nt
The localhost test page by apache runs correctly
The perl script runs from the command line, the Browser url line and just
by
clicking it in the dir.
Trying to launch this perl-dbi script from the browser,
I'm trying to take a string ( In this case, a password ), and encrypt it
with RSA encryption via the perl module, Crypt::RSA. Later on, I want
to be able to pull the encrypted string back out and decrypt it.
One of three things happens when I do this however.
1) Everything works fine.
2)
I didn't receive any response so thought I'd repost with some more
questions.
Is my problem so rare no one knew what to say? or Is there some obvious
solution here and everyone thought *someone else* would straighten me out?
Any pointers and help is appreciated.
Thanks,
Lance
Does anyone have
I got problems deleting a user which I've created before.
mysql delete from user where user=wus;
ERROR 1054: Unknown column 'wus' in 'where clause'
mysql
How about quoting a string type:
delete from user where user='wus';
-Lance
Does anyone have any documentation about a problem where the cpu gets pinned
in the high 90% after running for a while.
While it was in this state I tried mysqladmin processlist and saw 7 threads
all in sleep (persistent dbi connection). There was minimal load on this as
people weren't really
16 matches
Mail list logo