Is Connector/C++ dead?

Hi all, Looking at the changelog, Connector/C++ hasn't been touched in quite a while. Is this because the product is so incredibly solid or because of lack of interest? Regards, Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Using MySQL with a custom-built server

Hi all, I've just been contacted by a potential client that wants me to build a product for them of the following type: 1. Client workstations will have an applications that takes some data and sends it to a server we administer. 2. The server we take care of will hold on to the data and give it

dbf file import problem in MySQL

Dear Friends, I want to import the data from dbf file. Please tell me how to do this. I am using MySQL++ for accessing the MySQL. and writing the application in C++. Waiting your reply. With best regards, Suresh S Satpute -- MySQL General Mailing List For list archives: http://list

Inquery from Varian Medical Systems

To Whom It May Concern: I am Robert and work for Varian Medical Systems. MySQl is the backend of our Intranet, VMSNet. Our current environment is: The web server and MySQL reside in one hardware server- US server. If this hardware server fails, we switch the users to our European web server. B

Re: Strange issue with UPDATE.

On Fri, Nov 21, 2003 at 11:26:57PM +0200, [EMAIL PROTECTED] wrote: > My table is: > CREATE TABLE `some` ( > `id` bigint(20) NOT NULL auto_increment, > `name` varchar(100) NOT NULL default '', > `start_date` timestamp(14) NOT NULL, > `end_date` timestamp(14) NOT NULL, [snip] > And follow qu

Tru64_Unix

First time poster so let me know if there is anymore information you need. We have been have a problem with our database ever since we upgraded it from 3.23 to 4.0.15a. IT is being run on a Tru64 Unix box with several gigs of memory. Every 2 weeks roughly the database seems to slow down

Strange issue with UPDATE.

Hi all, Thanks for the help. However I have additional issue with UPDATE statement :-( I can understand what's wrong with my table/query going on, so could some one explain me why UPDATE statemen do that strange thing...? My table is: CREATE TABLE `some` ( `id` bigint(20) NOT NULL auto_increme

Variation of SELECT DISTINCT

I've got a query that looks like this.. "SELECT Foot_Id, Dir_Uni, Part_Suffix, Part_Number, Appln_No, Description, Product_Ref, Vehicle_Ref, Part_Prompt, Part_Description, Foot_Id, Qualifier, Years FROM application_parts WHERE (('$id' = Appln_No) and

Re: Migration to INODB?

Run all your tables thru this. Save the script as xinno_convert. As in xinno_convert < foo.sql | mysql Suposedly you can also alter a table to innodb. But that never worked for me it just looped using cpu for days. So I made this script which worked fine. Other than converting implicit lockin

RE: DB design question - shell scripting...

At 10:56 -0500 11/21/03, Julian Zottl wrote: Andy, Thanks for responding. I think that I am going to go with the idea of creating a tale for each day. My thoughts were to write a shell script to do this for me, but I am running into a problem: I wrote the following: #!/bin/sh date=`date "+%m%

Re: SHOW TABLE STATUS without LIKE

At 13:21 +0200 11/21/03, Jozsa Boti wrote: Hi! How an i get the last Check-time of a specific table without using LIKE statements? There isn't another way. There's the SHOW TABLE STATUS command, but if there are many tables in a database this command is very slow, even if a specific table name is

RE: Suggestions on querying parent/child records

well... I'm not 100% sure of your table structure, but if the children are in same tables, then join to each: select * from action_items a, child_table b, child_table c where a.owner_id = b.person_id and a.creator_id = c.person_id now if the values in the action_items table could be null (no

Re: InnoDB on master, MyISAM on slaves?

Thanks for the quick reply-- > Yes, this is a common strategy, actually. Any tricks to getting the tables converted on the master without the slaves knowing about it (IE how can I do 'alter table' on the master without it being executed on the slaves)? > Transactions are not written to the binar

Suggestions on querying parent/child records

I'm trying to figure out the best approach for doing this query. I have a list of action items, typically about 50, that I need to display. Each action item will have two related sets of child items (two different groups of people). So I need to query three main databases, a parent and two chil

Re: InnoDB on master, MyISAM on slaves?

At 11:36 -0700 11/21/03, Matt Sturtz wrote: Hello, We run a master-slave configuration and are considering migrating a few tables to InnoDB to get transaction capability... Question is, can we keep the tables as MyISAM on the slaves to maintain the high-speed accesses? I suppose this would requir

Mysql 4.1 with UTF8 support

Hello, I was wondering if anybody has mysql compiled with UTF8 support. I don't have VC++ but needed to at least do some proof of concept so if someone could email the files or tell me where I could download them I would appreciate it. Thanks, Theo Dettmer [EMAIL PROTECTED] -- MySQL General Mai

How to turn off read only for MySQL tables so UPDATE will work

I am trying to learn PHP using the tutorial for DWMX on macromedia.com. I was doing pretty good until it came time to edit a record. When I tried the page, it said the 'album' table was read only. I had copied the database files from my computer to the server so I went back and checked all the

InnoDB on master, MyISAM on slaves?

Hello, We run a master-slave configuration and are considering migrating a few tables to InnoDB to get transaction capability... Question is, can we keep the tables as MyISAM on the slaves to maintain the high-speed accesses? I suppose this would require the SQL not being written to the bin-log

Re: Adding a New Slave to a Live Replication Master

Currently LOAD DATA FROM MASTER "is subject to the following conditions: * It works only with MyISAM tables. * It acquires a global read lock on the master while taking the snapshot, which prevents updates on the master during the load operation. " What I would do is take a snapshot from

LOAD DATA LOCAL INFILE question...

Greetings, Having problems using 'LOAD DATA LOCAL INFILE' from a UNIX client talking to a Win32 server. I've read the documentation several times now and have had zero success with this command. My server has the appropriate permissions configured in the MY.INI file (this was verified using 'show

Re: mysql_fix_privilege_tables script

At 10:18 -0200 11/21/03, Fernando Gomes Bernardino wrote: > At 10:00 -0200 11/19/03, Fernando Gomes Bernardino wrote: >Hi eveybody, > >The mysql_fix_privilege tables can be undone? I have already >re-install mysql server and nothing Why do you want to undo it? You can undo it by restori

Re: Transaction newbie question

Thanks Peter. I strongly suspect that I'm getting deadlocks where it's simply a lock contention. Grrr. I chose BDB because my client has it available on his installation. I'll configure InnoDB support if necessary. It looks like a LOT less headache. Thanks. - Mike. ___

Adding a New Slave to a Live Replication Master

I've got two database servers in production, one of which is a master for a handful of tables and the other is a slave for these few tables. I want to add an additional slave server without taking down the master to create a snapshot. Is it possible to just setup the replication for the slave a

Equivalent in MySQL of the functions "first" and "last" of the "Group By"

Hi! I want to know if there is a equivalent in MySQL of the functions "first" and "last" of the "Group By"... Manoel Lopes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 4 converts special chars '?'

Hi, does anyone know how to solve the problem with MySQL 4 (on Win and Linux) that converts special characters like n-dash (if you hold down ALT and press 0150 on num keys) or typographic quotes (ALT+0132, ALT+0147) to question marks? Example: INSERT INTO test SET column = '\„Hello there\“'

Re: Errors with MySQL

Hi With connection to my problem I ran the phpinfo.php, and found this under the mysql section: mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 3.23.39 MYSQL_MODULE_TYPE builtin MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE MYSQL_LIBS Directive

RE: Choosing between VARCHAR and TEXT

One additional consideration would be if you're planning on doing a lot of mailing you should consider having some sort of address validation software. Once you settle on that package, it will also help you determine maximum field/column sizes. After looking at the package(s) you may decide to off

Re: Choosing between VARCHAR and TEXT

It is always best to set fields sizes as small as possible, to both conserve disk space, as well as improve performance. The smaller the record the faster the queries. While you do not want to make any field too small, you also don't want to make it too big. With current databases, you can e

Re: "Status" shows wrong version number for server after upgrade

Got it. mysqladmin version showed the 4.0.4 version. The Find is what clued me in. It did indeed find two mysqld executables. One in /usr/local/share/mysql/... and the other in /usr/local/mysql/share/mysql/... I copied the right one over the wrong one and after cleaning up a couple of erro

Re: DB design question

I was wondering if maybe your SELECTs could be optimized? Are you using an index? MySQL can handle billions of rows w/o a problem. -will Real-time Chat: irc.freenode.net -> #mysql ( http://www.mysql.com/doc/en/IRC.html ) - Original Message - From: "Julian Zottl" <[EMAIL PROTECTED]> To

Re: Choosing between VARCHAR and TEXT

Will any names or addresses exceed 255 characters? The documentation recommends to use the smallest column size possible. -will Real-time Chat: irc.freenode.net -> #mysql ( http://www.mysql.com/doc/en/IRC.html ) - Original Message - From: "Paul Fine" <[EMAIL PROTECTED]> To: <[EMAIL PRO

Fulltext TODO items

Hi all, I've searched the development roadmaps and I can't find any of the Fulltext TO DO items (http://www.mysql.com/doc/en/Fulltext_TODO.html) on them. Can anyone point me to something which would confirm or deny plans to implement these features? I am particularly interested in proximity oper

RE: DB design question - shell scripting...

Andy, Thanks for responding. I think that I am going to go with the idea of creating a tale for each day. My thoughts were to write a shell script to do this for me, but I am running into a problem: I wrote the following: #!/bin/sh date=`date "+%m%d%Y"` export date mysql -u root -p < createdb.

Choosing between VARCHAR and TEXT

Can anyone tell me what is better to use for items such as names and addresses? I suspect VARCHAR(max anticipated length) but why? Is it because Text will pad? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAI

Configuring built in OpenSLL

Hi all, I would like to know how to configure MySQL with the --with-vio and --with-openssl options. I have a MySQL-4.1 installed on a Red Hat 9 system from .rpm packages. When I use the show variables command, it returns have_opensll = NO. Does it mean that the ssl support is not compiled into t

Migration to INODB?

First of all I would like to thank everyone who has helped with my past posts. I'm not sure what the correct etiquette is, to post a thanks to every poster? Anyway, my situation is this. The production server is currently running mysql 3.23. I do not want to migrate to 4.x right away, however I am

RE: MySQL 4.0.16 on SCO OpenServer 5.0.6

I hate to respond to myself, but. I have it working now... MySQL 4.0.16-debug on SCO OPenServer 5.0.6a Stefaan Stefaan Van Dooren wrote: > Since I got no answers, I will put another question > > Is anybody using MySQL 4.x on SCO OpenServer 5.x ? > > Stefaan > > Stefaan Van Dooren wrot

Re: How to 'customize' GROUP BY?

must be bad luck, but this method doesn't work for me. to go to my actual case, I'm currently developing on: I have a bulletin board, and want to find any forum's thread with the most recent posting. here's what I tried first: mysql> select forum, id, lastpostdate from uni_threads group by forum

dbf2mysql

Does anyone have an example of a dfb2mysql (contributed software) character conversion file (-e)? I need to know which format should be used when specifying the characters (octal, hex, ascii etc). Many thanks for any help! fab. -- MySQL General Mailing List For list archives: http://lists.my

mySQL -- Any supporting function like RANK in ORACLE

Hi I am using MySQL for certain queries and i need to find out RANK of the columns also. ORACLE provided a function RANK() by which it can be retrieved. Is there any similar function in MySQL by which same thing can be done. Thanks Prakash Kamani -- MySQL General Mailing List For list archive

RE: Adding mysql to the subject line would improve clarity and ease of classification.

You'll notice that the 'To:' line of your emails are all addressed to [EMAIL PROTECTED] Set up a filter rule to distinguish these messages from your other ones. That way nobody has to adhere to any special subject rules. Hope that helps. Matt > -Original Message- > From: BAO RuiXian [mai

RE: DB design question

Julian, Your design is sound in my opinion. An area you probably need to consider is when you need to search across a day boundary. You will need to make the application aware that it needs to search across a day boundary, so that it searches two tables with a union where necessary. It will also

RE: MySQL 4.0.16 on SCO OpenServer 5.0.6

Since I got no answers, I will put another question Is anybody using MySQL 4.x on SCO OpenServer 5.x ? Stefaan Stefaan Van Dooren wrote: > Hi, > > I'm trying to install (compile, since there are no binaries for this > system) MySQL on an SCO OPenServer 5.0.6 system. > > Prior to compiling

DB design question

Hello all, I am designing a database right now that will have between 300-400k inserts per day. I need to keep this information for approximately 3 months and will probably do 5-10 reads on the data set per day. I've been storing it in one table up to now (only col.), but the searches are beco

How to join tables using pack_isam

Hello All Please give me the exact syntax to join 2 tables into a new table using "pack_isam". Thanks Mathan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SHOW TABLE STATUS without LIKE

Hi! How an i get the last Check-time of a specific table without using LIKE statements? There's the SHOW TABLE STATUS command, but if there are many tables in a database this command is very slow, even if a specific table name is after the LIKE statment. Thanks -- MySQL General Mailing List Fo

Re: "Status" shows wrong version number for server after upgrade

Mark, what's the output of shell> mysqladmin version It appears that you still have a version of 4.0.4-beta running. Try shell> find /usr /sbin /bin -name mysqld to see whether there is more than one copy of mysqld hanging around. Regards, Thomas Spahni On Wed, 19 Nov 2003, Mark Marshall w

Re: MySQL lost connection

John Cole <[EMAIL PROTECTED]> wrote: > > I installed MySQL 4.0.16-nt on a Win2000 Pro platform. > I want to implement a multi-table delete, so i type > following SQL statement: > > Delete from tablea, tableb using tablea, tableb > where tableb.number=2 and tableb.number=3; > > the server down an

Re: Cannot find an index that will be used for SELECT

Ed, You should still have a WHERE clause : SELECT * FROM ROWS AS R1 LEFT JOIN ROWS AS R2 ON (R1.index=R2.index AND R2.X<=Right) LEFT JOIN ROWS AS R3 ON (R1.index=R3.index AND R3.X>=Left) LEFT JOIN ROWS AS R4 ON (R1.index=R4.index AND R4.Y>=Bottom) WHERE R1.Y<=Top Does this work? Arnaud -

RE: How to 'customize' GROUP BY?

you would need to create a temporary table. So lets say you want to check 'id' column for highest value, you would do the following: CREATE TABLE tmp SELECT MAX(id) AS max_id FROM tbl; SELECT * FROM tbl WHERE tmp.max_id = tbl.id; Another approach would be to use an SQL variable, again if you want

Re: How to 'customize' GROUP BY?

I think that http://www.mysql.com/doc/en/example-Maximum-column-group-row.html covers your problem here. You either have to solve it with Temporary tables, the MAX-Concat trick (in the url above) or a subquery (which will be more inefficient than the other two options). On Thu, 20 Nov 2003, Yve

RE: How to 'customize' GROUP BY?

Maybe I'm misunderstanding you, if so use the HAVING and pretend I never said anything, other wise: A HAVING clause is essentially a WHERE clause, it just does the checks after it groups the rows. So you can't select which row in a group to return, as it's already been grouped. You may be getting

Re: Cannot find an index that will be used for SELECT

Hi Ed, i tried to create this table CREATE TABLE `rectangle` ( `myname` char(5) NOT NULL default '', `minx` tinyint(3) unsigned default '0', `miny` tinyint(3) unsigned default '0', `maxx` tinyint(3) unsigned default '0', `maxy` tinyint(3) unsigned default '0', `miscfield1` tinyint(3)

Re: How to 'customize' GROUP BY?

Hi Chris, Please tell me why a group by with a having shouldn't work in this case. I tested it with a small table and it works fine, at least in this case. Peter Sap. - Oorspronkelijk bericht - > Van: "Chris" <[EMAIL PROTECTED]> > Aan: "List: MySQL" <[EMAIL PROTECTED]> > Verzonden: vrij