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
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 Linux
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 =
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
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.
I
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
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 =
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
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.
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
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 your
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
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
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 dates
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:
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]
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
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
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 also like
to cluster them using OpenMosix
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:
CREATE
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 table
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
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
release lock
and select release_lock...
That looks like pseudo code
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.
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 Corporation
-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
-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
-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 there're
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)
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/cc -O2
30 matches
Mail list logo
