foreign keys for relation ships

Hello, I am creating tables within MySql 3.23.49. I want to add relation ships between different tables. I tried to do this with foreign key statements. For example: CREATE TABLE domains ( domain varchar(100) NOT NULL, registrarid int(10) NOT NULL, foreign key (registrarid) REFERENCES reg

Re: Re: mysql server can'

Thank you , The mysql server I using is downloaded from the internet. > Äþº£½¢ wrote: > > The mysql server can't work.Anyone know what will I do? > > > You can buy commercial support? > or be a lot more specific about the problem. > > > -- > Vincent Stoessel [EMAIL PROTECTED] > Linux and

RE: what's wrong with EXPLAIN?

I give an example to make clear what I mean. I had a table with about 100 records scanned from a book. I scanned another 70 and when I finished with INSERT/correcting/INSERT ecc cycle, my table had about 500 records. Of course I had in mind this, so one field was set to '1' so I could delete them

RE: Unicode support for MySQL

Im interested in UTF-8 or anything at least that will give me support on the database to hold both chinese, korean and english character sets at one time or at least cheat at it. -Original Message- From: David Ayliffe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 March 2002 6:10 a.m. To: '

Re: site search

On Tuesday, 12. March 2002 06:18, you wrote: > I want to build a MySQL site search. Can anyone help with my 'overview' > > I have written a perl programme to open each html file, cut out all the > tags and create a hash of hashes each word is a key, then the secondary key > is the filename, then t

Re: Why v3.23.49 does not build on RedHat 6.2 ?????

Hi Benjamin, Uhmm, I have not success with Pre-compiled / Binary code from MySQL. In the other hand (if I was success installed), could it placed all thing like static complied? I have been concern this because I must to install other program or library to use with MySQL. So, I have

Re: How to pass mysql connections across exec()

Rick, I have tried it and it works and there is no problem in executing any sql queries in the child. my application also is working fine. But the issue I am facing is the value of the four variables in the MYSQL structure, which I presume gets set only when doing mysql_real_connect(). I am wor

Re: mysql with java

Hmm, I have done some java/linux development using mysql and it works fine using the jdbc api. I highly recommend using Mark Mathews' jdbc driver in your java development area. It is licensed under GNU LGPL. http://mmmysql.sourceforge.net/ Be sure to join the mysql-java mailing list for questions

mysql with java

Hi, Is there any examples on developing a java interface with mysql? Thanks, Denny - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To r

Re: mysql + ext3 + data=j

On Mon, Mar 11, 2002 at 05:06:56PM +0100, Matthias Jaekle wrote: > Hello, > > I am running mysql with datafiles on a ext3 file system. Is there > an security advantage for mysql, if I mount the ext3 file system > with the option data=journal ? I don't know a lot about ext3 yet. Is that full jo

mysql server can't work.

The mysql server can't work.Anyone know what will I do? === ÊÖ»úºÅÂëÊǵçÓÊ£¬´Ó´Ë½»·Ñ²»ÓóһºÅÔÚÊÖ¡°ËæÉíÓÊ¡± ¡ª¡ª 163¡°ËæÉíÓÊ¡±ÊÖ»úÓÊÏä ¡ª¡ª ¡ò ÊÖ»úºÅÂë¾ÍÊǵç×ÓÓÊÏäµØÖ·£¬·½±ã¼ÇÒä ¡ò ²»ÓÃÉÏÍø£¬Í¸¹ýÊÖ»ú¶ÌÐÅ£¬ËæʱÕÆÎÕÓʼþµÄ½ÓÊÕÇé¿ö ¡ò ¾ö²»´í¹ýÈκÎÉ

site search

Hi everyone, I want to build a MySQL site search. Can anyone help with my 'overview' I have written a perl programme to open each html file, cut out all the tags and create a hash of hashes each word is a key, then the secondary key is the filename, then the value is the number of occurances in

Multiple languages (was Re: Cyrillic characters)

Sort of off topic, but here goes: Jim Philips wrote: > I am trying to understand how to store both Latin and Cyrillc characters > in a database. I built in support for koi-8 and win1251, but I don't > seem to be getting real support for Cyrillic. Cyrillic characters are > stored as ASCII Uhmmm,

Re: MySQL / XP / some expletive

I use the my.cnf file to direct MYSQL to look into different folders for the data files, you may not need to do that. When you say Services, you do mean a Service on NT, right? MYSQL does not automatically add the service, you need to install it as a service manually after the normal installa

Re: Order by list?

At 20:00 -0800 3/11/02, George Marnellos wrote: >Hi all, > >I'm executing the follow very simple type of query to select entries from a >list: > >"select entryid, entryinfo from mytable where entryid in ('id7', 'id4', >'id2', 'id5')" > >and, even though I don't specify any sorting order, MySQL sor

Order by list?

Hi all, I'm executing the follow very simple type of query to select entries from a list: "select entryid, entryinfo from mytable where entryid in ('id7', 'id4', 'id2', 'id5')" and, even though I don't specify any sorting order, MySQL sorts alphabetically by the field "entryid" (which happens

RE: Where do I place a notice that my server hosts mysql databases?

Thanks for the info! I sent your link off to a friend in ca who's looking for such a site. I think it would be of great help if MySQL site had a list of hosting providers as well. Cheers M;) -Original Message- From: System Administrator a.k.a. The Root of the Problem [mailto:[EMAIL PROT

Re: MySQL / XP / some expletive

Hi Paul, I am running it under XP without any problem. You need to go into the mysql 'bin' directory and install the service (as you would have done under win2K). e.g. to install mysqld-nt as a service do this from the command line. mysqld-nt --install Then either reboot (and the service wil

Re: Languages

Dave queried: > Does MySQL support the below languages? I can find info about character > sets but I can't find info to tell me what languages map to those character > sets. > > > Korean > > Chinese ( Simplified and Traditional ) > > Japanese > > Canadian French > > Latin Spanish > > Portuguese

Re: What type of Unicode?

David Ayliffe queried: > I hear MySQL 4.0.3 will support Unicode. But what sort of Unicode do > you mean > > UTF-8 encoding or UTF-16 or UCS or what? >From what I've been reading on this list, it sounds like they have two polarities of UTF-16 running, and are working on UTF-8. I might assume the

Re: MyODBC and .NET (C#)

I just got it to work in VB.NET. I played with the connection string. In fact, I took everything out except the DSN. Here is the code (VB.net). For the most part it is exactly like VB6 except no SET commands and no default properties. Try making your connection string minimal in C#.

Where do I place a notice that my server hosts mysql databases?

Could someone tell me where I could post/announce this question? I am an ISP being in busniness for 7 years. I support MySQL on my server and would welcome those of you who want to host their database on our system. -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL

Re: Why v3.23.49 does not build on RedHat 6.2 ?????

Hi. On Tue, Mar 12, 2002 at 08:20:46AM +0700, [EMAIL PROTECTED] wrote: > Hi, > What's wrong with GNU-cc 2.96? AFAIK, stability problems have been reported which did go away when using a precompiled binary... > Why could we use 2.95 (and old > 2.91) or above 3.*? or one of these compil

MySQL / XP / some expletive

Hello, This post pertaining to a previous one on the same subject. That is I cannot get MySQL to run on Win XP! I get the "ERROR 2003: can't connect to MySQL server on 'localhost' (10061)" when running mysql from c:\mysql\bin in the command prompt. I have looked for the MySQL service to

MyODBC and .NET (C#)

Hi All, I'm having problems connecting to MySQL with C# via MyODBC 3.51.02; the DSN I created is called 'MySQL1'. The error I am receiving is: "The 'MySQL1' provider is not registered on the local machine". This is what my connection string looks like: string strConn = "Provider=MySQL1;DNS=MySQL

Re: Request-URI Too Large

Hi, Can you help me edit my script because I'm used to doing the approach that I did in the script editform01.php. I'm quite confused. Actually in my edit script I used 3 php scripts. One is to view (editform01.php), the other one is the form to display the fields that you want to edit (editform0

Re: Request-URI Too Large

Hi, Can you help me edit my script because I'm used to doing the approach that I did in the script editform01.php. I'm quite confused. Actually in my edit script I used 3 php scripts. One is to view (editform01.php), the other one is the form to display the fields that you want to edit (editform0

Re: Why v3.23.49 does not build on RedHat 6.2 ?????

Hi, What's wrong with GNU-cc 2.96? Why could we use 2.95 (and old 2.91) or above 3.*? Is this the junction of MySQL's user to choose which Linux version and review the suitable Hardware and Software? I mentioned this statement because I have more MySQL Server for several purpose in

Myisamchk question

Hi, I'm currently testing the BACKUP TABLE function, and to reconstruct the MYI files, I'm performing the following action : For exemple : dd if=/home/mysql/Hardwarefr/cookie.MYI bs=16k count=1 of=/home/mirror/mysql/Hardwarefr /cookie.MYI (to restore the valid first 16 K block) [root@forum] /

Re: Mysql installation. Help!

Great, the uppercase in $sth->{NUM_OF_FIELDS} works. Now I can start to learn perl. Any advice on where could I find a good source for beginner on the web? Thank you very much. >From: ds <[EMAIL PROTECTED]> >To: Andy Cheng <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: Mysql insta

MySQL++ samples are not working?

Does anybody tried MySQL++ samples? I guess they are not working. Any help is appreciated -Radha _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

RE: Problem with locking i guess ...

Okay, i've build an application using the db a lot. Sometimes the db have 500-600 query per sec. avg. 400 concurrent connections. On some scripts i do a select (where ready='Y'), update the records (set ready='N') in a way that a new select will not show the previous selected records. (uhh..) S

mysqldumpslow errors

>Description: 1. Handling of string simplification confused, crashes perl! 2. Format of slow log had changed a while back, so now the timing information is broken in mysqldumpslow >How-To-Repeat: uploaded to mysql secret: n54-slow.log.gz gunzip n54-slow.log

LEFT/RIGHT Join?

So, it's been a while since I've actaully needed to do this and I can not for the life of me figure this out, maybe it's because I've been working for nine hours w/o getting up. Here it is: I have two tables, one table holds Team information, the other table holds top scorers. However, sometimes

error logging

Why doesn't mysql have a --err-log option? Are at the *very* least send it's output to STDERR instead of STDOUT? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

MySQL++ samples are not working?

Does anybody tried MySQL++ samples? I guess they are not working. Any help is appreciated -Radha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list a

Re: Encrypted table

Anyone who ever used 'authlib' script? On my local Apache server it works well however, it does not work on my domain... I would be very grateful to the person who explains me how to setup this script... It always says: connection to mysql failed... thanks in advance... - Original Message --

What type of Unicode?

I hear MySQL 4.0.3 will support Unicode. But what sort of Unicode do you mean UTF-8 encoding or UTF-16 or UCS or what? Will the same sort be used internally as externally (UI) what is used at the moment - standard ASCII? Can anyone clarify? Thanks lots David Ayliffe ICQ# 125646758 Query

Re: Encrypted table

encrypted table, no. encrypted data - yes! check out this AES algorithm, it can be used with C, C++, and there is even a VB implementation. I highly recommend. Chris www.MyDBA2000.com >From: Tripp Scott <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Encrypted table >Date: Tue, 12 Mar

RE: How to pass mysql connections across exec()

have you tried forking the process, then terminating the parent? All open file desciptors, including sockets, would be available to the child. The child would contain the code in try1.c. -Original Message- From: Manvendra Bhangui [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 5

RE: xml

I would think an add on to Apache Xerces would be perfect for this--and not difficult. Has anyone from MySQL contacted members of the Apache XML project about this? It would be great if this was done in a high profile open source environment. An XML wrapper API for MySQL would fit a huge whole i

Encrypted table

The downside of putting users' data in a MySQL database is that the sysadmin knows everything. Is there an implementation of an encrypted table in MySQL? t - Before posting, please check: http://www.mysql.com/manual.php

MySQL database connect issue..............!

Ashraf KAzmi writes: > Hi Jani, > That variable is already set to "max_allowed_packet=16M" in my.cnf file? > Any more clue..! > Ashraf Hi, First of all, Please turn off HTML mode in your email client and use plain text mode instead. HTML mode only increases the size of emails withou

Re: MySQL and MSAccess

Hi Chris, Also interested in exploring how MS products can interact with MySQL since I work in a diverse environment (PC's, some MACs, UNIX clusters-Solaris 8). I found this so far: Also, to check which version of MDAC you have use: Component C

MySQL and MSAccess

Anyone using MySQL on Linux/Unix with a MSAccess front end? Using odbc bound controls? Any issues, insights, suggestions? How's the interaction with the Jet engine? Any performance issues? Thanks in advance. Chris _ Send and

Re: On the logging of BLOBS

Hi- I apologize for being unclear. It is messing with the text update log. I have both binary and text logging running right now while I try figure this out. However I have since learned that the database that is writing the blobs is related to Resin JSP session data, and so does not need to

Re: On the logging of BLOBS

Hi- I apologize for being unclear. It is messing with the text update log. I have both binary and text logging running right now while I try figure this out. However I have since learned that the database that is writing the blobs is related to Resin JSP session data, and so does not need to b

Re: On the logging of BLOBS

Hi- I apologize for being unclear. It is messing with the text update log. I have both binary and text logging running right now while I try figure this out. However I have since learned that the database that is writing the blobs is related to Resin JSP session data, and so does not need to b

Re: mysql + ext3 + data=journal ?

I ve read an article tellinf that it s a plus. But with no explanation. With journal option you journaling the data too. So it migth prevent from a myisamchk ? It s my opinion. But the best security u can add into this is transaction. a+. > On Mon, Mar 11, 2002 at 05:06:56PM +0100, Matthias

Re: Request-URI Too Large

If all the data is in your database, why are you passing it in your query-string ?!?!?!!? Why don't you simply pass the idx like: Hi, > > To give you all an idea, i have a script named editform01.php that first > displays the data in a table. ThenI have this link called "Edit" in which it > goe

MySQL and MSAccess

Is anyone out there using MySQL on either Unix or NT, with MSAccess as the front-end? Are you using odbc bound controls on your access forms? Any issues? Suggestions? In-sights? We are planning on migrating a SQLServer back-end to MySQL on Linux as a robust and affordable back office solutio

Re: mysql + ext3 + data=journal ?

Jeremy Zawodny writes: > On Mon, Mar 11, 2002 at 05:06:56PM +0100, Matthias Jaekle wrote: > > Hello, > > > > I am running mysql with datafiles on a ext3 file system. Is there > > an security advantage for mysql, if I mount the ext3 file system > > with the option data=journal ? > > I don't know

Re: How to timestamp records across time zones? ##

Two more possibilities: 1. Set your MySQL server to use GMT for everything (that is, in the OS, not in MySQL). 2. Store all times as Unix time (seconds since 1970) -- the UNIX_TIMESTAMP() function can be useful for this. Either solution still has the problem of converting to another forma

Re: On the logging of BLOBS

On Mon, Mar 11, 2002 at 01:43:59PM -0500, Dan Patnaude wrote: > Is there SQL syntax to do selective logging. We have logging > turned on, but queries involving BLOBS tend to screw with the > logs. Any help would be useful Can you be more specific than "screw with the logs"? If it's a bug,

Re: mysql + ext3 + data=journal ?

On Mon, Mar 11, 2002 at 05:06:56PM +0100, Matthias Jaekle wrote: > Hello, > > I am running mysql with datafiles on a ext3 file system. Is there > an security advantage for mysql, if I mount the ext3 file system > with the option data=journal ? I don't know a lot about ext3 yet. Is that full jo

Re: Mysql installation. Help!

> > I don't understand the code. I copy it from a book. I am trying to print out > the records returned from a query. I have a table named client in database > andy. The table has 2 records. When I run the above code, I have 2 blank > lines return. Could any one tell me what the problem is?

Re: How to sum only nest N values?

I think that answer is (because I group on user field): create temporary table usertempcnt SELECT *,(@a:= IF(@b=user,@a+1,1)) as cnt , @b:=user from users order by user,points desc; Thanks for advice on temporary table and great example! Anzej P.S. Sorry form misspelled subject: "nest" sh

On the logging of BLOBS

Hi- Is there SQL syntax to do selective logging. We have logging turned on, but queries involving BLOBS tend to screw with the logs. Any help would be useful TIA, -Dan - Before posting, please check: http://www.mysql

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Lost connection to MySQL server during query

Greetings, We use MySQL 3.23.47 running on 4 Pentium III processors machine with 16GB of RAM. The site is hosted on 6 web servers using Alteon for load balancing. If someone had such problem and knows how to fix it, or any ideas are welcome regarding the following... Here's what we know about

Foreign keys in mysqldump?

When I do a mysqldump and include table creation, it does not seem to include the foreign key constraints in the create table statements of the InnoDB tables. Is there a command line switch or other way to make this happen? Thanks, -Bob

Problem entering data in Access, win2k default system locale differs from MySQL db locale

The problem is following: MySQL 4.0.1 alfa on Win2k machine MyODBC 3.51.01 Access XP I need to migrate my clients database from Access to MySQL server and use Access as a frontend to MySQL for adding data. BUT default system locale is different from MySQL locale (cp1257). My database is in latvi

Problem entering data in Access, win2k default system locale differs from MySQL db locale

The problem is following: MySQL 4.0.1 alfa on Win2k machine MyODBC 3.51.01 Access XP I need to migrate my clients database from Access to MySQL server and use Access as a frontend to MySQL for adding data. BUT default system locale is different from MySQL locale (cp1257). My database is in latvi

Re: How to sum only nest N values?

argh read your scheme wrong answer should be: create temporary table usertempcnt SELECT *,(@a:= IF(@b=id,@a+1,1)) as cnt, @b:=id from user order by user,points desc; select *,sum(points) from usertmpcnt where cnt<=2; where 2 is your N Regards, Richard - Original Message - F

Re: How to timestamp records across time zones? ##

Brent, > What's the best way to timestamp records if records are to be exported and > then re-imported to another web server in a different time zone? Data will > be exported as comma delimited data. All of the combined records should > reflect the same instant in time, and not have the web site

Re: How to sum only nest N values?

create temporary table usertempcnt SELECT *,(@a:= IF(@b=id,@a+1,1)) as cnt, @b:=id from user order by id,points desc; select *,sum(points) from usertmpcnt where cnt<=2; where 2 is your N Regards, Richard - Original Message - From: "Anzej Becan" <[EMAIL PROTECTED]> To: <[EMAIL P

Re: mysql under FreeBSD 4.5

I am now seeing this behavior as well. I will work with the developement group to help resolve this. Ken - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 2:10 AM Subject: mysql under FreeBSD 4.5 > Just recently installed FreeBSD 4.5-

Non odbc/jdbc connection

I am looking for different alternatives to getting data into a MySQL database from an unattended command line output (a script) from a remote machine. This is what I have so far: email: Parse the output from the command line and simply email it to the MySQL database server, where a sendmail scri

RE: Unicode support for MySQL

When you say: "Unicode will be supported in 4.0.3 version of MySQL." What do you mean - UTF-8 encoding or UTF-16 or what? Can you clarify -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: 11 March 2002 09:24 To: [EMAIL PROTECTED] Subject: Unicode support

replication stops when it shouldn't

>Description: Replication halts on drop of ignored, temporary table >How-To-Repeat: [mysqld] replicate-ignore-table=curioscape.avstemp replicate-ignore-table=tias.avtemp replicate-ignore-table=inventory.availableQuantity replicate-ignore-table=invent

Re: MYSQLGUI 1.7.5

Martin van Dijken writes: > Dear MySQL, > > I had quite a bit of contact with Sinisa a few months ago and suggested some >improvements and several bugs he might fix. A lot of time has passed, but no new >version of the program has been released. Can you give me a status-update? > > grtz > > M

MYSQLGUI 1.7.5

Dear MySQL, I had quite a bit of contact with Sinisa a few months ago and suggested some improvements and several bugs he might fix. A lot of time has passed, but no new version of the program has been released. Can you give me a status-update? grtz Martin van Dijken

RE: Mysql/Solaris: can't run configure or mysql_install_db

Hi.. I had faced a similar problem with mysql_install_db..but i had downloaded the source and done a make .. I had to change the path of sh in the first line of the script mysql_install_db..the default path of sh is /bin/sh. I had to change it to /usr/bin/sh and did a make intall again and lo

How to timestamp records across time zones? ##

What's the best way to timestamp records if records are to be exported and then re-imported to another web server in a different time zone? Data will be exported as comma delimited data. All of the combined records should reflect the same instant in time, and not have the web site in California

Re: Changing datatypes "on the fly"?

At 02:59 PM 3/9/2002, you wrote: >I have a column defined as varchar(255) in my MySql-database. Now I >realized that there's not enough room for my inserts. Is there any chance >to change it's datatype to tinytext without making an entirely new >database and inserting data from the old one to i

mysql + ext3 + data=journal ?

Hello, I am running mysql with datafiles on a ext3 file system. Is there an security advantage for mysql, if I mount the ext3 file system with the option data=journal ? Many thanks Matthias Jaekle - Before posting, please c

Re: bug: segfaults with mysql_read_default_group!

Christian Hammers writes: > On Mon, Mar 11, 2002 at 04:11:08PM +0200, Sinisa Milivojevic wrote: > > > There is a problem with the myslq_read_default_group function! > > > It's DBI 1.21, DBD::MySQL 1.2216 and mysql-3.23.49, compiled on the very > > > latest Debian unstable (I'm the mysql maintainer

Re: Help w/ "join" syntax

Hi. On Mon, Mar 11, 2002 at 09:42:01AM -0500, [EMAIL PROTECTED] wrote: > > When I call the following PHP script, $qry_1 doesn't work (No query # 1!). > > $result_1=mysql_query($qry_1,$connection) or die ("No query # 1!"); At first glance, I don't see any error. But change the previous line to

xBase (foxpro) conversion

I tried sending this earlier and it seemed to get sent but an error came back not long afterwards so I'm not sure it did. So, I'm sending it again to ensure it is sent, if this was sent before successfully I apologise for sending this twice: Needing to convert some old foxpro tables into mysql.

Memory problem

Hello, we use mysql 3.23 on a redhat 7.0 system and myodbc 2.50 on a windows 2000 system. If we make a insert, update or delete record from the windows system we have the problem that the mysql server on the redhat system takes memory. On each action the mysql server takes memory until the system

Mysql on Windows accessed client on Solaris--gives problem

hi, Mysql is installed on Windows 95. Client program runs on solarisConnection to DB fails I used the mm driver for mysql. see stack trace. please help!! *** panic: symbol "ioctl" undefinedSIGABRT 6* abort (generated by abort(3) routine)si_signo [6]: SIGABRT 6* abort (genera

Help w/ "join" syntax

When I call the following PHP script, $qry_1 doesn't work (No query # 1!). DONE"; flush(); exit; ?> Thank you! Anthony F. Rodriguez ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (th

Slow CONCAT on BLOBs

I am appending blocks of binary data to an existing BLOB in a database. The blocks are coming at me in 1000 to 3000 bytes chunks and the BLOB can grow to a few meg easily. I am using the sql command (from PHP): UPDATE MyTable SET MyBlobField=CONCAT(MyBlobField,"--escaped binary data here--") T

RE: Mysql/Solaris: can't run configure or mysql_install_db

Hi, I too am stuck with mysql installaiton on solaris. Please let me know if you can help me out. I prefer downlaoding the binary and installing ot..rather then getting the src and building. thanks Anis >>> "Chuck Roberts" <[EMAIL PROTECTED]> 03/11/02 07:47PM >>> > -Original Message-

install on Red Hat Linux 7.2 with rpm

Loftus, Monday, March 11, 2002, 2:31:06 PM, you wrote: Leoen> installing MySQL-Max-3.23.49-1.i386.rpm on Linux Red Hat 7.2 (server install Leoen> option) kernel 2.4 Leoen> while logged in as root, from /usr/local/mysql on an old PC Leoen> Hi. I am brand new to Linux, and I can't get MySQL instal

Re: 4.0.2 Replication Bug...

Hi! > "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes: Sasha> On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote: >> My 4.0.2 slave has run through about 14 million queries and it's going >> well. Sasha> Good news >> >> Do you have any feel for how much slower a debugging versio

Large table problems

Hi- We are running mysql version 3.23.33, along with resin. The tables we are using are large, but not overly so. We also, for reasons I cannot comprehend, but for which my manager thinks is a good idea, have index files that are as big as the data files themselves. So, here is the problem: E

Large table problems

Hi- We are running mysql version 3.23.33, along with resin. The tables we are using are large, but not overly so. We also, for reasons I cannot comprehend, but for which my manager thinks is a good idea, have index files that are as big as the data files themselves. So, here is the problem: E

Re: bug: segfaults with mysql_read_default_group!

On Mon, Mar 11, 2002 at 04:11:08PM +0200, Sinisa Milivojevic wrote: > > There is a problem with the myslq_read_default_group function! > > It's DBI 1.21, DBD::MySQL 1.2216 and mysql-3.23.49, compiled on the very > > latest Debian unstable (I'm the mysql maintainer of Debian). > This is the only c

RE: Mysql/Solaris: can't run configure or mysql_install_db

> -Original Message- > From: Egor Egorov [mailto:[EMAIL PROTECTED]] > Sent: Saturday, March 09, 2002 6:08 AM > To: [EMAIL PROTECTED] > Subject: Mysql/Solaris: can't run configure or mysql_install_db > > > Chuck, > Friday, March 08, 2002, 5:56:59 PM, you wrote: > > CR> Hi. We have Solaris

Re: bug: segfaults with mysql_read_default_group!

Christian Hammers writes: > Hello > > There is a problem with the myslq_read_default_group function! > It's DBI 1.21, DBD::MySQL 1.2216 and mysql-3.23.49, compiled on the very > latest Debian unstable (I'm the mysql maintainer of Debian). > > bye, > > -christian- > > There is no section "ch"

Languages

Does MySQL support the below languages? I can find info about character sets but I can't find info to tell me what languages map to those character sets. > Korean > Chinese ( Simplified and Traditional ) > Japanese > Canadian French > Latin Spanish > Portuguese Regards Dave

Re[2]: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

Hello Michael, Monday, March 11, 2002, 3:38:28 PM, you wrote: I had a close problem once - then having many active connections (and so threads) mysql speed may degrade a lot because of scheduling and convergency problem. This does not explain the mysql lock itself, but may be the reason (i.e t

Re: MySQL GUI

Luque writes: > Hello all, > > After install XDarwin in Mac OSX and experimenting installing the GIMP > and some other xapps I have tried to compile MySQL GUI unsuccesfully. > Would somebody show me a link with some advice? > > TIA, > > Luque > It should be possible to build MySQLGUI on OS

MySql in Linux, Unable to connect from windows

Hi, i am using the standard Mysql installation on Redhat Linux. I am trying to run a simple JDBC test pgm from windows machine and connect to DB on linux. I am not getting any error , but its hanging at this statment . statement is Connection connection = DriverManager.getConnection("jdbc:mysq

Re: install on Red Hat Linux 7.2 with rpm

Hi, > installing MySQL-Max-3.23.49-1.i386.rpm on Linux Red Hat 7.2 (server install > option) kernel 2.4 > while logged in as root, from /usr/local/mysql on an old PC > Hi. I am brand new to Linux, and I can't get MySQL installed. The client > part goes fine, but when I do > rpm -ivh MySQL-Max-3

Cyrillic characters

I am trying to understand how to store both Latin and Cyrillc characters in a database. I built in support for koi-8 and win1251, but I don't seem to be getting real support for Cyrillic. Cyrillic characters are stored as ASCII and are echoed back on the Web page that way. Will MySQL support stori

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

Hi! Sam> We have a very high volume site (3 million page views a day) that's run Sam> on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with Sam> persistent connections. Each MySQL serves 8 web servers & is supposed to Sam> act as a failover machine for the other group of 8 w

foxpro xbase conversion

Needing to convert some old foxpro tables into mysql. Have done this before using a long winded xbase-text-mysql through access97, but it through out Dr Watson errors with a couple of the tables, oddly enough a couple of important ones that I need. I was wondering if anyone knew of any apps/perl m

install on Red Hat Linux 7.2 with rpm

installing MySQL-Max-3.23.49-1.i386.rpm on Linux Red Hat 7.2 (server install option) kernel 2.4 while logged in as root, from /usr/local/mysql on an old PC Hi. I am brand new to Linux, and I can't get MySQL installed. The client part goes fine, but when I do rpm -ivh MySQL-Max-3.23.49-1.i386.rpm

  1   2   >