Cast a value as datetime using Mysql prior to 4.0

Hi. In MySql 4.0 you can use the function CAST to cast a value as datetime: CAST(value AS DATETIME), but in versions of MySql you can't. How can I do this cast in other versions of MySql? Iago. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

MySQL Administrator certain options only valid at localhost

Hi. I've downloaded MySql Administrator 1.0.1a alpha for Windows and tried it. It has options only enabled if MySQL Admnistrator is connected to localhost. I'm connected as root to other host (which is Linux). For example the Startup Variables. Some of these options are the most interesting

RE: MySQL Administrator certain options only valid at localhost

. The scheduled bit of this is blank on mine so I assume that this is a bug as it should display the Local host only message. Greg -Original Message- From: Iago Sineiro [mailto:[EMAIL PROTECTED] Sent: 13 February 2004 12:10 To: MySql Mail List Subject: MySQL Administrator certain options only

MaxDB Release?

Hi. Some curiosity. Does anyone know when the release of MySQL MaxDB 7.5 version will come out? In the MySQL web page at http://www.mysql.com/sapdb/timeline.html says that the release was planned for 15 of October but now we are at 11 of November and nothing has been released. Is it delayed

RE: Howto reduce size of MYISAM files after deleting records?

Thanks. Whith InnoDB tables I have to do something similar or it's not necessary? Iago. -Mensaje original- De: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Enviado el: martes, 28 de octubre de 2003 19:49 Para: 'Iago Sineiro'; 'MySql Mail List' Asunto: RE: Howto reduce size

Howto reduce size of MYISAM files after deleting records?

Hi. I delete a lot of records of one MyISAM table in MySQL 4.0.16. After that I execute mysqladmin refresh and now the size of the files of the table is the same than before. Is something wrong or is necessary doing something more to reduce the size of the files? Thanks in advance. Iago. --

Locked connection doesn't disconnect

Hi. I've developed a program in Delphi 5 that uses ZeosLib components for connect to a MySQL database that uses MyISAM tables and inserts some records. If I finalize the program with Ctrl-Alt-Supr when it's inserting the records the programs disconnects from MySQL (a Disconnect method is called

showing Host name in mysqladmin proc with wins using samba

proc in the linux box it shows the ip in Host column, not the name. If I add the name of the workstation to /etc/hosts it shows the name in mysql admin proc. Iago Sineiro. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

perl error when execute mysqlaccess

box is a RedHat 9 in where I installed mysql-4.0.13 using binary tar.gz package. Iago Sineiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: perl error when execute mysqlaccess

Thanks. I've installed package perl-CGI and now it works. Iago Sineiro -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviado el: viernes, 27 de junio de 2003 15:48 Para: Iago Sineiro; MySql Mail List Asunto: RE: perl error when execute mysqlaccess This more a perl

How to empty the cache?

Hi. I'm doing some testings and I want to know how to empty the cache in mysql (versions 3.23 and 4.0) between the differents tests. Iago Sineiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How to empty the cache?

(and also the query cache) without shutdown the mysql server? Iago Sineiro. -Mensaje original- De: Nils Valentin [mailto:[EMAIL PROTECTED] Enviado el: lunes, 09 de junio de 2003 12:48 Para: Iago Sineiro; MySql Mail List Asunto: Re: How to empty the cache? Hi Iago, I am unsure if I

RE: How to empty the cache?

Thanks. I will try it. Iago Sineiro. -Mensaje original- De: Dan Nelson [mailto:[EMAIL PROTECTED] Enviado el: lunes, 09 de junio de 2003 16:54 Para: Iago Sineiro CC: MySql Mail List Asunto: Re: How to empty the cache? In the last episode (Jun 09), Iago Sineiro said: Sorry

Possibly bug in InnoDB with mysql 3.23.55

updated instanceNo to 6. The transaction isolation is READ-COMMITED then in connection A I should obtain values updated in connection B (automatically committed). Note: I also tested this with MySQL 3.23.54 Iago Sineiro - Before

RE: Possibly bug in InnoDB with mysql 3.23.55

Thansk for the information Fred. Iago Sineiro. -Mensaje original- De: Fred van Engen [mailto:[EMAIL PROTECTED]] Enviado el: jueves, 20 de febrero de 2003 10:37 Para: Iago Sineiro CC: MySql Mail List Asunto: Re: Possibly bug in InnoDB with mysql 3.23.55 Hi, On Thu, Feb 20

Alternative to LOCK TABLES in InnoDB?

; UPDATE table_POID SET instanceNo = newInstanceNoValue; UNLOCK TABLES; But with table type InnoDB I have to use another connection to do this because the LOCK TABLE sentence commits the transacction. Is there any form to do it in MySQL with InnoDB? Thanks in advance. Iago Sineiro

my.cnf optimized for InnoDB

variables from my.cnf are only related for MyISAM table type (and not for InnoDB) and which are the minimal values for these variables. I'm using MySQL 3.23.53a-max in a dual Pentimum III 1000GHz Linux box with 1GB of memory. Thanks in advance. Iago Sineiro

Problems installing mysql-max-3.23.53a linux binaries

prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data 021120 12:52:05 mysqld ended Iago Sineiro. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: Problems installing mysql-max-3.23.53a linux binaries

/mysql.server: @HOSTNAME@: command not found prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data Iago Sineiro. -Mensaje original- De: Iago Sineiro [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 20 de noviembre de 2002 10:37 Para: MySql Mail List Asunto

RE: Problems installing mysql-max-3.23.53a linux binaries

Thanks Lenz. Now, after modifying the init script, I don't get the advise. Iago Sineiro. -Mensaje original- De: Lenz Grimmer [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 20 de noviembre de 2002 12:27 Para: Iago Sineiro CC: MySql Mail List Asunto: Re: Problems installing mysql

RE: Profiler

Hi Alexander. If you specify option log in section mysqld of my.cnf configuration file you get a log file of all queries and sql operations (inserts, updates, deletes) executed in the MySQL server. This log file is created by default at $DATADIR/$HOSTNAME.log. Iago. -Mensaje original-

RE: RedHat8.0 and MySQL

-Mensaje original- De: Mark Matthews [mailto:mark;mysql.com] Enviado el: miercoles, 23 de octubre de 2002 16:38 Para: Rolf Nilsen CC: [EMAIL PROTECTED] Asunto: Re: RedHat8.0 and MySQL Rolf Nilsen wrote: Hi, dont know if this is old information, but: RedHat 8.0, MySQL

RE: RedHat8.0 and MySQL

Thanks Mark. Iago. -Mensaje original- De: Mark Matthews [mailto:mark;thematthews.org] Enviado el: miercoles, 23 de octubre de 2002 18:30 Para: Iago Sineiro CC: [EMAIL PROTECTED] Asunto: Re: RedHat8.0 and MySQL Iago Sineiro wrote: -Mensaje original- De: Mark Matthews

RE: Where is the mysqladmin?

Hi Andre. You need MySQL-client-VERSION.rpm package for use mysqladmin. Also you could need MySQL-shared-VERSION.rpm for shared libraries needed for use MySQL with other programs and MySQL-devel-VERSION.rpm if you need include files for develop applications using MySQL. Iago. -Mensaje

RE: Where is the mysqladmin?

the MySQL-client-VERSION.rpm, ySQL-shared-VERSION.rpm and the MySQL-devel-VERSION.rpm? I didn't find them available at the www.mysql.com site. Thanks, Andre --- Iago Sineiro [EMAIL PROTECTED] wrote: Hi Andre. You need MySQL-client-VERSION.rpm package for use mysqladmin. Also you

RE: Compiling mysql with correct libraries

-Mensaje original- De: Sinisa Milivojevic [mailto:sinisa;mysql.com] Enviado el: lunes, 21 de octubre de 2002 14:28 Para: Iago Sineiro CC: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: Re: Compiling mysql with correct libraries On Mon, 21 Oct 2002 09:51:41 +0200 Iago Sineiro [EMAIL

Compiling mysql with correct libraries

Hi all. I want to compile MySQL statically with my own UDF and InnoDB support in one box and with make_binary_distribution install it in a RedHat 8.0 box. Which are the correct versions for gcc and glibc? And automake, autoconfig, and any another posible package needed for compile MySQL? Which

Problems installing Msql-Mysql-module in RedHat 7.2

Hi all. I installed MySQL 4.0.4 in RedHat 7.2 using rpms. Also I installed MySQL-bench rpm package, it saids it needs DBD-MySQL and I isntall it with parameter --nodeps. So I try to install Mysql modules for Perl. First I try with RedHat 7.2 rpm package but it didn't work. It needs

Problems installing Msql-Mysql-module in RedHat 7.2

Hi all. I installed MySQL 4.0.4 in RedHat 7.2 using rpms. Also I installed MySQL-bench rpm package, it saids it needs DBD-MySQL and I isntall it with parameter --nodeps. So I try to install Mysql modules for Perl. First I try with RedHat 7.2 rpm package but it didn't work. It needs

RE: Problems installing Msql-Mysql-module in RedHat 7.2

Iago Sineiro wrote: Hi all. I installed MySQL 4.0.4 in RedHat 7.2 using rpms. Also I installed MySQL-bench rpm package, it saids it needs DBD-MySQL and I isntall it with parameter --nodeps. maybe it need the mysql-devel package -- frankie mysql-devel package is installed

Compilation options of rpm packages

Hi all. Any of MySQL AB team could explain the options used in the compilation of rpm packages for Linux? Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Force NOW() result to type datetime

Hi all. I execute the query SELECT NOW() in Delphi 5.0 against MySQL 3.22.30 and Delphi understand that the column of the query is of type ftString (String) when it should be ftDateTime (datetime). Any query I execute that contains a datetime column returns the datetime type. In MySQL 4.0.3 I

chunk-size RAID-0 with InnoDB

Hi all. Anybody uses MySQL InnoDB with RAID-0? Wich would be the best chunk-size for a raid-0 where put the datafiles? Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the

Dependencies with MySQL-bench.rpm package

Hi. I install MySQL-3.23.52 in SuSE 8.0 with rpms packages. I could install all packages except MySQL-bench-3.23.52-1.i386.rpm. It needs MySQL-DBI-perl-bin I donwloaded Mysql-DBI-perl-bin-1.1825-1.i386.rpm (it also needs perl-DBI), but it isn'nt MySQL-DBI-perl-bin and after install it I

RE: Mysql with innodb support

Hi Peter. You should download the max version of mysql binaries from www.mysql.com. It has innodb support. Also you could download the source files and compile mysql with innnodb support. Iago -Mensaje original- De: Peter Goggin [mailto:[EMAIL PROTECTED]] Enviado el: miércoles 11 de

Server's Ip number

Hi all. Anybody knows how to obtain the server's ip number in MySQL? Is there any variable or function? Thanks in advance. Iago - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Is compiler advisory at source download valid?

Hi all. Is the compiler advisory at mysql source donwload web page still valid? The web page is http://www.mysql.com/downloads/mysql-3.23.html I've seen it some monts ago and I want to know if I could compiler the source with an gcc 3.0 compiler. These are the notes: Compiler Advisory:

Best Journaling file system?

Hi all. Which is the best journaling file system for mysql and innodb? Ext3, XFS or Reiserfs? Innodb needs a journaling file system or is better use ext2? Iago. - Before posting, please check:

Best Journaling file system?

Hi all. Which is the best journaling file system for mysql and innodb? Ext3 or Reiserfs? Innodb needs a journaling file system or is better use ext2? Iago. - Before posting, please check: http://www.mysql.com/manual.php

Type of column in query float instead of integer

Hi all. I execute the next query in Delphi 5.0 against MySQL and Delphi understand that the column of the query is of type ftFloat when it should be ftInteger (The field cantidad in the database is int). SELECT SUM(cantidad) AS Ventas FROM LALBARANCL WHERE fecha = 2002-05-01 AND fecha

RE: Multi-threaded MySQL?

The Makefile of mysql server says about linuxthreads: @${ECHO} WITH_LINUXTHREADS=yes Use the linuxthreads pthread library. @${ECHO} This is _NOT_ recommended for production @${ECHO} servers. Expect

Interbase vs MySQL

Hi all. I'm looking for a comparison between Interbase and MySQL. Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Help with InnoDB configuration

Hi. I need help with InnoDB configuration. - The machine is a 2 Pentium III 1000GHz, Memory 1G, 30GB SCSSI. - The operating system is FreeBSD 4.5. - The mysql server is 3.23.49 (using FreeBSD port). I read carefully section InnoDB in MySQL manual and set the innodb parameters as: #

innodb_buffer_pool_size too large

Hi all. I'm testing configuration of InnoDB tables in MySQL database server. The documentation of MySQL says that a good configuration for innodb_buffer_pool_size (the buffer) is 80% of physical memory if the computer is a dedicated MySQL server. I have 1GB of memory, then I set

Rows from STATUS differs from SELECT COUNT(*)

Hi all. I have two questions about InnoDB table type. 1) I execute command SHOW TABLE STATUS for a table and the value for column Rows is different from the result of SELECT COUNT(*) for that table. mysql SHOW TABLE STATUS LIKE 'ALBARANCL';

When is released mysql 3.23.50?

Hi all. When is released mysql 3.23.50? I received in the announce mail list an announce of a pre-release of mysql 3.23.50 one month ago. This release has some enhancements on InnoDB table type (specially the autoexten capability). The announcement mail says than this prerelease it will moved

How see InnoDB messages at startup mysql server?

Hi all. Anybody knows how to see innodb messages at startup or shutdown of mysql server? Is there any log of messages? Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the

Can I remove innobd binarie files?

Hi all. In the innodb directory I have these files (prototipo is the name of the computer): -rw-rw 1 mysql mysql 86 May 28 09:56 prototipo-bin.001 -rw-rw 1 mysql mysql 86 May 28 10:00 prototipo-bin.002 -rw-rw 1 mysql mysql 86 May 28 10:13

Error 1114 when import mysqldump in InnoDB table

Hi all. I import a mysqldump from MyISAM database in a new innodb database. It gives me an error saying that the table is full ERROR 1114 at line 3035: The table 'LALBARANPR' is full These are the values for the innodb variables in the my.cnf file: innodb_data_file_path =

Where is my.cnf in FreeBSD?

Hi. Anybody knows where is the my.cnf file (or equivalent) in FreeBSD? I've installed mysql-3.23.49 using the port in FreeBSD 4.5. The script than launches mysql (usr/local/etc/rc.d/mysql-server.sh) is very simple and don't look for any configuration file. The script is: -

See complete SQL sentence in mysqladmin process

Hi. When I use mysqladmin process I see the SQL sentence that is executed at that moment in the column Info. But I only see one part of the sentence if it is big. How could I see the complete SQL sentence being executed. I need it for see the queries. Iago.

Wich version of FreeBSD is better?

Hi all. I've read the manual of mysql and it says that for mysql is better use FreeBSD 3.x because the thread package is much more integrated (2.6.4.1 FreeBSD Notes). I have the doubt if this it's comentary refers to FreeBSD 3.x and next versions (FreeBSD 4.x) or it refers that FreeBSD 3.x is

Convert ISAM table to MyISAM

Hi all. I'm going to upgrade a mysql-3.22 Linux Pentium server to mysql-3.23.49a. Which is the best way to convert a database of ISAM table to MyISAM? mysqldump? How to do it? Iago. - Before posting, please check:

RE: Convert ISAM table to MyISAM

Thanks for your help Victoria. Iago. -Mensaje original- De: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Enviado el: jueves 14 de marzo de 2002 11:48 Para: [EMAIL PROTECTED] Asunto: Convert ISAM table to MyISAM Iago, Thursday, March 14, 2002, 10:17:10 AM, you wrote: IS I'm going

Files *.TMM and *.TMD

Hi. For what are files with extension .TMM and .TMD? Are residual files of mysqldump? I killed a mysqldump, and I see these files on the directory of the database but I don't know if they were before the mysqldump. Iago. -

Where is MySQL-DBI-perl-bin.rpm?

Hi. I've installed mysql-3.23.49a rpm packages from www.mysql.com on a Pentium RedHat 7.2 machine. When I try to install MySQL-bench-3.23.49a-1.i386.rpm package it depends in MySQL-DBI-perl-bin package. I failed to find MySQL-DBI-perl-bin package in www.mysql.com, where is it? and what version

3.23.42 version released?

Hi all. When is supposed the 3.23.42 mysql version released? Iago. __ mensaje enviado desde http://www.iespana.es emails (pop)-paginas web (espacio illimitado)-agenda-favoris (bookmarks)-foros

Any function to convert string to integer?

Hi all. Anybody knows a function or some way to convert a string to a integer? I've looked in the manual and I haven't seen anything. I need it to order a query by a column which contains numbers but the type of the column is varchar. I want to convert the values to integer before ordering the

Problems with my.ini in Windows NT

Hi all. I've installed mysql-max 3.23.41 in a Windows NT machine with Service Pack 6. I didn't installed mysql y the default directory (C:\mysql) and also changed the data directory to another directory y another drive (I moved the mysql and test directory of the data directory too). The

Optimizing a query with a new index

Hi all. I want to optimize a query that is executed often in the application we use at work. NOTE: Excuse me for using spanish names for the tables and the columns. In the database we have three tables for article: ARTICULOINFO (information of an article), LARTICULOINFO_IDIOMA (information of

Segmentation fault launching mysqld after compiling 3.23.33

Hi all. I've compiled mysql 3.23.33 with support for DB-Berkeley. After it when I try to launch mysqld it gave me a segmentation fault. Anybody has a similar problem? Note: I use Slackware 7.1 in a PC. Thanks in advance. Iago.