this is in which version of MYSQL..
One cant write procedures and functions in MYSQL 4.0.12...
Regards
Swati kalia
http://www.mecklai.com
where risk meets its match
***
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]
Sent: Thursday,
At 03:21 PM 11/26/2003, you wrote:
If someone can copy your database files, you're hosed. All the attacker
need do is start the server with --skip-grant-tables, and he can can
connect to it with no password, and has complete access to any files
managed by the server.
Paul & Curley,
hi all.,
i tried to compile mysql-3.23.58 source
distribution for windows using VisualStudio 6 and
found that MySqlManager.rc file missing and hence the
compilation failed , The MySqlManeger.rc file is not
available in the MySqlManager folder downloaded from
mysql home site.
plz help me out in
hi all.,
i tried to compile mysql-3.23.58 source
distribution for windows using VisualStudio 6 and
found that MySqlManager.rc file missing and hence the
compilation failed , The MySqlManeger.rc file is not
available in the MySqlManager folder downloaded from
mysql home site.
plz help me out in
Hi,
I'm trying to get the MySQL-4.0 for linux
(mysql-standard-4.0.16-pc-linux-i686.tar.gz), from the mirror
mysql.secsup.org but it has a problem when attempting to uncompress the file
(get "unexpected EOF in archive"). I'm getting this by using the ftp utility
on a Linux server. It clearly stat
Well, how about that. Using PHP, it just get's better each time! I found
this little snippet and adjusted accordingly...
http://us2.php.net/manual/en/function.implode.php
while(list($column, $value) = each($FOO))
{
$upd[] = " $column = '$value'"; //this will loop until sql is built
}
$
I'm generating a dynamic UPDATE command in a loop. The problem is the stupid
comma.
Given this general idea, how do I handle the pesky comma. It's either in the
front and in the way, or on the trailing end and in the way...
I either end up with something like this:
mysql> UPDATE contact_table SET
Hi Chris,
It doesn't take MySQL any more or less time to update a unique index
than a non-unique one. :-)
Hope that helps.
Matt
- Original Message -
From: "Chris Elsworth"
Sent: Wednesday, November 26, 2003 12:14 PM
Subject: Unique Index efficiency query
> Hello,
>
> Let me just ou
On Wed, Nov 19, 2003 at 05:09:26PM -0800, kp gbr wrote:
> How do I perform checkpoint in MySQL.
You cannot.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 74 days, processed 2,914,655,888 queries
On Wed, Nov 26, 2003 at 02:16:16PM -0800, trevor%tribenetwork.com wrote:
> Greetings,
>
> From what I can gather the" Queries per second average" quoted by
> ">status" is a pure division of "Questions" by "Uptime" in ">show
> status". Is there a way to flush these figures periodically?
Yes, you
At 16:20 -0800 11/26/03, Aaron Efland wrote:
Hello,
I was wondering if someone could provide a brief description
for both of
the following attributes within the 'db' table:
'create_tmp_table_priv' and 'References_priv'
The first allows you to create temporary tables with CREATE TEMPORARY
TABLE.
Hello,
I was wondering if someone could provide a brief description for both of
the following attributes within the 'db' table:
'create_tmp_table_priv' and 'References_priv'
Any information you can provide will be helpful.
Thanks,
Aaron
--
MySQL General Mailing List
For list archi
At 0:05 + 11/27/03, [EMAIL PROTECTED] wrote:
Hello,
we currently have MySQL ver., 4.0.15 RPM installed on a RH/linux 7.3
system, and would like to enable SSL support, we have openssl
installed. The "SHOW VARIABLES" indicates that SSL support is disabled,
"have_openssl=NO"
Is it possible to ena
Hello,
we currently have MySQL ver., 4.0.15 RPM installed on a RH/linux 7.3
system, and would like to enable SSL support, we have openssl
installed. The "SHOW VARIABLES" indicates that SSL support is disabled,
"have_openssl=NO"
Is it possible to enable with our my.cnf file
thx's
Mickalo
--
My
My apologies. The answer was in PHP-land.
- Original Message -
From: "Paul Freedman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 26, 2003 3:26 PM
Subject: putting an array in a column
I'm new at SQL, and am teaching myself. I hope this isn't too basic a
questio
Greetings,
>From what I can gather the" Queries per second average" quoted by ">status"
is a pure division of "Questions" by "Uptime" in ">show status". Is there a
way to flush these figures periodically? I want to be able to set the bin
interval for this average, otherwise fluctuations get s
Yeah the problem was the tables I created were not MyISAM. Once I changed
it; EVERYTING GONNA BE ALRIGHT!
/T
on 11/25/03 7:20, Victoria Reznichenko at [EMAIL PROTECTED]
wrote:
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>> I am getting the following error when I try to access a merged tabl
Mayuran wrote:
Ive never used MySQL navigator, but I think you should assign the
primary keys
in the same line, like so:
dt_amtDateNot Null
operINTNot Null
amountDecimal(3,3)Null
primary key (dt_amt, oper)
thats, ok. It's a sql navigator bug! I had created the tabl
At 16:13 -0500 11/26/03, Kevin Carlson wrote:
Curley, Thomas wrote:
I am trying to find a solution to the following security issue with
MySql DB on linux
- Someone copies the DB files to another box, starts a mysql
instance, loads the DB and presto - views the 'private' data !!!
As all the ot
Curley, Thomas wrote:
I am trying to find a solution to the following security issue with MySql DB on linux
- Someone copies the DB files to another box, starts a mysql instance, loads the DB and presto - views the 'private' data !!!
As all the other posters have mentioned, you should have ti
At 07:22 AM 11/26/2003, you wrote:
Another Assumption
--
Encrypting / decrypting all data on the fly would be too expensive and
grind the app to a halt
Not true. There are some databases that can encrypt records on the fly
without any speed degradation (< 1%) using either Blowfis
I couldn't ask for more :)
Mike
On 11/26/03 3:40 PM, "Jeremy Zawodny" <[EMAIL PROTECTED]> wrote:
> On Wed, Nov 26, 2003 at 02:30:42PM -0500, Mike Minard wrote:
>> I would rather see these questions and answers in the list if you don't
>> mind. We are setting-up a MySQL cluster right now with ac
On Wed, Nov 26, 2003 at 02:30:42PM -0500, Mike Minard wrote:
> I would rather see these questions and answers in the list if you don't
> mind. We are setting-up a MySQL cluster right now with active/passive on the
> master node and 6 slave nodes. We are using GLP/in-house tools for our setup
> but
>Description:
g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local\""
-DDATADIR="\"/usr/local/var\""
-DSHAREDIR="\"/usr/local/share/mysql\"" -DHAVE_CONFIG_H
-I./../include -I./../regex
Kriengkrai J. wrote:
> -- System: MySQL 4.0.13, 4.0.16 on Linux x86
> -- Table type: MyISAM, InnoDB
> -- Description / How-To-Repeat:
> -- 1. When I use
> -- SELECT id, type FROM test.report ORDER BY type, id;
> -- the result is in wrong order
> -- --
> -- ++-+
> -- | id | type|
>
I'm new at SQL, and am teaching myself. I hope this isn't too basic a question, but I
can't find any reference to this and I'd like not to hunt-and-peck yet another issue,
just this once.
I have a PHP array which is just a sequence of numbers: $ARA = [3,4,7,2,6]. I would
like to stash this arr
At 20:50 +0100 11/26/03, getting_out wrote:
Good evening people.
I'm trying to create a simple table via MySQl Navigator.
The table il structured in this way
dt_amt DateNot NullPrimary Key
operINT Not NullPrimary Key
amount Decimal(3,3)Null
getting_out wrote:
Good evening people.
I'm trying to create a simple table via MySQl Navigator.
The table il structured in this way
dt_amtDateNot NullPrimary Key
operINTNot NullPrimary Key
amountDecimal(3,3)Null---
but when I choose "fire" it shows
Good evening people.
I'm trying to create a simple table via MySQl Navigator.
The table il structured in this way
dt_amt DateNot NullPrimary Key
operINT Not NullPrimary Key
amount Decimal(3,3)Null---
but when I choose "fire" it shows me
I would rather see these questions and answers in the list if you don't
mind. We are setting-up a MySQL cluster right now with active/passive on the
master node and 6 slave nodes. We are using GLP/in-house tools for our setup
but we are always interested in seeing what else is out there.
Thanks!
If so, could you ping me off-list? I'd just like to ask a few quick
questions.
Thanks,
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 73 days, processed 2,905,787,388 queries (455/sec. av
You can't INSERT, but with mysql 4.0.15 and better, you can ON UPDATE
CASCADE and ON DELETE CASCADE
Daevid Vincent
http://daevid.com
> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 26, 2003 1:24 AM
> To: [EMAIL PROTECTED]
> Subject: Re: I
Hi All;
I inherited an old Access database at work which was not at all normalized. I then
managed to normalize the schema, but I am running into problems. First let me show you
the two tables I need to query:
--
# Host: 10.1.1.14
#
Hello,
Let me just outline the table in question first.
I have a rather large (40,000,000 rows) table as follows:
Table: MessageIDs
Create Table: CREATE TABLE `MessageIDs` (
`mid_msgid` char(96) NOT NULL default '',
`mid_fileid` int(10) unsigned NOT NULL default '0',
`mid_segment` sm
At 12:53 -0500 11/26/03, Mayuran wrote:
This is my current setup, two MySQL servers. One master, the other slave.
Suppose I created a table with one column named 'image', which is of
type BLOB.
Now, if I inserted binary data from an image file (using perl or
something) into
that column on the ma
This is my current setup, two MySQL servers. One master, the other slave.
Suppose I created a table with one column named 'image', which is of
type BLOB.
Now, if I inserted binary data from an image file (using perl or
something) into
that column on the master, how will replication be handled? b
At 11:51 -0500 11/26/03, Millaway, John wrote:
Inserting a NULL into a NOT NULL column used to automatically get the
DEFAULT value. I realize that it was non-portable, non-standard behavior,
but the code relies on it. How do I get this behavior in the 4.0.x server?
mysql> CREATE TABLE t (a INT NOT
Stefan Kuhn wrote:
To the chap who siad its not a DB issue - I will check with Oracle but I'm
sure that dropping in a directory in oracle will not give you full access
to a database (a clear one that is)
The chap was me :-) I'm sure it does on oracle. Once you have an Oracle
installation and
> > mysql> CREATE TABLE t (a INT NOT NULL DEFAULT 0);
> > Query OK, 0 rows affected (0.00 sec)
> >
> > mysql> INSERT INTO t (a) VALUES (NULL);
> > ERROR 1048: Column 'a' cannot be null
>
> Just leave the NOT NULL column out when inserting and it will
> get set to its default.
It's not just one
On Wednesday 26 November 2003 17.51, Millaway, John wrote:
> Inserting a NULL into a NOT NULL column used to automatically get the
> DEFAULT value. I realize that it was non-portable, non-standard behavior,
> but the code relies on it. How do I get this behavior in the 4.0.x server?
>
> mysql> CRE
http://www.mysql.com/doc/en/Replication.html
On Wednesday 26 November 2003 17.49, Mark wrote:
> Hello - we would like to be able to run multiple servers (probably on
> multiple networks) that all share one common database. By having more
> than one MySQL server on seperate networks we can guarante
Inserting a NULL into a NOT NULL column used to automatically get the
DEFAULT value. I realize that it was non-portable, non-standard behavior,
but the code relies on it. How do I get this behavior in the 4.0.x server?
mysql> CREATE TABLE t (a INT NOT NULL DEFAULT 0);
Query OK, 0 rows affected (0.
Hello - we would like to be able to run multiple servers (probably on
multiple networks) that all share one common database. By having more
than one MySQL server on seperate networks we can guarantee a higher
degree of resilience and stability.
Is this possible without writing code to send out up
Hi,
I recently upgraded from MySQL v3.23 to MySQL 4, and converted
my tables from MyISAM to InnoDB by using the ALTER TABLE
command. I did this for 16 tables. I know that MyISAM creates
seperate data/index files for each table and InnoDB uses a single file
for data and log. My question is, once
I'm using mySQL 4.0.14 Linux and the mySql CC 0.8.9 Beta.
I ran your script and I'm clear. So its version specific.
-Original Message-
From: Kriengkrai J. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 2:05 AM
To: [EMAIL PROTECTED]
Subject: Disorder result with ORDER BY wi
Why does only the [mysqld2] start see attached file
Does anybody have a my.cnf file for 3.23.58 since I can’t
get it started with InnoDB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
On Nov 26, Curley, Thomas wrote:
> thanks for reply - the requirement comes from a security audit - so
> try to think in terms of a hacker
>
> Obviously and (I had assumed)
> 1.- the files would have tight unix security file permissions
> applied
> 2.- indeed the key would be stored o
Andre Winarko wrote:
I have problem with mysqldump.
This query results an error.
mysqldump danamon [trx_temp2] > trx_temp2.sql
The error message is :
mysqldump : Can't get CREATE TABLE for table
'[trx_temp2]'
I'm sure the trx_temp2 table in danamon database
exists.
Yes, but [trx_temp2] do
Hacker gets in this way:
->[Webserver][rooted]->[DBServer][rooted]->File_Access(/var/lib/mysql/database)
I'd say the "major security breach" is already when the Webserver is rooted.^
If he gets to your webserver he could still read WHATEVER DATA he wants from
your database with the information he
-- System: MySQL 4.0.13, 4.0.16 on Linux x86
-- Table type: MyISAM, InnoDB
-- Description / How-To-Repeat:
-- 1. When I use
-- SELECT id, type FROM test.report ORDER BY type, id;
-- the result is in wrong order
-- --
-- ++-+
-- | id | type|
-- ++-+
-- | 4 | general |
--
> To the chap who siad its not a DB issue - I will check with Oracle but I'm
> sure that dropping in a directory in oracle will not give you full access
> to a database (a clear one that is)
The chap was me :-) I'm sure it does on oracle. Once you have an Oracle
installation and got hold of all da
Hi All;
The last MySQL newsletter linked to my article titled "Protecting MySQL
Sessions With SSH Port Forwarding", available at
http://www.vbmysql.com/articles/sshtunnel.html. Response was positive, but
there were multiple requests for information on hosting SSH sessions on a
Windows server.
In
On Wednesday 26 November 2003 13:43, Curley, Thomas wrote:
> Mike
>
> Correct and this is the architecture. The internet facing box has a
> routable IP, the DB box is separate and is not ext routable.
>
> The issue the security review highlighted strongly was the fact that if a
> hacker got access
Mike
Correct and this is the architecture. The internet facing box has a routable IP, the
DB box is separate and is not ext routable.
The issue the security review highlighted strongly was the fact that if a hacker got
access to the box (however) then copying /var/lib/mysql/database would resu
One of the first things that I did at my former job was to turn off all
external-facing network adapters to our DB machines. If you're fortunate
enough that your DB resides on it's own box and not the webserver itself,
then there's really no reason that you *need* to have it externally facing.
Ther
Well, I'm not an expert on security, but I don't think this is a database
issue. It is really a file/operating system issue. I don't think you can do
anything in the database against copying the files. If somebody has access on
file system level, the dbms is powerless. So I think you need to thi
On Wednesday 26 November 2003 13:22, Curley, Thomas wrote:
> Another Assumption
> --
> Encrypting / decrypting all data on the fly would be too expensive and
> grind the app to a halt
>
> So the question again :-
>
> Any ideas on how to avoid having data files stored with abso
thanks for reply - the requirement comes from a security audit - so try to think in
terms of a hacker
Obviously and (I had assumed)
1. - the files would have tight unix security file permissions applied
2. - indeed the key would be stored on an internal tightly managed box (or device)
a simple way is to do select $form as new_column_name from structure"; as
the query.
thus the return value of you column will be in new_column_name.
Vinay
joffrey leevy wrote:
> Would appreciate in anyone can help me.
>
> Let's say I do a query in php, eg. $query = "select
> shed from structure
Thomas,
I am trying to find a solution to the following security issue with MySql DB on linux
- Someone copies the DB files to another box, starts a mysql instance, loads the DB and presto - views the 'private' data !!!
Well, "someone" should not have access rights to the DB files on the
firs
Hi,
Version 4.1.0. crashing on my Windows 2000 box after this query:
SELECT * FROM `streets` where MBROverlaps(GeomFromText('Polygon(16345750
48185401, 16402348 48185401, 16402348 48156946, 16345750 48156946,
16345750 48185401)'), GEOM);
GEOM is field of type "geometry" inside streets table. I
Zenzo <[EMAIL PROTECTED]> wrote:
>
> What mysqldump does?
> I dont know it because i am new in the world of databases
>
mysqldump makes dump of the database or databases:
http://www.mysql.com/doc/en/mysqldump.html
--
For technical support contracts, goto https://order.mysql.com/?ref=e
I am trying to find a solution to the following security issue with MySql DB on linux
- Someone copies the DB files to another box, starts a mysql instance, loads the DB
and presto - views the 'private' data !!!
Ideally I would like to know if there is any option in MySql to store the DB files i
- Original Message -
From: Prashant A <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, November 26, 2003 5:20 PM
Subject: [PHP] Urgent Two Queries / Problems to be Solved--Prashant
Akerkar
>
> Dear Mr Jeffrey Dyke
>
>
> There
What mysqldump does?
I dont know it because i am new in the world of databases
Andre Winarko <[EMAIL PROTECTED]> wrote:
I have problem with mysqldump.
This query results an error.
mysqldump danamon [trx_temp2] > trx_temp2.sql
The error message is :
mysqldump : Can't get CREATE TABLE for table
'
Dear Mr Jeffrey Dyke
There are some queries regarding PHP 4.1.As you mentioned in php 4.1
register_globals=off. are set for security reasons.
Is it Required to have Form attribute as enctype="multipart/form-data" if i
have a File Upload on the Particular Form.
i.e
I am Facing a Problem as
"Kate Porter" <[EMAIL PROTECTED]> wrote:
> I am using 4.0.15 on RedHat 7.3 and ran it to a strangest problem today.
>
> SELECT col FROM table WHERE site_id=123;
> returns a list of data.
>
> SELECT col FROM table WHERE site_id IN(123);
> returns an empty set.
>
> Upon further investigation, I f
# uname -X
System = SCO_SV
Node = scospare
Release = 3.2v5.0.6
KernelID = 2000-07-27
Machine = PentII(D)
BusType = ISA
Serial = 3IG004365
Users = 5-user
OEM# = 0
Origin# = 1
NumCPU = 1
#
Stefaan Van Dooren .--.
Technical Support |o_o |
Kompas Automatisering |:_
"Paul Fine" <[EMAIL PROTECTED]> wrote:
>
> If I have two tables with the first table containing a field which is FK of
> table 2, when I insert a value into this field, should it not automagically
> insert a value into that PK in the second table?
>
No, it should not insert data in the child tab
Hello all,
I'm using mysql 3.23.49 under Debian Linux and gcc 2.95.4.
I'm writing a mysql client in C, and therefore I link libmysqlclient.a in my program.
The problem is that I also use and link a static list-handling library I've written
some time ago.
And of course problem arises with "mu
On Wednesday 26 November 2003 08:42, Andreas Buschka (tops.net) wrote:
> My question is: How is the general stability of the 4.1.x versions? Can it
> be used for new projects, or is it so unstable that the risk is too high?
In my testing so far, the connection capability seems to be intermittent
Hello!
We are currently using MySQL 4.0.x to develop a project for a customer which
should be released in early February 2004. The MySQL Download Page states
that for new developments, 4.1.x can be used. I would also like to use this
version, since it allows subqueries, a feature that 4.0.x curren
72 matches
Mail list logo
