Re: ENCODE algorithm

2002-06-03 Thread Tõnu Samuel
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

Re: I need 50.000 inserts / second

2002-05-31 Thread Tõnu Samuel
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

Re: SSL

2002-05-31 Thread Tõnu Samuel
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

Re: Replace strings

2001-03-30 Thread Tõnu Samuel
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

Re: MySQL vs PostreSQL ??

2001-03-23 Thread Tõnu Samuel
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 __ ___ ___ __ / |/ /_

Re: Mysql vs ....

2001-03-23 Thread Tõnu Samuel
"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

Re: Need some help on how to use mysql with web site

2001-03-19 Thread Tõnu Samuel
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

Re: Help for mysql error

2001-03-19 Thread Tõnu Samuel
"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

Re: mysql on redhat 7.0

2001-03-17 Thread Tõnu Samuel
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.

Re: Antwort: Webmin

2001-03-15 Thread Tõnu Samuel
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 __

Re: how to backup mySQL database?

2001-03-12 Thread Tõnu Samuel
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

Re: Antwort: ReisserFS

2001-03-02 Thread Tõnu Samuel
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

Re: Only changing part of a field...

2001-02-24 Thread Tõnu Samuel
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

Re: Antwort: ReisserFS

2001-02-23 Thread Tõnu Samuel
[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 :/ --

Re: ReisserFS

2001-02-23 Thread Tõnu Samuel
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

Re: Antwort: Re: Antwort: ReisserFS

2001-02-23 Thread Tõnu Samuel
[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

Re: Secure connection with SSH

2001-02-19 Thread Tõnu Samuel
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

Re: Optimizing Queries

2001-02-19 Thread Tõnu Samuel
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

Re: MYSQL failes at startup

2001-02-18 Thread Tõnu Samuel
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)

Re: MySQL version

2001-02-12 Thread Tõnu Samuel
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

Re: Performance Q

2001-02-12 Thread Tõnu Samuel
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

Re: HOW DO I CAN DO THIS...

2001-02-08 Thread Tõnu Samuel
"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

Re: Simple question

2001-02-05 Thread Tõnu Samuel
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

Re: Database/table encryption

2001-02-01 Thread Tõnu Samuel
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

Re: explain select question

2001-01-22 Thread Tõnu Samuel
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

Re: SECURITY issue in remote tcp/ip connecting?

2001-01-20 Thread Tõnu Samuel
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

Re: MySQL and Oracle

2001-01-19 Thread Tõnu Samuel
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 __

Re: Setting Up Users!

2001-01-19 Thread Tõnu Samuel
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

Re: databases size limitation #2

2001-01-13 Thread Tõnu Samuel
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