In the last episode (Jan 29), Suhas Pharkute said:
> Ok, I will explain it again,
>
> I need a way so that if some body gets the DB files (.MYD and .MYI)
> from my distribution, they can put it in their DB engine and can read
> my DB. I would like to STOP this stealing.
>
> Is there any way?
If
Ok, I will explain it again,
I need a way so that if some body gets the DB files (.MYD and .MYI) from my
distribution, they can put it in their DB engine and can read my DB. I would
like to STOP this stealing.
Is there any way?
Thanks
Suhas
Ok, I will explain it again,
I need a way so that if some body gets the DB files (.MYD and .MYI) from my
distribution, they can put it in their DB engine and can read my DB. I would
like to STOP this stealing.
Is there any way?
Thanks
Suhas
On 1/29/07, Logan, David (SST - Adelaide) <[EMAIL PRO
Ok, I will explain it again,
I need a way so that if some body gets the DB files (.MYD and .MYI) from my
distribution, they can put it in their DB engine and can read my DB. I would
like to STOP this stealing.
Is there any way?
Thanks
Suhas
On 1/29/07, Logan, David (SST - Adelaide) <[EMAIL PRO
Have you checked out
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html, you should
be able to en/decrypt your data via these functions thereby rendering any
data on the disk totally useless unless the process comes through your mysql
server. You will have to configure mysql with open
Yep, I do understand that, but when I give DB to someone, I do not want them
to see the database. I want them to access the database thr' the php
application.
It is very simple, I don't want any one to see my DB in open way. But they
can access it thr' my app.
I agree with about file system, and
Konstantin Saveljev wrote:
Hi,
i have a system that has media files ==> users can be fans of media ( so
media becomes their favorite ).
the table itself:
CREATE TABLE media_fans(
id int(11) unsigned not null auto_increment,
user_id int(11) unsigned not null,
media_id int(11) unsigned not
The area by the Santa Clara convention center is pretty dead, but you
can take the light rail to downtown San Jose and there is a pretty
lively nightlife there, lots of interesting restaurants, The Tech Museum
and other things depending on you interests.
Also there are lots more interesting plac
I understand that. I go there for the same thing. My point was that, the
conference needs the attendees as much we want the conference. When I go I'm
going for the conference stuff but I have a life and they're asking us to give
up that life for maybe 6 days. After a the second day things start
On Monday 29 January 2007 12:57, Ed Reed wrote:
> I just didn't enjoy the location. When it was in Orlando a few years ago,
> it was great. There were plenty of things to do and see; different places
> to eat every night. I had a really good time. Then the following year I
> went to Santa Clara and
What is it exactly that you need to achieve?
PHP script doesnt read a MySQL data files, MySQL server does. You can
configure your OS and filesystem rights, so that only MySQL server can
read them.
Ales.
-- Forwarded message --
From: "Suhas Pharkute" <[EMAIL PROTECTED]>
To: mys
I just didn't enjoy the location. When it was in Orlando a few years ago, it
was great. There were plenty of things to do and see; different places to eat
every night. I had a really good time. Then the following year I went to Santa
Clara and there was nothing to do. I went to the movies one ni
Hi David,
Is the space on hard-drive is major concern of yours or abilities to
recover from crash is?
Backups are usually taking to be able to recover from a crash. Which in
its turn means if there is a way to recover faster it is better. Having
slave that is constantly updated gives you very qui
Hi Mikhail,
I don't think that would save much space, in terms of file size. The
tables that are actively getting inserts are large and growing larger
(~750,000 records), and those that have no activity are either currently
empty or have less than a hundred records in them. So just dumping the
Hi David,
Let me point you in a bit different direction. You are already running
replication as it seems from your E-mail
So, why not just run chained replication from second to the third server
and use "replicate-do-table = [table_name]" in my.cnf of the third
server to limit selection of tables
Howdy Guys and Gals,
We are acquiring data on background radiation in a master-slave server
environment (RH9.0, MySQL 4.0.24) at the rate of approximately 19,000
records per day. The data are insert-only into about 25 of 31 tables in
the database -- no updates are ever applied to the data. Inf
HI,
I want to distribute the MySQL DB to different user with an PHP web app. My
biggest problem is MySQL data files. Is there anyway by which I can
configure the MySQL so that only PHP script can read it and if you happen to
copy the Data files and try to use it, that will be useless.
I know, th
I suggest you use parentheses, by the way, so that it is obvious what you
are doing. I never like to depend upon the precedence of operators to make
my intentions clear. It's too easy to make mistakes.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 0603
Hello,
I have a master that's been running since the 13th of January. Since
the same date I've had a slave running against it, without any errors
or serious lag. Suddenly, this morning replication broke with
duplicate entry errors. My master claimed to be on mysql-bin.14
with a significant LO
Be careful there...
You should probably use '(' ')' around that ...
select * from table1 where id=1 or (id>=3 and id<=4)
On Sunday 28 January 2007 02:21, Miguel Vaz wrote:
> I am dumb, so sorry:
>
> select * from table1 where id=1 or id >=3 and id <=4
>
> Ha
Hi,
In your SQL statement you have used subquery. The subquery feature is
introduced in MySQL version 4.1 and later. Thats why you are getting the
Syntax error while running subquery in v4.0.24.
Thanks,
ViSolve DB Team
- Original Message -
From: "A Blossom of Paradise" <[EMAIL PROTE
Hi,
You can use
select *
from table1
where id in (1,3,4,5);
Thanks,
ViSolve DB Team
- Original Message -
From: "Miguel Vaz" <[EMAIL PROTECTED]>
To:
Sent: Sunday, January 28, 2007 7:51 AM
Subject: Re: simple alternate query
I am dumb, so sorry:
select * from tabl
22 matches
Mail list logo
