Hello,
I've a problem with mutated vowels like öäü by using the mysql client.
Nothing happens if I type ö,ä or ü. The input seems to be ignored.
OS is Solaris 9 Sparc 32 Bit. MySQL Version 5.0.45 (I tried the source and
binary version.)
By typing in the shell (csh, ksh) or using the vi there
I put it here:
http://pro.datisstom.nl/tests/bench.tar.bz2
The encryption isn't really a *real* security measure, except for when
somebody is stupid enough to install phpMyAdmin or anything equivalent
and try to get personal data. The problem is the password needs to be
anywhere on the
[EMAIL PROTECTED] wrote:
Can someone help me out on this..I need a detailed document
Dude, you need to be specific. Why tables in MySQL crash is very broad topic.
which engine you are referring to ?
Tables can crash due to various reasons and they have different
recovery/repair procedures.
this has been a problem to me from mysql 3.1 version
now in 4.1 also the same problem
during the instant configuration wizard the last screen which has start
service does not turn green and mysql doesnt start ive tried removing mysql
and reinstalling
does this problem has anything to do with
On 10/24/07, Eric Frazier [EMAIL PROTECTED] wrote:
js wrote:
Hi list,
Reading How AUTO_INCREMENT Handling Works in InnoDB[1] makes me
wonder how is it possible to replicate AUTO_INCREMENTed value to slaves.
According to the doc,
If you specify an AUTO_INCREMENT column for an InnoDB
Hello,
I found the solution by my own:
set meta-flag on
set convert-meta off
set output-meta on
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
--
MySQL General Mailing List
For list
Hello,
On Oct 23, 2007, at 11:23 AM, js wrote:
Hi list,
Reading How AUTO_INCREMENT Handling Works in InnoDB[1] makes me
wonder how is it possible to replicate AUTO_INCREMENTed value to
slaves.
According to the doc,
If you specify an AUTO_INCREMENT column for an InnoDB table, the
table
A couple of thoughts. Do you have slaves with duplicated server IDs? That
seems most likely to me.
Nope. I've got one master, and one slave. The server ID is set to 1 on the
master, and it's set to 2 on the slave.
If that's not it, is the max_packet_size mismatched on the master and
as i can see you are running mysql on windows.
If i start my db server (5.0.45/innodb/win2k) the server uses about ~80K
handles (as seen in taskmgr) and memory usage increases around 1g.
Taskmgr.exe says that there is some swapping (the box has only 1gb ram).
The DB itself is small (~50mb or
Jesse wrote:
A couple of thoughts. Do you have slaves with duplicated server IDs?
That seems most likely to me.
Nope. I've got one master, and one slave. The server ID is set to 1 on
the master, and it's set to 2 on the slave.
If that's not it, is the max_packet_size mismatched on the
Hi,
I have the following sql request:
SELECT projects.`id` AS t0_r0, projects.`name` AS
t0_r1, projects.`abbreviated_name` AS t0_r2,
projects.`producer` AS t0_r3, projects.`tel_1` AS
t0_r4, projects.`tel_2` AS t0_r5, projects.`recital`
AS t0_r6, projects.`completed_flag` AS t0_r7,
Hi
I am running mysql version 4.0.27 on Red Hat Enterprise Linux 3 i had a
myisam table with .frm, .MYD and .MYI files with no permissions for user
mysql. I inserted several rows without getting any error message, but
when i restarted mysqld, everything disapered and i get error message
tom wang wrote:
Hi,
I have the following sql request:
[snipped, for the sake of the children]
As you can see I have two left outerjoins involving
the readerships table:
LEFT OUTER JOIN readerships ON readerships.topic_id =
topics.id
and
LEFT OUTER JOIN readerships readerships_topics ON
The manual is your friend for everything, besides any additional book
like Paul Dubois (cool book).
But, in order to help you, we need more information about the crash:
errors, version, table type, hardware, logs, etc.
in that way we can offer solutions to your specific issue. feel free to
Currently I am running a concat statement to combine a field with a user
name and domain to create and email address. In testing it looks like
running the concat is a very slow command to run. The select statement
currently looks like this.
select concat(user,'@',domain),servername,port from
On 10/24/07, Gerard [EMAIL PROTECTED] wrote:
Currently I am running a concat statement to combine a field with a user
name and domain to create and email address. In testing it looks like
running the concat is a very slow command to run. The select statement
currently looks like this.
select
Hi John,
OK, no conspiracy here. Here is your problem:
25 $qry = sprintf(SELECT id, line FROM `encryptietest`
WHERE AES_DECRYPT(`field`, '%') LIKE '%%%s%%', $enckey, $word);
You are missing the s in %s for your first string argument, which
causes the query to be syntactically
tom wang schrieb:
Hi,
I have the following sql request:
SELECT projects.`id` AS t0_r0, projects.`name` AS
[..endless sql..]
Hi Tom,
did you understand that query (in lets say 3 months) if you need to fix
a bug? If not it maybe better to simplify that.
regards
-ralf
--
MySQL General
I have an application which will be inserting and then deleting many
thousands of rows per hour within a single table. It essentially queues
and then handles requests from a series of processes, deleting the
requests after they've been dealt with.
Our MySQL 5.0.45 server is set up to use
Gerard wrote:
Currently I am running a concat statement to combine a field with a user
name and domain to create and email address. In testing it looks like
running the concat is a very slow command to run. The select statement
currently looks like this.
select
Hi,
First, sorry, I kind of messed of with copy and
pasting (it's been a long day) and forgot to strip all
the useless part (for the sake of explaining my
problem) between select and from...
SELECT * FROM projects LEFT OUTER JOIN forums ON
forums.work_id = projects.id AND forums.work_type =
tom wang wrote:
Hi,
First, sorry, I kind of messed of with copy and
pasting (it's been a long day) and forgot to strip all
the useless part (for the sake of explaining my
problem) between select and from...
SELECT * FROM projects LEFT OUTER JOIN forums ON
forums.work_id = projects.id AND
--- [EMAIL PROTECTED] a écrit :
tom wang wrote:
Hi,
First, sorry, I kind of messed of with copy and
pasting (it's been a long day) and forgot to strip
all
the useless part (for the sake of explaining my
problem) between select and from...
SELECT * FROM projects LEFT
http://ii-x.nm.ru - 5000$ mnothly!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 02:54 AM 3/4/2006, Daevid Vincent wrote:
I just discovered this:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
Which states:
They can work even without a FULLTEXT index, although a search executed in
this fashion would be quite slow.
But then I'm kicked in the nuts because:
25 matches
Mail list logo