Shawn,
I like your idea very much. Unfortunately I am not using version 5 yet,
but this may hasten my upgrade.
My initial thought was to try and find a function like PostgreSQL's
LISTEN command
(http://www.postgresql.org/docs/8.0/interactive/sql-listen.html). But I
think this method is
Hello there,
I am receiving Got error 136 from storage engine and I need some
light on this matter.
I have a table with 23,000,000 records and I want to update it with
datas from another one with the exact same amount of rows. The 2
tables can be linked by a primary key. Both tables are myISAM,
Hi,
error 136 = No more room in index file
so I suppose it's a problem with the size needed for your keys, maybe that
will help:
http://dev.mysql.com/doc/mysql/en/key-space.html
HTH,
Melanie
From: CheHax [EMAIL PROTECTED]
Reply-To: CheHax [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject:
Hi
according to Dr Google I'm not the first one to encounter this error
below.
SpamAssassin: invoked with 'spamd -D -q -u filter'
failed to load user (filter) scores from SQL database: SQL Error:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13)
Thus, I cannot
Hello.
See:
http://dev.mysql.com/doc/mysql/en/encryption-functions.html
symbulos partners [EMAIL PROTECTED] wrote:
Dear friends,
where is the description of the functions md5 in the manual? where is the
description of the function crypt()?
are there are good alternatives?
Hello.
The manual recommends to use ALTER TABLE to increase the MAX_ROWS and
AVG_ROW_LENGTH table options values. See:
http://dev.mysql.com/doc/mysql/en/repair.html
CheHax [EMAIL PROTECTED] wrote:
Hello there,
I am receiving Got error 136 from storage engine and I need
Dear friends,
thanks for the link to the dev manual page on encryption function.
Which encryption is more secure (strongest)
AES
DES
SHA
?
I would have said AES, but after reading the manual chapters on DES, SHA I am
not s(ec)ure any more.
By the way, I did not understand if the bug
On Tuesday, March 22, 2005 07:15, symbulos partners wrote:
Dear friends,
thanks for the link to the dev manual page on encryption function.
Which encryption is more secure (strongest)
AES
DES
SHA
?
Are you using this for password storage or encrypting actual data?
If you are using
A table exists with id and datetime columns; I need to SELECT records from
the previous business day. I began with this:
SELECT id FROM table WHERE TO_DAYS(NOW()) - TO_DAYS(datetime) =1
But if NOW() is a Monday, it pulls records from Sunday (there are none since
records are inserted
Z X C V [EMAIL PROTECTED] wrote on 03/21/2005 08:32:24 PM:
Hello,
Are there any good rfcs or other documents that would assist in the
discussion I'm having with our organization's Oracle programmers in
regards the following:
Oracle DB - MySQL
They recommend:
~ col~col ~col~
A quick try:
In most cases you need results from yesterday, but for Sunday and Monday we
must correct extra for the weekend.
DAYOFWEEK() returns 1 for Sunday, 2 for Monday, etc., so we can use this to
make a correction value:
SET @COR = (DAYOFWEEK(NOW()) 3) * DAYOFWEEK(NOW());
SELECT * FROM
Hello,
I have historical dates in datetime format and they are in UTC. I'd like
to convert them to localtime. Can this be done with mysql 3.23.22? It
looks like 4.1 can handle this, but I won't be upgrading in a while.
If not, does anyone know of a perl module that takes mysql formated
Have you seen this before:
mysqldump: Got errno 5 on write
I have started getting this error recently in my email box - the message is
result of my daily backup cronjob.
Ideas?
rgrdz,
Mihail Manolov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Stembridge, Michael [EMAIL PROTECTED] wrote on 03/22/2005 10:30:50
AM:
A table exists with id and datetime columns; I need to SELECT records
from
the previous business day. I began with this:
SELECT id FROM table WHERE TO_DAYS(NOW()) - TO_DAYS(datetime) =1
But if NOW() is
Mike Rykowski [EMAIL PROTECTED] wrote on 03/22/2005 11:12:41 AM:
Hello,
I have historical dates in datetime format and they are in UTC. I'd
like
to convert them to localtime. Can this be done with mysql 3.23.22? It
looks like 4.1 can handle this, but I won't be upgrading in a while.
According to the output of perror:
perror 5
Error code 5: I/O error
Are you having problems with your disk? Maybe syncing or bad sectors or
even something as simple as out of space?
Best of luck,
--V
Mihail Manolov wrote:
Have you seen this before:
mysqldump: Got errno 5 on write
I have
At 10:28 AM 3/22/2005, [EMAIL PROTECTED] wrote:
What do you mean by historical? Are we talking 20th century dates or
something BCE?
Dates that could be a couple of years old.
-
Mike Rykowski
IT - Telecommunication and Network Services
(847) 467-7335
[EMAIL PROTECTED]
--
MySQL General
Michael,
Someone on the list recently dave this quickie formula for computing
the no. of biz days::
DATEDIFF(date2, date1) - (WEEK(date2) - WEEK(date1)) * 2
PB
-
Stembridge, Michael wrote:
A table exists with id and datetime columns; I need to SELECT records from
the previous
One problem with that formula is that it fails if you wrap around from one
year to the next. But as a quickie, it's good.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Peter Brawley [EMAIL PROTECTED] wrote on 03/22/2005 01:01:29
PM:
Michael,
Someone on the list
Hello,
Please can someone tell me how you pass arrays between PHP pages.
I have tried something like this and have tried many variations of this but
nothing working yet ;
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2] =Peach;
echo INPUT NAME = \kcompany[]\ TYPE = \hidden\
[snip]
Please can someone tell me how you pass arrays between PHP pages.
I have tried something like this and have tried many variations of this
but
nothing working yet ;
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2] =Peach;
echo INPUT NAME = \kcompany[]\ TYPE = \hidden\
I have mysql version 4.0.15-nt in a server NT, I can
connecting with mysql localy, but when i try remote
connection the error is:
Error Number 2003 Can't connect to MySQL server on
'IP' (10060) .
I use mysql odbc 3.51
Is necesary the file my.cnf in c:\my.cnf
Regards
Gerardo Campos
From: PartyPosters [mailto:[EMAIL PROTECTED]
Hello,
Please can someone tell me how you pass arrays between PHP pages.
I have tried something like this and have tried many
variations of this but
nothing working yet ;
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2]
1) Are you running a firewall? If so, make sure that port 3306 is open.
2) Is your MySQL server is up and running?
3) Do you have the correct permissions to connect to the server via your
mysql.hosts table?
Just some thoughts.
J.R.
-Original Message-
From: gerardo Villanueva
When you are running as root, but are you running as 'root'@'%' or
'root'@'localhost'? This does make a big difference. The '%' means all
network connections, which isn't secure. I would only using it as testing
purposes.
However, because your error message says that you cannot see the server,
One other thing to check, make sure --skip-networking isn't specified in
your configuration.
mysql show variables like 'skip_networking';
+-+---+
| Variable_name | Value |
+-+---+
| skip_networking | OFF |
+-+---+
1 row in set (0.00
Not necessary to change my.cnf, unless --skip-networking was specified.
Also assuming that you are using port 3306.
mysql show variables like 'port';
+---+---+
| Variable_name | Value |
+---+---+
| port | 3306 |
+---+---+
1 row in set
Or you can issue session_start() at the top of each page, assign your
array to $_SESSION[] in one page, and pluck it from the session array
in the other page.
(But you asked the question in the wrong forum)
PB
-
Mike Johnson wrote:
From: PartyPosters [mailto:[EMAIL PROTECTED]]
Hi Kaan
try
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2] =Peach;
$testA=implode(!, $testArray);
echo INPUT NAME = \kcompany\ TYPE = \hidden\ VALUE=\$testA\;
Page2
$testArray=explode(!, $kcompany);
echo $testArray[1];
HTH
Steve
PartyPosters wrote:
Hello,
Please can someone
hi
How do I import data from Dbase3 into MySQL?
--
B.G. Mahesh
[EMAIL PROTECTED]
http://www.indiainfo.com/
--
__
IndiaInfo Mail - the free e-mail service with a difference! www.indiainfo.com
Check out our value-added Premium features, such as an
BG Mahesh wrote:
hi
How do I import data from Dbase3 into MySQL?
--
B.G. Mahesh
[EMAIL PROTECTED]
http://www.indiainfo.com/
BG,
There are tools you can use to migrate it to mysql, i use it before that
i get it in the forum. You can search some forum indicating the
migration tools for DB3,
31 matches
Mail list logo