Re: timeout

period. TIA mosaed -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Is deleting the .FRM, .MYD and .MYI files the same as dropping table?

accidentally dumped into several databases and then replicated. I'm wondering if I can just go through with a simple command to blow these all away: find /var/lib/mysql/ -name eventum* Or is there some other magic that a DROP TABLE eventum* does? -- Jim Lyons Web developer / Database

Re: UPDATE jujitsu?

...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: [PHP] Because you guys/gals/girls/women/insert pc term here are a smart lot

List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: long login times?

Jed: Are you using an in-network IP to access the database ie: 127.0.0.1 192.168.98.## or are you using a public IP or full domain name ie: DB001.MY-DOMAIN.COM ... Jim I've started logging how long my php application takes to login to mysql, and often it's well below 1 millisecond. However

Re: How many users access MySQL

, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Partial Replication

To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Replication

really this unreliable? It breaks at the slightest hiccup... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Trying to Create a Trigger

-1519) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

why is information schema so slow?

? Is there something I can do to speed up queries to IS? I know these are views, are they so complicated that it takes forever to query them. This reduces their usefulness if true. Thanks -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Need Help

on the road is not the end of the Road..., Unless you forget to make the turn -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Using Replication in mySQL version 5

should be aware of before investigating this route and putting it into practice ? Thanks, Neil -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

com_* status variables seem to reset in mysql 5

. Is this a bug in mysql 5? Is something set incorrectly in my config file that would cause this (I can't find anything)? Thanks for any help. -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: mysql dump problems, no data dumped

] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40111 SET [EMAIL PROTECTED] */; -- Dump completed on 2008-10-27 13:50:53 Can anyone help me? I need to work out why no data is written, thanks Andy. -- Jim Lyons Web developer / Database administrator http

Re: Getting more info from show full processlist

pr1, pr2 FROM someDB. Thanks Matias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Most efficient way of handling a large dataset

: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: How to count # of character occurrences in a string?

://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: MySQL Sort by Array

help. Keith No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.2/1739 - Release Date: 10/22/2008 7:23 AM -- Jim Lyons Web developer / Database

Re: SQL select basics

of group function I also tried SELECT ID_number, count( CU_number ) AS CC FROM MyTable GROUP BY ID_number WHERE CC = max( CC ); But this also causes an error, anyone able to offer some pointers am I able to use sub queries ? Thanks Dave. -- Jim Lyons Web developer

Re: access denied error

] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: mysql binlogs and their expiry times

/etc/ ? If it matters, I use mysql-server-5.0.67 on FreeBSD 7.0-Release machine. Many thanks! -- Zbigniew Szalbot -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer

Re: Question of Relationship between tables

] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Foreign Keys

OR can it also speed up JOIN queries? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: mysql binlogs and their expiry times

or bounce the server. We use Purge Master periodically. i do this from cron mysql -e PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY) perhaps not that 'clean' but it does the trick -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Complex SELECT

To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Large Query Question.

, look at the memory set aside for joins in join_buffer_size. On Thu, Sep 4, 2008 at 9:38 AM, mos [EMAIL PROTECTED] wrote: At 02:49 PM 9/3/2008, Jim Leavitt wrote: Hi Mike, Yes sometimes, the application is an online book selection tool with about 1 million titles in it. Now the queries which

Large Query Question.

file which could improve our performance? Are there any hardware recommendations that could help us improve the speed? Would more memory help us? Any comments or recommendations are greatly appreciated. Thanks much. Jim Leavitt Developer Treefrog Interactive Inc. (www.treefrog.ca

Re: Large Query Question.

What are the queries? Are they straight forward selects or joins? Are the columns you select from indexed and are the indexes up-to-date? On Wed, Sep 3, 2008 at 12:05 PM, Jim Leavitt [EMAIL PROTECTED] wrote: Greetings List, We have a medium-large size database application which we

question about the mysql prepare/execute commands

versus prepare/execute? And why prepare/execute in the mysql commandline program is so much slower than prepare/execute in Perl? Thanks. Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: question about the mysql prepare/execute commands

:41 PM, Jim Lyons [EMAIL PROTECTED] wrote: I have a question about the prepare/execute commands provided by mysql. I devised a benchmark, comparing updating a table using a statement-at-a-time versus using a prepare/execute pair. The table had a million rows. The statement-at-a-time

Re: Impossible WHERE in explain

noticed afte -- Krishna Chandra Prajapati -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

alter merge table doesn't work as documented (?)

-- -- alter table t_merge union=(t2, t3) -- ERROR 1146 (42S02) at line 16: Table 'jlyons.t1' doesn't exist Is this a bug or expected behavior? Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: alter merge table doesn't work as documented (?)

true, but I'm more interested in if the error message I received is documented behavior or not. Thanks, Jim On Tue, Aug 26, 2008 at 4:11 PM, Rolando Edwards [EMAIL PROTECTED]wrote: You are better off running it this way: create table t1 (x int); create table t2 (x int); create table t3 (x

Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

properly.. but either OS version or HW is very old. We took new powerfull server, anc we want to migrate our data to new server... onlt this i want to do it. 2008/8/22 Jim Lyons [EMAIL PROTECTED] As I said, it appears your mysqldump output is not doing a DROP TABLE before each create

Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

correction, the command that's failing evidently is the 'create table columns_priv', not a drop table. Sorry for the typo. 2008/8/24 Jim Lyons [EMAIL PROTECTED] The command that's failing evidently is the drop table columns_priv which is why you're getting the error message: *ERROR 1050

Re: multiple mysql service on the same server

that using different port, but should i use two different my.cnf files, and also, what is the procedure to stop one mysql service and keep other one running. regards anandkl -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

is running on old server but mysql-client-5.0.51a is running now what can i do regards -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

migrating database from mysql-client-4.0.20 running server(current) to mysql-client-5.0.51a running server(new) ..i ve took mysqldump and transfered to new server and restored but process broken up with this error message. On Fri, Aug 22, 2008 at 6:33 PM, Jim Lyons [EMAIL PROTECTED] wrote

Re: Replication Error

-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem. -- Krishna Chandra Prajapati -- Jim Lyons Web developer / Database administrator http

Re: can some please help me -- REPLICATION

copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web

Master-to-Master replication on same server

master needs to connect to on the 3307 master. In the change master to command I can only specify the port. I did specify it as 3307 but the slave still can't connect. Has anyone done this? -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Master-to-Master replication on same server

the 3306 master needs to connect to on the 3307 master. In the change master to command I can only specify the port. I did specify it as 3307 but the slave can't connect. Has anyone done this? -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Calendar creation

Craig: Not sure but we use: http://www.cascade.org.uk/software/php/calendar/ (ie. php) at: http://downtownoceancity.com/events Jim On Thu, Jul 17, 2008 at 8:50 AM, Weston, Craig (OFT) [EMAIL PROTECTED] wrote: Hi there, Is there any simple way to create a calendar table? For example I

Joining a table to itself

As cats2 ON cats3.ParentId = cats2.catid Thanks in advance! J Jim

RE: Joining a table to itself

Thanks Shannon. :) -Original Message- From: Shannon Wade [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2008 4:04 PM To: Jim MacDiarmid Subject: Re: Joining a table to itself not sure i understand the order of your table joining i just reordered them and it works. SELECT

Re: delete a data from 3 tables

a data from 3 table which is interconnected with each other by foreign key. i.e 1st table is connected with 2nd table by foreign key and 2nd table is connected with 3rd table with foreign key. please help to solve this problem. Thanks chandra -- Jim Lyons Web developer / Database

Re: Storing IP blocks

functions from base 256 to base 10 and back (although these are bigints). So range checking is easy: convert the range limits and the search IP to integers base-10, and do a normal compare. I found dealing with IPs any other way far too cumbersome. Jim On Thu, Jun 12, 2008 at 8:24 AM, Scusting [EMAIL

Can I dump procedures with mysqldump using --tabs?

but that would make it a 2 step process. If redirecting to STDOUT is the only way to do it, are there any plans to change this? -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: MySQL 5.0.51a and SHOW ENGINES

On Fri, Apr 11, 2008 at 08:54:26AM +0200, Martijn Tonies wrote: Hello Jim, On Thu, Apr 10, 2008 at 09:32:43AM +0200, Martijn Tonies wrote: It seems that SHOW ENGINES fails on MySQL 5.0.51a (community edition checked). Instead of returning the full data, the first two columns

Re: MySQL 5.0.51a and SHOW ENGINES

like you are using the wrong value for the length of a utf8 field, where the number of characters is being divided by the max character length. (10 / 3 = 3, 80 / 3 = 26) or it could be the server returning the wrong length. use mysql --column-type-info to see what it is returning. jim -- MySQL

Re: Question about reading info from another table.

data in Table2 on update to Table1. Jim Lyons - Jim Lyons MySQL DBA Hoover's, Inc. 512-380-4780 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: union operator problems in MySQL v3.23?

in the documentation: mysql SELECT REPEAT('a',1) UNION SELECT REPEAT('b',10); ERROR 1064: syntax error near 'UNION SELECT REPEAT('b',10)' at line 1 Support for UNION was not added until 4.0. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: ODBC 3.51.22 problem - please help

it will get fixed in a future server release, but I'm not sure when that will be, and it will almost certainly not be in the 5.1 series. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Unusual sort

I have a table containing web site host names, most of them having both a name.com and www.name.com version, that I'd like sorted in the following manner: axxx.com www.axxx.com bxxx.com www.bxxx.com wxxx.com www.wxxx.com zxxx.com www.zxxx.com Any way to do this? -- MySQL General Mailing

Table type for high number of insert/delete operations

I have an application which will be inserting and then deleting many thousands of rows per hour within a single table. It essentially queues and then handles requests from a series of processes, deleting the requests after they've been dealt with. Our MySQL 5.0.45 server is set up to use

Re: MySQL 5.1.22 is out

Is there any kind of timetable for when 5.1 is actually expected to be released? - Original Message - From: Kaj Arnö [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Wednesday, October 17, 2007 3:07 AM Subject: BLOG: MySQL 5.1.22 is out MySQL users, Sorry for spamming

Re: MySQL only listens on localhost

Franz: Did you setup user access permissions outside of 127.0.0.1 and is port 3306 open on your firewall/router? Jim Ginn http://www.Tenant.com Hello, Can anyone please give me a hint what I can do that MySQL also listens to the physical address of the host. I see that MySQL listen only

Re: Falcon and Foreign Key Constraints

, but this functionality is not exposed to the MySQL server.) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: The current version is 5.0.48, no?

Can these be legally run without a license? Is the only difference that MySQL AB doesn't publish links to the current version on their web page, instead purposely choosing to leave the community version several revisions behind? Yeah, I'm a little confused. - Original Message -

Query sloooow

do to speed things up on Fedora? Jim _ See what you’re getting into…before you go there http://newlivehotmail.com/?ocid=TXT_TAGHM_migration_HM_viral_preview_0507 -- MySQL General Mailing List For list archives: http

Release of Installation/Management script for MySQL Cluster (NDB)

for the cluster. You can install the script as a normal user, in which case MySQL Cluster is installed in a user-level directory, or as a root user, in which case MySQL Cluster is installed in the default installation directories. -- Regards, __ Jim Dowling, Ph.D. Swedish Institute

Re: innodb to be removed? and...

On Tue, Jul 24, 2007 at 11:48:38AM +0200, Christian Parpart wrote: so is it true, that innodb is to be removed? No, not in the forseeable future. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: innodb to be removed? and...

On Tue, Jul 24, 2007 at 11:17:11AM -0400, Les Schaffer wrote: Jim Winstead wrote: No, not in the forseeable future. if you are going to use that kind of Orwellian newspeak, then expect the followup question to be, how far into the future does MySQL see? do you have a number in mind, like 1

Re: innodb to be removed? and...

as Falcon gets closer to a stable release. (And of course, you should go ahead and download the Falcon development releases, try it out, and let us know about any problems you find.) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: MySQL admin GUI

Jerry: or: http://www.phpmyadmin.net/home_page/index.php ? Thanks! Jim Ginn http://www.Tenant.com Does anyone know how to add a field anyplace but at the bottom? I haven't found any insert here functionality. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195

Re: Query cache question when using HANDLER

On Wed, Jun 27, 2007 at 01:27:24PM +1200, Ian Collins wrote: Are HANDLER queries cached in the query cache? No, they are not. The query cache only caches the results of SELECT statements. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: why is `load data from master` obsolete?

), and will be replaced by the online backup support that is currently under development. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ODBC Drivers 3 and 5

the ANSI interfaces, and Connector/ODBC 5.0 is a ground-up rewrite that supports the ODBC Unicode interfaces and some other features. 5.0 is still only a beta, while 3.51 is production-ready. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: ODBC Drivers 3 and 5

functions on my ASP server that is using ODBC version 3? Should I be using the same version? No, Connector/J has always supported Unicode. There's no reason to stay with Connector/J 3.x because you're using Connector/ODBC 3.51. Jim -- MySQL General Mailing List For list archives: http

Re: Fields seem to be mis-wired (for lack of a better term)

AND `manager_id` = 0 AND `modified` = NOW() WHERE `id` = 5 you can't use 'AND' to connect your updates, you need to use commas: UPDATE users SET name = 'First Last', email = '[EMAIL PROTECTED]', ... what you're doing now is setting your name column to a boolean expression. jim -- MySQL

key_buffer_size and InnoDB tables

On the following page and in the example ini files installed with MySQL it's suggested that key_buffer_size is an option that affects MyISAM performance. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html But on the following page about tuning MySQL server parameters, it says

RE: Help With a Week ( date ) query

Jerry: We do this exactly at: http://www.WeeklyRentals.com Jim I'm not sure if this gets you all the way, or not. There is a WEEK() function that converts a date into its week of the year. There isn't any obvious way to turn it back into a date, but it doesn't sound like you need

Re: Searching for Dates

Dan: I've used the TO_DAYS on a SELECT statement ie: SELECT * FROM properties WHERE (TO_DAYS(NOW()) - TO_DAYS(CreationDate) = 1) ORDER BY id DESC however it didn't seem to take advantage or use the index on that field (ie. CreationDate) ... Jim In the last episode (Mar 16), Bob Cooper said

Re: Searching for Dates

Dan: Thanks! Jim In the last episode (Mar 18), Jim Ginn said: In the last episode (Mar 16), Bob Cooper said: I am working with MySQL ver 5.1 on a Ubuntu Linux x86_64. I am new to both SQL and MySQL. I have been able to query out most of the data I need from my tables without any

Re: [LICENSING] why so hazy? Comparing to Samba.

. They are happy to work with you to fit find the pricing model that makes the most sense. (Or, of course, you can just open source your application.) And I hope we can now consider this horse to be sufficiently dead. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http

Re: [LICENSING] why so hazy? Comparing to Samba.

'.) This licensing comment in the internals documentation is old, and is supposed to be removed. Unfortunately, updating the internals documentation is not something that gets a lot of priority. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL to Postgres

experienced with either Postgres or MySQL. It's cost me a weeks work already. It's fortunate that we planned for this kind of thing. Jim C. signature.asc Description: OpenPGP digital signature

Re: MySQL to Postgres

live in the commercial sector where users can blame me for anything they want. Even if it isn't justified. Jim C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL to Postgres

It looks more like the person that designed the schema has payed very little attention to the SQL standard. You can not blame anyone but the designer for naming a field 'role' (which is a keyword in the SQL standard) or using a non-standard set field type instead of a proper lookup table.

Re: MySQL to Postgres

CREATE TABLE credits ( person integer NOT NULL default '0', chanid int NOT NULL default '0', starttime timestamp NOT NULL default '1970-01-01 00:00:00+00', role VARCHAR NOT NULL, CONSTRAINT role_check CHECK role IN

Re: MySQL to Postgres

for the same table. Think I'm on the right track? Jim C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL to Postgres

Chris White wrote: Jim C. wrote: CREATE TABLE credits ( person integer NOT NULL default '0', chanid int NOT NULL default '0', starttime timestamp NOT NULL default '1970-01-01 00:00:00+00', role VARCHAR NOT NULL, CONSTRAINT role_check CHECK role IN ('actor','director','producer

RE: Getting number days between 2 dates

I've been trying to figure this out using the CURDATE() function, but I keep getting a syntax error. Below is the code I'm using: SELECT `vb_links`.`DateAdded` FROM `vb_links` WHERE DATEDIFF( CURDATE() , `vb_links`.`DateAdded` ); Any thoughts? -Original Message- From: Mike Blezien

MySQL to Postgres

) ); Note that it accepts everything until it hits the 'role' line. Errors found below: CREATE TABLE ERROR: table credits does not exist ERROR: syntax error at or near ( at character 183 Jim C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Dump to old dump format?

Is it possible to dump to the old MySQL 4.x format? There are some conversion tools I would like to use and they don't support 5.0 yet. Jim C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mandriva 2007 rpm's hosed - Detailed procedural info included - Need help badly

[EMAIL PROTECTED] jim]# mysqladmin -u [EMAIL PROTECTED] password new_password mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation' HUH? What's wrong? : [EMAIL PROTECTED] jim]# mysql -u [EMAIL PROTECTED] Welcome to the MySQL monitor

[ SOLVED I think ] Re: Mandriva 2007 rpm's hosed - Detailed procedural info included - Need help badly

, Dave G. Jim C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

List-Unsubscribe

List-Unsubscribe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqlimport csv file import problem

On Mon, 2006-08-28 at 13:47 +0200, Thomas Spahni wrote: On Sun, 27 Aug 2006, Jim Seymour wrote: Hi, I download a csv file from Yahoo in this format: ABIAX 20.63 2006-08-3 ACEIX 8.78 2006-08-3 CIGAX

mysqlimport csv file import problem

to find an easier way than typing all of the data into a text file for import. Thanks, -- Jim Seymour [EMAIL PROTECTED] signature.asc Description: This is a digitally signed message part

Re: Why release 5.0.23 instead of 5.0.24?

5.0.23 binaries are listed on the 5.0 download page -- this is a mistake.) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.1.21 has been released

releases.) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: connecting to the embedded server

://dev.mysql.com/doc/refman/5.1/en/mysql-options.html Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Random Hangs, Linux AMD 64, 5.0.22 AB Binaries

Sounds like the well-known problem with Debian stable's glibc on x86_64: http://hashmysql.org/index.php?title=Opteron_HOWTO#pthread_rwlock_wrlock_hang_with_nptl Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Differences between MySQL 4 and 5 for scripts

the special syntax for specifying version-specific parts of your query: http://dev.mysql.com/doc/refman/5.0/en/comments.html Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Security fix for 4.0.27?

On Mon, Jun 05, 2006 at 10:16:05PM -0700, Ken Williams wrote: Anyone know if 4.0.27 will be fixed for the mysql_real_escape issue? (http://lists.mysql.com/announce/364) 4.1 and 5 have been already, kinda wondering why 4.0 hasn't. It will not, because 4.0 does not have this bug. Jim Winstead

Auto Install mySQL

Hi All, Does anybody have some advise on automating the install of mySQL and our DB on a PC/Laptop with no user interaction required. Does the SETUP.EXE take any paramaters to auto install without the user dialogs? Thanks, Jim

RE: optemizer for mySQL!

:05 AM To: Jim Cc: mysql@lists.mysql.com Subject: Re: optemizer for mySQL! http://www.devshed.com/c/a/MySQL/A-Technical-Tour-of-MySQL/ The MySQL server has it built in. -Sheeri On 5/8/06, Jim [EMAIL PROTECTED] wrote: Hi All, Didn't know there was an optemizer for mySQL. Where can I get

optemizer for mySQL!

Hi All, Didn't know there was an optemizer for mySQL. Where can I get it from? Thanks Jim Best regards, Jim Clark Project Manager Multilink Systems Ph: 03 9425 9400 Fax: 03 9425 9811

Re: Sub-query optimizer improvements scheduled?

Queries session at the MySQL Users Conference, optimizations for subquery performance are currently scheduled for the 5.2 release. (And as I'm sure Robin and Zack covered at one of their talks on the MySQL roadmap, 5.2 is currently scheduled to reach a production release sometime in 2007.) Jim

<    1   2   3   4   5   6   7   >