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 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
---
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
Rol wrote:
>
> Hallo all,
>
> A table containing some text needs to have some of the letters changed (eg.
> letter ä to be replaced with "ä" ).
>
> 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
"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 p
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
__ ___ ___ __
/ |/
"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
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 tell
"Peter R. Wood - Mailing Lists" wrote:
> When he deletes an assignment from the class, it deletes it from both tables.
>
> However, after this, if he adds an assignment again, the unique ID generated
> by insertion into the assignment table is one greater than it should be -
> i.e., it auto incr
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!
> Befor
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
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
[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
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 pe
[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 writ
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. Th
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.goo
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
Fabio Berbert de Paula wrote:
>
> Hello,
>
> Did anybody perform MySQL in a cluster of
> machines using Mosix? Which was the result?
>
> Did MySQL uses shared memory?
>
> Or MySQL can't upgrade your perform in
> a cluster?
No, MOSIX can't run MySQL and because threads. At least this was in th
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-variab
"Thalis A. Kalfigopoulos" wrote:
>
> Has anyone tried running the TPC-W benchmarks on MySQL? I'm not talking about making
>the results official (I assume too much $$$) but just to implement them and see how
>it goes.
>
At least I do not know about such efforts. I wanted to run TPC-C while
ago
mysql wong wrote:
>
> how to i change the default connection from unix socket to tcpip 3306 ?
>
> currently is connection = localhost via unix socket
Client side command:
mysql -h 127.0.0.1
(not localhost)
also you can play with /etc/my.cnf file. Check the manual for details.
--
MySQL De
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
"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
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 serve
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
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 ve
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,
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
>
> mysql>create database customer15
>
> Now I want to setup a mysql
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
__
Derek Sivers wrote:
> searched the lists & books & found no mention of this:
>
> Are there any security issues in doing lots of remote-connecting (TCP/IP)
> to my MySQL database server?
Anything can be broken with this. MySQL limits this by amount of
max_connections but if someone else occupi
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 th
Marco Bizzarri wrote:
>
> Hi all.
>
> We're using mysql 3.22, on a Red Hat Linux 6.2 system. We're also
> accessing the data through MyODBC, from Windows. The mysqld is started
> with the skip-locking feature activated
>
> The problem is that we are experiencing index corruption when we access
lbraga wrote:
> Hi, my name is Lucio and i am with a
> problem in the definition of field
> type for a field that store IP address.
>
> I try varchar(15),varchar(32),
> char(15), bigint, but i don't have sucess.
> Can anyone help me?
> Thanks ... Lucio.
You should give us mysqlbug output, comm
"Ralf R. Kotowski" wrote:
>
> Ok I get a table is full error...
>
> So how/where do I set the tmp_table_size ? or the BIG_TABLES
> option so that its started that way at system start-up?
>
> from what I gather the Big_Tables option writes ALL tmp tables to
> disk, is that correct? so I should u
Robyn Renwick wrote:
> I use a MySQL database for the back end of our e-commerce site. We take
> credit as one method of payment and the last 8 digits of the card number
> are stored in the database. There is a web interface to the database from
> which I can get order information, but not the
fractals wrote:
> I have to deploy a java GUI to a remote MySQL server. The GUI part is OK,
> but now I have some concerns about security issues, like: how could the
> conduit between the GUI and the database be secured (possibly encrypted) ? I
> think one solution would be to use SSL, but that i
[EMAIL PROTECTED] wrote:
>
> Hey there, I've written about this a few times now and haven't received very many
>ideas.
>
> I'm running a pentium based server with 256 megs of ram using BSDI O/S 4.1
>
> I currently have the latest build of Perl 5 on my system as well.
>
> When I do a make on A
Aaron Schlesinger wrote:
> I agree with Carlos's response below. Tõnu I appologize for singling you
> out, but if you push away those simple questions, you'll just force those
> who are just getting started to find more patient people and software to
> use.
Critics is good :). I try to be more p
Carlos Corzo wrote:
> Some people have tried the manuals verbatim but are really confused
> because they are not at your intellectual level. If this list is for
> the "intelligent only", change the title please. Not everyone can
> decipher a manual. I may post questions but there are reasons
Maybe it is my depression and I see everything in black but please
read manual before posting questions in this list. Manual covers at
least 90% questions asked here. If manual does not cover them, we will
put new chapters in it. This is all because what we do in this list can
be called FREE
Chris Matthews wrote:
>
> Okay, so no jokes about telling my client, Ron, to go buy more memory... =)
>
> error is: "MySQL Client Run out of Memory"...
>
> > We get this error about every 2 weeks or so... Restarting MySQL, purging
> > hosts don't fix it, we actually have to restart Apache to fi
44 matches
Mail list logo