Re: characters oddity

If you insert new records (or update existing) containing correct UTF-8 data to the production database using a mysql client, does the data save correctly? Could it be your data source for the production database has/is incorrectly handling the charset prior to the data being stored in the

Re: dump, drop database then merge/aggregate

or whatever ingest it, allowing for your business logic for data validate/etc to be done in code (IMO where it belongs). S On Mon, Feb 29, 2016 at 12:12 PM, lejeczek <pelj...@yahoo.co.uk> wrote: > On 29/02/16 16:32, Steven Siebert wrote: > >> What level of control do you have

Re: dump, drop database then merge/aggregate

Totally with you, I had to get up and wash my hands after writing such filth =) On Mon, Feb 29, 2016 at 12:14 PM, Gary Smith <li...@l33t-d00d.co.uk> wrote: > On 29/02/2016 16:32, Steven Siebert wrote: > >> >> At risk of giving you too much rope to hang yourself: if you

Re: dump, drop database then merge/aggregate

What level of control do you have on the remote end that is collecting/dumping the data? Can you specify the command/arguments on how to dump? Is it possible to turn on binary logging and manually ship the logs rather than shipping the dump, effectively manually doing replication? I agree with

Re: can I just encrypt tables? what about the app?

Simple answer is no. What are you trying to accomplish? S On Mon, Feb 29, 2016 at 8:31 AM, lejeczek wrote: > hi everybody > > a novice type of question - having a php + mysql, can one just encrypt > (internally in mysql) tables and php will be fine? > If not, would it be

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

The error is stating that your innodb log sequence is higher that that of the actual data files...any chance your data partition is full after your restore? On Fri, Jan 22, 2016 at 3:23 PM, Neil Tompkins wrote: > Hi, > > Hoping someone can help me identify why I

Re: XML to RDB

: Larry Martell larry.mart...@gmail.com To: Steven Siebert smsi...@gmail.com Cc: mysql mailing list mysql@lists.mysql.com Sent: Friday, 22 November, 2013 3:17:44 PM Subject: Re: XML to RDB Yes, I will need to query the data, and yes, it's app specific to the data. The parent-node

Re: XML to RDB

Hi Larry, I'm trying to figure out what your wanting to do with the data once its in mysql? At first it seemed you didn't want to put it in as a lob because you might want to query on the data in different ways (kind of an assumption on my part, but a common reason to do this). Then, you

Re: Session ID Generation

12:48, Steven Siebert wrote: You stated these IDs are sequential...do you know if there is any way to modify this to utilize a random generation? Sequential session IDs are an avenue to session hijacking. as a MySQL client session is bound to a specific TCP connection ... how would being

Re: Session ID Generation

On Fri, Jun 21, 2013 at 7:58 AM, Denis Jedig d...@syneticon.net wrote: Steven, Am 21.06.2013 13:35, schrieb Steven Siebert: If the TCP connection is lost...is the effectively session over and can not be re-established on another socket? Yes. In a mysql client sense, I would need

Re: Session ID Generation

suspect, however, that you're looking for session IDs as used by websites -generation of those is entirely not a mysql issue, it is only a potential store for them. Steven Siebert smsi...@gmail.com wrote: Hello all, I've looked though, what I believe to be, the relevant areas in the MySQL

Session ID Generation

Hello all, I've looked though, what I believe to be, the relevant areas in the MySQL docs as well as standard search engine searches without luck. I was hoping to find some documentation that would tell me: - how MySQL session Ids are generated (specifically, are they considered random) -

RE: [Possible Spam]Php programmer

-Original Message- From: ratlhaga...@yahoo.com [mailto:ratlhaga...@yahoo.com] Sent: September 18, 2012 7:31 AM To: mysql@lists.mysql.com Subject: [Possible Spam]Php programmer Hi, I need help, I'm working on a project that need time query in Mysql. I want to display a time in

RE: function INTERVAL in view

-Original Message- From: Rick James [mailto:rja...@yahoo-inc.com] Sent: September 17, 2012 3:04 PM To: peter.braw...@earthlink.net; mysql@lists.mysql.com Subject: RE: function INTERVAL in view INTERVAL is a keyword. This is probably the root of the hiccup. Is that your Stored

RE: Mysql is toying me... why sometimes an insert or update can be slow!? I getting bald cuz this

-Original Message- From: Andrés Tello [mailto:mr.crip...@gmail.com] Sent: May 12, 2012 10:08 AM To: mysql Subject: Mysql is toying me... why sometimes an insert or update can be slow!? I getting bald cuz this While doning a batch process... show full processlist show: | 544

RE: How to quickly detect if there are any crashed tables

AFAIK the tables will be locked one by one until checked/repaired. On May 10, 2012, at 3:07 PM, Adrian Fita wrote: On 10/05/12 21:51, Mihail Manolov wrote: You can enable check/recovery automatically by using myisam_recover. Look it up in the documentation. There is no way to

Group_Concat help...

Hello! I am trying to do something, but I can't seem to figure out how... My query is as follows: SELECT `user_id`, GROUP_CONCAT(DISTINCT `login_ip`) AS 'login_ips', COUNT(`id`) AS 'connections' FROM `mysql_test` WHERE `login_datetime` BETWEEN '2012-03-19 00:00:00' AND '2012-03-19 23:59:59'

RE: Group_Concat help...

-Original Message- From: Mihail Manolov [mailto:mihail.mano...@liquidation.com] Sent: March 19, 2012 12:44 PM To: Steven Staples Cc: mysql@lists.mysql.com Subject: Re: Group_Concat help... Try this SELECT `user_id`, `login_ip`, COUNT(`id`) AS 'connections' FROM `mysql_test

MySQL Session Variables with PHP

shell() command instead, but I would rather avoid that if at all possible. Thanks in advance! Steven Staples -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

RE: MySQL Session Variables with PHP

-Original Message- From: Peter Brawley [mailto:peter.braw...@earthlink.net] Sent: February 22, 2012 11:07 AM To: Steven Staples; mysql@lists.mysql.com Subject: Re: MySQL Session Variables with PHP On 2/22/2012 9:47 AM, Steven Staples wrote: Good [insert time of day here] all

Relication Issues

Good morning list, I am having issues with my replication setup. it seems that every few weeks/months something happens, and I have to restart it, skip a row, or delete, rsync and restart replication from scratch. The databases that are being replicated, are rather large... there are about 12

RE: Relication Issues

: November 10, 2011 8:42 AM To: mysql@lists.mysql.com Subject: Re: Relication Issues replication is buggy sometimes but without any outputs desribing your problem nobody can really help you - memory tables as example are making much more troubles as myisam Am 10.11.2011 14:26, schrieb Steven

RE: dynamic alias?

DATE_ADD(NOW(), INTERVAL 1 DAY) will give you tomorrow... Not sure if that is what you're looking for or not... Steven Staples -Original Message- From: Eric Bloomquist [mailto:eric_bloomqu...@cooley-dickinson.org] Sent: August 27, 2010 12:17 PM To: mysql@lists.mysql.com Subject

RE: Reduce dataset but still show anomalies

I am not too good with charting (even though I would like to be), but what about getting the max, min and avg, if the max/min is greater than x% of the avg, show that... ? Just throwing out ideas... prolly not useful... but may cause a better idea ;) Steven Staples -Original Message

RE: Reduce dataset but still show anomalies

On another thought, what about if you group it by whatever, if the MIN()/MAX() is greater than X times STDDEV(), show MIN() or MAX() ? I just recalled a conversation with my boss the other week about the STDDEV() Steven Staples -Original Message- From: Steven Staples

query help

I am hoping that I can do this with one query, I have a table, Domains with 3 columns accountID, domainID, mailname what I am trying to do is find all accountID's for domainID of 12345 and see if a second row with domainID of 54321 exists for that accountID,mailname. If it doesn't exist, I

RE: Moving from one MySQL server to three MySQL servers?

, before adding to it. Steven Staples -Original Message- From: Nunzio Daveri [mailto:nunziodav...@yahoo.com] Sent: August 4, 2010 2:40 PM To: mysql@lists.mysql.com Subject: Moving from one MySQL server to three MySQL servers? Hello Gurus :-)  I was running a simple load generator

RE: [MySQL] Re: Decimal points

FLOOR() CEIL() or ROUND() SELECT ROUND(1+1.6, 0); = 3 SELECT FLOOR(1+1.6); = 2 SELECT CEIL(1+1.6); = 3 Steven Staples -Original Message- From: Ashley M. Kirchner [mailto:ash...@pcraft.com] Sent: July 20, 2010 1:52 PM To: mysql@lists.mysql.com Subject: Re: [MySQL] Re: Decimal points

RE: Why is MySQL always linked to Php?

care of the mysql as well? Steven Staples -Original Message- From: alba.albetti [mailto:alba.albe...@libero.it] Sent: July 15, 2010 10:00 AM To: mysql Subject: Why is MySQL always linked to Php? Browsing the Web I've seen that usually companies look for developers working

RE: phpMyAdmin and other management tools

incase you're locked out of it somehow, or if you need to repair, backup or create users. But if you're a windoze user, 99% of them don't know what a command line is :) Steven Staples -Original Message- From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Sent: July 1, 2010

RE: Two Primary Keys

on, where I've done this, but done it in code, rather than in mysql. Steven Staples -Original Message- From: Dušan Pavlica [mailto:pavl...@unidataz.cz] Sent: June 29, 2010 11:26 AM To: Victor Subervi Cc: mysql@lists.mysql.com Subject: Re: Two Primary Keys Hi, try

MySQL Upgrading

)?granted, this is not the debian mailing list, just thought I would ask that last part ;) Steven Staples -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Table Consistency/analize/check/repair

. Thanks in advance, Steven Staples -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

analyze table issue

long... Can I just kill it, or will it corrupt the table it is currently on? Steven Staples -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: analyze table issue

Nevermind, it just finished... holy uggh! Steven Staples -Original Message- From: Steven Staples [mailto:sstap...@mnsi.net] Sent: June 18, 2010 2:31 PM To: mysql@lists.mysql.com Subject: analyze table issue Ok, I know I am an idiot sometimes, and I think this falls

RE: Strange GREATEST() result in 5.0.32

, and is replicating 3 other servers). So, all the sql databases will have to be updated/upgraded, but is there anything I/we should be made aware of before we go ahead? (there is a lot of release notes to sift through) Steven Staples -Original Message- From: baron.schwa...@gmail.com

RE: WHERE clause from AS result

Putting the 'HAVING' in there, works perfectly :) THANKS! Steven Staples -Original Message- From: SHAWN L.GREEN [mailto:shawn.l.gr...@oracle.com] Sent: June 10, 2010 8:03 PM To: Steven Staples Cc: 'MySql' Subject: Re: WHERE clause from AS result On 6/10/2010 4:38 PM, Steven

WHERE clause from AS result

%'; It gives me this error: Error Code : 1054 Unknown column 'pnum' in 'where clause' Any ideas? Steven Staples -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Help needed on query on multiple tables

`.`progress` 0; Granted, you have not provided structure or names of the tables so this is just my interpretation, but maybe something like this could give you a starting point? Steven Staples -Original Message- From: Michael Stroh [mailto:st...@astroh.org] Sent: June 3, 2010 11:24 AM

RE: Help needed on query on multiple tables

I am glad that I was able to help someone finally :) There may be other ways to do this, but that was what first came to mind. I would maybe run an explain on that query to ensure that it is using indexes. Steven Staples -Original Message- From: Michael Stroh [mailto:st

Strange GREATEST() result in 5.0.32

anything wrong. Also, upgrading from 5.0.32 would require upgrading both the master and slave, and right now, that is not a good idea (we are discussing it though) Steven Staples -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

RE: Using RAND to get a unique ID that has not been used yet

If you wanted to use/go that route, then why not select a random limit 1 from that table, and then delete that row? SELECT `column` FROM `table` ORDER BY RAND() LIMIT 1; On a side note, I would use the auto-inc field still, and store this number in another field. Steven Staples

RE: Obtain week number between years

taken off the top of my head, but it should give something that you're looking for... hopefully ;) ) Steven Staples -Original Message- From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf Of Baron Schwartz Sent: April 29, 2010 8:34 AM To: MySql Subject: Re

RE: Join syntax problem

ON (table1.field=jointable.field) rather than just ON (field). And on a final thought, the where cause, seems to be the join clause as well, so isn't that redundant? (or is would that only be in the way that i said i do my joins?) ++ | Steven Staples

RE: subquery multiple rows

://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_grou p-concat SET [GLOBAL | SESSION] group_concat_max_len = val; Steven Staples -Original Message- From: kalin m [mailto:ka...@el.net] Sent: April 7, 2010 12:59 PM To: Nathan Sullivan Cc: mysql@lists.mysql.com Subject: Re

Table Length Question...

details? Also, when i would do a select, if i wanted say d02f1, would it load the entire row first, and then just give me that field? -Select `d02f01` from `mytable` where [where clause] Or would it jsut load that field... Does these questions make sense? (they do in my head) Steven Staples

MySQL Slave is almost 1 day behind

issue. Please help! :) Thanks in advance Steven Staples -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Master/Slave - trucate master table

on the master, where ID . Steven Staples -Original Message- From: Johnny Withers [mailto:joh...@pixelated.net] Sent: March 5, 2010 1:11 PM To: Steven Staples Cc: mysql@lists.mysql.com Subject: Re: Master/Slave - trucate master table Does START SLAVE fail? If so, what is the output

RE: Master/Slave - trucate master table

the ID and then reset the ID to 0 or 1... and then delete everything from and beyond I was just wondering if this was a bug, or if there was something wrong with what I did? Steven Staples -Original Message- From: Ananda Kumar [mailto:anan...@gmail.com] Sent: March 8, 2010 11

Master/Slave - trucate master table

getting an error now. Apparently one of the tables is out of sync now? What appears to have happened, is that when the slave was down, i truncated a table on the master. I've read that this sometimes causes errors, is this a bug? Or a is there something I should do differently? Steven Staples

declare multiple 'Definer'

Good morning! I have been struggleing with creating a store procedure, that will allow 2 users -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: declare multiple 'Definer'

`) PROCEDURE `sstest`() . CREATE definer=`use...@`%` OR definer=`sstapl...@`localhost` PROCEDURE `sstest`() . CREATE definer=`use...@`%` definer=`sstapl...@`localhost` PROCEDURE `sstest`() I can't think how it would be possible? Or is it? Steve -Original Message- From: Steven

sql file system + optimization

performance if this was a large database? If so, could I just symlink the test/ directory to another raid array to increase performance? Or would the increase be negligible? Steven Staples -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: Join Statement

didn't run this, or try to replicate it, it was just my observation on the query. Steven Staples -Original Message- From: Victor Subervi [mailto:victorsube...@gmail.com] Sent: December 14, 2009 11:26 AM To: mysql@lists.mysql.com Subject: Join Statement Hi; I have the following: mysql

RE: Stored Proc's

needing now) Steven Staples -Original Message- From: Michael Dykman [mailto:mdyk...@gmail.com] Sent: December 11, 2009 9:50 AM To: mysql@lists.mysql.com Subject: Re: Stored Proc's of course. you can have entries u...@domain1.me.com u...@xxx.foo.com the only caveat is to make sure

Select from remote server from stored procedure

created, my php app adds the username/customerid to that server, then makes a connection to the logging server and creates the same record, same with deleting and updating... but there just has to be a simpler way :) Thanks in advance. Steven Staples -- MySQL General Mailing List For list

RE: Select from remote server from stored procedure

, but I guess my searching keywords were insufficient ;) Steven Staples -Original Message- From: harrison.f...@sun.com [mailto:harrison.f...@sun.com] Sent: December 9, 2009 2:07 PM To: Johan De Meersman Cc: Neil Aggarwal; Steven Staples; mysql@lists.mysql.com Subject: Re: Select from

RE: MySQL View

-Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: Tuesday, February 10, 2009 5:10 AM To: mysql@lists.mysql.com Subject: Re: MySQL View On Mon, Feb 9, 2009 at 3:41 PM, Steven Buehler wrote: Ok, I just saw a post about using view's in mysql. I tried

MySQL View

Ok, I just saw a post about using view's in mysql. I tried to look it up and found how to use it, but my question is: what is a view and why would you use it? Is it like a temporary table? Does it write a new database to the disk or use memory? Thanks Steve

RE: MySQL View

-Original Message- From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf Of Baron Schwartz Sent: Monday, February 09, 2009 9:19 AM To: Steven Buehler Cc: mysql@lists.mysql.com Subject: Re: MySQL View On Mon, Feb 9, 2009 at 9:41 AM, Steven Buehler st

RE: MySQL View

correct? Thanks Steve From: Martin Gainty [mailto:mgai...@hotmail.com] Sent: Monday, February 09, 2009 11:26 AM To: Steven Buehler; ba...@xaprb.com Cc: mysql@lists.mysql.com Subject: RE: MySQL View My current understanding of the delta between Views and Temporary Tables Views are read

RE: MySQL View

From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: Monday, February 09, 2009 3:59 PM To: Steven Buehler Cc: mysql@lists.mysql.com Subject: Re: MySQL View Steven, I would suggest you the reading of a basic book about SQL and Databases, I explain you why. Views are a very fundamental

Re: mysqld, mysqld-nt, mysqld-debug

and reignite XAMPP. I just wanted to help. ;-) Viel Gluck! Martin Good Luck? What for? Greetings, Steven -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld, mysqld-nt, mysqld-debug

need MySQL-Debug Varuna Greetings from Germany, Steven P.S.: Why you don't use XAMPP? Especially for beginners is the clearly better choice, since much is already preset. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Multiple Query/Insert help

I have a query that I just can't seem to get working. insert into games2 (sea_id,date,time,loc_id,hteam,vteam,div_id) (select '36',game_date,begin_time,loc_id,home_team_id,away_team_id,(select div_id from team_season where team_id=s1.div_id) from scheduler s1); Of course, I am getting the

RE: Multiple Query/Insert help

Thank you, but I still get an error and I can't figure it out: Unknown column 's1.div_id' in 'on clause' Any other thoughts? Steve -Original Message- From: Andy Shellam [mailto:[EMAIL PROTECTED] Sent: Saturday, August 16, 2008 9:40 AM To: Steven Buehler Cc: mysql@lists.mysql.com

RE: Multiple Query/Insert help

Thank you, but I still get an error and I can't figure it out: Unknown column 's1.div_id' in 'on clause' Any other thoughts? Steve -Original Message- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Saturday, August 16, 2008 9:50 AM To: Andy Shellam; Steven Buehler Cc: mysql

RE: Multiple Query/Insert help

- From: Andy Shellam [mailto:[EMAIL PROTECTED] Sent: Saturday, August 16, 2008 10:03 AM To: Martin Gainty Cc: Steven Buehler; mysql@lists.mysql.com Subject: Re: Multiple Query/Insert help Hi Martin, Good point, I normally do but was just illustrating the join. I would also normally fully-qualify

Encryption with collation

I have a column in a table that was turned into an cp1251_general_ci for a type of encryption. Question is, how do I unencrypt it? Thanks Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How to auto repair db on hosting with quota

-Original Message- From: Artem Kuchin [mailto:[EMAIL PROTECTED] Sent: Friday, December 07, 2007 4:35 AM To: mysql@lists.mysql.com Subject: How to auto repair db on hosting with quota I am asking this question as a hosting PROVIDER, not as a hosting client. The sitation is like

RE: secure port 3306

-A PREROUTING -t nat -p tcp -s client-ip \ -d linux-fw-ip --dport 3306 -j DNAT --to internal-ip:3306 On Wed, May 2, 2007 17:03, Steven Buehler wrote: I have a client that needs to be able to remotely connect to port 3306 securely. I have tried to suggest an SSH Tunnel, but they do not want

RE: secure port 3306

But I also need to make sure that nobody is sniffing between Server-1 and Server-2. Steve -Original Message- From: Mogens Melander [mailto:[EMAIL PROTECTED] Sent: Monday, May 07, 2007 1:35 PM To: Steven Buehler Cc: mysql@lists.mysql.com Subject: RE: secure port 3306 On Mon, May 7

RE: secure port 3306

# Or whatever the interface that faces internet is called. iptables -A FORWARD -i $EXTIF -p tcp -s client-ip --dport 3306 -j ACCEPT iptables -A PREROUTING -t nat -p tcp -s client-ip \ -d linux-fw-ip --dport 3306 -j DNAT --to internal-ip:3306 On Wed, May 2, 2007 17:03, Steven Buehler wrote: I have

secure port 3306

I have a client that needs to be able to remotely connect to port 3306 securely. I have tried to suggest an SSH Tunnel, but they do not want their clients to have SSH access. Another problem is that even if we do tunnel, it needs to go thru one server that is connected to the Internet and into

Support for JDBC 4.0?

Does anyone know if there are plans to add support for JDBC 4.0 to the java connector? I'm particularly interested in support for the Connection.createQueryObject(Class cls) method. Thanks. Steve Buroff

Urgent: Please Confirm Interest in China Business Opportunity

This is a text part of the message. It is shown for the users of old-style e-mail clients

MySQL 4.1.15 on Red Hat 7.3?

Has anyone here successfully managed to install mysql 4.1.15 on a RedHat 7.3 box? RedHat 7.3 seems to be using the glibc 2.2.5 libraries and mysql seems to insist on using glibc 2.3. Am I out of luck? __ Yahoo! Mail - PC Magazine

Using MySQL libraries for a client app

checking for mysql_init in -lmysqlclient... yes checking whether mysql clients can run... no configure: error: Your MySQL client libraries aren't properly installed

RE: Using MySQL libraries for a client app

Message- From: Steven Altsman [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 11:37 AM To: 'mysql@lists.mysql.com' Subject: Using MySQL libraries for a client app checking for mysql_init in -lmysqlclient... yes

RE: Need older version of mysql (current version seeminly corrupts FTS tables)

See: http://downloads.mysql.com/archives.php Thank you. Nice link to have around. Key 3 is the FTS key. The others are a UNIQUE KEY (#1) and a KEY(#2). Do you have the same values for full-text parameters (ft_mit_word_len for example)? Not at first. I had noticed that not long after I sent

Need older version of mysql (current version seeminly corrupts FTS tables)

I have replaced one server with another, and the new one has everything new (RHEL 3, newest updates) and MySQL 4.0.23 (old one was RH9 and MySQL 4.0.18). We now get table corruptions constantly (it only takes a minute before several tables get marked as crashed). I'd like to revert to the 4.0.18

Re: MySQL as Email database [sort of OT]

Hi! I just finished a project just like this. We just put in a brand new mail server running PostFix on Mac OS X Panther. We added all the extra bells and whistles for spam and virus filtering, as well as squirrel mail There is an single-line option in Postfix's config file to have all email

Best Query Question

This has to be so simple, but my solution runs much slower than I would expect it to. I'm wondering if there is a more efficient way to do this type of query. I have a table of email messages, I have another table containing all of the email addresses linked to each email message I want to

RE: Does it matter?

Please remove me from your email distribution. Best Regards, Steven Grosch [EMAIL PROTECTED] TEK LLC 610 260 9899 -Original Message- From: mysql@lists.mysql.com [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 12:05 AM To: [EMAIL PROTECTED] Subject: Does it matter? You have

RE: Does it matter?

NO. Best Regards, Steven Grosch -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 8:41 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: Does it matter? {snip] Please remove me from your email distribution. [/snip] Do you

Help upgrading from 4.1.1 to 4.1.8

I haven't found anything in the documentation that will help me upgrade mysql from 4.1.1 to 4.1.8. We have several databases running under 4.1.1. How do they get migrated to run under 4.1.8? How do we migrate our user data over? Can someone point me toward a FAQ that might help me or the

Re: Foreign Key Error 1005:150

Michael, Thank you for your reply. Here is a bit more info. I changed the default table type to innodn in the my.ini file before creating the database, so all tables are innodb. I tried the create statements with and without explicit index clauses with all permutations - same result each

Foreign Key Error 1005:150

I am unable to define a foreign key with the following three tables. I am unable to find the error having searched the documentation and tried several variations. Note that I created the first two tables with and without the index clause in the table ddl with no difference in outcome. The

RE: Help with query performance anomaly

For production systems, I would never let the mysql optimizer guess a query plan when there are joins of big tables and you know exactly how it should behave. Once you think a query is finished, you should optimize it yourself. Use STRAIGHT_JOIN and USE INDEX as found here in the manual:

RE: Upgrading MySQL erased all data

Thanks. I passed this on and he found what was lost. I guess since the data directory was owned by mysql, he could not find the databases when doing a MacOS file search. I impressed upon him to use a separate datadir as we do with our servers, thus bypassing this whole thing. Thanks again!

Upgrading MySQL erased all data

Installing MySQL 4.1.7 (upgrading from 4.1.3) on MacOS X erased the contents of /usr/local/mysql/data -- the privs and data of the previous installation. FYI Luckily (and unfortunately) we have a backup of that database from last week. (The guy that did it here in the office is still in a bit of

Alternate directory for database

Is it possible to tell mysql to create the directory for a database in a specified directory rather than in mysql's data directory?

VIEW

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

mysqldump causes slave to stop

Hello, I am dumping a single innodb DB using mysqldump. Everytime I do it, it crashes the slave thread. Below are the commands I'm using to dump [I also have tried --delete-master-logs command in the actual data dump too (second line) with the same problem.] I am willing to hear advice on the

mysqldump causes slave to stop

Hello, I am dumping a single innodb DB using mysqldump. Everytime I do it, it crashes the slave thread. Below are the commands I'm using to dump [I also have tried --delete-master-logs command in the actual data dump too (second line) with the same problem.] I am willing to hear advice on the

RE: Problems with MySQL 4.0.20

Thank you very much for your bug report! And sorry if I doubted your report at the beginning; I hadn't thought of the rpm script. No problem. I sometimes get bug reports that I know are impossible! Yet they weren't. This one I would have barely noticed if it had not knocked the slaves all

RE: Problems with MySQL 4.0.20

We start mysql with 'service mysql start' (we install from the RPM for linux). I've never seen mysql create binlog files under the name root before, and after reverting to an old version, it doesn't again. It created a big mess with all the slaves stuck at the end of an older binlog and not

RE: Problems with MySQL 4.0.20

Hmm, I don't see any changes in ft-related files since 4.0.18 that could cause it (there were bugfixes, but they affect only *searching* - that is MATCH - and not *updating*). Can you create a test case ? Well, I put up a file in the secret folder a few days ago as referenced in a bug

Problems with MySQL 4.0.20

We had some servers that were upgraded from 4.0.17/18 to 4.0.20 and had several problems thereafter: 1. Tables with FTS indices became corrupted, with queries on them causing segfaults on the servers. 2. BinLog files were getting created with ownership of root, not mysql. Then Mysql complains

thread stack issues

Since going from 4.0.18 to 4.0.20 (or 4.0.19) I now receive these warnings on startup: 040520 14:55:21 mysqld started 040520 14:55:21 Warning: Asked for 196608 thread stack, but got 126976 /usr/sbin/mysqld: ready for connections. Version: '4.0.20-standard' socket: '/tmp/mysql.sock' port: 3306

  1   2   3   4   >