On 29/02/2016 19:54, Gary Smith wrote:
However, if TDE is employed, then you've got another significant
obstacle to overcome: The data is only encrypted (aiui) once it's in
memory.
Apologies, that should read "unencrypted (aiui) once it's in memory"
Gary
--
MySQL General Ma
On 29/02/2016 19:50, Reindl Harald wrote:
cryptsetup/luks can achieve that way better
Only to a degree. Once the disk is unencrypted, you've got access to the
filesystem. If you've got physical access to the machine, then anything
which gives you console access gives you (potentially) access
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 the database, if you use the --replace flag you'll
convert all INSERT statements to REPLACE, which when you merge will
update or insert the record, effectively
On 29/02/2016 15:30, lejeczek wrote:
On 28/02/16 20:50, lejeczek wrote:
fellow users, hopefully you experts too, could help...
...me to understand how, and what should be the best practice to dump
database, then drop it and merge the dumps..
What I'd like to do is something probably many have
On 29/04/2013 18:29, Patrice Olivier-Wilson wrote:
Hi all:
I have a membership directory where folks can belong to more than one category.
But all folks do not qualify for a category. So I want to list folks who have
qualified in a category but not have them repeat. So if member 1 is in cat 3
On 24/04/2012 17:11, Tompkins Neil wrote:
Hi
I've a number of different postal codes in a system for example
WC1B 5JA
WC1H 8EJ
W1J 7BX
W1H 7DL
NW1 1NY
I can use like statements for example
SELECT * FROM postal_codes WHERE zip LIKE 'W1%' giving me
W1J 7BX
W1H 7DL
In addition I have a number
On 24/04/2012 17:16, Gary Smith wrote:
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
Specifically, replace % with _ as this means match one character not
match any number of characters. So, you can do:
like W1 %
like W1_ %
etc.
Oh, and you can also get really dirty
On 24/04/2012 17:24, Tompkins Neil wrote:
How about if I want to only return postal codes that are like W1U 8JE
not W13 0SU.
Because in this example I have W1 as the postal code and W13 is the other
postal code
Then you'd do:
like 'W1 %' to return anything starting W1
like 'W13 %' to return
On 13/02/2012 22:09, Haluk Karamete wrote:
Gary,
you've mentioned that the user would have had access to the sysobjects
No, there's a difference. *If* they had access to sysobjects then it
could've caused issues.
Ideally, you should have some level of segregation within your database.
That
On 13/02/2012 21:48, Haluk Karamete wrote:
My logs shows that we have tried with a SQL Injection attempt, but
our engine has detected and avoided it but I am just curious, what are
these SQL statements are intending to achieve?
SELECT * FROM lecturer WHERE recID='25 ' and exists (select *
Krishna Chandra Prajapati wrote:
Hi guys,
Is the information is true.
http://planet.mysql.com/
http://tokutek.com/2010/04/tokutek-acquires-oracle/
Might want to check the date.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
machiel.richards wrote:
How can we do this when running in a cron script?
mysql -e select * from table into outfile '/path/to/output/file'
fields terminated by '|' ?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
bharani kumar wrote:
Hi
My fields something like
hospital1,hospital2,hospital3,patientname,
[...]
i know , i can display all hospital code with unique , but i dont in the
single column , with unique record,
Can you tell me how to do this ?
Would it be possible to reconsider your
Benedikt Schackenberg wrote:
Am 02.01.2010 13:43, schrieb bharani kumar:
No Duplicate records,
select hospital1code from *yourtable* grop by hospital1
This won't work as he's also looking for entities in the hospital2code
and hospital3code fields to be returned in the same resultset, but
Patrice Olivier-Wilson wrote:
I have 2 databases, different domains. Both have a table named
'tips'... both have different contents in the table.
Using phpMyAdmin for GUI.
I want to export databaseA tips as sql (done) then import content into
databaseB tips. But when I run that operation, the
Patrice Olivier-Wilson wrote:
I have data I need to keep in both db just trying to merge.
There's two ways around this:
First is to not export the structure (uncheck structure). The second is
to export with if not exists. This should (IIRC) do a create table if
not exists, so it'll do
Patrice Olivier-Wilson wrote:
Gave it a try got this:
MySQL said:
#1062 - Duplicate entry '1' for key 1
Yeah, that's what I was saying about in my previous mail. It looks like
you've got a primary key on one of your columns, and you're attempting
to insert data into it with a duplicate
Ken D'Ambrosio wrote:
Hey, all. I've been using databases clear back to xBase days; that being
said, I've never had a solid foundation for relational databases. While I
can muddle by in SQL, I really don't have a good understanding of exactly
how keys are set up, the underpinnings of indexing,
Victor Subervi wrote:
On Sun, Dec 27, 2009 at 12:00 PM, Michael Dykman mdyk...@gmail.com wrote:
last_insert_id() returns the last id auto-incremented in *the current
session*. If you disconnect and reconnect, it can not be retrieved.
Ahah! So how do I retrieve the last id inserted
Steve Edberg wrote:
(2) autoincrement values are not reused after deletion, so if you
deleted the record with ID=1000 inserted in (1), the next
autoincrement would still be 1001, even if the existing records are
IDs 1,2,3. This is usually the desired behavior, but again, may not be
what *you*
walter harms wrote:
hi list,
is it possible to get a list of all tables with a certain type in one statement
?
for now i collect all tables (show tables) and search for the type (show
columns).
Any way to circumvent that ? make it one statement ?
use information_schema;
select
Terry Van de Velde wrote:
Good Day,
I am attempting to do something new (to me) with MySQL. I am looking to have
my query return with the value in the visitor and home columns replaced with
the corresponding team name from the teams table. schedule.visitor and
schedule.home are essentially
James Coffman wrote:
Hello all,
My website has been hacked using a url such as:
-1%20union%20all%20select%201,2,concat(username,char(58),password),4,5,6%20f
rom%20users-- .
I have been searching on the web for a solution/fix to this issue and I
cannot seem to find one. The
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Friday, July 17, 2009 2:02 PM
To: Gary Smith; Todd Lyons
Cc: mysql@lists.mysql.com
Subject: RE: Slave log files going nuts...
The binlogs are closed and reopened every time you do a FLUSH LOGS;
command, or when
I have a new slave I setup against a new master server. The master server has
4 log files in it, the most current being updated on the 16th. The slave
server on the other hand has several files, many which seem to be blank. This
slave is set to slave the master and act as a master for
] On Behalf Of Todd Lyons
[tly...@ivenue.com]
Sent: Thursday, July 16, 2009 2:41 PM
To: Gary Smith
Cc: mysql@lists.mysql.com
Subject: Re: Slave log files going nuts...
On Thu, Jul 16, 2009 at 1:18 PM, Gary Smithg...@primeexalia.com wrote:
I have a new slave I setup against a new master server
, the startup recovery flags might be your best
bet.
From: Daevid Vincent [dae...@daevid.com]
Sent: Tuesday, July 14, 2009 12:23 PM
To: mysql@lists.mysql.com
Cc: Gary Smith
Subject: RE: Copy 70GB ibdata, etc. and server won't start now
-Original Message
? If this were a hot backup, I could see
this problem happening. If it were a could backup, it should work.
From: Johnny Withers [joh...@pixelated.net]
Sent: Tuesday, July 14, 2009 1:40 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com; Gary Smith
Subject: Re: Copy 70GB
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: for more information.
InnoDB: Error: trying to access page number 2144600306 in space 0,
-Original Message-
From: sjm...@pobox.com [mailto:sjm...@pobox.com]
Sent: Saturday, July 11, 2009 1:02 AM
To: mysql@lists.mysql.com
Subject: Re: Replication, Stored Proceedures and Databases
g...@primeexalia.com (Gary Smith) writes:
...
In database G we have 150+ stored
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Saturday, July 11, 2009 2:44 AM
To: Simon J Mudd
Cc: mysql@lists.mysql.com
Subject: R: Re: Replication, Stored Proceedures and Databases
You dont have changes coming from db G since it is ignored from
Here is steps take to get to the problem. Version is 5.1.35
To be on the safe side, I did this prior to executing the scripts. I deleted
the mysql directory and the mysql-log directory, recreated them, chowned them,
ran mysql_install_db, chowned them again. So, I know at least I'm working
though the tables are qualified.
Can anyone confirm this?
Gary
From: Gary Smith [g...@primeexalia.com]
Sent: Friday, July 10, 2009 5:12 PM
To: mysql@lists.mysql.com
Subject: Crazy replication problem
Here is steps take to get to the problem. Version
-Original Message-
From: Gary Smith
Sent: Friday, July 10, 2009 5:26 PM
To: Gary Smith; mysql@lists.mysql.com
Subject: RE: Crazy replication problem
One quick follow up note:
In the top of the big script, I'm doing:
CREATE DATABASE x;
CREATE TABLE x.whatever
After getting table replication to work by including the USE database on the
creation scripts, I have run into a rather large problem. We have 5 databases
on the server which get replicated to another server. We call them databases,
A, B, C, D, and E. we have two other databases F and G
I would like to prevent users from changing their passwords unless they have
grant permission. Is this possible?
We have an set of stored procedures for managing users/databases for a single
signon project that we are working on. The problem is if a user connects
directly to the database
Hello,
I've run into an odd problem. I have a connection data management library for
a project that we have been working with for a while. The purpose of this
library was to work around some oddities in the ODBC environment where lots of
connections were being held open for a long period of
Is there a way to test a connection prior to using it to find out if
it's actually open? Like pinging the active connection.
If I could do something like that prior to returning the connection, I
could then loop through the connections to check until I get a good
one. We have all of the
Off the top of my head, try this.
SELECT
MONTHNAME(s.created) AS month,
sum(if(ifnull(s.id,0) 0, 1, 0)) AS num_logins,
sim(if(ifnull(d.id, 0) 0, 1, 0)) AS num_downloads
FROM sessions AS s LEFT JOIN downloads AS d
ON d.session_id = s.id GROUP BY month
/2009 03:33 PM, Gary Smith wrote:
Off the top of my head, try this.
SELECT
MONTHNAME(s.created) AS month,
sum(if(ifnull(s.id,0) 0, 1, 0)) AS num_logins,
sim(if(ifnull(d.id, 0) 0, 1, 0)) AS num_downloads
FROM sessions AS s LEFT JOIN downloads AS d
ON d.session_id = s.id GROUP BY month
Nope
Hello,
I'm working on a project that will be inserting very large text streams into a
database. They range from 100K to 100M. I suspect that the average will be
about 2M per insert. This is a low volume (under 20 inserts per day). I don't
really need to optimize much on this but I had a
Michael,
Thanks. Thats what I was looking for, I just couldn't remember what it was.
Gary
From: Michael Dykman [mdyk...@gmail.com]
Sent: Wednesday, May 20, 2009 9:17 AM
To: Gary Smith
Cc: mysql@lists.mysql.com
Subject: Re: Large insert question
On Wed
: joerg.bru...@sun.com [joerg.bru...@sun.com]
Sent: Thursday, May 07, 2009 2:40 AM
To: Gary Smith
Cc: mysql@lists.mysql.com
Subject: Re: Problems After MySql 5.1.34
Hi Gary, all,
Gary Smith wrote:
Johnny,
Welcome to the hell that is php + apache + mysql. If you upgrade your MySql
(especially major
You are right. I misspoke regarding mysql - php - apache hell. It happens
anytime an interface changes.
From: Mark [ad...@asarian-host.net]
Sent: Thursday, May 07, 2009 5:57 AM
To: mysql@lists.mysql.com
Subject: RE: Problems After MySql 5.1.34
Gary
Johnny,
Welcome to the hell that is php + apache + mysql. If you upgrade your MySql
(especially major versions 5.0 = 5.1) you will also need to recompile php
against the new MySql client libs. We've had very limited success trying to
get it to work otherwise.
This is why you are receiving
Oracle owns the mess now. I assume the next release will be 5.11, followed by
5.11i, and then finally dropping of the 5 to be in line with how they manager
their os, leave it to just be 11i. To ensure it is smooth they will change the
license and add $5k in suport costs.
Lin,
I've had mixes results but you might have better success. As John mentioned,
there are a couple factors that you need to take into account.
How much data are you talking about (physical size and number of rows). I know
you say 15 years of data but is that 100's of millions of rows?
I have system that is generating a larger than normal number of connection
errors. We know why the errors are occuring and are working to resolve them
(connectivity and load issue on the client). The question is, how can I tweak
mysql to tolerate a higher level than normal of bad connections
]
Sent: Tuesday, April 07, 2009 9:18 AM
To: mysql@lists.mysql.com
Subject: Re: flush-host problem
At 10:39 AM 4/7/2009, Gary Smith wrote:
I have system that is generating a larger than normal number of connection
errors. We know why the errors are occuring and are working to resolve
them (connectivity
I'm working on a small project of re-implementing all of the sql for a web
site. The task is pretty trivial but overall there are some minor things that
I'm trying to code through.
We've moved much of the logic over to stored procs and call them with
parameterized queries. This works well
: Search based where claused and stored proc
Date: Fri, 27 Mar 2009 13:43:51 -0500
Ben Wiechman
Network Administrator
Wisper High Speed Internet
Office: 866.394.7737
Direct: 320.256.0184
Cell: 320.247.3224
b...@wisper-wireless.com
-Original Message-
From: Gary Smith [mailto:g
Velentin,
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
Note the section for the droping of foreign keys used the contraint name, not
the key name. Try this and see if it solves the first problem (of removing the
constraint). Then you should be able to drop the
...
--
Gary Smith - [EMAIL PROTECTED]
Web: http://www.l33t-d00d.co.uk
Pics: http://photos.l33t-d00d.co.uk
Webcam: http://webcam.l33t-d00d.co.uk
--
Gary Smith - [EMAIL PROTECTED]
Web: http://www.l33t-d00d.co.uk
Pics: http://photos.l33t-d00d.co.uk
Webcam: http://webcam.l33t-d00d.co.uk
I am running mySQL 3.23.32 with ColdFusion 4.5 on a RedHat Linux 6.2
machine. MySQL continuously crashes. I've been told that it could be that
the ODBC driver is not up to date. Where can I get these drivers... or do
you have any suggestions as to what I should do?
Please help.
54 matches
Mail list logo