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
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 brentgclarkl...@gmail.com
To: mysql@lists.mysql.com
Sent: Thursday, 10
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 |
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
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
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
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
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
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 doing
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 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 mo...@fastmail.fm
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
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_id
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
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`
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
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'
(using source)
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
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
question is
On Mar 10, 2011 9:13 PM, mos mo...@fastmail.fm 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
On Mar 10, 2011 9:23 PM, Reindl Harald h.rei...@thelounge.net 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
Am 10.03.2011 21:56, schrieb Claudio Nanni:
On Mar 10, 2011 9:23 PM, Reindl Harald h.rei...@thelounge.net 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
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
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
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
On Thu, Mar 10, 2011 at 5:05 PM, Jim McNeely j...@newcenturydata.com 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
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:
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
- Original Message -
From: Vikram A vikkiatb...@yahoo.in
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
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;
30 matches
Mail list logo