Re: Insert static column into VIEW

2008-10-14 Thread Samuel Vogel
This is exactly what I tried to avoid by using a view. I do not want to have to take care about synchronizing two tables. Is there any way to avoid this? Regards, Samy

Insert static column into VIEW

2008-10-14 Thread Samuel Vogel
Hey guys, I am trying to construct a specially crafted view for the powerdns DNS-Server. This is what I have so far: CREATE VIEW test4 AS SELECT nummer AS name, ip as content FROM jabix.spaces JOIN jabix.ves ON spaces.veid = ves.id; ++---+ | name | content | +

Re: Triggering an action every 24 hours

2008-05-22 Thread Samuel Vogel
Dan Nelson schrieb: In the last episode (May 22), Samuel Vogel said: Hey, I am wondering how I can trigger an Action every 24 hours inside of mysql. A cron job would also do the job, but it won't work on shared hosts and it's just another point of failure. So is there any wa

Triggering an action every 24 hours

2008-05-22 Thread Samuel Vogel
Hey, I am wondering how I can trigger an Action every 24 hours inside of mysql. A cron job would also do the job, but it won't work on shared hosts and it's just another point of failure. So is there any way to run a specific SQL command every 24 hours inside of mysql? I'm using MySQL 5.0.51

Re: 30 % of my databases dissapeared

2007-12-06 Thread Samuel Vogel
Ok, I ran xfs_check and the filesystem is all well. Does anybody else have an idea? Regards, Samy Samuel Vogel schrieb: Hey, Thanks for the very fast reply. Of course I forgot that I'm running Linux Debian Etch with mysql 5.0.45 from backports. We have a 20GB quota set for MySQL. B

Re: 30 % of my databases dissapeared

2007-12-06 Thread Samuel Vogel
eport back here! Regards, Samy Michael Dykman schrieb: What system are you on? What is your disk capacity? It looks like the disk got corrupted.. How *that* happened is hard to say, but know what host OS/hardware you are on would give us a first clue. - michael On Dec 6, 2007 2:42 PM, Sa

30 % of my databases dissapeared

2007-12-06 Thread Samuel Vogel
Hey guys, I have a big Problem. About 30 % of my databases just disappeared around 6pm today. I do not have any clue how this happened. Is can just guess the time it happened from my munin graphs. The only thing that might be a clue are the following files in my data directory: h1314631:~#

Re: Processlist full of "Opening tables"

2007-11-13 Thread Samuel Vogel
ow many tables MySQL will keep open (table cache). You need to increase this number using the table_cache variable. set global table_cache=#; The Open_files number from the show status command is important, make sure that stays within limits of your operating system. On Nov 12, 2007 5:09 PM, Samu

Processlist full of "Opening tables"

2007-11-12 Thread Samuel Vogel
Hey guys, I do run MySQL on a high traffic Server with approximately 10k databases. Since some time MySQL is has become very sluggish. When I look at my processlist it shows more than 25 processes (sometimes of the same & table) with status "Opening tables". Some processes also show "closing t

Re: Storing Apache logs in MySQL.

2007-11-09 Thread Samuel Vogel
Hi, An easier method may be to install mod_log_mysql on each of the Apache servers and log directly to the central MySQL installation. Regards Ian This however is not an option at all when you run Apache in prefork mode. Because the sum of your MaxClients will be equal to the connectio

Re: ADDITIONAL SETTING IN MYCNF

2007-10-18 Thread Samuel Vogel
This line has not come later, it is standard in Debian, to be able to have parts of your configuration in different files. This line does all configuration files that are in "/etc/mysql/conf.d/. Since this directory is probably empty, nothing is done at all. So you are safe with just leaving th

Re: MySQL Server crashing & database corruption

2007-10-10 Thread Samuel Vogel
314631 mysqld[13284]: Version: '5.0.45-Debian_1~bpo.1-debug' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution What am I supposed to do? Regards, Samy Samuel Vogel schrieb: Actually I have an somewhat reproducible test case. Problem is, it

Re: MySQL Server crashing & database corruption

2007-10-07 Thread Samuel Vogel
ructure Oct 7 21:51:24 h1314631 mysqld[18836]: 071007 21:51:24 [Note] /usr/sbin/mysqld: ready for connections. Oct 7 21:51:24 h1314631 mysqld[18836]: Version: '5.0.45-Debian_1~bpo.1-debug' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution Ma

Re: MySQL Server crashing & database corruption

2007-10-07 Thread Samuel Vogel
I did some more research: I ran "xfs_check" on the partition and it didn't report any errors at all, so I'm guessing, that the hard drives are ok. I also recompiled MySQL with "--with-debug". How would I get some debug output about the crashes now? Thanks, Sa

MySQL Server crashing & database corruption

2007-10-07 Thread Samuel Vogel
Hey guys, First of all: I have tried to post this Issue on forums.mysql.com, but the Topic doesn't appear in the Forum. When I try to post again, it tells me that it's a duplicate?!?! Now the real problem: I have MySQL set up on two Servers with 7000 Users each and about the same amount of d

Re: Could drbd randomly flip bits? Was: Database page corruption on disk occurring during mysqldump on a fresh database and Was: Spontaneous development of supremely large files on different ext3 file

2007-09-18 Thread Stephen Samuel
> Ext3-users mailing list > [EMAIL PROTECTED] > https://www.redhat.com/mailman/listinfo/ext3-users > -- Stephen Samuel http://www.bcgreen.com 778-861-7641 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem with external connections

2007-09-17 Thread Samuel Vogel
he server. I'm setting an connection timeout of 10 seconds. It seems, that under high load, some of the connections are dropped, and this causes the problem! I started logging the attempts and they seem to randomly fail (since the same host and password is used every time) ! Does this help

Problem with external connections

2007-09-17 Thread Samuel Vogel
Hey guys, I'm using SSL encrypted MySQL connections between my Servers. Suddenly today, the connection to one of my servers stopped working. When I try to connect from the outside, I enter the password, and then nothing happens, it just stays blank: # mysql -h beta.kilu.de -p Enter password:

Re: SSL Problem with outdated zertificates

2007-09-05 Thread Samuel Vogel
Actually I fixed the problem by generating a whole new set of SSL certificates! Thanks for the help! Regards, Samy [EMAIL PROTECTED] schrieb: Hey, This morning the default timespan of ssl certificates took my servers down... Everything was running fine, but this morning the SSL encrypted MyS

RE: How To Pronounce MySQL

2006-06-09 Thread Samuel C Flores
Um, did anyone actually answer Jesse's question? -Original Message- From: Daniel da Veiga [mailto:[EMAIL PROTECTED] Sent: Friday, June 09, 2006 12:57 PM To: mysql@lists.mysql.com Subject: Re: How To Pronounce MySQL On 6/9/06, Duane Hill <[EMAIL PROTECTED]> wrote: > On Fri, 9 Jun 2006, Ch

Re: Per query DB stats... ideally for InnoDB

2006-04-21 Thread Samuel Ziegler
at this Samuel? > > http://www.mysql.com/products/tools/administrator/index.html > > Check out the demo in the TRH corner. > > May be of some use to you. > > Regards > > Keith > > In theory, theory and practice are the same; > in practice they are not.

Re: Per query DB stats... ideally for InnoDB

2006-04-19 Thread Samuel Ziegler
> administrators should always be able to connect and check > the system (assuming that you are not giving this privilege > to all your users). > > Regards > > Keith > > In theory, theory and practice are the same; > in practice they are not. > > On Wed, 19 Apr

Per query DB stats... ideally for InnoDB

2006-04-19 Thread Samuel Ziegler
Is there any way to retrieve per SQL query stats from MySQL? Specifically for my need, the ability to determine the amount of system resources required to perform the query, ie CPU, disk usage, etc... I poked through the docs & did some net searching, but couldn't find anything that I could use.

never mind.. works now.. 'localhost' not matched by '%' for some reason.

2005-04-04 Thread Samuel Flores
-Original Message- From: Samuel Flores [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:52 PM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: ERROR 1044: Access denied for user: '@localhost' to database 'mysql' Howdy all, I keep getting this error

ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

2005-04-04 Thread Samuel Flores
Howdy all, I keep getting this error when I try to issue: mysql mysql -u root -p the same thing happens when I substitute any other database name, not just mysql. I have another,nearly identical machine from which I copied the contents of /var/lib/mysql/mysql/ . The permissions all appear to

Delete user/no access to mysql db

2003-07-07 Thread Stephan Samuel
hat I could find was deleting records from mysql.user. Is there another way? Thanks, Stephan Samuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL in CNN

2003-03-20 Thread Tonu Samuel
Just found story about MySQL in CNN: http://www.cnn.com/2003/TECH/ptech/03/12/fortune.ff.open.source/index.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: sql diff for mysql

2003-03-20 Thread Tonu Samuel
On Fri, 2003-03-14 at 17:19, Florent Martineau wrote: > Hi, > > I'm searching for a mysql diff tool to update my database when changing > structure and so. > Does anybody outthere knowing such a tool ? As much I know, there is no such tool exists. I am doing myself some version control of SQL ta

Re: CFLAGS="-march=k6" ?

2003-03-18 Thread Tonu Samuel
On Wed, 2003-03-19 at 03:27, Daniel Kasak wrote: > Anyone know whether this is a bad idea or not (gcc-2.95.3)? > I previously (MySQL-4.0.5 or so) built a server with -march=k6 which > seemed to run OK apart from crashing when I did a very particular select > on one table, but I was never sure whe

Re: Using ssh tunnel and mysql

2003-03-11 Thread Tonu Samuel
On Mon, 2003-03-10 at 22:01, Pete Harlan wrote: > On Mon, Mar 10, 2003 at 11:32:06AM -0600, Paul DuBois wrote: > > Whether it's a feature or not, it's not always so easy to figure out > > what to do. If you specify -h localhost, it can be argued that you > > really want the socket even if you spec

Re: Off topic help, SSL and form posts

2003-03-11 Thread Tonu Samuel
On Tue, 2003-03-11 at 04:15, Scott Haneda wrote: > I have run into a problem where data is truncated when sending to MySql via > a SSL connection, I can not determine whether this is my server or just the > protocol, I hope the later, as I know web* 4, which is what I am using will > never get it f

Re: 4.0.x and SSL replication thoughts.

2003-03-07 Thread Tonu Samuel
On Fri, 2003-03-07 at 17:56, Dan Geist wrote: > > If I understand the process, the act of replication is a simple connect > > via a dedicated and persistent thread on the slave which which registers No, it is not simple. It is not very complicated also but bit unusual. Usually SSL layer stuff us

Re: problem setting up DES_ENCRYPT on MySQL 3.23.46

2003-03-07 Thread Tonu Samuel
On Thu, 2003-03-06 at 17:52, tommy liu wrote: > anyways, yes I did run > # ./configure --with-vio --with-openssl --prefix=/usr/local/mysql > and also tried the max version > > I also ran mysql_fix_privilege_tables.sh (one along 3.23.46 source)because > we have MySQL 3.23.46 but I don't think it

Re: encrypted password

2003-02-13 Thread Tonu Samuel
On Tue, 2003-02-11 at 15:39, Curtis Maurand wrote: > > The manual suggests that the password function is really for intenal mysql > functions. Ideally you should use the encode or md5_encode functions. > > update user set password=encode('password', 'salt') where user = > 'your_user'; > Unle

Re: encrypted password

2003-02-07 Thread Tonu Samuel
On Wed, 2003-02-05 at 13:53, Kamara Eric R-M wrote: > INSERT into tbl_name (username,password) values > ('user',PASSWORD('passwd')); > > and when authenticating the user you can do something like > > SELECT username from tbl_name where passwd=PASSWORD('$pass'); and in this > case $pass is the va

Bug? InnoDB transactions and temporary table hanging

2003-02-07 Thread Samuel Liddicott
I came accross a problem porting our tv listings system from postgres to mysql with InnoDB. With InnoDB tables, read-only transactions started after a read-write transaction touching the same rows are able to read data as it was before the read-write transaction began; UNLESS the "read-only" trans

Re: What is the best known practice for insertion...?

2003-01-20 Thread Tonu Samuel
On Mon, 2003-01-20 at 09:15, Zysman, Roiy wrote: > Hi All, > I'm trying to insert multiple lines to a table with 3 col. All 3 of them > are a part of the primary key. > But while inserting the data , sometime occurs the situation where I > want to insert an already exist entry with the same keys. A

Re: MySQL Secure Replication

2003-01-17 Thread Tonu Samuel
On Fri, 2003-01-17 at 08:51, Ivan Hoo wrote: > is there any way you can implement a secure replication via ssh or sth else? Who can implement? As user you can use SSH tunnel with it. There are many tutorial about making SSH tunneling in the internet. I believe if MySQL will have some kind of tra

Re: MySQL Secure Replication

2003-01-16 Thread Tonu Samuel
On Tue, 2003-01-14 at 20:47, Jeremy Zawodny wrote: > > has anyone been able to setup ssl secure replication for mysql? > > I don't believe you can do that yet. There's now way to specify the > necessary credentials in the slave setup. > > > how do i know whether the replication is actually done

RE: Initiating secure connection to MySQL4 from PHP

2003-01-16 Thread Tonu Samuel
On Mon, 2003-01-13 at 23:48, David Rock wrote: > Hello, > This is discouraging after I spent most of the weekend getting OpenSSL > working with our MySQL 4 server. Unfortunately I can't use Stunnel to secure > the connection between our website and our MySQL server because our ISP will > not allo

Re: Initiating secure connection to MySQL4 from PHP

2003-01-13 Thread Tonu Samuel
On Mon, 2003-01-13 at 16:41, David Rock wrote: > Could someone please post the basics on connecting to a MySQL 4 server from > PHP at my website using a secure connection? The server is ready to accept > a connection, I'm just not sure what to do next to initiate it. It seems > like I would need t

Re: MySQL4 SSL certificate required?

2003-01-13 Thread Tonu Samuel
On Thu, 2003-01-09 at 17:40, David Rock wrote: > Hello, > Can someone give me a some overview information regarding using SSL with > MySQL version 4? I want to setup a 128bit SSL connection between our website > hosted at an ISP and our MySQL (on FreeBSD) server which is hosted in our > office. B

Re: installing RPM RedHat 8.0

2002-12-28 Thread Samuel Pizzuto
> >I am getting the following message when submitting the following: > > >how-to-repeat: > >[root@localhost sam]# rpm -ivh /mnt/cdrom/MySQL-4.0.6-.0.i386.rpm > >error:/mnt/cdrom/MySQl-4.0.6-.0.i386.rpm: MD5 digest : BAD >expected(ba03cefd50c27d9d993ce693457c072d) != >(ad8cba3b72f6ae19

Re: [OT] LEGAL information about MySQL.

2002-11-30 Thread Tonu Samuel
On Sat, 2002-11-30 at 14:46, Pae Choi wrote: > If MySQL plays so dirty, go with PostgreSQL. It's been known > to be better and more acceptable in all platforms. Ex, they > have triggers, etc that MySQL does not have. FUD. I pointed to information of FSF and people not related to MySQL. Seems l

Re: [OT] LEGAL information about MySQL.

2002-11-30 Thread Tonu Samuel
All who haven't read GPL FAQ, go and read it: http://www.fsf.org/licenses/gpl-faq.html Current discussion is covered beginning from: http://www.fsf.org/licenses/gpl-faq.html#ModifiedJustBinary http://www.fsf.org/philosophy/free-sw.html Also, discussion here reminded me MySQL vs Progress case wh

Re: LEGAL information about MySQL.

2002-11-29 Thread Tonu Samuel
On Fri, 2002-11-29 at 14:59, Darney Lampert wrote: > > >Hi, I'm beginner in maillist and my english is limited.. > > > >I want know about LEGAL MySQL software information. > >On www.mysql.com page, in download section I read that: > > > >"You need to purchase commercial non-GPL MySQL licenses: > >

Re: ssl support in mysql

2002-11-29 Thread Tonu Samuel
On Fri, 2002-11-29 at 13:23, Giannis Vrentzos wrote: > Hello. > > Can somebody tell me how can i enable ssl support in mysql? All is in manual. And manual is included with MySQL distribution and http://www.mysql.com. Always. In case of security-specific questions not covered in manual, come bac

Re: converting from foxpro to mysql ???????

2002-11-28 Thread Tonu Samuel
On Wed, 2002-11-27 at 17:05, toby z wrote: > > > ok guyz i need some inside info . > > plz help me with: > > 2. if i ve to conver a db in foxpro to mysql or sql which one should i > preffer and y pz do nt use thz hax0r w0rdz It is really hard to read. Many people here do not speak e

RE: ODBC problem

2002-10-30 Thread GAY Samuel
p? DSN, ADO Connection String, DAO, etc... JFercan *** sql *** -Original Message- From: GAY Samuel [mailto:S.GAY@;envergure-conseil.com] Sent: October 30, 2002 04:47 To: Mail List MySQL (E-mail) Subject: ODBC problem Hi, To test MySQL I'm migrating a small VB project wich already run wi

ODBC problem

2002-10-30 Thread GAY Samuel
Hi, To test MySQL I'm migrating a small VB project wich already run with SQLServer2000 to try ODBC. I've a problem with two versions of MyODBC (2.50.39 and 3.51.04). I can connect, make some "select..." with succes, one update, and my VB program always crash on an update ! Here is the request,

RE: Backup DB

2002-10-29 Thread GAY Samuel
Hi, Shut your database down, backup all files, and restart it If you use InnoDB you can do a hot backup like Oracle (the implementation of InnoDB is near of Oracle), but it's not free. I can't say more about this, but it's in the documentation about InnoDB. You can also keep a differenti

Multiple MySQL running

2002-10-29 Thread GAY Samuel
Hi, I'm a new user of MySQL (but not of databases...), and new member of this mail-list, and I hope I don't bother anyone with a question already asked (and with my english...). I'm interested in the InnoDB part of MySQL because I thing it's more reliable than other table's type, and because i

problem connecting to mysql with gui

2002-08-15 Thread samuel umoette
please how can i set Sql command on connect to be able to connect to mysql.i am a novice.i tried to enter /var/lib/mysql/mysql.sock but still couldn't connect.help please. i have tried with both static and semi-static files. thanks.

Odp: mysql.sock and other small animals

2002-07-01 Thread Samuel Mendelowski
permissin problem - Original Message - From: Christopher Marsh-Bourdon <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 28, 2002 12:22 PM Subject: mysql.sock and other small animals > I have a bit of an issue: > > I have just upgraded my version of MySQL on my Cobalt Qube L

Re: MySQL 4.0.1 & SSL config - a shot in the dark

2002-06-15 Thread Tonu Samuel
On Sat, 15 Jun 2002, Clay Loveless wrote: > I've been trying to figure out how to set up SSL support in mysql-4.0.1 ... > The online documentation is pretty sparse on the subject. > > Here's what I've got so far -- and so far this is *NOT* working. I'm putting > it out here so that someone else

Re: how to increase max connections above 1024 in Linux

2002-06-12 Thread Tonu Samuel
On Thu, 13 Jun 2002, Patrick Hsieh wrote: > Hello, > > I want to raise the max connections in mysql. Due to the linux limix > thread limitation, I can only increase the number to around 1024. How > can I break the limitation? This is topic of glibc (assuming you are using kernel 2.4 at least).

Re: table is read only when DB copied from Win to UNIX

2002-06-12 Thread Tonu Samuel
On Wed, 12 Jun 2002, Francisco Reinaldo wrote: > Fine, I can see the database, show tables works, > selects works. The whole nine yards? Nope! I cannot > insert any values in that database. I get the > following error: "Table xxx is read only". I have > checked the OS permission for that direct

Re: Foreign key integrity pb ?

2002-06-12 Thread Tonu Samuel
On Wed, 12 Jun 2002, Christophe BRAM wrote: > I'm using MySQL Max 4.0.1 > > > CREATE TABLE TableTwo > ( > Id int NOT NULL auto_increment, > FK_TableOne int NOT NULL REFERENCES TableOne(Id), > > PRIMARY KEY (Id) > ) TYPE=InnoDB; > > > --> How can this

Re: security paranoia

2002-06-11 Thread Tonu Samuel
On Tue, 11 Jun 2002, MikeParton wrote: > Where in the MySQL docs does it discuss DES_ENCRYPT/DES_DECRYPT support? > > Alternatively (and I am posting this to the php lists), anyone know where, > or if, I can get pre-compiled libmcrypt library for php 4.2.1? http://www.mysql.com/doc/M/i/Misce

Re: Advise Requested: Troubleshooting Perl/Mysql/Sendmail Performance

2002-06-11 Thread Tonu Samuel
On Tue, 11 Jun 2002, Keith Smith (E-mail) wrote: > The system: a perl mailing list tool which accepts add/deletes via > emails (sendmail piped) and then updates the backend database > accordingly. > > The problem: once about 10 or more emails arrive, I begin to get > performance problems from t

Re: license...

2002-06-11 Thread Tonu Samuel
On Tue, 11 Jun 2002, Colin Faber wrote: > According to the Arguments document this isn't true. The API's are > published under the LGPL license and are not governed by the same > restrictions as the server it self. 3.23.x API is LGPL 4.x is API is GPL 3.23.x and 4.x servers are both GPL Own

Re: security paranoia

2002-06-11 Thread Tonu Samuel
On Tue, 11 Jun 2002, Ray wrote: > looking for something like > encrypt(str, protected_str) > and > decrypt (crypt_str, private_str) > and probably a make_key_pair() > > its not a vital part of my current project, but i'm sure someone will get > cracked into (again) and then there will be anothe

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: 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: 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

Re: A Proprietary MySQL Business Model

2002-05-27 Thread Tonu Samuel
On Mon, 27 May 2002, Solomon John HART wrote: > How much third party software is incorporated into the non-GPL version of > MySQL. Obviously the included software can't itself be under the GPL. How > does MySQL get around this? Does MySQL have contracts with contributors > instead of contributi

Re: Socket problem connecting

2002-05-19 Thread Samuel Mendelowski
problem with permission; change rights to group and user mysql to mysql data directory Todd Cary > I am getting this message when I try to establish a connect to the DB. > Any suggestions on where I can find an answer? > > Warning: Can't connect to local MySQL server through socket > '/tmp/mys

Re: Can't connect to ....

2002-05-19 Thread Samuel Mendelowski
problem in permission; change rights to group an user mysql Jaan Jürgenson > Hi everybody. > > Just installed Red Hat Linux on a machine. I included the MySQL > packages but cant get it up working. > > When starting from shell it looks like this: > > $ mysql > ERROR 2002: Can't connect to loca

hostname.err

2002-05-06 Thread Samuel Mendelowski
The file hostname.err description: mysqld started /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) mysql ended The file host.frm exists in /var/lib/mysql/mysql I can't open mysql using 'mysql' from prompt.I see an error: Can't connect to local MySQL server through s

Re: MySQL start

2002-04-23 Thread Samuel Mendelowski
Victoria Reznichenko > Samuel, > Tuesday, April 23, 2002, 4:04:20 PM, you wrote: > > SM> Can you help me in the following problem? > > SM> OS: Linux Slackware 8.0 > SM> Source: mysql-3.23.42.tar.gz > > SM> I can't start mysql after installing

MySQL start

2002-04-23 Thread Samuel Mendelowski
Can you help me in the following problem? OS: Linux Slackware 8.0 Source: mysql-3.23.42.tar.gz I can't start mysql after installing the source file. I did it step by step according guidance from Install-Source file. My OS is generating such messages: root@serwer:/TEMP# mysql ERROR 2002: C

Re: Configuring MySQL 4.0.0 with SSL shortens idle timeout horribly

2001-11-01 Thread Tonu Samuel
es seem > to have normal values. Thank you for bug report. I will reproduce and fix it. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL

Re: pls help !!

2001-10-31 Thread Tonu Samuel
wrong. Can you rebuild your indexes with command "REPAIR TABLE tlcounter200109" ? What is your MySQL version? It should use index. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Sam

Re: MySQL licencing [id:fns]

2001-10-28 Thread Tonu Samuel
___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Räpina, Estonia <___/ www.mysql.com

Re: Access Denied

2001-10-28 Thread Tonu Samuel
c/Access_denied.html http://www.mysql.com/doc/R/e/Request_access.html http://www.mysql.com/doc/G/R/GRANT.html -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ M

Re: MySQL caching.

2001-10-05 Thread Tonu Samuel
Query/Result caching is under development. All buffering related topics should be covered in manual. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__

Re: InnoDB Tables/Databases

2001-10-05 Thread Tonu Samuel
the difference. Much smarter row-level locking. This gives the speed. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_

Re: MySQL performance and limit

2001-10-05 Thread Tonu Samuel
echnical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /_

Re: Windows Threads Support

2001-10-05 Thread Tonu Samuel
file. My.cnf is used on the *nix versions. > > I only point this out as I wasted time looking for the my.cnf file! :) Sorry, I am using only unix systems. My fault. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/

Re: MySQL performance and limit

2001-10-05 Thread Tonu Samuel
an handle issues with directories containing 1 files much faster. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrat

Re: Max Database

2001-10-05 Thread Tonu Samuel
ead more: http://www.mysql.com/doc/T/a/Table_size.html -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/

Re: Encryption

2001-10-05 Thread Tonu Samuel
, from 4.0.0 MySQL will support SSL secured connections. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Secu

Re: Windows Threads Support

2001-10-05 Thread Tonu Samuel
ection limit. Yes, you can change any variables shown with SHOW VARIABLES. MySQL reads default values from my.cnf file -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / //

Re: MySQL performance and limit

2001-10-05 Thread Tonu Samuel
e with > PHP+MySQL, is this possible? This should be no problem for MySQL. Everything is depending how to you use MySQL. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel &l

Re: InnoDB Tables/Databases

2001-10-05 Thread Tonu Samuel
quot;fulltext". MySQL supports fulltext indexes which are made for this purpose. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EM

Re: IDE-RAID QUESTION

2001-09-19 Thread Tonu Samuel
t thing to go. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallin

Notice about seconds overroll - S7K bug

2001-09-10 Thread Tonu Samuel
___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China <___/ www.mysql.com ---

Re: REMOVE NOW THIS IS THE SECOND TIME

2001-09-10 Thread Tonu Samuel
On 09 Sep 2001 21:24:51 +, Mourad de Riche wrote: > > Is he drunk or something? Report to a federal law? No, he is from United States. According to Sklyarov case they think that world consists only from them and everyone should follow their rules, even when not being U.S citizen nor loca

Re: Billionium Bug

2001-09-09 Thread Tonu Samuel
posted separate message with needed explanations about this to mysql and bugraq lists. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__

search with wildcards

2001-09-05 Thread Samuel Andersson
Hi folks! I need to search a mysql database using wildcards. I know about the * and the _ wildcards (any number of any character and 1 character of any kind, respectively) but I need to match any number, any letter and thing like that. An SQL book claimed it could be done using brackets and

Re: carrying database

2001-08-27 Thread Tonu Samuel
r "mysqldump" -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\_

Re: No Lock

2001-08-27 Thread Tonu Samuel
y MySQL and he told that usually same behaviour can be got if INSERT DELAYED is used. SELECTS do not lock on tables like adview/adclick stuff where no high accuracy needed. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |

Re: Data Encryption

2001-08-22 Thread Tonu Samuel
ntracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China <___/ www.mysql.com --

Re: 'pre-load' data after restarting...

2001-08-21 Thread Tonu Samuel
cessing all needed data: mysql -e "SELECT something" > /dev/null But it still seems that you can optimize your queries and MySQL server, not to do such weird things. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ _

Re: innodb on linux raw partitions

2001-08-20 Thread Tonu Samuel
hnical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hon

Re: apache stops in make

2001-08-19 Thread Tonu Samuel
ss 187c t compress_block [tonu@x153 tonu]$ Have you zlib-devel RPM installed? -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sec

Re: lotus -> mysql

2001-08-18 Thread Tonu Samuel
chnical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China

Re: Accessing MySql database using Bash shell Script

2001-08-17 Thread Tonu Samuel
--+ | 4.0.0-debug-log | +-+ [tonu@x153 tonu]$ There are some additional flags which can be used to turn headers and boxes around data off if you need to. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu

RE: NuSphere final speaks out

2001-08-16 Thread Tonu Samuel
On 15 Aug 2001 14:07:08 -0700, Philippe Paravicini wrote: > Dear Philippe: > > mySQL.org is a not for profit organization dedicated to promoting > and further enhancing the mySQL database engine. Like all open > source projects we welcome community input to help enhance the > product. FYI htt

SORRY: I was wrong

2001-08-14 Thread Tonu Samuel
> > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___

  1   2   3   >