MySQL in CNN

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

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" ?

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

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

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.

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

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

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

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

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

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

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

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

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

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?

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: [OT] LEGAL information about MySQL.

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.

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.

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

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

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: MySQL 4.0.1 & SSL config - a shot in the dark

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

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

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 ?

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

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

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

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

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: A Proprietary MySQL Business Model

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: Configuring MySQL 4.0.0 with SSL shortens idle timeout horribly

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

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]

r application is not depending directly on MySQL. > Opinions? 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/ __

Re: Access Denied

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.

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

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

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

Re: Windows Threads Support

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

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

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

, 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

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

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

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

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

strings get sorted in order: 1,11,2,22 but integers: 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/ __ ___ ___ _

Re: REMOVE NOW THIS IS THE SECOND TIME

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

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]> / /|_/ / // /\ \/ /_/ / /__

Re: carrying database

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

Re: No Lock

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

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

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

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

Re: apache stops in make

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

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

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

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

> > 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/ __ ___ ___

Re: Problem creating a database with my ISP

this. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrat

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

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

Re: searching columns with lots of text

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

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

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

Re: searching columns with lots of text

stomer 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 <[EMAIL PROT

Re: mysql-php mailing list

tps://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China

Re: DBASE help

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

Re: Sub select.

ually MySQL 4.0 will do. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China

Re: mysql w/SSL support howto?..

On 07 Aug 2001 16:21:13 +0800, louie miranda wrote: > Is it possible for mysql 3.23.40 to support SSL. > > hm, how? No, from MySQL 4.0 only. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Tonu Samue

Re: MySql and PHP

pport first step help for you as it depends on exact details how this site is set up and configured. Also take a look on simple PHP tutorials on the web. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Sam

Re: Sub select.

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

Re: Some questions About DBMS.

e life easier for many software providers and also embedded version should be faster because missing communication overhead. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / /

Re: SELECT to get last entry

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

Re: Thinking of switching from MyISAM to InnoDB

is nice thing. Just bith MyISAM and InnoDB have good advantages and you should decide, which ones you need more. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\

Re: Char Set (Arabic) question

ut 220 error messages to Arabic. This is the part we cannot do as nobody of us can speak this language as far I know :( -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|

Re: urgent: mysql compile problem

hnical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, Chin

Re: ssl denial of service in 3.23.39?

T stuff also into ACL-s, so non-SSL connections can be refused. Also there will appear functions to determine exact SSL cipher, keylength and certificate stuff. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samu

Re: Waste of data while using MySQL database

-e "FLUSH TABLES" writes everything down and closes all files. OS can then maybe delay it and you should issue "sync". -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL

Re: table types

ut this depends of context of usage. Test it! -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\_

Re: how do I do this?

column named "OrderNumber" where you insert -1 then everything seems OK to me. Please descibe where you can see problem and what is your table structure. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/

Re: Contact

marks. And watch out they are not ' but ` -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrat

Re: How do you insert into two tables at once

use MERGE table type instead when doing SELECTs later. I do not know your exact problem but looks like MERGE may help. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMA

Re: Getting more than 256 connections with MySQL/Linux

hich you should to increase. There are some comments about it also. All this is documented in manual... -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ /

Re: Database Backups

when cron is avalaible? Just put right commands in /etc/crontab Ando take a look on mysqlhotcopy script. Some people prefer this to make backups of MySQL database. I do not take position in this. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ _

Re: HELP ! Myisamchk doesn't seem to see error in my table :(

ZIZDELAZUP > | 0 | > > > The date column is DATETIME, and as you can see, the datas are completely corrupted, >but myisamchk doesn't see anything wrong :( I believe your data is not restorable. -- For technical support contracts, goto https://order

Re: encrition /security

will learn fast by reading something". Pay to some expert who will consult you for all time of this project. Without you loose your customer now or in future. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __

Re: character set

dodge wrote: > I've problem with sorting table rows, thats why i need to get mysql > work with my character set. > can you explain better about ctype array when defining character set. > I really did not understand about elements in this array. The rest > ones to_lower, to_upper, sort it's simple

Re: Manual for sale? (was Re[2]: mysql.org)

ps://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China

Re: Update problems

rk fine. > > Anybody knows what could be the problem? No, until you haven't supplied us with exact error message. Also please provide table structure and update command. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __

Re: Help needed

For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___

Re: changing mysql prompt

he end of this list. If you are paying support customer and really need this feature, write about this feature request into support list. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PR

Re: simpify chinese and traditional chinese

targets is to get MySQL support both traditional and simplified chinese but as far I can see there is a huge technical problems. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_

Re: Effect of quoting numbers

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

Re: mysql and PHP problems

ort contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, Chin

Re: change db name???

//www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) You see this "before posting ..."? Here is the manual :) -- -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. T

Re: PROPOUSE

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

Re: Installinging MySQL on a virtual server

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

Re: direct ISAM access vs. SQL parser

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

Re: Perhaps a stupid question about KEY...

pport contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China

Re: BACKUP TABLE command error

/" directory. I think, this is normal :) -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China <

Re: Where is the "MySQL-DBI-perl-bin" RPM?

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

Re: re-sorting auto_increment fields

ng, fresh and alive even when this application is already dead after many years. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MyS

Re: mysqld as a library in 4.0

some special license. I Cc: it to licensing, they should tell if I am wrong. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__

  1   2   >