Re: script error in program.

are correct... there are always a million things that could go wrong at runtime. Each of those php mysql_XXX calls will return a null or false on failure .. if you check every time you will save yourself a lot of hassle in the long run, - michael dykman - [EMAIL PROTECTED] On Thu, 2006-01

Re: select query taking too long

Im a little confused by the query you posted.. it looks like it would work, although with many redundant subqueries to get there. From your requirement, I don't understand why you needs to wrap it in a self- referencing subquery.. Why does this not give you the same logical value?

what is the appropriate forum to discuss test errors?

error. As of this mornings patch, I'm back to failing on test #2. Can anyone suggest the best place to get some advice on this? - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: pattern matching - but in reverse

time would be much more efficient. A procedural script/program to convert historical data would also be pretty straightforward. - michael dykman - [EMAIL PROTECTED] Luke Majewski wrote: Hi everyone, ok, so I know how to use RLIKE to match regular expressions. However, let's say I have an isbn

Re: How to get count(id) when count is zero?

This should work select C.cId cc, count(D.catId) dd from C left outer join D on C.cId = D.catId group by cc; - michael dykman - [EMAIL PROTECTED] Kapoor, Nishikant wrote: Hello List, It sounds like a simple query but I have spent quite a few hours already, and still do not have

Re: Upgrade from 3.23 to 4.0 - mysql.sock error

/mysql/mysql.sock. - michael dykman - [EMAIL PROTECTED] Jough P wrote: Greetings all, I recently upgraded from mysql 3.23 to 4.0 on a Fedora box. I moved the old installation to a directory called old_mysql in my home directory. I can start the new installation using mysqld_safe . Now, when I

Re: how to switch off logging?

will affect mysql performance. - michael dykman - [EMAIL PROTECTED] J S wrote: Hi, I would like to switch off the logging that creates the large files below (in the mysql data directory) Could someone tell me how to do this please? Thanks, js. # ls -l total 5418648 -rw-rw 1 mysqlmysql

Re: INSERT if record NOT EXISTS

you. Regards, Adai. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

File size limits with mysql 4.1

this or have any practical advice on how to transcend this limitation? -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: File size limits with mysql 4.1

the way. On Mon, 2004-07-26 at 14:19, Paul DuBois wrote: At 12:48 -0400 7/26/04, Michael Dykman wrote: I am using a development build of 4.1.3 (the last 4.1.3 release I think; mysql-4.1.3-beta-nightly-20040628) so I suppose I have this coming, but here goes: As I am running on RH Enterprise

Re: File size limits with mysql 4.1

I apologize for my skepticism of 15 minutes ago. I finally _read_ http://dev.mysql.com/doc/mysql/en/Table_size.html carefully, and indeed your suggestion is dead on. thank you again. On Mon, 2004-07-26 at 14:19, Paul DuBois wrote: At 12:48 -0400 7/26/04, Michael Dykman wrote: I am using

Re: select * on all current?

all current dateposted per office? i have tried.. sql select * from datafiles where dateposted current(); And i think its wrong, i could not find how to get it. -- Louie Miranda http://www.axishift.com -- Louie Miranda http://www.axishift.com -- - michael dykman

Re: Spamcease ?

that I have to validate my email at Spamcease. Looking at the mail header mail seems to come from tgpnexus.com? Anybody else getting this type of emails? Alexander Newald -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com

daisy-chaining replication

lend me a clue? -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL and SSL

could someone please tell me which versions of mysql support SSL connections for both clients and replication slaves? thank you. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: daisy-chaining replication

TO ...' and the error log is substantially the same. On Tue, 2004-07-27 at 14:59, Paul DuBois wrote: At 14:31 -0400 7/27/04, Michael Dykman wrote: Hello, I'm running a development build of 4.1.3 and trying to set up of chain of replication servers. The first level of replication works

Re: daisy-chaining replication

TO ...' and the error log is substantially the same. On Tue, 2004-07-27 at 14:59, Paul DuBois wrote: At 14:31 -0400 7/27/04, Michael Dykman wrote: Hello, I'm running a development build of 4.1.3 and trying to set up of chai thank you again Paul, I did miss that one altogether, but that does

Re: Python library for cluster support?

client libraries built for 3.x and the 4.1 servers which support clusters. you might have to rebuild python against a 4.1 library On Wed, 2004-07-28 at 00:32, Joe Wong wrote: Hi, may I know of the current MySQL python library supports MySQL cluster or not? Regards, - Wong -- - michael

Re: Enum or Int

? Best regards Olivier Salzgeber -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

Re: Login question

PROTECTED]' (Using password: YES) Argh... your help is appreciated. Respectfully, ASP -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: creating a new user with mysql on 4.0.20a

on where they are logged in from. GRANT ALL ON llcopy.* TO auser.'%' IDENTIFIED BY 'thepassword'; -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: make test grant_cache test failing

running your test as a regular user and this should fix itself. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Failed to initialize the master info structure

The first thing that occurs to me is to double-check the r/w permissions in your data directory. I assume you are logged into mysql as root when you attempt this command? - michael dykman On Mon, Aug 11, 2008 at 1:47 PM, Brown, Charles [EMAIL PROTECTED] wrote: Can someone tell me why I am

Re: Replication between debian and fedora box

OS - linux, - michael dykmsn On Wed, Aug 13, 2008 at 4:30 AM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi all, Is it possible to create replication between debian and fedora box. -- Krishna Chandra Prajapati -- - michael dykman - [EMAIL PROTECTED] - All models

Re: Intermittent Can't connect to MySQL server on 'host' (4) (2003) after 20+ days uptime

. Thanks in advance for any and all help! Pieter de Zwart -- Sreekanth CHAVA -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: question about the mysql prepare/execute commands

; and then, at the end insert COMMIT See if that improves the numbers on the prepared statement. - michael dykman On Tue, Sep 2, 2008 at 5: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

Re: MySQL crash (negative mmapped regions)

How are you performing the backup? What tools are involved? Are there any ther users of the database while you are doing this? - michael dykman On Wed, Sep 3, 2008 at 4:43 PM, L'argent [EMAIL PROTECTED] wrote: I've been trying to backdown a production database for some time and can't seem

Re: innodb/myisam performance issues

work with START TRANSACTION/COMMIT, then the database can avoid doing a commit after each individual statement. I have found this necessary to reap the performance improvements from transactional table types. -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful

Re: too many connections

returns to normal, which counter-indicates using the method for any pratiacl web application. Most developers/admins prefer to take the hit and use mysql_connect, opening and closing a connection for each request rather than risk having all connections consumed. - michael dykman On Fri, Sep 19

MySQL and SAN storage - a request for comments

I merely confused? -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: REPOST: ON DUPLICATE failure

subsequent run of the insert statement. I thought this odd as I only ran the same statement repeatedly leaving me with one row ever, but the value updated just fine. - michael dykman On Wed, Jan 21, 2009 at 10:54 PM, Ashley M. Kirchner ash...@pcraft.com wrote: Anyone? I'm trying to diagnose

Re: Are dates stored as String? Or Integer?

/en/date-and-time-types.html You may also save considerable space.. from http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html DATE3 bytes TIME3 bytes DATETIME8 bytes TIMESTAMP 4 bytes YEAR1 byte - michael dykman On Wed, Jan 28, 2009 at 12:31 AM, mos mo

Re: Are dates stored as String? Or Integer?

to squeeze out any performance benefit by converting to int.. you might even lose some ground to the special handling your date-as-int your app might have to do. - michael dykman On Wed, Jan 28, 2009 at 1:30 AM, mos mo...@fastmail.fm wrote: At 11:43 PM 1/27/2009, Michael Dykman wrote: Absolutely

Re: Curious Error, anyone have a guess?

arbitrary string, so it si inevitable that you will get unsafe input sooner or later. - michael dykman On Sun, Feb 8, 2009 at 12:31 AM, mik...@qualityadvantages.com wrote: Hello mysql, On one of my sites, I have a query that logs attempts to access the site by potential bad guys. It has been

Re: What ever happened to NitroEDb engine for MySQL

it? TIA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list

Re: What ever happened to NitroEDb engine for MySQL

the operational business data which is the backbone of our day-to-day business. - michael dykman On Sun, Feb 8, 2009 at 5:51 PM, mos mo...@fastmail.fm wrote: At 11:14 AM 2/8/2009, Michael Dykman wrote: We recently began using infobright in my shop.. reporting queries against 10's of millions

Re: mysql optimization tips

the right optimization for our company's server. I suggest High Performance MySQL, Second Edition :-) There's no way to really give any good advice without knowing what you use the server for. I enthusiastically second that recommendation -- - michael dykman - mdyk...@gmail.com - All

Re: how to deal with multiple authors for one book

' by convention as 'order' is a SQL keyword) AUTHORS - authorid - name -- other fields BOOKS - bookid - title -- other fields A2B - bookid - authorid - ordinal -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list

Re: how to deal with multiple authors for one book

On Mon, Feb 16, 2009 at 8:37 PM, PJ af.gour...@videotron.ca wrote: Michael Dykman wrote: On Mon, Feb 16, 2009 at 5:20 PM, PJ af.gour...@videotron.ca wrote: In my db there are a number of books with several authors; so, I am wondering how to set up a table on books and authors to be able

Re: Best RAID for a DB + LVM?

I work for a high-volume web site and we use nothing but RAID 10 on all databases which requires a minimum of 4 disks. The write penalty for raid 5 is just too high for our application. Much of that space goes unused, but we need the stripe to keep up with the I/O. - michael dykman On Sun

Re: insert question

, last_name, ordinal) VALUES ('$first_nameIN', '$last_nameIN', '1'), ('$first_name2IN', '$last_name2IN', '2'); -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL Log and Data directories

spindles.. Separate partitions on the same physical device will be of little-to-no-value. For systems like Oracle or DB2, this is part of the standard installation drill. ON MySQL, I do not do this routinely, but I do when I am expecting high, sustained loads, -- - michael dykman - mdyk

Re: Upgrade large databases from 4.1 to 5.1

changes along the way using a similar slave-driven, process-as-much-as-you-can-in-advance plan. It was excruciating, but we pulled it off. - michael dykman On Tue, Mar 24, 2009 at 9:38 AM, Craig Dunn li...@codenation.net wrote: Baron Schwartz wrote: If you can't take downtime, I'd go

Re: MySQL - facts

. -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Include SQL files

No include is possible, but this is done pretty routinely: cat *.sql | mysql ... - michael dykman On Wed, Apr 1, 2009 at 10:19 AM, Jørn Dahl-Stamnes sq...@dahl-stamnes.net wrote: Hello, After googling for an hour I gave up to find a solution. Problem: A framework is creating a lot of SQL

Re: binlog question

No, I'm afraid not. - michael dykman On Sat, Apr 18, 2009 at 7:11 AM, Uwe Kiewel m...@kiewel-online.ch wrote: Hi, is it possible to have separated binlogs for each mysql-db? Thanks, Uwe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: binlog question

for binlog-do-db - michael dykman On Sat, Apr 18, 2009 at 12:10 PM, Uwe Kiewel m...@kiewel-online.ch wrote: Michael Dykman schrieb: No, I'm afraid not. So, how it's possible to replicate one specific db? I have 4 db's writing into binlog. I need only one of them at client site. After

Re: size of database on disk

this helps. -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How to generate unique primary key in MySQL?

. SELECT uuid(); and produces a guaranteed unique 36 character sitrng, but this might not be very efficient in joins as your dataset grows. - michael dykman On Tue, Apr 28, 2009 at 12:59 AM, yuan edit edit.y...@gmail.com wrote: I have a shopping cart table like this: CREATE TABLE

Re: How to generate unique primary key in MySQL?

LPAD. ie.: mysql SELECT lpad(5,8,'0'); +---+ | lpad(5,8,'0') | +---+ | 0005 | +---+ -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http

Re: expired mysql connection ?

the shutdown event or did it stay stopped? If it did restart, was your perl program able to recognize that and start using it again or did your application stop on first detecting that error? - michael dykman On Sun, May 3, 2009 at 11:21 PM, Randomcoder randomcod...@gmail.com wrote: Hi, I run a Perl

Re: Creating a New DB / User

Your directive looks fine assuming dublin expects to always connect from localhost. One thing though: your user does not need the 'WITH GRANT OPTION' bit as that gives them permission to gratn permissions to other users, which I don't think is what you want. - michael dykman On Wed, May 13

Re: How to copy an statement in Mysql console

console in order to avoid typing it each time you want to fill a new record. I tried to right click my mouse,it doesn't select what I need to highlight. Please,any advice is welcome. What you have at the console is history. Use your up and down arrows.. - michael dykman - mdyk...@gmail.com

Re: Large insert question

connection.  Anyone know what setting I need to tweak to ensure that it can accept large inserts of this size? Thanks, Gary As I recall, max_allowed_packet is what controls that limit. -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General

Re: cannot alter table - rather urgent

but is clearly designed to link 2 other tables. If you are failing to insert or update, it seems likely that it is because the data is absent in the foreign tables. Can you confirm? Because without that forgeign data, these rows are pretty meaningless. What is it you are trying to do? -- - michael

Re: cannot alter table - solved

On Fri, May 22, 2009 at 12:26 AM, PJ af.gour...@videotron.ca wrote: Michael Dykman wrote: On Thu, May 21, 2009 at 11:06 PM, PJ af.gour...@videotron.ca wrote: I have a seemingly impossible situation. I cannot insert values into the tables and I cannot alter or delete the primary key (which

Re: Date Time

at all in your case is because you happen to have + which we can safely ignore. -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: cannot alter table - solved

, 2009 at 3:17 PM, PJ af.gour...@videotron.ca wrote: Michael Dykman wrote: On Fri, May 22, 2009 at 12:26 AM, PJ af.gour...@videotron.ca wrote: Michael Dykman wrote: On Thu, May 21, 2009 at 11:06 PM, PJ af.gour...@videotron.ca wrote: I have a seemingly impossible situation. I cannot insert values

Re: mysql error 2013 Lost connection to MySQL server during query

data. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General

Re: mysql error 2013 Lost connection to MySQL server during query

...@computer.org wrote: Per Jessen wrote: Michael Dykman wrote: Have you tried running the offending SQL manually against you new installation?  Does it come back clean in the isolated case? No, not manually, but the job/the SQL is run several times a day, maybe 2-3 times per hour. I've

Re: mysql error 2013 Lost connection to MySQL server during query

have reacted. - michael On Mon, May 25, 2009 at 12:19 PM, Per Jessen p...@computer.org wrote: Michael Dykman wrote: Given the new hardware, I'm now suspecting the RAID controller. I have seen misconfigured RAIDs or bad RAID drivers take out a server in just such a manner.  I had a debian server

Re: Create function ignore deps

... and then wrote a shell script to fire them off in sort-order. I deliberately used the numbering convention from line-numbered basic to allow me to inject intervening files without having to renumber the set. -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models

Re: Mysterious progress after recovery in MySQL Community Edition 5.1.34

27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Thanks, Mike Spreitzer -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: how to get the timestamp from remote mysql

, but it will work - michael dykman On Sat, Jul 4, 2009 at 2:48 AM, Nathan Huangnathan.vorbei.t...@gmail.com wrote: Hi guys I am going to fetch out the data from remote mysql database according to timestamps colmmen, however my local date is different from the one on remote mysql database, how can

Re: show warnings;

to be guaranteed of consistent behaviour, explicitly ask for what you want. - michael dykman On Mon, Jul 13, 2009 at 8:20 PM, Artie Ziffartie.z...@gmail.com wrote: Hello, I am returning to mysql after long break, so not experienced with details. I inherited a text file with the mysql DDL

Re: Date Translation Issues

. Thoughts? Hagen On 7/14/09 12:44 PM, Michael Dykman mdyk...@gmail.com wrote: Hagan, your premise looks reasonable enough (excepting that your dates must always be in quotes in your insert statement.. the system is expecting a string).. might you show us your schema and perhaps a print-out

Re: Update Syntax

you that if you create a unique key for when ever your 'search' criteria is, you can get this behaviour like so: INSERT INTO mytable SET col1 = val1, ... ON DUPLIATE KEY UPDATE - michael dykman On Sun, Jul 26, 2009 at 1:11 PM, Victor Subervivictorsube...@gmail.com wrote: Hi; I would like

Re: Does InnoDB ever not cluster data by primary key?

/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com --  - michael dykman  - mdyk...@gmail.com Don’t worry about people stealing your ideas. If they’re any good, you’ll have to ram them down their throats!   Howard Aiken -- - michael dykman - mdyk

Re: Mysql batch file help

://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com Don’t worry about people stealing your ideas. If they’re any good, you’ll have to ram them down their throats! Howard Aiken -- MySQL General Mailing

Re: mysqldump warning or actual error?

If you look at the options for mysqldump more closely, you will see that you can specify the version of the server which will be importing the result file. These cause MySQL to taylor the SQL syntax according to the target platform. - michael dykman On Wed, Sep 2, 2009 at 11:03 AM, Matt

Re: HOW TO Backup a mysql innodb on windows?

If I may, If you have foreign keys on your InnoDB, you can still import your data to MyISAM but foreign keys will be lost. Otherwise, the data will load just fine. - michael dykman On Mon, Sep 14, 2009 at 11:14 AM, Todd Lyons tly...@ivenue.com wrote: On Mon, Sep 14, 2009 at 7:44 AM, Néstor

Re: HOW TO Backup a mysql innodb on windows?

A mysqldump will work just fine. By default, that dump is going to explicitly specify the table type .. you will have to edit it if you want to import to MyISAM. - michael dykman On Mon, Sep 14, 2009 at 10:44 AM, Néstor rot...@gmail.com wrote: Maybe one of you experts know the answer. I

Re: incremental name search?

Perhaps this could help you out.. http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_soundex - michael dykman On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer mspre...@us.ibm.com wrote: Suppose I have a table of a few thousand people, with a FirstName field and a LastName

Re: Correct way to start new .MYD .MYI files

Message- From: Michael Dykman [mailto:mdyk...@gmail.com] Sent: Friday, September 25, 2009 3:42 PM To: Jones, Keven Subject: Re: Correct way to start new .MYD .MYI files If you are prepared to accept that any data associated with those tables is *LOST*, it's pretty simple. First try

Re: Correct way to start new .MYD .MYI files

= 0x1F9779FD, 0x319393F4 PGP keys available on request         ICQ 3113529                 O- - On 09/25/2009 04:04 PM, Michael Dykman wrote: Alas, none that I am aware of, but if you can successfully run 'SHOW CREATE TABLE

Re: login issue..pls help

Engines http://dev.mysql.com/doc/refman/5.1/en/storage-engine-compare-transactions.html -- - michael dykman - mdyk...@gmail.com Don’t worry about people stealing your ideas. If they’re any good, you’ll have to ram them down their throats! Howard Aiken -- MySQL General Mailing List For list

Re: No tuples, but AttributeError about tuple!

This looks like much more of a python question than a MySQL question.. I'll reply offline. - michael dykman On Sun, Oct 4, 2009 at 2:04 PM, Victor Subervi victorsube...@gmail.com wrote: Hi; I have the following python code:      sql = 'insert into products values(%s, %s, %s, %s, %s, %s, %s

Re: [OT] Suggestion of query manager

.png Thanks! -- Marcelo de Assis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com Don’t worry about people stealing your ideas. If they’re any

Re: mysqldump Unknown command '\''.

mysqldump is by no means the fastest way to move data between systems. For a bulk job of this magnitude, try this: http://dev.mysql.com/doc/refman/5.1/en/load-data.html - michael dykman On Wed, Oct 14, 2009 at 3:59 AM, Claudio Nanni claudio.na...@gmail.com wrote: We dumped a mysql 4.1.22

Re: Mysql service will not stop

Brian, You could spend a lot of time crawling through version release notes looking for something which might refer to your issue, or you might just upgrade to 5.0.86-0 which is the latest 5.0. There have been close to 2 years worth of bug-fixes since 5.0.51a - michael dykman On Wed

Re: MySQL Cluster / NDB MyISAM mix

I can think of no reason why this shouldn't work, My administrator colleagues would probably beat me with 2x4's for handing them such a delicate construct to maintain in production but it seems perfectly feasible to me :-) - michael dykman On Wed, Oct 14, 2009 at 11:03 AM, Christian Meisinger

Re: Inserting csv

If you could show us the table structure (SHOW CREATE TABLE membership), we could easily correctly the query.. you seems to have some data among your field names... If the question is about the CSV converter, you will have to ask them. - michael dykman On Thu, Oct 15, 2009 at 11:26 AM

Re: replace / insert into with sum not working

] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Trying to open a big sql script

and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong

Re: Stopping Replication

Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http

Re: Research Subjects drawn randomly from databases

| +--+-++--+ 9 rows in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing

Re: Rename or Delete Users

/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

BEFORE trigger abd REPLACE

this is not causing our project any real inconvenience, but it could come as a nasty shock to some. -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Mysterious 'Lost connection' errors

] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysterious 'Lost connection' errors

problems.. When you do find the cause let me know; Im thinking of starting a collection :-) - michael On 5/9/07, Jon Ribbens [EMAIL PROTECTED] wrote: On Wed, May 09, 2007 at 09:22:34AM -0400, Michael Dykman wrote: I realize that's quite unlikely that you have performed a similar sloppy import

Re: Which is a better design?

; (call this C) It is very possible (in the presence of other simultaneous database activity) that A != B + C. It depends on the application whether this is significant. Table locking is the easiest way to prevent this if it matters. Dave. -- - michael dykman - [EMAIL PROTECTED] - All

Re: table not found

t1.f1=table1.f1 order by date desc limit 1 ) t2 Then everything together - which ones work and which ones break ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED

Fwd: Issue with locking and INSERT DELAYED

] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: index overhead

if it was a postive int field) and force it to use the previous index. Long email. Thanks for reading it and getting to this point. :o) Les -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael

Re: Replicating an existing table

the structure of an existing table and giving it a different name? I have a table of items on sale in the shops, I want to create a table of items not yet in the shops but due to be introduced very soon. MySQL 5.0.37 Windows XP. Thanks in advance. Jonathan Trahair -- - michael dykman - [EMAIL

Re: stored procedure not working in legacy ASP

response.write Thanks -- David Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List

Re: stored procedure not working in legacy ASP

? -- Dave Michael Dykman wrote: Surely, you don't have legacy stored procedure in ASP under MySQL? are you sure this is the right list to be asking? - michael On 5/30/07, Critters [EMAIL PROTECTED] wrote: Hi How do you get multiple record sets from a stored procedure in legacy ASP? It doesn't

Re: mysql_init segmentation fault

for all the help, Sam On 6/5/07, Michael Dykman [EMAIL PROTECTED] wrote: It looks like you application bailed while trying to resuolve the server address, but the nature of the dump looks to me like some kind of build error..did you build libmysql.so yourself or is this a binary download from

Re: Mysql 5.0.* client connection to Mysql 4.0.* Database

to connect to a 4.0.18 DB from the client of a 5.0.27 system? I know there is an old_passwords function. Can this be used somehow from a DOS command prompt? David -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list

String Locks

I saw mention of something called string locks in an earlier thread, yet I see nothing like it in the mysql documentation. Could somebody please point me at a reference? -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List

  1   2   3   4   5   >