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 product
l php script on cron 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 wrote:
> On 29/02/16 16:32, Steven Siebert wrote:
>
>> What level of control do yo
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 wrote:
> On 29/02/2016 16:32, Steven Siebert wrote:
>
>>
>> At risk of giving you too much rope to hang yourself: if you use
>> mysqldump to dump
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 o
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 easy to re-code php to
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 keep having to restore my
> datab
#x27;s own benefits and downsides; nothing prevents you from taking any
> or all of those approaches at the same time.
>
>
> - Original Message -
> > From: "Larry Martell"
> > To: "Steven Siebert"
> > Cc: "mysql mailing list"
>
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 thought
they come in. I 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 wrote:
>>
>> Hello all,
>>
>> I've looked tho
sightful and quite helpful responses.
S
On Fri, Jun 21, 2013 at 7:58 AM, Denis Jedig 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 soc
rather than just reconnect using the session ID from the "dropped"
connection?
I apologize about these basic mysql-mechanics questions - I need to satisfy
our auditors, so I need to understand =)
Thanks,
S
On Fri, Jun 21, 2013 at 7:13 AM, Hartmut Holzgraefe wrote:
> On 21.06.2013
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")
- do
> -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
> -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 Sto
> -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:
> 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
> -Original Message-
> From: Mihail Manolov [mailto:mihail.mano...@liquidation.com]
> Sent: March 19, 2012 12:44 PM
> To: Steven Staples
> Cc:
> Subject: Re: Group_Concat help...
>
> Try this
>
> SELECT `user_id`, `login_ip`,
> COUNT(`id`) AS 'co
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'
GROUP
> -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:
> > Go
ll() 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
you
-
> memory tables as example are making much more troubles as myisam
>
> Am 10.11.2011 14:26, schrieb Steven Staples:
> > Good morning list,
> >
> > I am having issues with my replication setup. it seems that every few
> > weeks/months something happens, and
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 new
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: mysq
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 exis
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 S
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 Mess
cause of the problem, 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?
>
> Hel
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: [MyS
take 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 usuall
mmand line, just 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:prajap
y projects I am working 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
>
and the 5.1.47)?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
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
s to run all weekend 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
that would be ideal.
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
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...@gma
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 fr
RE pnum LIKE
'555-12%';
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
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 [mai
irst_table`.`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]
> Se
I am doing wrong? I can't seem to see 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/my
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
(`datefield`);
(this was just 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: A
, when I do my "JOIN"s, I tend to write "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
ysql site:
http://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: m
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
shoulnd't even be an i/o or cpu 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
i will just delete from the table
where 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 [mail
te on the master, where ID <
XXXX.
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 th
ql. We're 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 different
lhost`) 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-----
Fr
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
t increase 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 unsubscrib
t.ProdID = p.ID
;
<-- end -->
I 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: Joi
what I am 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 t
it before, 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: S
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
> -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 abou
Steve
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 fundam
that sound
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
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
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
ct, I wanted no discussion on the pros 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]
ld. For starting with MySQL, you don't 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: htt
l
Steve
-Original Message-
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 woul
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: And
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: Steve
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 d
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]
> -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
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
ING -t nat -p tcp -s \
-d --dport 3306 -j DNAT --to :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
> their clients to have SSH a
whatever the interface that faces internet is called.
iptables -A FORWARD -i $EXTIF -p tcp -s --dport 3306 -j ACCEPT
iptables -A PREROUTING -t nat -p tcp -s \
-d --dport 3306 -j DNAT --to :3306
On Wed, May 2, 2007 17:03, Steven Buehler wrote:
> I have a client that needs to be able to remot
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
th
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
This is a text part of the message.
It is shown for the users of old-style e-mail clients
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 Edit
Original 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 i
checking for mysql_init in -lmysqlclient... yes
checking whether mysql clients can run... no
configure: error: Your MySQL client libraries aren't properly installed
-
> 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 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
v
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 go
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 sea
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 not
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
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 docu
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 tim
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 t
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:
http://de
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!
-steve
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
Is it possible to tell mysql to create the directory for a database in a
specified directory rather than in mysql's "data" directory?
with mysql ?
Thanks,
Steven
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 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 of
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 be
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 b
> 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 r
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 advanc
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 tha
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 - 100 of 413 matches
Mail list logo
