On Mon, 2002-06-03 at 04:58, Evgeny Chuykov wrote:
What algorithm do ENCODE-DECODE functions use?
This is noname algorithm with questionable security level. Use
DES_ENCRYPT/DES_DECRYPT instead. This uses triple DES.
Tõnu
sql
On Fri, 2002-05-31 at 20:54, Cesar Mello - Axi wrote:
Hello,
You could maybe buffer the data in Your application
and then run inserts later... like this.
This is not a solution for me as the data acquisition can take hours without
any break.
Whatever you do, with any SQL you get stuck
On Fri, 2002-05-31 at 17:52, Marcel wrote:
Hi all,
How is the best tool for acess Mysql By SSL protocol ?
What do you need to do? MySQL C API has all neccessary stuff to use SSL
and mysql command line tool can use it from 4.0.x versions.
Tònu
Rol wrote:
Hallo all,
A table containing some text needs to have some of the letters changed (eg.
letter to be replaced with "auml;" ).
Is there a way to use a replace function to search for such chararcters in a
text and then replace it with the html tag?
Yes of course and this
tmb wrote:
How does PostreSQL compair to MySQL ?
I'm sure each has it's own advantages disadvantages.
What are some of the major ones?
Both are very good databases with free type licenses. There are
advantages. dot.
--
MySQL Development Team
__ ___ ___ __
/ |/ /_
"Ciprian A." wrote:
I would need some reasons for choosing MySQL instead of Microsoft SQL.
(beside the fact that MySQL is free). (not for me but for my boss).
It may sound silly but trust me I really need these reasons. So please help
me with this.
The biggest reason to avoid Microsoft
Kyzen Computers wrote:
I was wondering if someone can help me, I am new to the list and was looking for
some help on how I can use mysql with my website to keep track of who comes in and
giving them logins
I have just read mysql and don't know anything PHP or CGI but if some one tells me
"J.C. Ting" wrote:
I use Mysql for half year. At this moment, I encounter a big problem
that I can not query any data from my server.
The following is my configuration.
Platform: Solaris 2.7 on Sun Ultra2
Mysql version: 3.22.29
Table Name: mailhead;
mysql select * from mailhead where
Sanjeev Adhyapak wrote:
We have installed redhat 7.0 server on one machine and want to run mysql
server on that. The installation is default. After that only the root is
allowed to connect to the server and if login as different user i am
getting the error as error 111 connection refused.
Sunrise wrote:
Hi, alexander.skwar,
Mysql has the type as the MSSQL BIT???
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Yes and this is documented in manual.
--
MySQL Development Team
__
Keneth wrote:
"When I try to dump sql database it gives me some errors 1.Error 1045
mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045:
Access denied for user: 'accp@localhost' (Using pass word: NO) "
can you help?
Please read the manual and list archive!
Before
Tim Bunce wrote:
Only problem we know is that in our tests on ReiserFS is MySQL was 30%
faster on writes :/
How does it compare to FreeBSD with "soft updates" enabled?
Sorry, I use only linux and very rarely touch anything else. So this 30%
was meant under linux. Sorry for confusion. I
Marcus Ouimet wrote:
One quick question, I am trying just replace part of the entry ie:
change:
/image/covers/009.jpg
to
image/covers/09.jpg
I have tried to update products set 'image/covers' where
products_image like '/images/covers%'; but it seems to replace the whole
field and not
[EMAIL PROTECTED] wrote:
On 22.02.2001 16:22:13 Simon Windsor wrote:
Has anyone user MySql on a ReisserFS file system ?
HERE!
No problems whatsoever - why should there be problems anyway?
Only problem we know is that in our tests on ReiserFS is MySQL was 30%
faster on writes :/
--
Peter Skipworth wrote:
I'd heard that even in general use, some users had a noticeable increase
in disk reads/writes under ReiserFS...it sounds like you haven't
experienced this (?). I'm thinking about moving over to ReiserFS as well,
shortly, and am looking for as much feedback from people
[EMAIL PROTECTED] wrote:
On 23.02.2001 10:29:21 ?iso-8859-1?Q?T=F5nu?= Samuel wrote:
Only problem we know is that in our tests on ReiserFS is MySQL was 30%
faster on writes :/
Hmm, so, I understand you right: You're saying that it's not a good idea to use
MySQL on ReiserFS, as you
Andrea wrote:
Depending on manual, i have information about conecting to a remote MySql
from windows with SSH
and there a site http://www.doc.ic.ac.uk/~ci2/ssh/
But this site is gone.. :(
Where i can download a free ssh ?
This is offtopic. Hint: download it from http://www.google.com
Jim Bayers wrote:
I have a non-profit site that uses mysql. I need to optimize two queries so
they won't put such a load on the mysql server. If I don't lighten the
load, they've treatened to kick us off.
Check the manual chaper about optimizations, especially about EXPLAIN
command. This
Sascha Andres wrote:
hi,
on a suse 7.1 system my mysql fails on startup.
it can't create a pid. how can i fix this ?
sascha
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
paul herigs wrote:
I want to know something about MySQL versions
we have a database working with version 4.0. can you tell me were I can
download this version. On the internet I only can find version 5.0 and
my database don't response on this version.
Something is totally wrong. MySQL-4.0
Rus wrote:
Hi!
Does MySQL open all tables in database when I select data from one table?
No. But he will keep last x ones for faster access. My my.cnf file:
[tonu@no tonu]$ cat /etc/my.cnf
[mysqld]
log-slow-queries=/var/log/mysql-slow-query.log
set-variable = long_query_time=1
set-variable
"MAN ..." wrote:
HI THERE, I HAVE A PROBLEM WITH THE ETTIQUETES OF THE DATABASE, I MEAN HOW DO I CAN
MAKE A SITE WHERE I CAN UPLOAD INFORMATION WITH A DATABASE, FOR EXAMPLE:
IF I WANT A PAE WHERE SAYS "PUT YOUR NAME HERE" AND YOU HAVE TO PUT IT IN AN
TEXTAREA HOW DO I MAKE THAT THAT NAME
Joel Holtzman wrote:
Hello, I always wanted a gui interface to use on my win 98 pc to connect to mysql,
and create/edit tables. However, i always get an access denied error, saying I'm not
allowed to connect to the mysql server.
However, via telnet, I am fine.
By default MySQL server
msquared wrote:
I'm working for a company that has a paranoid client, and the client wants
their database to be 'secure'.
By 'secure' they mean that even if someone gains root access on the
server, the data in the database can't be compromised (obtained).
I can think of a couple of
Dimitar Boiadjiev wrote:
Hi all,
I've been working on optimizing my query but no success. Concerning the
type of query shown by "explain select", about join type "ALL" in the
manual is written: "This is normally not good if the table is the first
table not marked const, and usually very
Derek Sivers wrote:
Any measures I could take (like SSH) to encrypt the transaction?
Use CIPE tunnel. You can find it:
http://sites.inka.de/sites/bigred/devel/cipe.html
Is this anything like ipsec?
http://www.openbsd.org/faq/faq13.html
(I'm using OpenBSD.)
Or, rather, could I use
Jason Radley wrote:
I am currently using php and mysql and I was wondering if you can take the
data from a mysql database and move it to a oracle database?
Thank you,
mysqldump exports data from MySQL database and them Oracle should be
able to import it.
--
MySQL Development Team
__
Muhanad Mustafa wrote:
Ok, i'm very new to Mysql. . The documentation is a little confusing for me to
figure out so I thought this might help. I had created a database on my system
called "customer15"
I did this
mysqlcreate database customer15
Now I want to setup a mysql username
marko milovanovic wrote:
uh! i already posted this message a while ago!
could anyone please help me?
i could find some informations about increasing the size of the
databases, but not about limitations to their size.
how would it be possible to set a limitation in the size of the
29 matches
Mail list logo