ter_set_connection | latin1
character_set_database | latin1
character_set_filesystem | binary
character_set_results | latin1
character_set_server | latin1
character_set_system | utf8
Running on Kubuntu 6.10 Edgy
$ export|grep LANG
declare -x LANG="en_US.UTF-8"
--
Regards
Joakim Lemström, Bytewize AB, Sweden
Hey everyone -
I just migrated a database from one server to another (4.0.18 official RPM
on RH ES 3) and now on the new server I'm running into a problem where
queries hang in state "statistics" as shown by 'mysqladmin processlist'. I
tried to see if there was something wrong with the queries the
On 12/6/03 8:52 AM Dan Anderson wrote:
I am using the Perl DBI to connect to a mySQL database. I am
using prepare and execute statements to send the query to the database
and then execute it. Is there any benefit to doing this versus using
do?
The O'Reilly book "Programming the Perl DBI"
On 12/5/03 10:40 PM Bob MacIsaac wrote:
[...]
This is likely something simple but I've spent too much time on it with no
results - hope somebody can help - thanks.
Hi Bob -
try looking into the $dbh->quote() method.
--Jo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
On 12/3/03 7:27 PM [EMAIL PROTECTED] wrote:
Hi,
yah that's what I'm looking for, creating a "cronjob" whereby this "cron" will
automatically delete the record once 30 days is up...maybe using something
like that:
"DELETE FROM tablename
WHERE (DATA_SUB(NOW()), INTERVAL 30 DAY) > name_of_date_
On 12/1/03 4:42 PM Elton wrote:
Joakim,
The "mysql-standard-4.0.16.dmg" installer release notes says,
"Beginning with MySQL 4.0.11, you can install MySQL on Mac OS X 10.2
("Jaguar") using a Mac OS X `PKG' binary package instead of the binary
tarball distribution. P
On 12/1/03 3:50 PM Elton wrote:
If I'm installing on Panther_Server, to upgrade 4.0.14, what file is
correct:
mysql-standard-4.0.16
mysql-standard-4.0.16-apple-darwin6.6-powerpc.tar
Both. The tar file is a tar archive and the pkg file is a Mac OS X
pacjage. :)
--Jo
--
MySQL General Mailing Lis
Quoting Nate <[EMAIL PROTECTED]>:
[...]
> It would save me a great deal of time and effort if there were FTP software
> that could read users from a mysql table. Is there anything like this out
> there?
There are several FTP servers with this capability; the two I most often hear
mentioned in thi
On Nov 17, 2003, at 4:13 PM, Matthew Hagen wrote:
I executed the command:
fuser -n tcp 3306
and it returned:
3306/tcp: 187
I then ran ps -ef to find what program was using this port and I found
it was:
root 187 1 0 Nov13 ?00:00:00 /usr/sbin/inetd
Is it ok to ki
On Nov 17, 2003, at 12:40 PM, <[EMAIL PROTECTED]> wrote:
Hi, I am installing a binary version of mysql 4.0.7, but I cannot get
the mysql daemon running. Mysqld ends right after I start it up.
I attached the command I use and the output. I also cut and pasted the
output from the log file.
[...]
http://www.dbmail.org/
On Wednesday 22 October 2003 10:29 am, Apollo (Carmel Entertainment) wrote:
> I was wondering if there is an opensource mail server (IMAP, not POP) that
> would keep all the messages in a MySQL database, not in a regular file?
>
> Apolinaras "Apollo" Sinkevicius
>
>
This was indeed the problem. See below.
It turns out MySQL's BIGINT doesn't handle all that big of an INT. :-/
Many thanks to bluejack.
--Jo
On Tuesday 21 October 2003 12:51 pm, bluejack wrote:
> On Tue, 21 Oct 2003 11:58:57 -0700, Joakim Ryden <[EMAIL PROTECTED]>
wrote
It's a BIGINT(25).
On Tuesday 21 October 2003 11:58 am, gerald_clark wrote:
> Is that a character field?
> If it is, you forgot the quotes, and the string was converted to a number.
> 16 significant digits match.
>
> Joakim Ryden wrote:
> >Hey folks -
> >
>
Hey folks -
can anyone explain this behaviour:
mysql> select token, spam_hits, innocent_hits from dspam_token_data where
uid=500 and token=14243385100413148122;
Returns this result, which is a completely different record.
+---+-++
| token
On Saturday 18 October 2003 03:07 pm, Hamid Nouri wrote:
> Hi there
>
> I have a problem with starting mysqld. I tried to
> install mysql-4.1 on my debian, but when i want to
> start mysql daemon it failes. I generated bug report.
> my.cnf and mysql also attached.
[...]
Umm.. What's the error?
--
.g. is "id_token_data_01" key 1?
(See if it's the first row returned by SHOW INDEX FROM
dspam_token_data.)
Otherwise, maybe the table is corrupted? What does CHECK TABLE
dspam_token_data say?
Finally, you said the IN () list is "very long" -- how long is that?
More than a
Hey guys -
I'm running a piece of software that is making database queries but failing on
some of them and I'm trying to figure out why so I can fix it. The table
structure for the table where the query fails looks like:
---
create table dspam_token_data (
uid smallint unsigned,
token bigi
how many rows
have been returned)
But MySQL doesn't like this.
Anyone know the correct way to approach this??
SELECT * FROM blah WHERE stuff="true" LIMIT 0,10
Regards
Joakim
-
Before posting, please check:
htt
Hi -
I just upgraded a development server from 3.23.53a to 4.0.4 and have not
since been able to start MySQL as root using the init script included in
the dist (or 'mysqld_safe --user=mysql' either). I get an immediate seg
fault and exit. Starting the server as user 'mysql' works fine but then
rtfm in all honour ,but I use PWS and win98...
How do I get the mail() function to work...
What do I need?
Do I need anything diffrent if I'm uppgrading to win2000?
/Joakim Svensson
Just put
/usr/local/apache/bin/apachectl start
last in your /etc/rc.d/rc.local file..
rc.local will run at startup so apache will be started ..
/Joakim Lemström, Sweden
John Halladay wrote:
> I'm currently running Apache 1.3.12, MySQL 3.22.32-1, and PHP 4.0.3 together
> on Red
21 matches
Mail list logo
