Mysql 5.1 - 5.0

2011-03-10 Thread Brent Clark
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

Re: Mysql 5.1 - 5.0

2011-03-10 Thread Johan De Meersman
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

Re: Help with slow query

2011-03-10 Thread Jim McNeely
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 |

How to protect primary key value on a web page?

2011-03-10 Thread mos
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

Re: Help with slow query

2011-03-10 Thread Jim McNeely
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

Re: Help with slow query

2011-03-10 Thread mos
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

Re: Help with slow query

2011-03-10 Thread Shawn Green (MySQL)
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

Re: Help with slow query

2011-03-10 Thread Jim McNeely
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

Pruning the slow_log Table

2011-03-10 Thread Tim Gustafson
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

mysql vs source

2011-03-10 Thread Brent Clark
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,

Re: How to protect primary key value on a web page?

2011-03-10 Thread Claudio Nanni
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

Re: How to protect primary key value on a web page?

2011-03-10 Thread Reindl Harald
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

Re: How to protect primary key value on a web page?

2011-03-10 Thread Mike Diehl
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

MySQL Enterprise support now at Oracle?

2011-03-10 Thread Jim McNeely
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

Re: Help with slow query

2011-03-10 Thread Shawn Green (MySQL)
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`

Re: Help with slow query

2011-03-10 Thread Andy Wallace
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

Re: mysql vs source

2011-03-10 Thread Dan Nelson
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)

Re: How to protect primary key value on a web page?

2011-03-10 Thread 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 , are you afraid of sql injection? I'm

Re: How to protect primary key value on a web page?

2011-03-10 Thread Reindl Harald
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

Re: How to protect primary key value on a web page?

2011-03-10 Thread Claudio Nanni
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

Re: How to protect primary key value on a web page?

2011-03-10 Thread Claudio Nanni
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

Re: How to protect primary key value on a web page?

2011-03-10 Thread Reindl Harald
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

Re: How to protect primary key value on a web page?

2011-03-10 Thread Shawn Green (MySQL)
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

Re: How to protect primary key value on a web page?

2011-03-10 Thread Mark Kelly
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

Re: MySQL Enterprise support now at Oracle?

2011-03-10 Thread Jim McNeely
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

Re: MySQL Enterprise support now at Oracle?

2011-03-10 Thread David Giragosian
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

trigger-dumping

2011-03-10 Thread hsv
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:

Table Records Deleted by anonymous user!

2011-03-10 Thread Vikram A
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

Re: Table Records Deleted by anonymous user!

2011-03-10 Thread Johan De Meersman
- 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

Re: Table Records Deleted by anonymous user!

2011-03-10 Thread Geoff Galitz
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;