It´s working.
The problem was related to grant permission.
Thank you.
Cheers,
Hugo
-Mensagem original-
De: Gavin Towey [mailto:gto...@ffn.com]
Enviada em: terça-feira, 4 de agosto de 2009 19:46
Para: Hugo Leonardo Ferrer Rebello; mysql@lists.mysql.com
Assunto: [SPAM] RE: Remote
27;@'192.168.12.50' (using
password: YES)
Cheers,
Hugo
results.
Best regards
Hugo
=
Hugo Kohmann |
Dolphin Interconnect Solutions AS | E-mail:
P.O. Box 150 Oppsal| hu...@dolphinics.com
N-0619 Oslo, Norway
discount.
More information can be found at
http://www.dolphinics.com/solutions/mysql.html
Please e-mail me ([EMAIL PROTECTED]) to express your interest in
participating in this test.
Best regards
Hugo
===
Hi,
I've done some indexes in my tables and I solved my problem.
But I still confused with indexes. I created one multiple index with the
main 4 columns for mensagenspara's table. But it doesn't work. So, I created
one index with 3 columns and one for each column, wich give me 4 indexes,
and later
I found something weird.
This is my query now
--
(SELECT
m.codmensagem,
m.codprioridade,
m.codusuario,
m.codmensagemoriginal,
m.codmensagempai,
m.assunto,
m.dataenvio,
m.horaenvio,
m.datalimite,
m.horalimite,
m.anexo,
m.tipo,
u.nome,
up.nome as nomepara,
mp.codrespondida,
mp
I've created an index with the statement
create index `usuario_pasta_situacao` on `mensagens` (codusuario, codpasta,
situacao);
And for mensagenspara table this index
create index `mensagem_usuario_pasta_situacao_idx` on `mensagenspara`
(codmensagem, codusuario, codpasta, situacao);
This is quer
hum... I get it.
But in my query, I look in 3 tables
FROM
mensagens m,
mensagenspara mp,
usuarios u,
usuarios up
WHERE
m.codmensagem = mp.codmensagem
AND u.codusaurio = m.codusuario
AND up.codusuario = mp.codusuario
m.codmensagem, u.codusaurio and up.codusuario are primary keys
mp.codusuario,
but still too slow, because we
have around 300 employees using this system at same time, and in these tests
I'm using only my computer.
2007/8/14, Martin Gainty <[EMAIL PROTECTED]>:
>
> Hello Hugo
> In your last CREATE TABLE statement you have
> PRIMARY KEY (`codmensagempara`
agine (I'm
work this issue for 5 days)
Using 5.1.20-beta-community-nt-debug.
Thanks in advanced.
--
Hugo Ferreira da Silva
Programador
Fone: (45) 9102-1148
http://www.hufersil.com.br
[EMAIL PROTECTED]
Hi,
I'm a mysql user for a long time and i would like to knoe if exists
any implementation of cube operator in mysql. I already used rollup
operator .
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ndows-centric applications where "MS Office-like Toolbars" is a main
feature :) ...
Cheers, Hugo.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
correctly in MySQL even though they look strange? If not, what can I do to
correct it?
Kind regards
Hugo Alroe
Administrator of Organic Eprints at http://orgprints.org
Personal workpage: http://hugo.alroe.dk/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Does anyone know how to use text fields (BLOB) in the full text search?
Hugo
PS.
sql,query,queries,smallint
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
? Any clue? I'm new to this so i apollogize if
this is a very basci thing.
Thxs in advance
Hugo Veiga
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
hi there
the present serves for some clearing some doubts i have:
1 - if i wanna make an action based on the fact that a query i just made
won't return results (empty set), how can i test that?
will this do?
if(!mysql_query(myData, query)
{
results = mysql_store_results(myData);
Hi,
I'm developing a web site with PHP and I want to show some information
only
if I'm able to connect to a mysql database . If I can´t connect , simply I
don´t
show some parts of the web page.
Sounds easy and it works fine in local , but when I install it in the web
server ,
if it can´t c
Hi,
I'm developing a web site with PHP and I want to show some information
only if I'm able to connect to a mysql database . If I can´t connect ,
simply I don´t show some parts of the web page.
Sounds easy and it works fine in local , but when I install it in the
web server ,if it can´t conne
Hi there.
Im having some troubles with mysql and FULLTEXT.
I create one table like this:
create table pets (id INT AUTO_INCREMENT NOT NULL PRIMARY KEY);
alter table pets add name TEXT;
alter table pets add kind TEXT;
alter table pets add FULLTEXT name (name);
alter table pets add FULLTEXT kind (k
rg% /opt/mysql-3.23.44/bin/my_print_defaults mysqld mysql_install_db
--datadir=/var/lib/mysql
--socket=/var/lib/mysql/mysql.sock
crypt.org%
.. so now I don't know.
Hugo
-
Before posting, please check:
http://www.mysql.com/ma
On Wed, Oct 03, 2001 at 05:02:27PM +, Carl Troein wrote:
>
> Hugo Koji Kobayashi writes:
>
> > I'm making some tests with mysql and I got the errors below when I
> > run these selects:
> >
> > SELECT id, COUNT(*) FROM error_test WHERE info =
On Wed, Oct 03, 2001 at 06:39:45PM +0200, Carsten H. Pedersen wrote:
> > Hi,
> >
> > I'm making some tests with mysql and I got the errors below when I
> > run these selects:
> >
> > SELECT id, COUNT(*) FROM error_test WHERE info = 1 GROUP BY id LIMIT 10;
> > ERROR 1034: Incorrect key file for t
vide some information that can be useful to reproduce the
problem.
TIA,
Hugo
How to repeat: run the sql script generated by the perl code below
--begin--
#!/usr/bin/perl
open(DESC, "> error_test.sql");
print DESC< 8;\n";
print DESC "SELECT id, COUNT(*) FROM error_test W
>Description:
I compiled MySQL 3.23.39 from the Source RPM
Compilation went fine. (These is 1.1MB log file for anyone interrested)
Compile command was:
sparc32 rpm -bb --clean mysql-3.23.29.spec 2>&1|tee mysql.log
Starting mysqld however burbed with the following
ipt ($bindir/mysql_install_db):
-
echo "PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !"
echo "This is done with:"
echo "$bindir/mysqladmin -u root -p password 'new-password'"
echo "$bindir/mysqladmin -u root -h $hostname -p password
Tengo una base de datos en Mysql pero programando en visual foxpro no me regresa la
informacion
no se, si hay que hacer algo en especial ??
el codigo en que hace la conexion es el sig.
STORE SQLCONNECT('Sipaae') TO db_conec
IF db_conec <= 0
= MESSAGEBOX('Falla al Conectarse al
Hola a todos.
Que metodo hay que hacer para poder traerse una bd de Informix a Mysql???
Por la Atencion Gracias :)
Hugo orta
BigBrother (www.bb4.com) has a plugin for MySQL. It monitors the IP port of
the mysqlserver and sends you a message when it is down (or start a script
and do wahtever you want e.g. start up the slave).
Hugo Burm
[EMAIL PROTECTED]
> -Original MessageH-
> From: Simon Green [mailto:
28 matches
Mail list logo
