say that it is done intentionally but could not point anyone because
we did not enable the logging feature in MySQL.
You already said it yourself: you don't have logging enabled, so that data
is not available.
If you have binary logs, you could comb through those for the delete
statements; t
- Original Message -
> From: "Vikram A"
>
> say that it is done intentionally but could not point anyone because
> we did not enable the logging feature in MySQL.
You already said it yourself: you don't have logging enabled, so that data is
not available.
If you have binary logs, you
Dear Experts!
Our institution has a centralized MySQL server which is accessed by several
clients. Today we found that a particular table's records are missing. We could
say that it is done intentionally but could not point anyone because we did not
enable the logging feature in MySQL. I w
MYSQLDUMP.EXE (Ver 10.13 Distrib 5.5.8, for Win32 (x86)) has flags for
trigger-dumping; the help that I downloaded for this version says it dumps
triggers--but it does not. Now what?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
On Thu, Mar 10, 2011 at 5:05 PM, Jim McNeely wrote:
> Shawn Green works for Oracle and has been very helpful, and I am happy to
> eat a little bit of shoe leather!
>
> Thanks Shawn!
>
> Jim
>
Check the archives for Shawn's posts. IMNSHO, they are unparalleled in
clarity and depth and breadth of
Shawn Green works for Oracle and has been very helpful, and I am happy to eat a
little bit of shoe leather!
Thanks Shawn!
Jim
On Mar 10, 2011, at 11:11 AM, Jim McNeely wrote:
> Wow! We paid for MySQL enterprise plus enterprise support back in the good
> old days before ORACLE bought MySQL. I
Hi.
On Thursday 10 Mar 2011 at 20:09 mos wrote:
[snip]
> Let's say I have a Document_Id column and the url is
> www.mydocuments.com/public?docid=4
> to retrieve document_id=4, I don't want someone to write a program to
> retrieve all of my public documents and download them. I want them to go
>
On 3/10/2011 12:10, mos wrote:
I want to bounce some ideas off of MySQL developers that use it for web
development. Maybe I'm a little paranoid, but when dealing with the
Internet, I want to make my web app as secure as possible. I'm hoping
some of you can offer me some ideas in this respect.
I
Am 10.03.2011 21:56, schrieb Claudio Nanni:
> On Mar 10, 2011 9:23 PM, "Reindl Harald" wrote:
>>> So hashing or encrypting the id column will make the id's non-contiguous
> and impossible to guess.
>>
>> sorry but this is foolish
>> leave the id in peace and add a colum with some checksum
>
>
On Mar 10, 2011 9:23 PM, "Reindl Harald" wrote:
>
>
>
> Am 10.03.2011 21:09, schrieb mos:
> > At 12:37 PM 3/10/2011, Claudio Nanni wrote:
> >
> >> Hi there,
> >> Yes I think its actually a pattern a few hundreds million sites solved
already :)
> >
> > Great. How did they do it? :)
> >
> >> And any
On Mar 10, 2011 9:13 PM, "mos" wrote:
>
> At 12:37 PM 3/10/2011, Claudio Nanni wrote:
>
>> Hi there,
>> Yes I think its actually a pattern a few hundreds million sites solved
already :)
>
>
> Great. How did they do it? :)
>
Please, google for me I am cooking right now :)
>
>> And any way to encry
Am 10.03.2011 21:09, schrieb mos:
> At 12:37 PM 3/10/2011, Claudio Nanni wrote:
>
>> Hi there,
>> Yes I think its actually a pattern a few hundreds million sites solved
>> already :)
>
> Great. How did they do it? :)
>
>> And any way to encrypt (scramble)the http get string would do. But my
At 12:37 PM 3/10/2011, Claudio Nanni wrote:
Hi there,
Yes I think its actually a pattern a few hundreds million sites solved
already :)
Great. How did they do it? :)
And any way to encrypt (scramble)the http get string would do. But my
question is , are you afraid of sql injection?
I'm us
In the last episode (Mar 10), Brent Clark said:
> Hiya
>
> I just found that I can run
> mysql db -e 'source exporteddbdata.sql'
>
> The question I would like to ask is. Is there a speed difference between
>
> mysql db < exporteddbdata.sql
> and
> mysql db -e 'source exporteddbdata.sql'
> (usi
On 3/10/11 10:46 AM, Shawn Green (MySQL) wrote:
On 3/10/2011 12:32, Jim McNeely wrote:
Rhino,
Thanks for the help and time! Actually, I thought the same thing, but what's
weird is that is the only thing that doesn't slow it down.
If I take out all of the join clauses EXCEPT that one the quer
On 3/10/2011 13:12, Jim McNeely wrote:
Shawn,
This is the first thing that I though as well, but here is a portion from the
show create table for patient_:
PRIMARY KEY (`zzk`),
KEY `IdPatient` (`IdPatient`),
KEY `SSN` (`SSN`),
KEY `IdLastword` (`IdLastword`),
KEY `DOB` (`DateOfBirth`)
Wow! We paid for MySQL enterprise plus enterprise support back in the good old
days before ORACLE bought MySQL. I just sacrificed the sacred chicken and
sprinkled the blood around my computer and went to sign up for support at
support.oracle.com. After wading through the crappy Flash interface a
On Thursday 10 March 2011 11:45:27 am Reindl Harald wrote:
> Am 10.03.2011 18:10, schrieb mos:
> > I am building a web application that uses MySQL 5.5 with Innodb tables
> > and I don't want the user to see the actual primary key value on the web
> > page. The primary key could be the cust_id, bill
Am 10.03.2011 18:10, schrieb mos:
> I am building a web application that uses MySQL 5.5 with Innodb tables and I
> don't want the user to see the actual
> primary key value on the web page. The primary key could be the cust_id,
> bill_id etc and is usually auto increment.
> This primary key can
Hi there,
Yes I think its actually a pattern a few hundreds million sites solved
already :)
And any way to encrypt (scramble)the http get string would do. But my
question is , are you afraid of sql injection? How do fear your db would be
violated?
On Mar 10, 2011 6:13 PM, "mos" wrote:
> I want to
Hiya
I just found that I can run
mysql db -e 'source exporteddbdata.sql'
The question I would like to ask is. Is there a speed difference between
mysql db < exporteddbdata.sql
and
mysql db -e 'source exporteddbdata.sql'
(using source)
Reason im asking is, I got a exported 5.4GB database file,
Hi,
I've enabled slow query logging to the mysql.slow_log table, like this:
log_output = TABLE
general_log = 0
slow_query_log = 1
long_query_time = 5
I'm getting queries in the mysql.slow_log table now, which is awesome. But my
question is this: how does one "prune" that log file, without doin
Shawn,
This is the first thing that I though as well, but here is a portion from the
show create table for patient_:
PRIMARY KEY (`zzk`),
KEY `IdPatient` (`IdPatient`),
KEY `SSN` (`SSN`),
KEY `IdLastword` (`IdLastword`),
KEY `DOB` (`DateOfBirth`),
KEY `NameFirst` (`NameFirst`),
KEY `NameL
On 3/10/2011 12:32, Jim McNeely wrote:
Rhino,
Thanks for the help and time! Actually, I thought the same thing, but what's
weird is that is the only thing that doesn't slow it down. If I take out all of
the join clauses EXCEPT that one the query runs virtually instantaneously. for
some reason
If the optimizer chooses the wrong index, you can tell it what index to use.
SELECT a.IdAppt, a.IdPatient,
p.NameLast, p.NameFirst, p.NameMI
from Appt_ a force index(id_patient)
LEFT JOIN patient_ p
ON a.IdPatient = p.IdPatient
WHERE a.ApptDate >= '2009-03-01';
See http://dev.mysql.com/doc/re
Rhino,
Thanks for the help and time! Actually, I thought the same thing, but what's
weird is that is the only thing that doesn't slow it down. If I take out all of
the join clauses EXCEPT that one the query runs virtually instantaneously. for
some reason it will use the index in that case and i
I want to bounce some ideas off of MySQL developers that use it for web
development. Maybe I'm a little paranoid, but when dealing with the
Internet, I want to make my web app as secure as possible. I'm hoping some
of you can offer me some ideas in this respect.
I am building a web application
Shawn,
Thanks for the great help! It still is not working. I did an EXPLAIN on this
query with your amended split out join statements and got this:
++-+---+---+---++-+--++-+
| id | select_type | table | type | possi
Just like that, not advisable. There's upgrade scripts in the packages that
should handle 5.0 to 5.1; but your safest bet is still going to be a clean
mysqldump and import.
- Original Message -
> From: "Brent Clark"
> To: mysql@lists.mysql.com
> Sent: Thursday, 10 March, 2011 2:07:11 PM
Hiya
We have client that is using Ubuntu, therefore MySQL is 5.1, but where I
work, we still standardise on Debian Lenny (upgrading to Squeeze, is in
the pipeline), therefore, MySQL is 5.0.
What I would like to know is, can I just make a copy of the mysql
database files and copy them the Len
30 matches
Mail list logo
