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:ht
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
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 opti
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 until
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:
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.
--
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 i
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
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
Linux 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]
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 for
key_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 u
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]
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
>
) I 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
-
Bef
instanceNo = ;
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
which 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.
Ia
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:
/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 L
t.d/mysql.server start
/etc/init.d/mysql.server: @HOSTNAME@: command not found
prototipo mysql # Starting mysqld daemon with databases from
/usr/local/mysql/data
021120 12:52:05 mysqld ended
Iago Sineiro.
-
Before posting, plea
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-
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 [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:
> >
> > Re
; Hi Iago,
>
> but where can I get 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]>
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 orig
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 is
> -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
>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
>
&
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
libmysqlclien
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
libmysqlclien
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)
http://l
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 d
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 manual
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 couldn
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: Severa
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)
http://list
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 se
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:
http://www.mysql.com/manual
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
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 < "2002
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 pr
Hi all.
I use WinZeos 3.0.3 to access MySQL 3.23.49 with Delphi 5.0. I'm using
InnoDB tables and I want to use transactions.
I try to begin a transaction with BEGIN and SET AUTOCOMIT=0 but doesn't work
I can see the rows inserted in the database
with another connection.
What is the problem? The
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 arch
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:
# Uncommen
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';
+---++++-
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 innodb_buffer_poo
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 prototipo
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 manua
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
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 = ibdata1:2000M;ibdata2
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:
-
#!/b
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.
---
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 be
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.
-
B
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 t
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:
http://
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
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
--
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 q
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 server
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 a
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.
-
-Mensaje original-
De: Iago Sineiro [mailto:[EMAIL PROTECTED]]
Enviado el: jueves 1 de febrero de 2001 14:09
Para: mysql list
Asunto: Where is file mysql.sock?
Hi all.
I want to know where is file mysql.sock. I ask it because I change the
my.cnf configuration file placed in /etc
63 matches
Mail list logo
