Re: Compare two tables

2005-08-26 Thread Alfredo Cole
El Viernes, 26 de Agosto de 2005 08:56, Gordon Bruce escribió: > If you have the 5.0.x version of MySQL then INFROMATION SCHEMA can give > you what you want. i.e. > > SELECT a.*, b.* > FROM INFORMATION_SCHEMA.COLUMNS AS a >INNER JOIN _SCHEMA.COLUMNS AS b >ON (a.column_name

Re: Compare two tables

2005-08-26 Thread Alfredo Cole
El Viernes, 26 de Agosto de 2005 08:16, Martijn Tonies escribió: > > You could check the table DDL. > > Or use a third party tool, like Database Workbench, that can do this for > you and even generator a change script. Check www.upscene.com > > With regards, > > Martijn Tonies Hmmm. No L

Compare two tables

2005-08-26 Thread Alfredo Cole
Hi: I need to compare the structure of two tables (fields, field types, field lengths, indices, etc.) to determine if they have the same schema, even if the fields may be in a different order. Is there a command in mysql that will do this? This will be used to determine if the tables are basica

Accessing a MySQL server from PocketPC

2005-04-30 Thread Alfredo Cole
Hi: I would like to use the DALP libraries (http://solutions.mysql.com/software/?item=145) to access a MySQL server 4.1.10 on Linux, from my PocketPC (iPAQ 3100 WM 2003 SE). I would appreciate it if somebody could provide me with a minimal sample that would just connect to a database so I can

Re: Develop an application

2005-03-14 Thread Alfredo Cole
El Lun 14 Mar 2005 14:59, Stephen Andert escribió: > Hi there, > > I searched the archives, but didn't find anything helpful. > > I am trying to build a fairly simple application for contact > management. I already have what I want built in MS Access, but I need > this application to run on Linux.

How to determine how many ibdata files are needed?

2005-03-11 Thread Alfredo Cole
Using MySQL 4.1.10, SuSE 8.2 Pro, reiser file system. Hi: I have been trying to locate a reference which would provide guidelines to determine if one ibdata should be used, or when to use several (two, three, etc.), but I can not seem to find anything in the manual. I have tried a single ibdat

Re: Switching to InnoDB turns out dissapointing

2005-03-02 Thread Alfredo Cole
El Mié 02 Mar 2005 16:04, escribió: > H, sounds like you are trying to mix OLTP and OLAP in one database > structure. That's a tough one. You want your tables designed to always > accept data in real time, but once the data is in, it doesn't change > and you want to query it. Relational vs. Dim

Re: Switching to InnoDB turns out dissapointing

2005-03-02 Thread Alfredo Cole
El Mié 02 Mar 2005 11:41, Brent Baisley escribió: > Coming in late on this thread. The testing on your laptop, are you just > running the one query or are you somehow emulating the typical load you > are trying to design for? As you said, you are trying to improve > concurrency, so you'll need to c

Re: Switching to InnoDB turns out dissapointing

2005-03-02 Thread Alfredo Cole
El Mar 01 Mar 2005 18:29, Heikki Tuuri escribió: > Alfredo, > I have changed my my.cnf to try and include the suggestions from the list, as much as possible and try to run my program again. It now reads like this: innodb_data_file_path = ibdata1:2G;ibdata2:2G:autoextend set-variable = innodb_buf

Re: Switching to InnoDB turns out dissapointing

2005-03-01 Thread Alfredo Cole
El Mar 01 Mar 2005 17:32, Gary Richardson escribió: > What have you actually done to 'tune' the server? How are you doing > the inserts? > > InnoDB uses transactions. If you are doing each row as a single > transaction (the default), it would probably take a lot longer. > > I assume you're doing yo

Switching to InnoDB turns out dissapointing

2005-03-01 Thread Alfredo Cole
Hi: I have switched from MyISAM tables to InnoDB, using MySQL 4.1.10 under SuSE 8.2. My application, an ERP system developed in-house, uses 70 tables, the largest one holding a little over one million rows. To assist when changing table structures, we developed a software that creates a new ta

mysql-query-browser and SuSE 8.2

2005-02-01 Thread Alfredo Cole
Hi: I have not been able to find a precompiled version of mysql-query-browser for SuSE 8.2, either at mysql web site, or using google. Compiling from source fails because of version differences in libxml-2.0, for instance. Anybody know of a URL where I can find a version that will work with SuS

Fwd: Re: MySQL 4.0 and concat

2004-10-11 Thread Alfredo Cole
Sorry. This should have gone back to the list. -- Mensaje reenviado -- Subject: Re: MySQL 4.0 and concat Date: Lun 11 Oct 2004 11:37 From: Alfredo Cole <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] El Lun 11 Oct 2004 08:35, escribió: > Have you considered NOT comparing

MySQL 4.0 and concat

2004-10-11 Thread Alfredo Cole
Hi: I have a problem in that all statements that include concat execute very slowly. For instance, if I have three fields in string format that represent a year, month and day, and want to issue a select like: select * from cxcmanpag where contact (year,month,day)<=stringYear+stringMonth+stri

temporary tables and replication

2004-09-01 Thread Alfredo Cole
Hi: I'm using MySQL 4.0, and have setup replication with one server and one slave, both running LM 9.1. My application creates a temporary table on the master, which is supposed to be deleted when the connection is closed. When that happens, replication stops with the following message: ERROR:

Re: Help, slave wont stay running!

2004-08-12 Thread Alfredo Cole
of the tables (MyISAM) had a corrupt index. After fixing it, everything was fine again. Regards. -- Alfredo Cole Grupo ACyC www.acyc.com - www.clshonduras.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Using MySQL and OpenMosix

2004-05-08 Thread Alfredo Cole
El Vie 07 May 2004 00:20, escribió: (...) > > My knowledge of OpenMosix is extremely limited. I've not heard of > anyone successfully using MySQL with OpenMosix for fail-over. That > doesn't mean it hasn't been done, but it'd be news to me. > > I assume you've also asked on the relevant OpenMosix

Re: Using MySQL and OpenMosix

2004-05-06 Thread Alfredo Cole
El Jue 06 May 2004 11:05, escribió: > On Thu, May 06, 2004 at 06:55:38AM -0600, Alfredo Cole wrote: > > Hi: > > > > I would like to add an identical server to the one I already have: Double > > Xeon processors, 4 Gb RAM and RAID 5 (Hardware) HD's. I would als

Using MySQL and OpenMosix

2004-05-06 Thread Alfredo Cole
Hi: I would like to add an identical server to the one I already have: Double Xeon processors, 4 Gb RAM and RAID 5 (Hardware) HD's. I would also like to cluster them using OpenMosix, but I'm told that MySQL 4.0 will not take advantage of the cluster. Is there a way to cluster MySQL so that quer

Re: MySQL 4 goes to sleep with table locks?

2004-02-07 Thread Alfredo Cole
El Sáb 07 Feb 2004 02:28, escribió: > Mr. Alfredo > Pls, will you give the complete structure as 'create query' of your > database? that will help us to solve your problem. > Pradap This is the structure of the table that holds the sequential numbers for various documents that need them: CRE

MySQL 4 goes to sleep with table locks?

2004-02-06 Thread Alfredo Cole
I am using Mandrake 9.1 and MySQL 4.0.11 from the LM CD's. In my application, I have a table that stores the sequential numbers of invoices prepared by several stores. Every time a salesman prepares an invoice for a customer, the system goes to this table, locks it with lock tables write, read

Too many connections

2004-01-16 Thread Alfredo Cole
I'm using mysql 3.23.55 and Linux Mandrake 9.1. I have about 60 users connecting to mysql using our accounting system. The users get some times a "Too many connections" error. I have set max_connections at 200, and the system opens only one connection per user at start up. Can somebody indicate

Re: select lock - How reliable?

2004-01-09 Thread Alfredo Cole
El Jue 08 Ene 2004 19:56, Paul DuBois escribió: > At 19:16 -0600 1/8/04, Alfredo Cole wrote: > >Hi: > > (...) > >The code I use is: > > > >select lock > > Sorry. It's select get_lock... > >get code > >add one to code > >write code

select lock - How reliable?

2004-01-08 Thread Alfredo Cole
Hi: I have an application that is used by around 40 users who need to access a table, obtain a sequential code, and write it back. I'm using MyISAM tables, and mysql 3.23 running under LM 9.0. A couple of times during the day, the users get the same code, and that is causing us many problems.

Re: Yet another server vendor inquiry

2003-09-08 Thread Alfredo Cole
El Lunes, 8 de Septiembre de 2003 09:01, Michael Bacarella escribió: > Names of vendors who are happy to provide servers > applicable for high load Linux/MySQL. Willing to > do custom configurations. > > Anyone? > > -- > Michael Bacarella24/7 phone: 1-646-641-8662 > Netgraft Corpor

Using MySQL with Mingw32

2002-03-14 Thread Alfredo Cole
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi: I'm using MySQL 3.2.3.39 for Win98. Has anybody been able to develop applications using Mingw32 compiler? If so, where can I get a version of the libmysqlclient library that will work with this compiler? Thank you. - -- Alfredo J. Cole http

select takes a very long time

2002-02-27 Thread Alfredo Cole
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi: Using MySQL version 3.23.39-Max, SuSE 7.2 I have two tables, cbtran with 46564 rows and cbma with 4184 rows. Both tables are indexed. The following query: select tr.*,ma.nombre from cbtran as tr, cbma as ma where tr.empresa='1' and tr.mes='1

Re: [mysql] Integridad Referencial

2001-11-26 Thread Alfredo Cole
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 El Lun 26 Nov 2001 00:42, escribiste: > Hola a todos. > > Bueno,ya sabemos todos o casi todos que MySQL no tiene integridad > referencial ni transacciones.Para mantener la integridad > referencial es necesario hacerlo a mano. Por ahora todo correcto.

Re: [mysql] DBF a MySql

2001-11-16 Thread Alfredo Cole
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 El Viernes 16 Noviembre 2001 08:23, escribiste: > Hola a todos. > Alguien tiene una herramienta para exportar tablas dbf a MySql? > > saludos > Gastón > Puedes usar dbf2mysql. Saludos. - -- Alfredo J. Cole Tegucigalpa, D. C., Honduras http://www.ac

Re: About huge numbers

2001-11-15 Thread Alfredo Cole
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 El Jueves 15 Noviembre 2001 13:15, escribiste: > Gyulay Gabor wrote: > > The problem is that I need to store numbers with lot more > > than 16 decimal digits - e.g. 1234567890123456789012345.12 > > [...] > > > > The reason is why we need this that the

Re: foxpro conversion

2001-11-14 Thread Alfredo Cole
El Miércoles 14 Noviembre 2001 09:00, escribiste: > Anybody have any tools/tips for converting a foxpro database to > mysql > > ___ > Sean O'Donnell Try dbf2mysql. It works for me. -- Alfredo J. Cole Tegucigalpa, D. C., Honduras http://www.acyc.com (Accounting Systems)

Re: DBF to MySQL Problem?

2001-08-21 Thread Alfredo Cole
El Martes 21 Agosto 2001 15:23, escribiste: > Hello, > > I have downloaded your dbf2mysql-1.14.tar file from the > MySQL.com site. I read through the README and still > cannot seem to get this to work. Here is the error I'm > getting: > > [info:admin/Desktop/dbf2mysql-1.14] root# make > /usr/bin/