reports

2010-05-18 Thread Gallego Juan
place? - size of each database, data, logs, indexes. I kown how to obtain them - Memory used, CPU used. The main report that i want to make is the first one and i don't know how to obtain it. Thanks for your help. Juan Gallego. EL Ahorro de papel nos ayuda a proteger el

Re: MySQL versus PostgreSQL for GPS Data

2009-03-20 Thread Juan Pereira
d to deliver GPS data in real time; we have customers that sometimes want to track their trucks in real time, that's why we think the worst scenario could be one position per second. Juan Karlos 2009/3/18 Jim Ginn > Juan: > > We've had success with spatial indexes and mysql on

MySQL versus PostgreSQL for GPS Data

2009-03-18 Thread Juan Pereira
stion is: Which DBMS do you think is the best for this kind of application? PostgreSQL or MySQL? Thanks in advance Juan Karlos.

Re: mysql x64en server 64 bits

2008-07-03 Thread Juan Eduardo Moreno
l-5.0.51b-winx64.msi/from/ftp://mirror.x10.com/mysql/> Install the software. Regards, Juan On Thu, Jul 3, 2008 at 5:10 PM, Jaime Fuentes <[EMAIL PROTECTED]> wrote: > Hi every body: > I've a Server with Intel quad Core processor + Wndows 2003 server R2 64 > bits, I'm

Re: mySQL support required

2008-06-09 Thread Juan Eduardo Moreno
Hi Kishore, Please see the following approach : http://dschneller.blogspot.com/2007/09/error-1033-hy000-on-innodb.html Regards, Juan On Mon, Jun 9, 2008 at 8:26 AM, <[EMAIL PROTECTED]> wrote: > > > > Hi , > > > > We are in Urgent need of support to r

Re: purge binary logs on master

2008-05-17 Thread Juan Eduardo Moreno
Ananda, Use, PURGE MASTER LOGS TO 'name of the last binary that you want leave in your disk'; Regards On Sat, May 17, 2008 at 8:56 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi All, > I using this command to purge binary logs on master, but i dont see the > binary logs getting deleted. These

Re: changing 'max_allowed_packet'

2008-05-16 Thread Juan Eduardo Moreno
Hi, In your my.cnf put this : [mysqldump] quick max_allowed_packet = 32M Regards, Juan On Fri, May 16, 2008 at 6:55 PM, Sigfrid <[EMAIL PROTECTED]> wrote: > > Hello, I have a simple question: how can I change the value of > max_allowed_packet ? (I use server version: 5.0.51a

Re: master - slave replication - slave not updating

2008-05-16 Thread Juan Eduardo Moreno
, Juan On Fri, May 16, 2008 at 10:09 AM, Tom Brown <[EMAIL PROTECTED]> wrote: > > >> Yes thanks - i have done that and restarted the slave and _some_ tables >> now appear to update but others dont >> >> eg >> >> master: >> mysql> select c

Re: master - slave replication - slave not updating

2008-05-16 Thread Juan Eduardo Moreno
Hi Tom, The error 1062 you could skipped in the slave modifying your my.cnf ( slave side) using : slave-skip-errors=1062 This error on duplicated records, normally is problem in binarylogs transfer data. But, anyway, please confer that the data exist in the slave. Regards, Juan On Fri

Re: MySQL (mysql-5.0.54)

2008-05-06 Thread Juan Eduardo Moreno
Hi, Please, you must set up the log-bin for enable replication : Example ( in your my.cnf ) --log-bin=mysqld-bin The mysql signal 4 error appear when you install erroneus your environment. I recommed reinstall your MySQL in your OS. Regards, Juan On 5/6/08, Kaushal Shriyan <[EMAIL PROTEC

Re: innodb disabled

2008-05-06 Thread Juan Eduardo Moreno
Hi, Can you send the error log file of mysql server in your machine?. Regards, Juan On 5/6/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Hi Juan, > > I have verified directory permissions, its shown below. > > linux76:~# ls -l /data/mysql/ > total

Re: innodb disabled

2008-05-06 Thread Juan Eduardo Moreno
. If you don´t understand nothing in the error log file, please send this errors to the list. Regards, Juan On Tue, May 6, 2008 at 5:27 AM, Krishna Chandra Prajapati < [EMAIL PROTECTED]> wrote: > Hi all, > > I have change the data directory from /var/lib/mysql to /data/mysql

Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)

2008-04-28 Thread Juan Eduardo Moreno
Hi, This error occur when slave servers could incorrectly interpret an out-of-memory error from the master and reconnect using the wrong binary log position. This was fix in 5.0.48 version. Please, try to update your version ( from 5.0.45) of mysql and try again. regards, Juan On 4/28/08

Re: Performance problem MySQL 4.0.20

2007-07-03 Thread Juan Eduardo Moreno
Please, mount your disks using "forcedirectio". Regards, Juan On 7/3/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello, I've a performance problem with our database: Some select statements take about 20 seconds. The same statements on an equal testmachine ta

Re: Alternative command of SET GLOBAL SQL_SLAVE_SKIP_COUNTER

2007-06-08 Thread Juan Eduardo Moreno
Hi, We have some options in order to skip type of errors in the replication process. Please, identify your number error in slave machine and put into my.cnf "slave_skip_errors= 1087" for example, where 1087 is a recurrent error for your replication architecture. Regards, Juan

Re: only select privilege

2007-06-08 Thread Juan Eduardo Moreno
Hi, Try to do that : GRANT SELECT ON abc.* to 'qa'@'%' identified by 'qa'; flush privileges; Explain : The user qa have access of all tables of user abc. In this command, only SELECT is possible is you connect using user qa. Regards, Juan On 6/8/07, Ananda K

Re: error after system setup/replication

2007-06-05 Thread Juan Eduardo Moreno
Keith, When you copied the database, you need recreate de logfiles and the sequences. Then, startup the database. 1) clean your actually log files ( backup to another side) 2) When the database startup automatically recreate the log files and sequence. Send feedback about it. Regards, Juan On

Re: Problem with compex query

2007-05-22 Thread Juan Eduardo Moreno
Patricio, 2) What you meant with " indexes for the query"? A: Create some indexes for a query in order to improve the performance. Regards, Juan Eduardo On 5/22/07, Patricio A. Bruna <[EMAIL PROTECTED]> wrote: Juan Eduardo, 1) The versions are the same. 2) What you mean

Re: Problem with compex query

2007-05-22 Thread Juan Eduardo Moreno
) 1 records. Ask to programers for provide some cursor or something like that. Regards, Juan On 5/22/07, Patricio A. Bruna <[EMAIL PROTECTED] > wrote: Juan Eduardo, Great to hear about you :) One thing you must know is that i can run this query from a mysql client, without the inser

Re: Problem with compex query

2007-05-22 Thread Juan Eduardo Moreno
SESSION SQL_MAX_JOIN_SIZE=DEFAULT; Run the query; 2) Send your results and explain of query ( explain select ) Regards, Juan On 5/22/07, Patricio A. Bruna <[EMAIL PROTECTED]> wrote: Friends, im having troubles with the following query: ---

Re: help on loading the world.sql(script and data) onto world database

2007-05-09 Thread Juan Eduardo Moreno
Kebede, Send some example of WORLD contains. Regards Juan On 5/9/07, kebede teferi <[EMAIL PROTECTED]> wrote: hi, it's my first time trying my hand in inputting data in batches to mysql database and it drives me crazy, please help. *I've created the WORLD database.

Re: expire_logs_days

2007-05-02 Thread Juan Eduardo Moreno
Hi, I'm experience using expire_log_days and don't work. I set this parameters in the CNF and when the time of ( for example 5 days) is in, don't delete anything. On my expirience, this parameters don't work ( 5.0.27). Regards Juan On 5/2/07, Ofer Inbar <[EMAIL PRO

Re: MySQL 64 bits

2007-04-10 Thread Juan Eduardo Moreno
, please, send a email or call me : 21 86391874 Regards, Juan On 4/10/07, Dyego Souza Dantas Leal <[EMAIL PROTECTED]> wrote: I want to use Debian 4.0 x64 with MySQL 64 bits... (5.0 version) and InnoDB tables is it safe ? is it stable ? is it ready for enterprise production ?

Re: Database creation question

2007-03-21 Thread Juan Eduardo Moreno
In your conf file, please add : Previously create a temp directory [mysqld] tmpdir=/usr/local/mysql/temp Regards, Juan On 3/20/07, Lopez, Denise <[EMAIL PROTECTED]> wrote: That still didn't work. I think I just need to restart the mysql service. Denise Lopez UCLA Center

Re: Database creation question

2007-03-20 Thread Juan Eduardo Moreno
Denise, Hola!. 1) Connect to the system like root user 2) $ chown -R mysql:mysql /usr/local/mysql/ 3) In oder to create user use : mysql> GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@"%" IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION; Regards, J

Re: load sharing

2007-02-26 Thread Juan Eduardo Moreno
me app. server). DATABASE SERVERS MySQL and multimaster replication, please see below http://www.onlamp.com/lpt/a/6549 Technology : for OS try to use Linux, for Hearbeat try to use UltraMonkey ( www.ultramonkey.org) for Balancing try to use LVS ( Linux). I hope this help. Regards. Juan E

Re: Qustion

2007-02-25 Thread Juan Eduardo Moreno
What a fu...? On 2/24/07, nessah arezki <[EMAIL PROTECTED]> wrote: Bonjour ; Je suis un étudiant en fin de cycle. Dans le cadre de mon projet de fin d'étude, je devais transférer une base de données sous Access à MySQL. J'ai effectué le transfère par Excel Mais j'ai t

Re: backup stratergy

2007-02-23 Thread Juan Eduardo Moreno
Ananda, For Innodb the best is Innodb Hot Backup ( www.innodb.com (US$) ) For MyISAM you can use a simple backup ( copy/paste) of your files. Also, you can do snapshots using mysqldump. Also, you can use Zmanda ( www.zmanda.com). Regards, Juan Eduardo On 2/23/07, Ananda Kumar <[EM

Re: Abnormal mySQL service behavior / 5.0.26

2007-02-16 Thread Juan Eduardo Moreno
On 2/16/07, Mark Papadakis <[EMAIL PROTECTED]> wrote: Good day, R: are you using MyISAM or InnoDB tables? For the past 2 weeks, we have been dealing with some rather strange problems. While nothing changed in terms of the mySQL server or clients configuration ( including the options provid

Re: How can I detect if MySql is already installed?

2007-02-15 Thread Juan Eduardo Moreno
Linux : $ rpm -qa |grep -i mysql Regards, Juan On 2/14/07, Zsolt Csillag <[EMAIL PROTECTED]> wrote: Hello, I would like to create a setup program for my demo version that uses MySql database. I need to detect if the target computer has already got the MySql installed because I don&

Re: 2 ways replication

2007-02-13 Thread Juan Eduardo Moreno
Dear all, We can view interesting tipic into : http://www.onlamp.com/lpt/a/6549 Regards, Juan Eduardo On 2/12/07, Atle Veka <[EMAIL PROTECTED]> wrote: 2 way replication, also referred to as dual master replication, has been available for quite some time. However implementation

Re: MySQL log_slow_queries Error

2007-02-11 Thread Juan Eduardo Moreno
Regards, Juan On 2/11/07, Pratchaya Chatuphian <[EMAIL PROTECTED]> wrote: Hi , Everyone :: I need your help. I have problem about mysql. it about log_slow_queries this is my.cnf file [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords=1 #skip

Re: Error starting service

2007-01-31 Thread Juan Eduardo Moreno
$ chown -R mysql:mysql yourdirectoryofmysql On 1/31/07, WebIT <[EMAIL PROTECTED]> wrote: Sorry, probably a really simple thing, but when I try and start mysqld it fails. [EMAIL PROTECTED] yum.repos.d]# /sbin/service mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MyS

Re: Strange InnoDB Deadlock Behavior

2007-01-18 Thread Juan Eduardo Moreno
Jason, I assume that your principal databases are INNODB databases. Regards On 1/17/07, Jason J. W. Williams <[EMAIL PROTECTED]> wrote: Hi Juan, Just wanted to touchbase and see if you had any suggestions based on the my.cnf and machine config. Thank you in advance. Best Regards,

Re: Dual Hardisk

2007-01-12 Thread Juan Eduardo Moreno
, Juan On 1/11/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi, I have a database named X on a hardisk, and the hardisk can not store new record because it has no space anymore. Can I just add a new hardisk and ask MySQL to store new record for database X to the new hardisk? Please sh

Re: InnoDB vs MyISAM

2007-01-04 Thread Juan Eduardo Moreno
) of a lot of sales man ( 1000). please see below http://en.wikipedia.org/wiki/ACID Bye, Juan On 1/4/07, Octavian Rasnita <[EMAIL PROTECTED]> wrote: > >> And is InnoDB recommended now? > It depends.. :) Depends on... what? I mean, if I don't need transactions, is t

Fwd: innodb_log_files_in_group

2006-12-27 Thread Juan Eduardo Moreno
FYI -- Forwarded message -- From: Juan Eduardo Moreno <[EMAIL PROTECTED]> Date: Dec 27, 2006 9:30 PM Subject: Fwd: innodb_log_files_in_group To: [EMAIL PROTECTED] Dave, The default (and recommended) is 2. The log files, save the trasactions into file in circular order

Re: socket error

2006-12-21 Thread Juan Eduardo Moreno
Waleed, First, please try to upgrade your mysql. Try to review in your my.cnf if your configuration socket appear two twice ( in two lines ). Verify in your environment if your mysql is running using "ps -aux | grep -i mysql". $ service mysql stop $ ps -aux | grep -i mysql $ (if still running

Re: ERROR 1114

2006-12-20 Thread Juan Eduardo Moreno
Raj, Normally, if you have problem with your configurations, I suggest recreate your databases : 1) backup all your database using mysqldump *$ mysqldump --opt --user=root --password= --databases db1 db2 db3 db4 > /your/directory/of backups/backup.databases.dmp* ** ** 2) delete your databa

Re: innodb_buffer_pool_size. How to setup with more than 5G ?

2006-12-18 Thread Juan Eduardo Moreno
innodb_log_files_in_group. For example, if your set innodb_log_files_in_group=2 ( ib_log_file001, ib_log_file002 are created) the total size must not exceed 4G. Regards, Juan On 12/18/06, Remigiusz Soko?owski <[EMAIL PROTECTED]> wrote: Uz.ytkownik Juan Eduardo Moreno napisa?: > Hi everyone!! > > &g

innodb_buffer_pool_size. How to setup with more than 5G ?

2006-12-12 Thread Juan Eduardo Moreno
something for innodb/mysql?. Today we only config 5G in the innodb_buffer_pool_size. Thank you, Juan

Milliseconds of now()

2006-12-04 Thread Juan Eduardo Moreno
Hello!, How can obtain the miliseconds of function of NOW()?? In the example we can obtain only 0 ( zero)The result is zero. *SELECT MICROSECOND(now());* Thank you, Juan

Re: Again Doubt on Query pls help (Doubt not cleared)

2006-01-28 Thread Juan Pedro Reyes Molina
I think this is what you want to do: SELECT t1.Division,t1.year, t1.units this_year_units, t2.units last_year_units, case when t2.units is null then t1.units else (t1.units-t2.units) end as Difference_Units FROM `narra_table` t1 left join narra_table t2 on (t1.Division=t2.Division) and (t1.Ye

Merge/Combine two server

2005-12-12 Thread Juan Jose Sanchez Mesa
Hi! We have 2 MySQL servers and now we have purchased one more powerfull server and want to combine the databases from the two older server into the new server. Can we just make dumps from older server and make restores into new servers ? What happen with databases users ? Can be dumped the dat

Re: What is a schema?

2005-08-03 Thread Juan Pedro Reyes Molina
as far as I know a schema is a description of a database. [EMAIL PROTECTED] wrote: What is a schema? How is different from a database? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Sleeping Processes Timeout?

2005-07-28 Thread Juan Pedro Reyes Molina
I had a similar problem while connecting to mysql 4.0.21 throuhg MyODBC 3.51.11. If so you must upgrade mysql to 4.1 or downgrade MyOdbc to 3.51.06 Jason Williard wrote: Hello, Today, I started experiencing some issues on our website with max connections exceeded errors. In looking into th

Re: Fw: table export problem

2005-07-19 Thread Juan Pedro Reyes Molina
I have been able to create your table in my mysql 4.1.12 I think your remote server is in mysql 4.0 series [EMAIL PROTECTED] wrote: - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, July 19, 2005 10:08 PM Subject: table export problem Hi all, I

Re: problem with LEFT JOIN

2005-07-11 Thread Juan Pablo Espino
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

2005-07-10 Thread Juan Pablo Espino
B-RAM White Box Linux 3 MySQL v4.0 Something wrong with the query?, another idea?, thanks in advance for any suggestion, regards Juan P. Espino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my-medium.cnf file not created

2005-07-05 Thread Juan Pedro Reyes Molina
search for "my-medium.ini" [EMAIL PROTECTED] wrote: Dear Sir or Madam: After installing mysql, the template files, my-small.cnf, my-medium.cnf or my-large.cnf, were not created. I uninstalled and then reinstalled mysql, but they were still not created. I am using mysql-4.0.20a-win on Windo

[Fwd: Re: ORDER by Question]

2005-06-26 Thread Juan Pedro Reyes Molina
You can use: SELECT .. order by case substring(Name,1,4) when 'The ' then substring(Name,5,800) else Name end Un saludo Juan Pedro Jack Lauman wrote: I'm using a query similar to the following to get an ordered list. SELECT ORDER BY Subscriber ASC, Name ASC;

Re: ORDER by Question

2005-06-26 Thread Juan Pedro Reyes Molina
You can use: SELECT .. order by case substring(Name,1,4) when 'The ' then substring(Name,5,800) else Name end Un saludo Juan Pedro Jack Lauman wrote: I'm using a query similar to the following to get an ordered list. SELECT ORDER BY Subscriber ASC, Name ASC; How d

Re: starting mysql 4.1.12 on Ubuntu Linux

2005-06-25 Thread Juan Pedro Reyes Molina
: - Original Message - From: "Juan Pedro Reyes Molina" <[EMAIL PROTECTED]> To: "Hassan Schroeder" <[EMAIL PROTECTED]> Cc: "mysql general list" Sent: Saturday, June 25, 2005 2:08 PM Subject: Re: starting mysql 4.1.12 on Ubuntu Linux hello, Hassan which

Re: starting mysql 4.1.12 on Ubuntu Linux

2005-06-25 Thread Juan Pedro Reyes Molina
ks, Hassan Hassan Schroeder wrote: Juan Pedro Reyes Molina wrote: which mysql gives me /usr/bin/mysql. echo $PATH shows me that /usr/bin is the fourth try. I thougth this was windows like, where PATH is only used if program is not found in active directory. Executables in the 'curren

Re: starting mysql 4.1.12 on Ubuntu Linux

2005-06-25 Thread Juan Pedro Reyes Molina
buntu distro. I have tried cp /etc/init.d/mysql /etc/init.d/mysqltmp but issuing /etc/init.d/mysqltmp gives me "bash: mysqltmp: command not found" Hassan Schroeder wrote: Juan Pedro Reyes Molina wrote: With my sql stopped I go to console as root and write: cd /etc/init.d mysql s

starting mysql 4.1.12 on Ubuntu Linux

2005-06-25 Thread Juan Pedro Reyes Molina
I'm starting to play with linux. Till now I have over my shoulders three days experience with it :-) I have been able to install and successfully run mysql 4.1.12 but something it's happening I cannot understand (no surprise) With my sql stopped I go to console as root and write: cd /etc/ini

Re: How to summarize a table?

2005-06-19 Thread Juan Pedro Reyes Molina
chine traslations are far from perfect but it can be understood. Un saludo Juan Pedro [EMAIL PROTECTED] wrote: Juan, i found you a link explaining the access and sqlserver ansi inner joins in update. it's in german, but can be read (i don't speak german :o)) : http://www.sql-und-xml.

Re: How to summarize a table?

2005-06-18 Thread Juan Pedro Reyes Molina
o know if there is a pure sql solution because I don't like to have more temp tables that strictly needed. Thanks for your time. Time is our most valuable asset! [EMAIL PROTECTED] wrote: Hu Juan, see my answer above "Re: Subselect in an Update query". You can't update and

How to summarize a table?

2005-06-18 Thread Juan Pedro Reyes Molina
I'm running mysql 4.1.7. For the sake of this message I have created this tables: CREATE TABLE `log` ( `ID` int(11) NOT NULL auto_increment, `Cod_P` varchar(5) NOT NULL default '', `Import` double NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM; CREATE TABLE `master` ( `Cod_P` varch

What is the difference between 4.1 and MAXDB 7.5?

2005-01-03 Thread Juan M . Quiroz
Could some one enlighten me about the differences between these 2 mysql products? Thanks Juan M. Quiroz Oregon Department of Agriculture Systems Analyst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Windows specific characters

2004-09-15 Thread Juan Alvarado
Hello: I have some data in a spreadsheet that I need to load into a database. The data in the excel spreadsheet apparently contains windows specific characters. Whenever I import the data into my database, those special characters remain and since my database runs on an unix platform, I am get

RE: problem installing without the server

2004-09-13 Thread Juan Fernandez
I see 3 packges: Mod_auto_mysql-20030510-3.i386.rpm Mysql-3.23.58-4.i386.rpm Php-mysql. Which one to pick Thanks !! -Original Message- From: Alex Greg [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 4:06 PM To: Juan Fernandez Cc: '[EMAIL PROTECTED]' S

Problem with imported data from mysqldump file

2004-09-13 Thread Juan Alvarado
I am generating a backup of a database using mysqldump and using that dumped file to repopulate another database. The dump and import process work just fine, BUT I am having some problems in my application with some enconding issues. For example, one of the rows that mysqldump outputs is the

problem installing without the server

2004-09-13 Thread Juan Fernandez
Hi !! I am trying to install mysql without the server on fedora: when I issue the command : [EMAIL PROTECTED] snort-2.2.0]# cd ../mysql-3.23.52 [EMAIL PROTECTED] mysql-3.23.52]# ./configure --without-server --prefix=/usr/local/mysql everything is fine but after I issue the command "make I recei

MySQL in vxWorks ?

2004-04-01 Thread Juan Romano
ciate any words of wisdom on the subject. Thanks, Juan//

Update question

2004-02-28 Thread Juan E Suris
h the same row and I would lose some data. Am I correct? Thanks, Juan

If Exists update else insert

2004-02-18 Thread Juan E Suris
e in the update and select: replace into table set user='someuser', cnt=(select cnt+1 from table where user='someuser') Can this be done (in 1 query, of course)? Thanks, Juan E

mysqld corruption

2004-02-14 Thread Juan E Suris
/sbin/mysqld after reboot: $ md5sum /usr/sbin/mysqld 81089d38ef2753c831e929c53f7a4b58 /usr/sbin/mysqld do I have a bad hard drive or I am missing something here? Any help would be greatly appreciated. Thanks, Juan E.

Websphere and mysql

2004-01-25 Thread Juan Alvarado
Hello: I have been trying to configure websphere 5 to use mysql. I have set up the datasource using the mysql driver and whenever I test the connection from the websphere admin console, I get the following: Test Connection failed for datasource Securance Datasource on server server1 at node linux w

Problem with websphere configuration

2004-01-24 Thread Juan Alvarado
Hello: I have been trying to configure websphere 5 to use mysql. I have set up the datasource using the mysql driver and whenever I test the connection from the websphere admin console, I get the following: Test Connection failed for datasource Securance Datasource on server server1 at node linu

getting size of query rows

2004-01-24 Thread Juan Nin
OBs... So, is there any other way of getting this sizes?? I've Googled and found about getting table sizes with "SHOW TABLE STATUS", but nothing on what I want... Thanks in advance, Juan -- Open WebMail Project (http://openwebmail.org) -- MySQL General Mailing List For li

Re: How do I have 3.23.54 and 4.0.15 running at the same time?

2003-10-29 Thread Juan M. Quiroz
a different user. I went to the basedir/bin. I cannot find a switch for datadir. Thanks Juan "Egor Egorov on 10/22/03 at 6:21 PM +0300 wrote about: Re: How do I have 3.23.54 and 4.0.15 running at the sam" >"Juan M. Quiroz" <[EMAIL PROTECTED]> wrote: >> Hi, >

How do I have 3.23.54 and 4.0.15 running at the same time?

2003-10-21 Thread Juan M. Quiroz
Hi, That's basically my question. I want to be able to run the 2 releases on the same OSX 10.2.8 machine. Is there a way? Thanks Juan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Setting the timezone

2003-10-13 Thread Juan Antonio Ruiz Zwollo
Hi: Do you use version 4 or 3? I thought that I need to use "set-variable = timezone = CST" for it to work under MySQL 3. Also, does anybody know if "CST" is recognized? Or do I have to use GMT-6 or something like that? Thanks for your time and help. King reg

Setting the timezone

2003-10-13 Thread Juan Antonio Ruiz Zwollo
t then the timezone stays at MDT. Thanks for your time. Kind regards, Juan Antonio Ruiz Zwollo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unicode(ucs2) setup question

2003-06-11 Thread Juan Sebastian Alarcon
In wich version of Windows do you have compiled mysql? I have Win XP and I need a mysql version that works with UTF-I. I am waiting for the development of MySQL 4.1 beta, but it is too late for me. It is posible if you publish your compiled version? (I suppose that is for windows). Or if you send

error message

2003-06-06 Thread Juan Carlos Escobar Gzz
ex 4 in What is my error? Thanks, *** Ing. Juan Carlos Escobar González Jefe de la Unidad de Informática Secretaría de Desarrollo Económico Gobierno del Estado de Chiapas Tel. 01 962 6 28 94 50 ext. 3300 ***

Fw: Mysql and postfix

2003-04-01 Thread Juan Nin
> From: "Arthur Lessard" <[EMAIL PROTECTED]> > > > Thanks, Juan, and Patrik as well, this helped > > immensely. I can get postfix working, and it seems to > > read the mysql tables on startup, which it wouldn't do > > before. great

Re: Mysql and postfix

2003-04-01 Thread Juan Nin
an see the whole list of options # Tuomo Soini's http://tis.foobar.fi/software/?postfix # rpm -ivh postfix-xxx.src.rpm # cd /usr/src/redhat/SPECS # rpmbuild -ba postfix.spec --with mysql the RPM will be left on /usr/src/redhat/RPMS/i386/ In his site you can see the whole list of op

MySQL vs. PostgreSQL recent article?

2003-03-31 Thread Juan Nin
Hi, Does anybody know of any MySQL vs. PostgreSQL recent article? I mean, that it covers MySQL 4.x and PostgreSQL 7.3.x Thanks in advance, Juan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Re: auto generated column data: is it possible?

2003-03-21 Thread Juan Nin
find an operation for Dates that could do that... but now I know UNIX_TIMESTAMP() that suites perfect for what I want. I was about to do the calcs in my Perl script, but you're right, I can easily do it that way in the

auto generated column data: is it possible?

2003-03-20 Thread Juan Nin
column1 and column2. If I insert a row that contains "2" for column1 and "3" for column2, the column3 should be automatically filled with "5". I know that in other DBMs this can be done with triggers, but MySQL still doesn't support them.. Can it be done in

Re: Show record index, limit

2003-02-28 Thread Juan Carlos
ROTECTED]> To: "Juan Carlos" <[EMAIL PROTECTED]> Cc: "MysqlList" <[EMAIL PROTECTED]> Sent: Friday, February 28, 2003 4:03 PM Subject: Re: Show record index, limit > Juan Carlos wrote: > > >Hello Everybody > >I using MySQL and I want to sh

Re: Re: SELECT DISTINCT question

2003-02-28 Thread Juan Nin
:) SELECT queries do not alter your rows, you can only do that with update or delete regards, Juan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (

Show record index, limit

2003-02-28 Thread Juan Carlos
Hello Everybody I using MySQL and I want to show the record id for the SELECT I know you can do SELECT clientCode, clientName limit 20, 3 2030John 2040Charles 2050Mery The limit show from record 21 (record id = 20) because the first start in 0 I want to show that record i

Re: performance issue of innodb

2003-02-28 Thread Juan Nin
u're using the count() function at least in Oracle it's like that... In Oracle you can see how the query is done using EXPLAIN I know MySQL has it's own EXPLAIN, but haven't tested it yet... regards, Juan

Show number of records 1, 2, 3...

2003-02-28 Thread Juan Carlos
Hi I want to make a Simple Select using MySQL that show me number of rows, or make a count and show something like this: record#ClientCodeClientName 1 1020John 2 1032 Mary 3

MySQL 4.1 status / yahoogroups kind project

2003-02-26 Thread Juan Nin
that MySQL is better for light web applications, and smaller databases where quickness is needed... but I've heared that the new MySQL 4.x branch changes this a bit, and that from MySQL 4.1 there are nested queries support, etc any re

MySQL 4.0 and UNICODE

2003-02-26 Thread Juan
Does the last binary version available of MySQL (4.0xx) support UNICODE? Thanks. ___ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es

MySQL and EUC_JP (japanese character set)

2003-02-26 Thread Juan
Do MySQL 3.23 bynary distribution of Windows XP support EUC_JP character set? I have tried to change it with the --default-character-set but it don´t work. (It works ok with SJIS or UJIS). How I configure MySQL to work with EUC_JP (the same charset as PHP)? Thanks.

CPUUsage

2003-02-25 Thread Juan Enrique Gómez
(current version) to 4.x version will help?, any advice will help. Thanks! -- -- |Juan Enrique Gomez Perez | CEO & CTO |Metropoli2000 Networks, S.L. | Phone: +34 914250023 Fax: +34 914250136 | email: [EMAIL PROTE

Problem with MySQL, MyODBC, Access 2002 and Japanese.

2003-02-25 Thread Juan
Help!, I am developing a multilingual site in English, Spanish and Japanese. I am using MySQL with PHP in the server side, and Access 2002 in the local side, using MyODBC to communicate MySQL with Access 2002. MySQL and PHP works toguether ok in Japanese, English and Spanish (using EUC_JP in both

Advice on query

2003-02-20 Thread Juan Enrique Gómez
ng it previously to int), but we're sure there is a more optimum way to do this. Thanks in advance for your help. Best, -- -- |Juan Enrique Gomez Perez | CEO & CTO |Metropoli2000 Networks, S.L. | Phone: +34 914250023 Fax:

problem mirroring

2003-02-20 Thread Juan Pablo Abuyeres
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

MySQL for QNX

2003-01-20 Thread CRUZ M. Juan MAN-TAMSA
sql > Do you have any idea how the release for qnx will be ready? > > Juan Cruz > Veracruz, Ver. > Mexico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

Re: Limitation of SQL when making LEFT JOIN

2002-11-21 Thread Juan C. P. Garrido
Keith C. Ivey wrote: On 21 Nov 2002, at 8:46, Juan C. P. Garrido wrote: When I make the LEFT JOIN between the two tables, it takes a long time, and it seems that the machine is crashed , because everything I try to make in the machine is extremely slow, so I have to reset it manually

Limitation of SQL when making LEFT JOIN

2002-11-21 Thread Juan C. P. Garrido
with a certain number of records or is there a different way to solve this problem in order to increase the speed of the query ? Thanks, Juan - Before posting, please check: http://www.mysql.com/manual.php (the manual

Configuring Tomcat JNDI Connection to MySQL

2002-09-21 Thread Juan Iván Carrasco Rodríguez
i`ve tried to solve this problem, and i think i did it! First of all: I've tried with: Tomcat 4.0.4 Mysql 3.23.49 You should have in your application's lib these libraries: - commons-collections.jar - commons-dbcp.jar - commons-pool.jar (You can find these jar in www.apache.org) - mysql-uncomp

RE: Demande de confirmation d'inscription à mysql-france

2002-04-20 Thread Juan Maunel
- Original Message - From: Yahoo! Groupes <[EMAIL PROTECTED] r> To: <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 10:56 PM Subject: Demande de confirmation d'inscription à mysql-france Bonjour, Nous avons reçu votre demande d'inscription au groupe mysql-france sur Yahoo! Groupes, l

Lasso to mysql

2002-04-10 Thread Juan M. Quiroz
I'm trying to connect to mysql using lasso but no success. The message I get is that there are no databases found. Our environment is mysql 3.23.49 on osx server 10.1.3 and lasso 5 What do I need to do to connect to mysql from lasso? Also, how do I start a deamon at boot? Thanks J

  1   2   >