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

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

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 way to run

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: 30 % of my databases dissapeared

2007-12-06 Thread Samuel Vogel
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, Samuel Vogel

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. Before

Re: Processlist full of Opening tables

2007-11-13 Thread Samuel Vogel
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, Samuel Vogel [EMAIL PROTECTED] wrote: Hey guys, I do run

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

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

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

Re: MySQL Server crashing database corruption

2007-10-10 Thread Samuel Vogel
' 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 only works on my Server. When I start MySQL it crashes almost exactly after one

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

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, Samy Samuel Vogel schrieb: Hey guys

Re: MySQL Server crashing database corruption

2007-10-07 Thread Samuel Vogel
: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 Maybe this helps somebody? Regards, Samy Samuel Vogel schrieb: I did some more

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
an issue for SATA). Cheers, Andreas -- Andreas Dilger Principal Software Engineer Cluster File Systems, Inc. ___ Ext3-users mailing list [EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/ext3-users -- Stephen Samuel http

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: Problem with external connections

2007-09-17 Thread Samuel Vogel
. 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 a bit? Samuel

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

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,

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. On Wed, 19 Apr 2006, Samuel Ziegler wrote: To: [EMAIL

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.

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

2006-04-19 Thread Samuel Ziegler
In theory, theory and practice are the same; in practice they are not. On Wed, 19 Apr 2006, Samuel Ziegler wrote: To: mysql@lists.mysql.com From: Samuel Ziegler [EMAIL PROTECTED] Subject: Per query DB stats... ideally for InnoDB Is there any way to retrieve per SQL query stats from

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

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 when I try to issue

Delete user/no access to mysql db

2003-07-07 Thread Stephan Samuel
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]

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 tables

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

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

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 specify

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 did

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 uses

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'; Unless

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

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 variable

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. And

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

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 allow me

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 over

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.

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) !=

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

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

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 back

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

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 english

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

2002-10-30 Thread GAY Samuel
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 with SQLServer2000 to try ODBC. I've a problem with two versions of MyODBC

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

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

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 Linux

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 may

Re: how to increase max connections above 1024 in Linux

2002-06-13 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: security paranoia

2002-06-12 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?

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 work without

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 directory

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 another wave

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 Owner

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 the

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

Re: Can't connect to ....

2002-05-19 Thread Samuel Mendelowski
problem in permission; change rights to group an user mysql Jaan Jrgenson 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 local MySQL

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

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

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:

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 the source file. I did it step by step SM according guidance

Re: Configuring MySQL 4.0.0 with SSL shortens idle timeout horribly

2001-11-01 Thread Tonu Samuel
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 AB, Security Administrator

Re: Access Denied

2001-10-28 Thread Tonu Samuel
/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] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator

Re: MySQL licencing [id:fns]

2001-10-28 Thread Tonu Samuel
? If you want really official answer, mail to [EMAIL PROTECTED] I forward current posting there. Those people are responsible about related topics. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL

Re: MySQL performance and limit

2001-10-05 Thread Tonu Samuel
, 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 [EMAIL PROTECTED

Re: Windows Threads Support

2001-10-05 Thread Tonu Samuel
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] / /|_/ / // /\ \/ /_/ / /__ MySQL AB

Re: Encryption

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

Re: Max Database

2001-10-05 Thread Tonu Samuel
://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 /_/ /_/\_, /___/\___\_\___/ Tallinn

Re: MySQL performance and limit

2001-10-05 Thread Tonu Samuel
much faster. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia

Re: Windows Threads Support

2001-10-05 Thread Tonu Samuel
. 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED

Re: MySQL performance and limit

2001-10-05 Thread Tonu Samuel
/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting

Re: InnoDB Tables/Databases

2001-10-05 Thread Tonu Samuel
/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com

Re: IDE-RAID QUESTION

2001-09-19 Thread Tonu Samuel
contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ 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

Notice about seconds overroll - S7K bug

2001-09-10 Thread Tonu Samuel
: 1.2.11.22 So, this is why 13253 10 It is possible that some web applicatons have endless expiry times now and not only in MySQL contexts. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel

Re: Billionium Bug

2001-09-09 Thread Tonu Samuel
explanations about this to mysql and bugraq lists. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator

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

2001-08-27 Thread Tonu Samuel
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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL

Re: carrying database

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

Re: Data Encryption

2001-08-22 Thread Tonu Samuel
/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting

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

2001-08-21 Thread Tonu Samuel
that you can optimize your queries and MySQL server, not to do such weird things. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security

Re: apache stops in make

2001-08-20 Thread Tonu Samuel
installed? -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China

Re: innodb on linux raw partitions

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

Re: lotus - mysql

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

Re: Accessing MySql database using Bash shell Script

2001-08-17 Thread Tonu Samuel
| +-+ [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 Samuel [EMAIL PROTECTED

SORRY: I was wrong

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

Re: searching columns with lots of text

2001-08-13 Thread Tonu Samuel
and responsiveness of the MySQL team. I think you will share the same reaction. Sincerely, -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security

Re: Copy of databse on my PC....

2001-08-13 Thread Tonu Samuel
was once a MySQL customer who was delighted with the skill and responsiveness of the MySQL team. I think you will share the same reaction. Sincerely, -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel

Re: searching columns with lots of text

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

Re: Problem creating a database with my ISP

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

Re: Sub select.

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

  1   2   3   >