RE: Remote connection

May not have root access to remotely! Try to reconfigure the parameters of the engine. although it is not good idea to allow remote access to the root user!. Greetings, Pablo -Mensaje original- De: Hugo Leonardo Ferrer Rebello [mailto:hugo.rebe...@t-systems.com.br] Enviado el: Martes

Difference between 4.1 and 5

Hi all, I'm looking for some information about difference and new features between mysql 5 and mysql 4.1 Can somebody give me any documentation or link? All documentation is good for me ;) Thanks Pablo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Operation has been cancelled by the user

hi! In the application's log i have this message (when a query is execute): "Operation has been cancelled by the user" It´s a web application developed with ASP.NET. I try to solve it in many ways... but no success... any idea? thanks Pablo -- MySQL General Mailing List Fo

Re: problem with LEFT JOIN

Thanks to all, As you says me, the solution was the indexes. I didn't have an index in results.sample_id. Now the query returns succesfully in a few seconds, regards Juan P. Espino On 7/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Juan Pablo Espi

problem with LEFT JOIN

Hello all! I have two tables in my database: results(20 000 rows) and data_lab1(3 000 rows) Both are related by a sample number (sample_id.) I need to find the samples of data_lab1 table that they are not in results table. I think the following query is the solution: SELECT data_lab1.sample_id,

Re: A problem of structure

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 After the good comments I've got on this mailing list, I think I have the structure more or less complete. In some cases I follow the comments, in some others, I've improvised (hehehe). So, this is the (explained) structure, what do you think ? Anyth

mysql c client library for AIX 5.2

command I get the following error message: configure: error: C++ preprocessor "/lib/cpp" fails sanity check See `config.log' for more details. Can anybody provide me with a mysql client library compiled with cc compiler fo

Re: two questions on starting and stopping mysld

op the server? Currently, I'm doing a killall > mysqld, is there a more graceful way? /usr/bin/mysqladmin [OPTIONS] shutdown Pablo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database problem.

I hope you can help me with this: Incorrect information in file: './sarara/searchindex.frm' Error consulta SQL : SHOW KEYS FROM `searchindex` MySQL ha dicho: #1033 - Incorrect information in file: './sarara/searchindex.frm' How can I fix this??? Thanks ___

group by with hidden fields

Is there a way to tell mysql witch row (from a non unique value column) return when you do a group by omitting some fields from the ones that apear in the select list? Thanks in advance Please reply to this addres to. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system

Openbsd 3.4 performance

Hi list, two questions: - Any tips on improving openbsd performance for mysql 4.0.17? - Creating an index on a primary key improves performance? thank to all.

problem mirroring

from?? pd: where is the official mirror mailing list? -- Juan Pablo Abuyeres <[EMAIL PROTECTED]> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (th

Re: DateTime Calculations

('1999-09-18 13:30:18') - unix_timestamp('1999-09-17 16:30:18'))/60 as total; +-+ | total | +-+ | 1260.00 | +-+ 1 row in set (0.00 sec) Pablo - Before posting, please check:

Trying to Compile (or Install) (mysql++)

++ main.cc -o main 2. Like I see that the rpm doesnt works I remove it (rpm -e package), and tar zxvf the source (1.7.9), I type: automake and I get: [root@pablo mysql++-1.7.9]# automake configure.in:11: your implementation of AM_INIT_AUTOMAKE comes from an configure.in:11: old Automake version. You

Trying to Compile (or Install) (mysql++)

++ main.cc -o main 2. Like I see that the rpm doesnt works I remove it (rpm -e package), and tar zxvf the source (1.7.9), I type: automake and I get: [root@pablo mysql++-1.7.9]# automake configure.in:11: your implementation of AM_INIT_AUTOMAKE comes from an configure.in:11: old Automake version. You

Re: Mysql, PHP and a wrapper

;http://www.php.net/manual/en/configuration.php#ini.auto-prepend-file> Pablo sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re:MySQL server has gone away

Yes, Heikki, the error come from the very first SQL statement of my C program Thanks for your help. Pablo --- Heikki Tuuri <[EMAIL PROTECTED]> escribió: > Pablo, > > if your application claims that MySQL server has > gone > away but you can see with the interactive clien

MySQL server has gone away

ed for me. I've checked the mysqld, and it's up and running. I've runned manually the same INSERT command of the C program from mysql. It worked and created the record succesfully. Any help ? Sorry for my poor English :-) Thanks in advance Pablo PD: My MySQL's versio

ERROR 2002

Anyone can help me with this What can i do thanks a lot ! ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) -- Pablo Javier Gonzalez Mateos, [EMAIL PROTECTED

In the table Properties... What is Row_Format???

What´s the diference between The row storage format (Fixed, Dynamic, or Compressed) . I'am experiencing problems with update statements which goes against a table with the row_format property set to Fixed. Thanks. Pablo Fraga (MIS). e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED] icq: 1134

In the table Properties... What is Row_Format???

What´s the diference between The row storage format (Fixed, Dynamic, or Compressed) . I'am experiencing problems with update statements which goes against a table with the row_format property set to Fixed. Thanks. Pablo Fraga (MIS). e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED] icq: 1134

HELP ME trouble with instalation of Apache+php4+MySQL!!!!!

. what can i do ??? anyone can help me ???, thanks you very much ! P.D. Excuse me for my bad english... -- Pablo Javier Gonzalez Mateos, [EMAIL PROTECTED] on 31/08/2001 - Before

Error 12 from table handler

hi guys: I'am having this error code (Error 12 from table handler) when i am trying to create an index on a table that has about 20 records (it's not a big table)... What does this error code means?. Yours Faithfully. Pablo Fraga (MIS). e-mail: [EMAIL PROTECTED] - [EMAIL PROT

VB with MySQL

Hello, im new in the list, im a VB 6.0 programmer, and im learning the MySQL basics with the Paul DuBois Book... i have a question to do... its possible to make a connection from an VB app. to a MySQL database ???, if its possible, how can i do it ???. Thanks you. Best Regards... ---

MySQLGUI problems

Sun ultra10 with solaris the first screen with the logo appears and a few seconds laters dissapears with the message Segmentation fault (core dumped). Could you please help me. Thanks, Pablo Prado Gemini Observatory - Before

does mysql supports check???

), fechaalta Date NOT NULL, idusuario Int(5) NOT NULL, Primary Key (idcliente) ) ; Pablo Fraga (MIS). e-mail: [EMAIL PROTECTED] [EMAIL PROTECTED]

does the create table supports checks on column definition on mysql???

(idcliente) ) ; Pablo Fraga (MIS). e-mail: [EMAIL PROTECTED] [EMAIL PROTECTED]

doubt about a SELECT

Hi, I have those tables: CREATE TABLE citys ( id mediumint(8) unsigned NOT NULL auto_increment, name varchar(100) NOT NULL, UNIQUE id (id) ); CREATE TABLE route ( id mediumint(8) unsigned NOT NULL auto_increment, id_from mediumint(8) unsigned DEFAULT '0' NOT NULL, id_to mediumi

WinMySqlAdmin

refore the field name of my second field falls into the wrong column in the "Table Columns" display (which incidentally is mis-spelled "previleges". Should be priveleges). Oops! - pablo alonso, ventura, ca.

Slow replies (DNS problem?)

able, and wonder if mysql supports returning schema data using jdbc driver from mark mathews. Fun, but tedious.- pablo alonso, ventura, ca.

just a question

manual saying win98 doesn't support running mysqld as a service. - pablo alonso - ventura, california

Views !!

Hi again Folks !! How may create a view in mysql, o make some seem to the queiries in access !!! THanks Pablo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Another Localtion for databases

Hi Folks!! I have a question, How may set another location for my productions db, so, for instance if i want put my db in /mydb filesystem in my Linux Redhat??? because when i create a db, this is in /var/lib/mysql/data Please , help me Thanks !! Pablo