Re: questions about timestamps and DST

not interchangeable, and not intended to be. Mark -- http://www.markgoodge.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: forum vs email

infrequently and don't want to have to subscribe in order to do so. But all this should, IMO, be in addition to the core features of an email mailing list, rather than a replacement for them. Mark -- http://www.markgoodge.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com

column aliases in query

= 2012-10-11 Where I've aliased the SUBSTR of the date and then used the alias in the WHERE clause of the query. I'm getting an error message now, but I'm almost certain I've used that syntax before. Am I missing something? -- Mark Haney Software Developer/Consultant AB Emblem ma

Re: Need Help Converting Character Sets

? Thanks, Mark On Fri, Sep 28, 2012 at 7:59 AM, Rick James rja...@yahoo-inc.com wrote: Thanks for that link! That's another subtle issue I had not noted. There are so many combinations, that it is hard to say do this: * Incoming bytes are latin1 / utf8 / Microsquish control characters

Need Help Converting Character Sets

an apostrophe had been converted into a question mark. (FWIW, the apostrophe was one of those offending non utf-8 characters): Before conversion: I stepped into the observatory’s control room ... After conversion: I stepped into the observatory?s control room... Is there a better way to accomplish my first

InnoDB vs. other storage engines

to something else so I can optimize the tables on a regular basis. Is it worth the effort? Any caveats? I've never really encountered this situation before and I'm curious to see what others have to say on it. Thanks in advance. -- Mark Haney Software Developer/Consultant AB Emblem ma

Re: Create a VIEW with nested SQL

with Vicodin, I'm no House. I can't function 100% on pain meds. I'll take a look at this, and if I need any help, I'll holler, but this looks really good at the moment. Thanks. -- Mark Haney Software Developer/Consultant AB Emblem ma...@abemblem.com Linux marius.homelinux.org 3.5.1-1.fc17.x86_64

Re: Create a VIEW with nested SQL

for only 2 machines when I'll have 40+ at production time. All I need is the most recent record for EACH machine ID, THEN to pull the machine name from the table that has the name in it. Somehow I'm missing something incredibly obvious here. -- Mark Haney Software Developer/Consultant AB Emblem

Create a VIEW with nested SQL

soaked brain (I have a torn rotator cuff and tendon in my shoulder) that I should hit the list before I go any farther. So, what's the best way, or the most common way to deal with this issue. I'll be happy to clarify anything in here that doesn't make sense. Thanks in advance. -- Mark

Unique index - opinions sought

that, because the content of item_spine has to be updated on a regular basis from external data and using autoincrement means I can't do that using REPLACE INTO while still maintaining a key association with item_detail. Any thoughts? How would you do it? Mark -- Sent from my Turing-Flowers Colossus

Re: Unique index - opinions sought

much faster) Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Trying to compile mysql 5.5 on Ubuntu 12.04

and honestly haven't found any difference. There may be some difference at really like transaction levels, but my DBs run pretty much the same compiled with either. YMMV. -- Mark Haney Software Developer/Consultant AB Emblem ma...@abemblem.com Linux marius.homelinux 3.4.2-1.fc16.x86_64 GNU

Re: SQL query help. Retrieve all DVDs that have at least one scene of a certain encoding format

AND b.format_id = '13'; or am I misunderstanding something? Cheers, Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Postal code searching

in a separate column. Mark -- Sent from my ZX Spectrum HD http://mark.goodge.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

OT: SQL Question

teacher_id and the data in the flights table. I need to change the data model to allow for a many to many relationship between teacher_id and the data in the flight table. What is the best way to do this? Thanks, Mark

Re: One inst has 39 columns- the other 40

. No, the problem is not unique to your site. It's an easy mistake to make. Please could you now give some indication of having read and understood this reply. Mark -- Sent from my Babbage Difference Engine 2 http://mark.goodge.co.uk -- MySQL General Mailing List For list archives: http

errors running WHILE loop

I've had a DEVIL of a time with this problem and I'm sure it's something simple, but I can't find it anywhere in the documentation or online what the problem is. Let me explain. I cannot get any WHILE loop to work from either a CLI or a script on MySQL 5.1.41. For example, this is a simple

Re: In case you all missed it.

:%s') :-) Mark -- Sent from my Babbage Difference Engine http://mark.goodge.co.uk http://www.ratemysupermarket.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

One database per server architecture

Architecture question I'm having trouble finding an answer to: I run four WordPress websites. I have mysql setup in a write master/read replica slave configuration on Amazon. There is one master that all the WordPress instances write to. I'm trying to figure out how to setup the read replicas.

RE: mysql server does not recognize user password

Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session? - Mark -Original Message- From: Tim Johnson [mailto:t...@akwebsoft.com] Sent: woensdag 19 oktober 2011 1:02 To: MySQL ML Subject: mysql server does not recognize user password using 5.1.57 on Mac Lion. blush I've

Re: One database per server architecture

, Mark, Ryan rm...@tribune.com wrote: Architecture question I'm having trouble finding an answer to: I run four WordPress websites. I have mysql setup in a write master/read replica slave configuration on Amazon. There is one master that all the WordPress instances write to. I'm trying

Re: Databasename/Tablename is marked as crashed and should be repaired

) then you may have problems with the hardware - with the disk itself. Mark -- Sent from my Babbage Difference Engine http://mark.goodge.co.uk http://www.ratemysupermarket.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Doubt regarding Mysqlsump

Hi We use the --single-transaction switch thinking it does less locking or waiting for a required table lock. You then get a snapshot without stopping. Subject should have included the word 'hot'? Looking forward to other suggestions. Mark On 2011/06/07 08:00, Adarsh Sharma wrote: Dear all

Allowing all users to access a specified database

needing to have access to each site's own database. Clues, anyone? Mark -- Sent from my Babbage Difference Engine http://mark.goodge.co.uk http://www.ratemyairport.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Allowing all users to access a specified database

? 5.0.7 Mark -- Sent from my Babbage Difference Engine http://mark.goodge.co.uk http://www.ratemyairport.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: ` vs '

more clear :-) Mark -- http://mark.goodge.co.uk http://www.ratemysupermarket.com -- 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 protect primary key value on a web page?

is pointless and misdirected. Cheers, Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Auto-Increment Values in Mysql

`; ALTER TABLE `mytable` ADD `myfield` INT NOT NULL AUTO_INCREMENT PRIMARY KEY; Mark -- http://mark.goodge.co.uk http://www.ratemysupermarket.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: CURRENT insert ID

, in PHP: mysql_query(insert into mytable set name = 'foo'); $id = mysql_insert_id(); the value of $id will be the auto-increment number from the line you just inserted. Mark -- http://mark.goodge.co.uk http://www.ratemysupermarket.com -- MySQL General Mailing List For list archives: http

Re: Bulk Insertion Performance

On Dec 14, 2010, at 7:21 PM, Feris Thia wrote: Hi Mark, On Wed, Dec 15, 2010 at 8:10 AM, Mark Matthews mark.matth...@oracle.com wrote: Feris, *How* are you writing, via batch statements with rewriting, or directly, or via LOAD DATA INFILE? It seems you're off by about a factor of 10

Re: Bulk Insertion Performance

, or directly, or via LOAD DATA INFILE? It seems you're off by about a factor of 10-20x from what I've seen performance-wise for writes. -Mark -- Mark Matthews Principal Software Developer - MySQL Enterprise Tools Oracle http://www.mysql.com/products/enterprise/monitor.html

Lowest non-zero number

Given a table containing a range of INT values, is there any easy way to select from it the lowest non-zero number? Obviously, MAX(column) will return the highest, but MIN(column) will return 0 if any row contains a 0, which isn't what I want. Any clues? Mark -- http://mark.goodge.co.uk

Re: Lowest non-zero number

On 03/12/2010 16:56, Paul Halliday wrote: On Fri, Dec 3, 2010 at 12:50 PM, Mark Goodgem...@good-stuff.co.uk wrote: Given a table containing a range of INT values, is there any easy way to select from it the lowest non-zero number? SELECT number FROM table WHERE number 0 ORDER BY number ASC

Possible causes of table crashing

the databases use MyISAM exclusively. Given the above, can anyone suggest any possible causes? Thanks Mark -- http://mark.goodge.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: backfill results for the same month and year

) as MONTHYEAR, sum(QTY) as TOTAL from MYTABLE group by concat(ID,MONTH,YEAR) Mark -- http://mark.goodge.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Order by in clause

| title | +--+-+ | 10 |foo | +--+-+ | 3 |baz | +--+-+ | 8 |bar | +--+-+ | 5 | wibble | +--+-+ | 1 | flirble | +--+-+ Is this possible? If so, how? Mark -- http://mark.goodge.co.uk -- MySQL

Re: SELECT WHERE IN help

possible. Why do you want a duplicate record to be retrieved? There may be a better way of doing it. Mark -- http://mark.goodge.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Best method to keep totals

should, of course, be not only identical to each other but also to the sum of the individual items, so there is not only duplication but the potential for skew. But that, of course, is precisely *why* you store them, as any discrepancy indicates an error which needs to be investigated. Mark -- http

Re: Performing subtraction between fields

mytable SET C = A - B http://dev.mysql.com/doc/refman/5.1/en/numeric-functions.html Simples :-) Mark -- 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 use SSL? (SSL is enabled but not used)

worth, the MySQL JDBC driver has had client-side SSL require (i.e. requireSSL=true) since 2003 and the ADO.Net driver has had SSL Mode=Required since 2009. -Mark -- Mark Matthews Principal Software Developer - MySQL Enterprise Tools Oracle http://www.mysql.com/products/enterprise

Re: searching serialized data stored in mysql

per cart, and then a separate cart_contents table with one line per product and a cart_id column which links it to the cart table. That also allows a separate cart_address table which can have multiple addresses per cart (eg, billing address, delivery address). Mark -- http://mark.goodge.co.uk

Re: Need Help Writing Simple Query

On Sun, Jul 25, 2010 at 8:49 PM, Nguyen Manh Cuong cuong.m...@vienthongso.com wrote: Hi Mark, Please test this query: select test1.*, (select name from test2 where test2.id=test1.`v_id` limit 1) as name_1, (select name from test2 where test2.id=test1.`h_id` limit 1) as name_2 from test1

Need Help Writing Simple Query

C Thanks! Mark

Re: Help me

://dev.mysql.com/doc/refman/5.1/en/fulltext-restrictions.html Mark -- http://mark.goodge.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Decimal points

don't have built-in functions to do this, it's a trivial piece of code to recreate it. Mark -- http://mark.goodge.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL Replication

doesn't provide it natively. See the replication FAQ for more information: http://dev.mysql.com/doc/refman/5.1/en/replication-faq.html Mark -- http://mark.goodge.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: substring query

SUBSTRING_INDEX('myfile.pth','.',-1) = 'pth' or, in a version that's closer to real life usage: SELECT SUBSTRING_INDEX(myfield,'.',-1) from mytable http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substring-index Mark -- http://mark.goodge.co.uk -- MySQL General Mailing List

Re: Master - master replication

to implement them. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Array data type

for storing the array values separately using the appropriate table design where you do need to run queries against it. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Fulltext Match BOOLEAN MODE not searching integers

, so will never match. Blue, on the other hand, is indexed and therefore is returned by a search. The default minimum word length is four characters. See http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html for more information on how to change that if necessary. Mark -- MySQL

Re: mysql proxy in production?

supposed to use for loadbalancing mysql. Thank you for your reply. Kind Regards Brent Clark Brent, Some clients (namely the JDBC driver, and the R-O-R adapter) have load balancing built in. -Mark -- Mark Matthews Principal Software Developer - Enterprise Tools Oracle http

Re: Possible to find this duplicate?

a substring_index on the Author column. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Good source for sample data?

have the same problem for US or Canadian data. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Good source for sample data?

/ for a topical twist on this) Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Problem starting connection pooling

missing? What is going on here? How do I fix it? -Do I need to create a foo user in the tomcat-users.xml? -Do I have to mess with the policy files? or security? Thanks for your help. Mark No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.432 / Virus Database

Re: Problem starting connection pooling

On Jan 22, 2010, at 10:21 AM, Mark Witczak wrote: [snip] I create the WAR (jar cvf testapp.war *), undeploy the old version and redeploy the new one through Tomcat Web Application Manager. Then restart Tomcat (sudo /etc/init.d/tomcat restart). The result is: Jan 21, 2010 9:40:35 PM

Re: Problem starting connection pooling

11:38 AM, Mark Matthews wrote: On Jan 22, 2010, at 10:21 AM, Mark Witczak wrote: [snip] I create the WAR (jar cvf testapp.war *), undeploy the old version and redeploy the new one through Tomcat Web Application Manager. Then restart Tomcat (sudo /etc/init.d/tomcat restart). The result

Re: Problem starting connection pooling

On Jan 22, 2010, at 10:49 AM, Mark Witczak wrote: Alright, here is the entire log entry: Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log INFO: ContextListener: contextInitialized() Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log INFO

Re: Problem starting connection pooling

skip-networking is OFF On 1/22/2010 12:09 PM, Mark Matthews wrote: On Jan 22, 2010, at 10:49 AM, Mark Witczak wrote: Alright, here is the entire log entry: Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log INFO: ContextListener: contextInitialized() Jan 21, 2010 9

Re: Record old passwords ?

doesn't alter the need to comply with them - at least, not if you want to be able to use their payment APIs. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Record old passwords ?

within the past N days, for whatever value of N you prefer. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Record old passwords ?

that is inflexible and generally bad database design. I'd be somewhat surprised if PCI compliance really did require it. Mark -- http://mark.goodge.co.uk - blog htp://www.good-stuff.co.uk - stuff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: last_insert_id

inserted id will still be 10, not 6. Mark -- http://mark.goodge.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Join Statement

tem126080739853 t join products p on t.ProdID=p.ID Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Update Doesn't Update!

at the message, 0 rows changed and 1 warning. You cannot have ID=0 if ID is an index. You can, but not if it's an auto-increment field. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysqldump vs phpmyadmin dump

on Apache, although the administrators can change that). But the source of the file is irrelevant; so long as it's within the file upload limit then it doesn't matter whether it was exported by phpMyAdmin itself or created using mysqldump from the command line. Mark -- MySQL General Mailing List

Re: Questions on Database Design

Thanks to Martin and John for their help! Mark On Sat, Oct 3, 2009 at 5:53 PM, Martin Gainty mgai...@hotmail.com wrote: enforcing by username/password to the DB is your safest method and if you want to really be safe put ssh access onto the MySQL Server here is how to install SSH and MySQL

Questions on Database Design

into one database (ie one set of tables) and with multiple userIDs? 10 users? 1,000 users? Never? Thanks! Mark

Re: Questions on Database Design

On Sat, Oct 3, 2009 at 2:47 PM, John Meyer john.l.me...@gmail.com wrote: Mark Phillips wrote: I am new at database design, and my question relates to the trade-offs between putting all data in one database or several for mysql. For example, say I have an application where a users login from

Re: Questions on Database Design

a where userID=xxx clause? Mark Date: Sat, 3 Oct 2009 14:38:25 -0700 Subject: Questions on Database Design From: To: mysql@lists.mysql.com I am new at database design, and my question relates to the trade-offs between putting all data in one database or several for mysql

Re: Questions on Database Design

for separate databases? Mark Are the actions of a similar nature (i.e. they're all writing the same type of data and the databases themselves would be similar if not the same)? Each user will write the same type of data to the same schema. So the databases schemas would be identical. Is there any

Re: Another Join Problem

products.ID, Item FROM products JOIN categories ON categories.ID = products.Category LIMIT 0 , 30; Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Wierd PHP/MySQL result

is elsewhere in the code. I suspect that the problem is in the json_encode() function. According to the PHP documentation this requires utf8-encoded data. If your values in oname are not utf8, then that may explain why the function is returning a 'null' where it should have a string. Mark

Re: How to compare 2 columns in different tables.

are defined as VARCHAR. Does anyone have an answer to this? I, too, would like to know how to use fulltext to compare data between two columns (as opposed to comparing data between a column and a pre-defined string). Is there any way to do this? Mark -- MySQL General Mailing List For list archives

Fulltext query expansion query

? Thanks Mark -- Stuff: http://www.good-stuff.co.uk Blog: http://mark.goodge.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Join

Join -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Problems After MySql 5.1.34

upgrading PostgreSQL, or BerkeleyDB, etc. It's just the nature of the beast. - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Problems After MySql 5.1.34

Depends on your OS, I guess. On FreeBSD you can just go to the 'php5-extensions' port, run a 'make config', and deselect everything but the MySQL extension. Then it will only build mysql.so for you. Very easy. :) - Mark From: Martin Gainty [mailto:mgai...@hotmail.com] Sent

RE: 1135: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

into this. - Mark -Original Message- From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] Sent: woensdag 29 april 2009 8:14 To: Mark; mysql@lists.mysql.com Subject: Re: 1135: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual

RE: Information Schema

; ++ | Database | ++ | information_schema | | hgallery | ++ 2 rows in set (0.00 sec) mysql Ok, so how do I disable that? - Mark -Original Message- From: John Daisley [mailto:john.dais...@mypostoffice.co.uk] Sent: woensdag 29 april 2009

Re: Start MySQL with --intit-file?

i dont think that the init.d script will accept the argument. you need to run /usr/bin/mysqld_safe --init-file=clouds.sql (or whatever the path to mysqld_safe is) 2009/4/29 Jason Todd Slack-Moehrle mailingli...@mailnewsrss.com Hi Guys, i am still lost here: GRANT ALL ON mysql.* TO

RE: 1135: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

(and 'sysctl' it to higher if it's not sufficient). I'm always amazed how much open files MySQL keeps. The amount of files MySQL reserves, way I recall, is also directly related to max. connections; so you could lower that too, temporarily, to see if it makes the error go away. - Mark -Original

RE: 1135: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

to Jörg's expertise on the matter. :) - Mark -Original Message- From: Martin Gainty [mailto:mgai...@hotmail.com] Sent: dinsdag 28 april 2009 14:44 To: Joerg Bruehe; maan...@gmail.com Cc: ad...@asarian-host.net; mysql@lists.mysql.com Subject: RE: 1135: Can't create a new thread (errno 35); if you

Re: Start MySQL with --intit-file?

hey jason, you need to restart the *server* with the init-file option, have a look at: http://dev.mysql.com/doc/refman/5.0/en/server-options.html 2009/4/28 Jason Todd Slack-Moehrle mailingli...@mailnewsrss.com I am trying to start MySQL with --init-file but i get that it is an invalid

RE: Error : Incorrect key file for table 'X'

crashes. - Mark From: zhu dingze [mailto:mysql.li...@gmail.com] Sent: zondag 26 april 2009 16:40 To: Mark Cc: mysql@lists.mysql.com Subject: Re: Error : Incorrect key file for table 'X' Hey Dude, So many errors imply that there are some issues with your meta_data other than

SOLVED! (was: RE: Error : Incorrect key file for table 'X')

. After that, the import succeeds, and all errors are gone. Odd. It's been quite quiet on this list of late. I expected at least someone to know the answer. If this is indicative of people's interest in MySQL these days, then maybe it really IS a good idea to start using PostgreSQL. - Mark

RE: Error : Incorrect key file for table 'X'

C'mon, guys, there's gotta be someone who knows something about this. :) Anyone? Anyone? Bueller? Bueller? I even did a complete mysqldump (from the 5.0.77 mysqld) and imported it that way. To no luck, alas. Thanks, - Mark -Original Message- From: Mark [mailto:ad...@asarian-host.net

Error : Incorrect key file for table 'X'

any idea what's happening? Thanks, - Mark Repairing tables albatross.banned Error: Incorrect key file for table 'banned'; try to repair it error: Corrupt albatross.bridge Error: Incorrect key file for table 'bridge'; try to repair it error: Corrupt

RE: A good US Hosting Site?

Okay, does anyone know of a hosting site that supports 'Image::Magick'? (the Perl package). The salesrep at AwardSpace said they didn't have it. P.S. This is probably getting a mite off-topic. So, feel free to reply to me off-list, if you happen to know the answer. Thanks, - Mark -- MySQL

RE: A good US Hosting Site?

-Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: maandag 20 april 2009 10:28 To: p...@pwilson.net Cc: mysql@lists.mysql.com; Cameron Rogers; step...@kionic.com Subject: Re: A good US Hosting Site? www.awardspace.com I have both free and paid hosting and it

RE: A good US Hosting Site?

-Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: maandag 20 april 2009 17:22 To: Mark Cc: mysql@lists.mysql.com Subject: Re: A good US Hosting Site? Well, not a joke for free hosting. But it is, for me, by far the best hosting site. Compleat, easy

RE: A good US Hosting Site?

-Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: maandag 20 april 2009 22:29 To: Mark Cc: mysql@lists.mysql.com Subject: Re: A good US Hosting Site? Mark wrote: Yeah, but a Maximum file size limit 500 KB, what can you do with that?? Your average

RE: MySQL runs on 16-cores server

to have is the Hyperdrive 5 from http://www.hyperossystems.co.uk/. It is a DDR SSD and each drive has slots for 8 DIMM's which means it can hold up to 32GB (64GB if you can find 8GB DDR2's) per drive. Too bad these aren't SCSI drives, so they could be used with Vmware ESX 3.5. - Mark

Re: if there're a tool which can replace mysql-proxy?

changing) state, and also to provide input into the direction of the developers. Best regards, -Mark -- Mark Matthews, Architect - Enterprise Tools MySQL @ Sun Microsystems, Inc., http://www.sun.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Mysqld fails to start

to run mysql_upgrade to fix the missing table problem (which is a warning, not a fatal error, hence why you need to have the server running to be able to fix it). Mark -- http://www.good-stuff.co.uk - Stuff, some of it good -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Optimizing nullable expiration dates

expiration dates with NOW() if they can be in the future - which, from your description, isn't possible. If an expiry date can be either future, past or non-existent, then your existing selector is as good as any. Mark -- http://mark.goodge.co.uk - my pointless blog http://www.good-stuff.co.uk

Re: normalised designs: customer database

that the database design reflects your actual workflow and business requirements. Having a field that's empty 50% or more of the time is far less of a problem than not being able to process a sale because your database structure is too inflexible :-) Mark -- http://mark.goodge.co.uk - my pointless blog http

Re: Most efficient way of handling a large dataset

Joerg Bruehe wrote: Hi Mark, all! Mark Goodge wrote: I'd appreciate some advice on how best to handle a biggish dataset consisting of around 5 million lines. At the moment, I have a single table consisting of four fields and one primary key: partcode varchar(20) region varchar(10) location

Most efficient way of handling a large dataset

have any suggestions? My initial thought is to replace the region and location varchar fields with int fields keyed to a separate list of region and location names. Would that help, or is there a better way? Mark -- http://mark.goodge.co.uk - my pointless blog http://www.good-stuff.co.uk - my

Re: quick question on innodb_log_file_size

(log_file_size, innobase_log_file_size, The docs are wrong - I'll have that updated. Best regards Mark -- Mark Leith MySQL Regional Support Manager, Americas Sun Microsystems, Inc., http://www.sun.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

  1   2   3   4   5   6   7   8   9   10   >