Re: 4.1.4a-gamma in production?

Gamma to Production. However, Gamma status indicates that no major bugs have been found for over a month. IMHO: With an estimated (and growing) user base of over 4 million (early 2003) I'd say that Gamma is more than safe enough to use in a production environment. Regards, Jim Grill -- MySQL

Re: mysql still can't start up OT

/to/mysql.sock Make sure that the directory is owned (or at least writable) by the user that MySQL runs as or you will get the dreaded MySQL ended errors when starting the server. Regards, Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: mysql still can't start up OT

without the quotes under the [mysqld] and [client] sections of your my.cnf file. 2) Specify it when starting the server like mysqld_safe --socket=/path/to/mysql.sock 3) Reconfigure mysql adding --with-unix-socket-path=/path/to/mysql.sock Regards, Jim Grill -- MySQL General Mailing List For list

Re: Problem with tables;

| ++ 1 rows in set (0.00 sec) Try doing 'desc spamdata' There is no table named id; hence the error. Regards, Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unable to download MySQL (fwd)

lists. When you receive such emails, you can forward them to [EMAIL PROTECTED] and we'll take care of it. 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: question

connect to local MySQL server through socket '/tmp/mysql.sock' (2) is due to the fact that mysqld is not running when you try to connect via the mysql client. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Compilation Error

a clean start.) CFLAGS=-O3 -mcpu=pentiumpro CXX=gcc CXXFLAGS=-O3 -mcpu=pentiumpro \ -felide-constructors -fno-exceptions -fno-rtti \ ./configure --your options here change -mcpu=pentiumpro to suite your system (i386, i486, i586, i686, pentium, pentiumpro, k6, or athlon). Jim Grill -- MySQL

Re: MYSQL CONNECT ISSUE

port is 3306 Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: help urgent please

The --add-drop-table will add a DROP TABLE IF EXISTS tablename to your script before creating and populating the tables. This is useful when restoring a possibly corrupt table. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: when to use backquote in SQL

if an application your working on requires table names or field names to be supplied from user input (always a bad idea) like a select box. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table fixed BUT...Re: Table crashed! Please help

table WHERE id=[your duplicate value] LIMIT 6; Now you have one left. I hope that helps. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table fixed BUT...Re: Table crashed! Please help OT

communication problems between Navicat and MySQL caused the problem to begin with, which brings me back to my first thought. Best of luck to you, Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: sql problem

an IF. SELECT parent.id, parent.name, IF(child.parent_id IS NULL, 'none', COUNT(child.parent_id)) AS child_count FROM PARENT INNER JOIN CHILD ON parent.id=child.parent_id GROUP BY parent.id; Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: sql problem

This is not meant as an rtfm, but this helped me in the past. http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins/ Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

caclulating bdb_max_lock

an appropriate value. Can anyone point me to some information on this? A Google search has turned up only my old questions on this. Thanks, Jim Hopp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Data Dictionary (INFORMATION_SCHEMA)

. A developer (Sergey Gluhov) is currently working on the implementation. The 'New Features Planned for 5.0' section of the manual will be updated soon to mention it. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: [mysql] Question about the reference manual

the MySQL Press imprint that are derived from the online manual. You can find more information about them at http://www.mysqlpress.com/ Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

help tuning a DB installation

Hi. I'm wondering if anyone can help me tune this database so it runs better on my hardware. I've made some attempts, but either they've made it worse or not changed anything. Changing the database design itself has shown the most improvement, but I'd still like to know how to tune things

slave should not stop

and the whole system keeps going. If there's no way to fix this problem, has anyone come up with a workaround, like some sort of clever script that will keep things replicating? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

How to follow-up on bug reports

I'd like to ask some questions regarding a work-around for bug #861, a configure problem preventing installation on mac os x. Status on bug is currently Need Feedback. Any suggestions on how to route questions to bug author and/or the developer? Thanks. Ron

mysqldump question

database or one table at a time? I see the mysqlhotcopy script mentioned almost any time mysqldump is recommended. What are the advantages (if any) to using mysqlhotcopy? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: SCO Openserver Install

. Simple PHP MySQL function request are not found ? Have you had any luck in interfacing PHP and MySQL on SCO Openserver? Thanks Again, Jim Our Configure Command './configure' '--with-apxs=/usr/lib/apache/bin/apxs' '--prefix=/usr' '--with-exec-dir=/usr/lib/php/bin' '--with-config-file-path=/usr/lib/php

Re: SCO Openserver Install

Boyd Lyn Gerber: Not sure why we can get PHP-MySQL functions working? We're using PHP: php4/4.3.6a (SCO build) Are you using same build of PHP? Thanks! Jim On Sun, 18 Jul 2004, Jim Ginn wrote: First - Thanks again for your help. Your welcome. Second - Installed SCO release

Re: how to switch off logging?

You can stop creating the logs like rsl156-bin.00[123] (the bin logs) by commenting out the log-bin line in your my.cnf, and restarting mysql. You need them, though, if your server is a replication master. More on the logs here: http://dev.mysql.com/doc/mysql/en/Log_Files.html Jim Michael

SCO Openserver Install

Trying to get MySQL running on SCO Openserver 5.0.7 and get this message: dynamic linker: ./bin/mysqld: binder error: symbol not found: pthread_key_delete; referenced from: ./bin/mysqld And I have FSU threads installed ... Any help would be appreciated Thanks! Jim Ginn -- MySQL

Re: SCO Openserver Install

Boyd Lynn Gerber: I'll give the newer version a try as I was using: /usr/local/mysql-4.0.18-pc-sco3.2v5.0.7-i386 build from your site ... Thanks! Jim On Tue, 13 Jul 2004, Jim Ginn wrote: Trying to get MySQL running on SCO Openserver 5.0.7 and get this message: dynamic linker: ./bin

Re: SCO Openserver Install

? Thanks! Jim On Tue, 13 Jul 2004, Jim Ginn wrote: Trying to get MySQL running on SCO Openserver 5.0.7 and get this message: dynamic linker: ./bin/mysqld: binder error: symbol not found: pthread_key_delete; referenced from: ./bin/mysqld This was an error for some versions of MySQL

Re: SCO Openserver Install

Boyd Lynn gerber: Much better but it complains about max_allowed_packet? It is set to the default 1M ... Thanks! Jim Installing all prepared tables Fill help tables ERROR: 1153 Got a packet bigger than 'max_allowed_packet' bytes 040713 17:43:07 Aborting 040713 17:43:07 ./bin/mysqld

Re: SCO Openserver Install

Boyd Lynn Gerber: I have (think) the MySQL dataserver running. You wouldn't know where I could find a compiled: mysql.so module for apache/php data access? Thanks! Jim On Tue, 13 Jul 2004, Jim Ginn wrote: Much better but it complains about max_allowed_packet? It is set to the default 1M

Re: Data corruption on deletes

://bugs.mysql.com/bug.php?id=3822 http://bugs.mysql.com/bug.php?id=3808 ? Jim Jim wrote: gerald_clark wrote: Hardware? Celeron 1.3Ghz, IDE drive, 512Mb RAM OS and version? GNU/Linux, 2.4.20-8 kernel MySql version? 4.0.17 Size of data file? Size of index file? postsearch.frm 8.7K postsearch.MYD

Re: Data corruption on deletes

file: 'postsearch.MYI'. (errno: 144) So now I am repairing again. Thanks for your interest, Jim I have a table with several keys. When I try to delete anything from this table, I get data corruption and have to repair it with myisamchk. Selects, updates work fine. Here's the create table

Data corruption on deletes

where postId=65031 limit 1; ERROR 1034: Incorrect key file for table: 'postsearch'. Try to repair it Anybody have any idea? Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Display of ? and Hex conversion

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

Re: MySQL and Macs

Thanks so much to everyone for all your help... Jim on 6/29/04 11:31 PM, Paul DuBois wrote: At 22:14 -0300 6/29/04, Jim Carwardine wrote: I'm new to the list and new to mySQL. I'm a Mac user and would like to set up a DB on my Mac. When I look at the MySQL web site, I can't seem to find

MySQL and Macs

to a setup procedure? Jim -- OYF is... Highly resourceful people working together. http://www.OwnYourFuture-net.com Own Your Future Consulting Services Limited, 1959 Upper Water Street, Suite 407, Halifax, Nova Scotia. B3J 3N2 Info Line: 902-823-2477, Phone: 902-823-2339. Fax: 902-823-2139

mysql client connectivity and orphaned connections

stops doing anything when the ssh connection is dropped? Is there any way, other than show processlist to tell whether something is actually going on? Whether there is actual progress? Thanks! Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Rights required to run myisamcheck

an --extended operation. This finds only 99.99% of all errors, which should be good enough in most cases.)? Thanks Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Rights required to run myisamcheck

Dan Nelson wrote: In the last episode (Jun 24), Jim Shea said: I'm setting up a cron job to run myisamcheck with the options -Aacmorv. As I have to put in a username and password, for security I http://dev.mysql.com/doc/mysql/en/GRANT.html lists the available privileges and http

OPTIMIZE TABLE takes a very long time, can I kill it?

A few days ago, Dennis T Cook asked this list if it is OK to abort a OPTIMIZE that is taking a very long time. I am also wondering this. Will it cause any damage to the half-optimized table, adnd is there a right and a wrong way to stop this process? Any help appreciated! -Jim -- MySQL

Re: average in Group By

, but wrong results. What is the correct query? Why not use the AVG() function? It does exactly what you want. http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Off Topic: Search in this list not are functioning

On Fri, Jun 04, 2004 at 10:33:27AM -0300, Renato Cramer wrote: I tried search numerous times and not get: either return all messages or neither. Is one known problem? The search box in the sidebar was simply not going to the right place. This has been fixed. Thanks for the report. Jim

Re: Backing up InnoDB MySQL DB

, should something go wrong. MySQL requires master servers to have log-bin enabled. You will have to figure out how to get rid of the bin-logs from the master machine, or else they will keep growing indefinately. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Where is Release mysql-4.1.2a-alpha-win.zip

. Is that correct? No, some files were simply copied into the wrong directory, and thus listed on the wrong page. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Why is MySQL.com using MnoGoSearch for searching its site???

-text search of our sites. (It is used in the first set of documentation links that are presented with some searches, and for the search on http://solutions.mysql.com/.) Also, mnoGoSearch uses MySQL for its index storage. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http

Re: query to see if db exists...........mysql_query( myQuery)

LIKE 'myDb'. http://dev.mysql.com/doc/mysql/en/Show_database_info.html Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SHOW PROCESSLIST State Locked - what does this mean?

diagnose it. Thanks for your help. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Determine table type and comments

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

Re: Defaul of NOW()

/doc/mysql/en/TIMESTAMP_pre-4.1.html Support for specifying how TIMESTAMP columns get updated is coming in 4.1.2. Right now, it is only documented in the change notes: http://dev.mysql.com/doc/mysql/en/News-4.1.2.html Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http

Copy a mysql user's permissions

Hi List, Is there a way to copy a user in the database's mysql database, so that it will have the same permissions (GRANTs) within the database? Or does one have to create a different user and then manually modify the permissions to match the first? Thanks, Jim -- MySQL General Mailing List

mysql slow server after crash

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

OPTIMIZE TABLE and mySQL replication

Hi List, What are some issues relating to using OPTIMIZE TABLE and replication? Does running OPTIMIZE TABLE on a master DB cause the optimizations to be passed on to the slaves? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: OPTIMIZE TABLE and mySQL replication

Jeremy Zawodny wrote: On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote: Hi List, What are some issues relating to using OPTIMIZE TABLE and replication? Does running OPTIMIZE TABLE on a master DB cause the optimizations to be passed on to the slaves? It does not. The command doesn't

[mysql] replication of database structure changes

that replication is for data and not for structure, but a formal explanation of what exactly that means is hard to find. Thanks again. Jim N. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [MYSQL] Multiple instances of server starting

Thanks, Paul. The machines are running RH 9 (one instance) and Fedora Core 1 (multiple instances). It's not really a problem, so much as a curiosity about whether the one with more processes showing was using more resources. Jim On Friday 30 April 2004 07:36 pm, Paul DuBois wrote: At 18:02

[MYSQL] Multiple instances of server starting

have had this problem, but the answer there does not really explain why these two servers are behaving differently. Can anyone help? Thanks very much! -Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[MySQL] Using the MAX() value in WHERE clause

this, so that the SELECT can get only values for users who have validated LIKE 'N' and their dateCreated is 10 days before the latest dateCreated? Thanks for your help. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: [MySQL] Using the MAX() value in WHERE clause

jim wrote: Hi, The task is to find users whose accounts have not been validated for the last 10 days. This SELECT accomplishes that: SELECT * FROM user WHERE validated LIKE 'N' AND dateCreated = DATE_SUB(CURDATE(), INTERVAL 10 DAY) But, using curdate() is dangerous. What

Re: MySQL User Conference - Session Presentations?

at http://www.mysql.com/uc2004 by the end of the week. (Those that we've collected from the speakers, that is. We'll continue to publish additional ones as we receive them.) Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: MySQL cluster

means it will show up in the nightly snapshots at http://downloads.mysql.com/snaps.php soon), it will be part of the source download for MySQL 4.1.2 when that is released, and binaries will be included in 4.1.2 or later 4.1 releases for those platforms that MySQL Cluster supports. Jim Winstead MySQL

Re: Server not configured as slave

jim [EMAIL PROTECTED] wrote: Does this machine have a valid server-id? Run show variables like 'server_id' from the mysql monitor. Interesting. The my.cnf says server-id = 75 but the show_variables; command says server_id 0 (zero). Why would that be, and could

Server not configured as slave

config file information from the other slaves to the new slave. Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Server not configured as slave

file on this machine? Nothing but record of server startups and shutdowns. Thanks for your help. -Jim -Original Message- From: jim To: [EMAIL PROTECTED] Sent: 4/14/04 3:26 PM Subject: Server not configured as slave Hi, Can anyone suggest some troubleshooting tips when

Replication and Error 1200

ok, but slave start; gives the error. This is in mySQL 4.0.12, on Linux. Sorry if that's too much information. Thanks to any and all for comments or help. Regards, Jim N. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

join problem: indexed columns being ignored

of seconds. I don't see why this should not be possible with the right indexes, judging by what I have been abloe to achieve with similar scripts on the same data. Thanks in advance Jim [EMAIL PROTECTED] Details: spam (t1) contains 5317996 rows recip (t2) conatins 9340685 rows mailin (t3) contains

Joins

with personnel.id set to NULL. Then remove the 'OR' phrase, and it should work, the null record being selected from personnel when closedby is NULL. Jim Imagine a service that checks your business email for viruses, junk-mail and pornographic content BEFORE it reaches you. Imagine a service that allows you

stuck with simple query..... Plz have a look

SELECT ta.Name,tb.Name,tc.Name,Description FROM Table2,Table1 ta,Table1 tb,Table1 tc WHERE ta.ID=PL AND tb.ID=PC AND tc.ID=PA; Jim (This email has been scanned for viruses by www.emf-systems.com) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

stuck with simple query..... Plz have a look

Looks like I trod on original post - forgot to add RE: to subject. Sorry about that! Jim (This email has been scanned for viruses by www.emf-systems.com) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: stuck with simple query..... Plz have a look

SELECT ta.Name,tb.Name,tc.Name,Description FROM Table2,Table1 ta,Table1 tb,Table1 tc WHERE ta.ID=PL AND tb.ID=PC AND tc.ID=PA; Should work Jim (This email has been scanned for viruses by www.emf-systems.com) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: join problem: indexed columns being ignored

Thanks for the suggestion, but according to explain we are in worse shape than before. In both cases the multi-column index is ignored. I am going to try fiddling with the index col order to see if this helps. Here is what it comes up with as you suggested: Query1: explain SELECT COUNT(*) as

Re: stuck with simple query..... Plz have a look

Forgive me, but it would be a cartesian product if there were no where condition, I agree? It would return (size Table1)x(size Table2)^3 rows, definitely not what Tariq wants. The query I supplied will return (size Table2)x(1)^3 rows won't it? Or am I missing the point? Jim SELECT ta.Name

Re: Hey what, no pity for a new user?

to access the data directory and socket directory? Jim PS I am answering loads of questions in the hope that the power of my Karma will force someone to answer mine ... (join problem:indexed columns being ignored) (This email has been scanned for viruses by www.emf-systems.com) -- MySQL General

Re: Hey what, no pity for a new user?

gets answers ... there is a pithy aphorism in there somewhere ... :) Jim PS I am answering loads of questions in the hope that the power of my Karma will force someone to answer mine ... (join problem:indexed columns being ignored) My first reaction would be to turn your index round

Re: Locked myself out

solution to delete the whole thing and re-install it? stop the mysql process, then restart it with the --skip-grant-tables option, reset the passwords, and then restart it as normal. -- Jim Richardson http://www.eskimo.com/~warlock Have you ever noticed that at trade shows Microsoft

Re: Speeding up MySQL server

time on the main table (If I understand it correctly). I'll have to look into this. -- Jim Richardson http://www.eskimo.com/~warlock Madness takes its toll. Please have exact change ready. signature.asc Description: Digital signature

Speeding up MySQL server

. But I am curious about the internal to MySQL load of logging all that data. -- Jim Richardson http://www.eskimo.com/~warlock All true wisdom is found on T-shirts. signature.asc Description: Digital signature

Re: Speeding up MySQL server

On Wed, Mar 24, 2004 at 08:21:15PM -0600, Paul DuBois wrote: At 17:55 -0800 3/24/04, Jim Richardson wrote: I have a rather heavily loaded server, which I would like to tweak a little more performance out of. It currently is binlogging although there is no slave yet. Does the process of bin logging

Max Open Tables

The value for Open Tables is 512, which looks suspiciously to me like it's hit a limit. Is there a way to increase that limit? Or am I misunderstanding what status is telling me? -- Jim Richardson http://www.eskimo.com/~warlock Ahhh... I see the fuck-up fairy has visited us again. -- MySQL

Re: Max Open Tables

On Tue, Mar 23, 2004 at 11:34:13AM -0800, Jim Richardson wrote: I am trying to push the performance of a Mysql database a little more, it's pretty busy, but I hope to squeeze a tad more out of it. I am a newbie/pretty clueless wrt MySQL in general, so ... I run the status command, and see

Re: Preventing Duplicate Entries

, but they will be few and far between. -- Jim Richardson http://www.eskimo.com/~warlock The race isn't always to the swift, nor the battle to the strong, But it's the safest way to bet. signature.asc Description: Digital signature

String Concatenation Operator?

Does MySQL have a string contatenation operator, or must you use the CONCAT() function? SELECT firstname + ' ' + lastname AS fullname FROM customers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Type TEXT

Are the TEXT column types padded out to their max length by spaces? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Type TEXT

- Original Message - From: Richard Davey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 01, 2004 11:02 AM Subject: Re: Type TEXT Hello Jim, Monday, March 1, 2004, 5:44:22 PM, you wrote: JM Are the TEXT column types padded out to their max length by spaces

Minimum privileges required for mysqldump

Table Structure and Data http://www.mysql.com/doc/en/mysqldump.html Can someone point me in the right direction? Thanks Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Minimum privileges required for mysqldump

On 2/27/04, 10:12:56 AM, Jim Shea [EMAIL PROTECTED] wrote regarding Minimum privileges required for mysqldump: I want to create a user that has the minimum rights to dump a database. I can't find a discussion of the minimum required rights in the MySQL docs. At 2/27/2004 08:35 AM, [EMAIL

Re: Minimum privileges required for mysqldump

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

bdb tables: calculating an appropriate value for bdb_max_lock

gather, since --opt means --lock-tables and BDB tables are locked at the page level that I'll need enough locks to cover all the pages in the largest table. How can I determine how many pages are in a table?) Thanks, Jim Hopp -- MySQL General Mailing List For list archives: http

Moving server

into account? The firewall rules will block all connections to 3306 that don't come from either Alpha or Beta, the data isn't sensitive in any way, so I am not worried about sniffing, and I will shut the replication connection down after all is working on Beta. Thanks all. -- Jim Richardson

rpm upgrade file conflict

with rpm -e to no avail. What should I be doing to get a clean installation? Thanks for the help! Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

privileges question

PROTECTED] I get in, no password. How can I tell mysql to refuse anything that isn't from localhost, and to require a password for root no matter what? Thanks. New to MySQL and databases in general, trying to make sure I don't screw up too badly. -- Jim Richardson http://www.eskimo.com/~warlock

Re: privileges question

On Mon, Feb 23, 2004 at 05:30:38PM -0600, Paul DuBois wrote: At 15:18 -0800 2/23/04, Jim Richardson wrote: Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I don't feel like using stuff from out of the RH tree.) I am a little confused about the privileges. I have done a GRANT

bdb tables: calculating bdb_max_lock

see that that error message means that we should increase the bdb_max_lock variable from its default of 1. But nowhere can I find an algorithm for calculating an appropriate value. Can anyone point me to some information on this? Thanks, Jim Hopp -- MySQL General Mailing List For list

RE: SELF JOIN implementing a logical tree on one table

It's been my experience that adjacency lists like what you describe are difficult to query. I have had success with nested sets to represent that kind of hierarchical data. More information at: http://users.starpower.net/rjhalljr/Serve/MySQL/traer.html -Original Message- From: Joe

RE: Size v Speed

I can't really speak to OLEDB optimization, but I can speak to changing over to PHP. The MySQL database connector in PHP is pretty good from a performance standpoint, and PHP itself is blazing fast in my experience. I've seen massive performance gains in PERL by creating an abstraction that

Re: Advise on High Availability configuration

interested in yours experience. Greetings. A.J.Millan ZATOR Systems. Very much so! -- Jim Richardson http://www.eskimo.com/~warlock If space is warped, time is all that's weft. signature.asc Description: Digital signature

Re: Read Slaves, and load balancing between them...

tunnel, or is there something in MySQL I can use to connect securely? -- Jim Richardson http://www.eskimo.com/~warlock We have to go forth and crush every world view that doesn't believe in tolerance and free speech, - David Brin signature.asc Description: Digital signature

Re: Read Slaves, and load balancing between them...

probably wind up using ssh or stunnel. -- Jim Richardson http://www.eskimo.com/~warlock I'll get a life when it is proven and substantiated to be better than what I am currently experiencing. signature.asc Description: Digital signature

RE: Very big IN ( $value )

I've had tens of thousands of items in an IN list without failure, but it seems that when you get that many it takes a very long time to parse. The speed thing bothers me, so I'm toying with a new design, but it's a big enough system that it's slow going. J -Original Message- From:

Re: blacklist

blacklisted, without any notification to that host. Sorry for the inconvenience. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL 4.1 Production Release

Any chance that there's a quarterly strategic roadmap published somewhere? I have projects that sometimes depend on a feature in the next rev' or some such, and I need to plan out for my organization... Difficult to answer my boss when the dependencies are released when they're ready.

Re: BUG IN MYSQL

4.0.16, running on Linux, and it worked just fine. No need to comment out the insert. -- Jim Richardson http://www.eskimo.com/~warlock Man's way to God is with beer in hand. --Koffyar Tribal Wisdom, Nigeria signature.asc Description: Digital signature

<    1   2   3   4   5   6   7   >