Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret information in the database.
And this information should not be visible/accessible to any other person but
the owner of the data.
Whilst I know that encryption/decryption is the solution for this, are there
any
?
- Original Message -
From: Chris [EMAIL PROTECTED]
To: Ratheesh K J [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, May 15, 2007 2:42 PM
Subject: Re: Data security - help required
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret information
Well,
you can save all data encoded in the database:
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function_encode
- Mike
Chris schreef:
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret information in the
database. And this information
Ratheesh K J wrote:
Ok.. Will it be secure if the data is encrypted. mysqldump will show
encrypted data right.
mysqldump will show whatever the database table does - it just grabs
that info and puts it into a file. If it's encrypted in the table,
that's what mysqldump will show.
Actually I
On Tue, May 15, 2007 11:12, Chris wrote:
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret information in the
database. And this information should not be visible/accessible to any
other person but the owner of the data.
Whilst I know that encryption/decryption
, since at the very least the programmer needs access to it so it can be presented to
the user.
- Original Message -
From: Ratheesh K J [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: Chris [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2007 5:19 AM
Subject: Re: Data security - help required
On 5/15/07, Ratheesh K J [EMAIL PROTECTED] wrote:
Hello all,
I have a requirement of maintaining some secret information in the
database. And this information should not be visible/accessible to any other
person but the owner of the data.
Whilst I know that encryption/decryption is the
Hlo,
I got this Stat of MySQL. I want to know is there something to worry about,
especially the number of temp tables.
Key Reads/Key Read Requests = 0.007094 (Cache hit = 99.992906%)
Key Writes/Key Write Requests = 0.239130
Connections/second = 8.741 (/hour = 31467.279)
KB received/second =
Ratheesh K J wrote:
Hlo,
I got this Stat of MySQL. I want to know is there something to worry about,
especially the number of temp tables.
That looks like a sign of missing indexes.
Temporary tables shouldn't be created that often if your queries are
indexed properly, even though they're
-
From: Chris [EMAIL PROTECTED]
To: Ratheesh K J [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, September 27, 2006 12:50 PM
Subject: Re: Mysql Stat - Help required
Ratheesh K J wrote:
Hlo,
I got this Stat of MySQL. I want to know is there something to worry
about, especially
, grouping, table joins, subqueries (possibly)..
- Original Message - From: Chris [EMAIL PROTECTED]
To: Ratheesh K J [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, September 27, 2006 12:50 PM
Subject: Re: Mysql Stat - Help required
Ratheesh K J wrote:
Hlo,
I got this Stat
Hello all,
I am required to analyze all the tables of our system. I need to know the key
parameters that should be taken into consideration for analysis. I am not
speaking about ANALYZE TABLE tbl name. I am required to manually look into
all table structures and pin point problems ( if any ).
If i was you i'd start reading the manual. Look under the optimization
chapter. Also, brush up on database normalization and look into how
exactly the tables are being used - run explains on the sql statements
that are used with the tables and see how you can optimize index usage.
Ratheesh K
Ratheesh K J wrote:
Hello all,
I am required to analyze all the tables of our system. I need to know the key
parameters that should be taken into consideration for analysis. I am not speaking
about ANALYZE TABLE tbl name. I am required to manually look into all table
structures and pin point
. 6 months).
So how large can a table be? As large as you want.
- Original Message -
From: Ratheesh K J [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, August 03, 2006 2:42 AM
Subject: Table analysis - Help required urgently
Hello all,
I am required to analyze all
Hi,
I am building the insert string for inserting into particular table t1
using C program. The below string is stored in a variable.
say sqlstmt = 'INSERT INTo T1 values(:id,:ename);'
The values for the field's id, name will come from the front end. The
sql string will be executed using Pro
Check here. You will find examples here.
http://www.geocities.com/jahan.geo
[EMAIL PROTECTED] wrote:
Hi,
I am building the insert string for inserting into particular table t1
using C program. The below string is stored in a variable.
say sqlstmt = 'INSERT INTo T1 values(:id,:ename);'
The values
Soni, Sanjay K [EMAIL PROTECTED] wrote:
040225 13:57:20 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040225 13:57:21 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
Hi!
It seems that you have installed mysql, but you did not run the
mysql_install_db, this script will create mysql internal databases(the
ones that carries user and config info), the script is usually in
install_prefix/bin/mysql_install_db
If you have no recently installed mysql, and the server
GE Financial Assurance
-Original Message-
From: Soni, Sanjay K [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 6:48 PM
To: [EMAIL PROTECTED]
Subject: urgent help required for mysql
040225 13:57:20 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist
040225 13:57:20 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040225 13:57:21 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040225 13:57:22 InnoDB: Log file
Hi,
Background: I run a prediction league for soccer
competitions. For every game, I want to show how many
predictions were submitted per scoreline, ie.
10% said 1-0
20% said 0-1
30% said 2-3
etc.
My prediction table has a predictionA and predicionB
column with the submitted scores.
Currently
- Original Message -
From: Riaan Oberholzer [EMAIL PROTECTED]
2-0, 2-1, 2-2, 2-3
1-0, 1-1, 1-2, 1-3
0-0, 0-1, 0-2, 0-3
SELECT CONCAT(predictionA, '-', predictionB) AS score,
COUNT(CONCAT(predictionA, '-', predictionB)) AS count
FROM table
WHERE CONCAT(predictionA, '-', predictionB)
I am trying to create a html search results page with the following:
SELECT *
FROM tbl_allarticles
WHERE (fld_headline LIKE'%userinput%' OR fld_summary
LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND fld_category
LIKE 'catvalue'
The above works fine, but the below code is giving me some
I am trying to create a html search results page with the following:
SELECT *
FROM tbl_allarticles
WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%'
OR fld_body LIKE'%userinput%') AND fld_category LIKE 'catvalue'
The above works fine, but the below code is giving me some
Matthew Stuart wrote:
I am trying to create a html search results page with the following:
SELECT *
FROM tbl_allarticles
WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%'
OR fld_body LIKE'%userinput%') AND fld_category LIKE 'catvalue'
The above works fine, but the below
Hi,
I'm looking for information on testing MySQL server with Open SSL
using any client(JDBC/ODBC). Please let me know how to test using a
MySQL client for SSL. I was able to compile mysql with using open SSL
Thanks
Ram
--
MySQL General Mailing List
For list archives:
,
Robin
-Original Message-
From: Almar van Pel [mailto:[EMAIL PROTECTED]]
Sent: 05 February 2002 00:02
To: [EMAIL PROTECTED]; Robin Keech
Subject: RE: performance help required. (2G - 4G Ram upgrade)
Hi,
Your problem is that your query uses all of the rows in the table. That
means
I've asked this before, but let me describe it another way, and see if
anyone has any bright ideas:
My client has 3 offices.
Each office needs to use same app (over MySQL).
Each office needs (effectively) same database.
Updates done at each office need to be used at other offices.
Updates
,
Robin
-Original Message-
From: Almar van Pel [mailto:[EMAIL PROTECTED]]
Sent: 05 February 2002 00:02
To: [EMAIL PROTECTED]; Robin Keech
Subject: RE: performance help required. (2G - 4G Ram upgrade)
Hi,
Your problem is that your query uses all of the rows in the table. That
means
(Please reply directly, I am only on the digest list, thanks)
I have an SQL statement that is taking far too long to run, around 11
minutes (while locking inserts/updates).
We have installed some more RAM, and I need help with my.cnf and the
troublesome SQL.
Can anyone suggest some config
On Mon, Feb 04, 2002 at 05:41:46PM -, Robin Keech wrote:
(Please reply directly, I am only on the digest list, thanks)
I have an SQL statement that is taking far too long to run, around
11 minutes (while locking inserts/updates).
We have installed some more RAM, and I need help with
for maintenance periodically to optimize these heavy
tables.
Regards,
Almar van Pel
-Oorspronkelijk bericht-
Van: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 5 februari 2002 0:04
Aan: Robin Keech
CC: '[EMAIL PROTECTED]'
Onderwerp: Re: performance help required. (2G - 4G Ram
Hi,
Does the mysql support internationalisation?. If so, Kindly let me know
what settings I need to configure
to insert korean strings into the table and retrieve the same and show it in
a browser(jsp page)?.
Is there any GUI tool for mysql(like Toad for Oracle)?. if so where can I
get that?.
Hi Karthik,
Most probably the PHP module that you are using with Apache is not compiled
with Mysql support. Can you post the information about php installation that
you have?
Put this in a file called say phpinfo.php:
?php
On Thursday 06 December 2001 01:08, Karthikeyan wrote:
Dear Members,
I installed RedHat 7.1, Apache, PHP4 and MySQL in a Intel Pentium processor
system.
Everything works fine (i.e. MySQL, PHP, etc). But when I want to connect
Is phpinfo() working ?
Test on mysql support.
Check on the file
Asit,
Did you ever solve your problem? - I have the same...
Bruce
-Original Message-
From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]]
Sent: Thu, 07 June 2001 21:42
To: asit; [EMAIL PROTECTED]
Subject: Re: Help required for OLEDB on win32 for MySQL(linux)
At 20:56 07/06/2001
At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote:
innodb_data_file_path=ibdata1:200M
innodb_data_home_dir=f:/mysql/innodb/ibdata
innodb_log_group_home_dir=f:/mysql/innodb/iblogs
The directories specified in the above variables exist.
However when I try to run the service I get the error Could
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Using InnoDb table type - Urgent help required
At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote:
innodb_data_file_path=ibdata1:200M
innodb_data_home_dir=f:/mysql/innodb/ibdata
innodb_log_group_home_dir=f:/mysql/innodb/iblogs
The directories
Hi,
I am using mySQL on Windows 2000. I need to use the InnoDb table type to get
transaction support. I had initially installed mysql and was using the ISAM
table type and everything was working fine. My NT service was configured to
run the mysqld-nt.exe. For using the InnoDb type I
Hi,
I am facing problem while connecting to MYSQL server (linux) from Win32 VB client
through OLEDB provider from MYSQL.
I am successfully connecting to server through MyODBC using DSN but
unable to connect to through OLEDB provider ( downloaded from www.MYSQL.com)
Following is the script
At 20:56 07/06/2001 +0530, asit wrote:
Hi,
Please take a look on the help file, where you should find that
your connection string is wrong. You find the instructions of
the connection string just below of Overview item.
server=192.168.100.101 ?
Regards,
Miguel
Hi,
I am facing problem while
42 matches
Mail list logo
