MySQL source component?

2001-03-15 Thread
HI ALL I study mysql, and I want to trace the source code. Are there any documents that describe the data structure and the relationships between function in MySQL? Many thanks! - Before posting, please check:

make test hassle with 3.23.24a

2001-03-15 Thread CaT
I've been trying to figure this out for ages. I've compiled mysql with the following options: ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-user=mysq l --with-comment --without-readline "$@" and the compile goes just fine. Then I do make test (as one is want to do) and

Re: How many rows does a table can hold?

2001-03-15 Thread Rino Nucara
I think a good soluthion it is to do a table for every thing and use MERGE table for searching data in all the table (for MERGE see documentation at pag. 271 "MySql table Type" chapter). Il 16:24, mercoled 14 marzo 2001, abdelhamid bettache scrisse: I want to ask you : 1- How many rows

How to have a table very very big?

2001-03-15 Thread Mario Latens
I have to store data for Internet desining (10-20 Gb at Day) so I have to use a data base very fast: MySql is fast? I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb (I know that reading manual of Mysql). How to do a table so big? Thank you in advance, Rino.

ordering a table by myiasmchk?

2001-03-15 Thread Mario Latens
If I order a table using myiasmchk then, when I put other row in the table, this thable is still ordered or I have to reorder again? Thank you in advance,Mario. - Before posting, please check: http://www.mysql.com/manual.php

Re: error 127

2001-03-15 Thread mohamed Abd El-Samei Mohamed
Thanks for help ., I tried it but also got the same error any other advice "Gerald L. Clark" wrote: Run isamchk on your tables. mohamed Abd El-Samei Mohamed wrote: Dear all i need help i have mysql-3.22.26a over unix solairs 7 when i try to apply query from the console to

Antwort: Webmin

2001-03-15 Thread alexander . skwar
On 14.03.2001 22:33:13 Charles L Hagen wrote: Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? phpMyAdmin - see freshmeat - Before posting, please

Re: Antwort: Webmin

2001-03-15 Thread Sunrise
Hi, alexander.skwar, Mysql has the type as the MSSQL BIT??? Regards, Sunrise [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Invalid field size?!

2001-03-15 Thread Eric Holmbom
I got a problem.. im using mySQL the newest release on a redhat 7.x for the server.. And im doing some programming.. on a win2k pro with delphi 5.0 ent ed. and im using the myODBC driver in windows to connect to the db. Tho when the db is empty [mailboxes] mailbox char 50 fullname

Innobase table check.

2001-03-15 Thread Peter Zaitsev
Hello Heikki, Finally I was able to check the innobase tables included into mysql 3.23.34. Well first several times I was quite happy about them, but later understud that this is because option --create-options is broken :) So now I must say On my system innobase seems to work as bad

how to index on soundex / define own soundex-function

2001-03-15 Thread Gunnar von Boehn
Hello I'm run a family/pedigree database with about 250.000 records of dogs. The dogs are mostly (to 90%) searched by name. To find similar records I have my own 'soundex' colums wich is searched and ofcourse indexed. table dog id int4(indexed) name varchar soundex varchar

Re: ordering a table by myiasmchk?

2001-03-15 Thread Fred van Engen
On Thu, Mar 15, 2001 at 09:54:18AM +0100, Mario Latens wrote: If I order a table using myiasmchk then, when I put other row in the table, this thable is still ordered or I have to reorder again? You'll need to reorder again. Ordering with myisamchk is meant to increase performance, not to

how to syncronisy/mirror two or more databases?

2001-03-15 Thread Gunnar von Boehn
Hi I run a database using mysql 2.23 by a webspace provider. I would like to keep a 1to1 mirror of it at home. Unluckiely I have no shell/ftp access to the tables directory. The database-dump (with php) is far too big to download it every day. - Any ideas how to backup it? - I'm dreaming

Re: real limit of BLOBs

2001-03-15 Thread Fred van Engen
On Tue, Mar 13, 2001 at 04:18:41PM +0100, Alessandro de Manzano wrote: I'm planning to deploy MySQL for a project of my company but I've some concern about real size limit of BLOBs. I read on Paul DuBois' excellent book that longblob are 2^32-1 wide, but actually the communication

Error msg saying what?

2001-03-15 Thread Eric Holmbom
Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied for user: 'root@ipaddress' (Using password: YES)

Antwort: Re: Antwort: Webmin

2001-03-15 Thread alexander . skwar
On 15.03.2001 10:23:19 Sunrise wrote: Hi, alexander.skwar, Mysql has the type as the MSSQL BIT??? Pardon me? What do you mean? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Error msg saying what?

2001-03-15 Thread Jan-Aage Bruvoll
On Thu, 15 Mar 2001, Eric Holmbom wrote: Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied for user: 'root@ipaddress' (Using password: YES) It is saying (quite straightforwardly) that you either a)

A little bug?

2001-03-15 Thread Robert Vetter
Hello, I have just had a little problem with a SELECT query like this: SELECT DATE_FORMAT(Day,"%e.%m.%Y") AS ftag,* from TheTable; this query returns an SQL error: ERROR 1064: You have an error in your SQL syntax near '* from TheTable' at line 1 BUT: SELECT *,DATE_FORMAT(Day,"%e.%m.%Y") AS

Antwort: Error msg saying what?

2001-03-15 Thread alexander . skwar
On 15.03.2001 11:10:24 Eric Holmbom wrote: Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied for user: 'root@ipaddress' (Using password: YES) Wrong password, I'd say.

Re: Monitoring Database

2001-03-15 Thread naveed
dear simon hello try mysqlman its the best tool to manage database remotely naveed - Original Message - From: Simon Green [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 4:50 PM Subject: Monitoring Database Hi I am trying to right a program to monitor

Record locking problems

2001-03-15 Thread Paul Will
I am experiencing problems with record locking on database updates. When I use an Access update query to modify a record subsequent updates to the same records result an Access 97 message stating that the record is in use by another user. This happens if I am the sole user of the database. It

Innobase compile problems

2001-03-15 Thread Mehalick, Richard RE SSI-GRAX
Hi, I tried to build from source the latest MySQL 3.23.34a and I found the following problems: 1) The Makefile in the 'pars' and 'mem' directory have missing ../include/ paths on some dependencies. 2) In the 'mem' directory, the file mem0mem.c tries to include mem0dbg.c, but I think this

Re: Monitoring Database

2001-03-15 Thread Paul Will
naveed wrote: dear simon hello try mysqlman its the best tool to manage database remotely naveed - Original Message - From: Simon Green [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 4:50 PM Subject: Monitoring Database Hi I am trying to right

RE: Monitoring Database

2001-03-15 Thread Hugo Burm
BigBrother (www.bb4.com) has a plugin for MySQL. It monitors the IP port of the mysqlserver and sends you a message when it is down (or start a script and do wahtever you want e.g. start up the slave). Hugo Burm [EMAIL PROTECTED] -Original MessageH- From: Simon Green [mailto:[EMAIL

Stupid question but can't find it in manual

2001-03-15 Thread ddiaz
Hi, How do I put two or more hosts in a single user row? I have all them at 'localhost' but I'd like to set it to something like 'localhost,machine.domain.tld,machine2.domain.tld' without having to repeat the line since I've got to manage a *bunch* of users. Thanks...

Re: show tables bug - minor update

2001-03-15 Thread Canadian Lumberer
Hi Greg, If you are speaking about show tables returns blank lines, than thank you very much and I hope you will find it! Please, keep us on track! Best regards, Lumberer. On Mon, Mar 12, 2001 at 09:57:28PM +, Greg Cope wrote: The following C and CXX flags will work (/usr/local/bin/gcc

Re: Compile failing

2001-03-15 Thread Sinisa Milivojevic
Martyn Perring writes: Hi, Can anyone shed any light on this? I'm trying to build mySQL V3.23.34a on Tru64 V4.0G using gcc2.95.2 and GNU Make version 3.79.1. The makefiles were created using ./configure --prefix=/nipweb/mysql. No other configure paramaters were used.

MySQL over ODBC

2001-03-15 Thread denis mettler
Hi there, i received the following message: [TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server (#1130) any ideas regards denis - Before posting, please check: http://www.mysql.com/manual.php (the

Stange behaviour max(length(a)) on table with index on column a varchar(255)

2001-03-15 Thread Saulius Gurklys
Hi, I have a table: CREATE TABLE http_refer( rid int unsigned auto_increment, refer varchar(255), unique index(rid), unique index(refer) ); It is filled with referrers from our webserver log and has 4138 rows. Today I've tried to execute: mysql select

Conversion

2001-03-15 Thread Val Baker, Paris
I have been told you offer a service to convert ASP scripts that connect to an access database to a mySQL database. If this is the case could you send me the URL of this resource. Many Thanks Paris. -- Paris Val Baker

RE: Innobase compile problems

2001-03-15 Thread Mehalick, Richard RE SSI-GRAX
I failed to mention that I used the RedHat Source RPM and I am using RedHat 6.2. Rick -Original Message- From: Mehalick, Richard RE SSI-GRAX Sent: Thursday, March 15, 2001 6:10 AM To: 'Heikki Tuuri' Cc: '[EMAIL PROTECTED]' Subject: Innobase compile problems Hi, I tried to build from

Help querying a simple but large table

2001-03-15 Thread Dan Makovec
Hi all, I'm having problems getting reasonable speed queries from a simple table. First, a little info about my server setup: From mysqladmin version: mysqladmin Ver 7.11 Distrib 3.22.27, for

table design and structure

2001-03-15 Thread Raymond_Reddy
I had two questions about table design and format. I'm designing an application that has two tables. The first table will have -Many selects that return about 20 results on average. -Few inserts -Very few UPDATEs For this table it is not important that the newest inserts show up in selects

Innobase table check.

2001-03-15 Thread Michael Widenius
Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello Heikki, Peter Finally I was able to check the innobase tables included into mysql Peter 3.23.34. Well first several times I was quite happy about them, but Peter later understud that this is because option

problem in running My SQL

2001-03-15 Thread Rajat Rajvanshi
hi i am installing My Sql on Linux 7 i was trying it for the whole day..the only problem i am facing since morning is that.. the SQL server starts during the booting of system when i go in bin and give mysqladmin command it gives error - Can't connect to server.. either the server is not running

Re: error 127

2001-03-15 Thread Gerald L. Clark
Yes, make sure you shutdown the server before running isamchk. mohamed Abd El-Samei Mohamed wrote: Thanks for help ., I tried it but also got the same error any other advice "Gerald L. Clark" wrote: Run isamchk on your tables. mohamed Abd El-Samei Mohamed wrote: Dear all

Re: Help querying a simple but large table

2001-03-15 Thread Fred van Engen
On Fri, Mar 16, 2001 at 12:32:37AM +1030, Dan Makovec wrote: Hi all, I'm having problems getting reasonable speed queries from a simple table. ... I've created a simple table that contains stock exchange data, as follows: CREATE TABLE shares ( date date DEFAULT '-00-00' NOT NULL,

synopsis of the problem (one line) configure fails on aix 3.4.0

2001-03-15 Thread Jack Summanen x
Description: Compiling Mysql for aix. I receive an error saying char size is 0, I noticed that another file is looked up and it is not present. "conftestval" How-To-Repeat: I have set my c compiler and c++ compiler to gcc, then entered the following, you

Re: problem in running My SQL

2001-03-15 Thread Gerald L. Clark
You did not tell us what hardware and MySQL version you are using. There is no Linux 7. If you are refering to RedHat Linux Version 7.0, and you installed the mysql found on the CD, then you have 3 choices. 1. chown -R mysql /var/lib/mysql If the mysql data directories are not in

Re: MySQL over ODBC

2001-03-15 Thread Gerald L. Clark
Did you read chapter 6 in the manual? denis mettler wrote: Hi there, i received the following message: [TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server (#1130) any ideas regards denis -

Re: MySQL make install problem.

2001-03-15 Thread Gerald L. Clark
No, it should not be. Eric Morgan wrote: Yes, The prefix path I used below is the path to the source distribution. Should it not be? Eric Mohamad Ilhami wrote: On Wed, 14 Mar 2001, Eric Morgan wrote: I configured and compiled mysql-3.23.34a without even a warning:

connection from php (please help!!)

2001-03-15 Thread Juan
Hello, im trying to connect to mysql server from php but i cant do it. i created the databases successfully!! i put : ?php $link = mysql_connect(host, user, password); ? Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Re: Help querying a simple but large table

2001-03-15 Thread David Diaz i Torrico
And I've filled this with a bit of data. Well, more than a bit - 5,791,651 rows actually. Still, while this is large, it doesn't seem rediculously huge. Let's say I want to perform a query to

Re: Innobase compile problems

2001-03-15 Thread Heikki Tuuri
Rick, I tried to build from source the latest MySQL 3.23.34a and I found the following problems: 1) The Makefile in the 'pars' and 'mem' directory have missing ../include/ paths on some dependencies. Do you mean that when you compile, on the compiler line there is not the flag -I../include?

Re: Innobase table check.

2001-03-15 Thread Heikki Tuuri
Peter, could you ftp your binary (compiled with -g option) to support.mysql.com directory /pub/mysql/Incoming I can then try to run the ATIS test on your binary on our SMP Linux. One possible reason for the errors you get is that your version of GCC is buggy in inlining of code, but that is

What to optimize when disc activita is very high?

2001-03-15 Thread Christian Hammers
Hi I have a long-running select that's basicly just summing a couple of columns in a 1-2GB big table. It lasts for 5-10 hours and I notice that the disc activity is *very* high: vmstat 1 says: 5 0 0 30332 3068 5240 129260 0 0 10260 658 498 63 35 3 4 0 0 30332 3192 5244

Re: Data tool

2001-03-15 Thread Rolf Hopkins
Yes, there are a couple of methods such as mysqlimport. Please read the manual for the others. - Original Message - From: "WANG_KING£¨Íõ¸Ö£©" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 10:30 Subject: Data tool I want to load data to mysql. Does mysql has

Re: How to have a table very very big?

2001-03-15 Thread Roger Westin
Hi Mario, I think I had the same problem as you, and got som help... You have three ways of doing this: 1. Switch to a FileSystem that supports bigger Files 2. Use MERGE, create a lot of small tables and use MERGE in you select Querys, The manual is quit god at explaining how to do this, but

RE: How many rows does a table can hold?

2001-03-15 Thread gavin . wood
I want to ask you : 1- How many rows does a mysql table can hold? 2- I have to design a database for all universities of my country , Is it better to consider one database for each university or one database for all universities . Note that a query on a table "student" would be more quick

Fwd: Question: What sort of lock occurs during Optimization?

2001-03-15 Thread Mark Dombeck, Ph.D.
All, I've got a quick question - In section 7.11 of the manual on Optimize_Table it states that the table is "locked" during optimization. It does not state however, if this is a read-lock, a write-lock or both. Can you clarify? Thanks Since I'm not a member of this list, could any responses

JDBC CONNECTION PROBLEM

2001-03-15 Thread Madhulika Bahl
Hi I am using Resin1.2.3 engine to run my servlet and mysql database with mysql-jdbc driver to connect my servlet with database but it gives me null pointer exception when I run my servlet 500 servlet exception java.lang.NullPointerException I hope many of you might have face

SQL query

2001-03-15 Thread Pawan Kanda
Hi , i have the following method: public Object getValueAt(int row, int column){ // in here i want to construct a SQL query which gives the object at a certain row and column } Do you know how to do it? Thanks Pawan -

Re: Fwd: Question: What sort of lock occurs during Optimization?

2001-03-15 Thread Dan Nelson
In the last episode (Mar 15), Mark Dombeck, Ph.D. said: All, I've got a quick question - In section 7.11 of the manual on Optimize_Table it states that the table is "locked" during optimization. It does not state however, if this is a read-lock, a write-lock or both. Can you clarify?

Source Control

2001-03-15 Thread Duncan Hudson
Anyone know of a Source control system implemented in MySQL? C. Duncan Hudson Dynax Solutions, Inc. Tel 216.292.8203 FAX 216.292.8273 EMail [EMAIL PROTECTED] - Before posting, please check:

mysqldump generates invalid SQL for db table

2001-03-15 Thread neil
Description: Performing a "mysqldump --all-databases --opt" produces invalid SQL for the "db" table i.e.: KEY User(User) Attempting to rebuild tables with the mysql client using this SQL fails with a syntax error. If the SQL is modified to: KEY User (User) then the mysql

connecting Microsoft Access to MySQL (Formerly Re: [#Deleted]records in Access)

2001-03-15 Thread Christopher Lewis
I see. I added the timestamp field (I never knew there was a field type of timestamp), relinked the table in Access 2000 and the darn thing actually worked! Did this just become a requirement in MySQL 3.23? As I mentioned in a previous post, the timestamp field was not required when I was

Re: SQL query

2001-03-15 Thread Steve Ruby
Pawan Kanda wrote: Hi , i have the following method: public Object getValueAt(int row, int column){ // in here i want to construct a SQL query which gives the object at a certain row and column } Do you know how to do it? Thanks Pawan Maybe make your sql statement read sql =

Regexp matching

2001-03-15 Thread Mike DeWolfe
I'm having a problem with REGEXP : I have several rows that look like this : Health : health services : safety : physical abuse : women Health : health services : safety : rescue Health : health services : safety : sexual abuse Health : health services : safety : sexual abuse : children Health

Re: Postgres to MySQL Migration

2001-03-15 Thread Yurais Fernández Leal
Does someone has an answer for this already done question ?? - Original Message - From: "Jason Bell" [EMAIL PROTECTED] To: "mysql list" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 5:58 PM Subject: Postgres to MySQL Migration Anyone know an easy way to migrate a Database from

mysql++ binary RPM broken

2001-03-15 Thread Jerome Abela
I encountered a few problems with the genuine 1.7.8-1 binary RPM for mysql++. - If I compile: Connection con("temp","localhost","root","temp",3306,0,60,1,"",0); The linker complains: undefined reference to `MysqlConnection::MysqlConnection(char const *, char const *, char const *, char

Question: Tuning Ram vs Hardrive ?

2001-03-15 Thread Gunnar von Boehn
Hi, I would like to tune the performance of my database. The database is rather small about 80 MB altogether. (with 20 Mb indexes) The most complex selections open 32 tables at ones. The database is mostly readonly (99%). What settings show I use to maximize the speed of the queries? What

join

2001-03-15 Thread Jeff Honken
join - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL

System requirements for MySQL?

2001-03-15 Thread Chris Peterson
I cant seem to find system requirements anywhere for MySQL, even inside the hundreds of pages of the manual... I wish to run the latest stable release on MySQL on a Windows NT Workstation PC, and will also use this PC to run ColdFusion Professional 4.5 server. Where could I find recommended

Re: mysqldump generates invalid SQL for db table

2001-03-15 Thread Jason Terry
Does anybody know if this amount of memory usage is normal? (taken from *top*) PID USER PRI NI SIZE SWAP RSS SHARE LC STAT %CPU %MEM TIME COMMAND 677 root 90 19228 0 18M 15801S 0.0 2.1 0:07 mysqld 679 root 9

Re: Postgres to MySQL Migration

2001-03-15 Thread Jason Bell
I never found an answer. I plan to write a PHP page to help automate this, and expect to have it done soon, time permitting. --Jason Bell Yurais Fernndez Leal wrote: Does someone has an answer for this already done question ?? - Original Message - From: "Jason Bell" [EMAIL

Re: System requirements for MySQL?

2001-03-15 Thread Charles L Hagen
Cold Fusion 4.5 Server is a hog. If you can run that you probably have enough memory for MySQL. I would not run them simultaneously with less than 384 MB ram. Charles Hagen On Thu, 15 Mar 2001, Chris Peterson wrote: I cant seem to find system requirements anywhere for MySQL, even inside the

Re: How to have a table very very big?

2001-03-15 Thread Eric Fitzgerald
I saw that someone already gave you some suggestions, but the reply seemed to lack a bit of WHY you have that limitation, so I thought I would explain. The 2Gb limitation is not in MySQL. It's in your operating system. If you read some of your OS's docs, you can see how to get around this

table + index repartition

2001-03-15 Thread Pascal THIVENT
Hi, I have to mananage a very big table (about 20 Go) A database correspond to a directory. A table correspond to a file. Is it possible to distribute the table on several physical partition (like with Oracle that can use several table space to store one table) ? Thanks, -- Pascal Thivent

composite primary key in Access..?

2001-03-15 Thread vijay khanna
Friends. people out in here are very afraid , when they hear Mysql does not support foreign keys. It really become difficult , why foreign keys are not enforced by mysql. Anyways, can u please tell me does our favourite database support composite primary keys as in Acess databse key...? U

Re: INFO

2001-03-15 Thread Javier Armendáriz jarmendariz@teleline . es
MySQLGui is a good option in graphical mode, there are other command line clients too At 19.40 14/3/01 +0100, you wrote: can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on win nt ? thank you in advance. regards. Andrea GIGLIOTTI GB Net S.n.c. Via Bagni Caldi, 11 55021

Question about indexes

2001-03-15 Thread Jason Landry
I seem to remember that Microsoft SQL Server has the concept of a "covered index" that worked something like this: Suppose you have a table with a product_category, and a price. You query alot on product_category, so you create an index on it. You're expression might look like this: select

RE: Innobase compile problems

2001-03-15 Thread Mehalick, Richard RE SSI-GRAX
Please see my comments below. Do you mean that when you compile, on the compiler line there is not the flag -I../include? No, not really. I mean in the dependencies for a target. If the flag is missing, there obviously is something wrong with our Makefile.am's or configure.in's. You probably

Re: Antwort: Webmin

2001-03-15 Thread Tõnu Samuel
Sunrise wrote: Hi, alexander.skwar, Mysql has the type as the MSSQL BIT??? Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Yes and this is documented in manual. -- MySQL Development Team __

SQLxxxx.ISM/ISD files in /tmp

2001-03-15 Thread Justin
For some reason I cannot figure, mysqld is now leaving loads of SQL.ISD/ISM files in /tmp/ .. perhaps 10 a minute.. there are no errors reported in the mysqld log file, other than one or two connection aborted every hour. the files are all owned by root, group root. /tmp is rwx word with t

RE: Innobase compile problems

2001-03-15 Thread Heikki Tuuri
Rick, have you downloaded version 3.23.34 and not 3.23.34a? I downloaded 3.23.34a, untarred it, and mem0dbg.c was in innobase/mem directory. I have attached to this email a copy of mem0dbg.c. Are your Makefile's such that they did not build all the object files and libraries needed for linking

En: En:Fw: [BQ75] Fwd: Re: LER COM URGÊNCIA (fwd)

2001-03-15 Thread Vagno A.G.
- Original Message - From: walkiriocosta To: Sérgio floripa Cc: adrianovarig ; berg ; beto ; emilson ; fenix ; jacira ; junior ; marcelao ; vagno ; zeus Sent: Sunday, March 11, 2001 6:43 PM Subject: En:Fw: [BQ75] Fwd: Re: LER COM URGÊNCIA (fwd) E-mail grátis BOL com antivírus!

Enforcing quotas with MySQL?

2001-03-15 Thread Jose de Leon
Does MySQL allow either user or group quotas to be enforced per database? Thanks, Jose - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Got an error reading communication packets

2001-03-15 Thread Anthony R. J. Ball
I have been getting this error quite a bit, and keep losing my access to the database from my persistent connection, it seems... any idea where I should be looking to solve the problem? Mysql 3.23.34 on Solaris 2.7 Error is: 010315 10:41:55 Aborted connection 27 to db: 'events' user:

Can't connect to local MySQL server through socket '' (111)

2001-03-15 Thread CAL T. DEMIER
I get the subject error when running the static or semi-static linux builds on Mandrake 7.2. My database is working fine and I am able to use another client, KMySQLAdmin, without problems. Cal __ Do You Yahoo!? Yahoo! Auctions - Buy the things

Join question

2001-03-15 Thread Carl Schrader
I have 2 tables with a common field of Title. Table 1 defined as: Name;varchar(60) Title;varchar(60) Year;varchar(4) Other;varchar(30) Other2;varchar(30) act_no;int(8) unsigned zerofill Table 2 defined as: MM;varchar(4) Title;varchar(48) Archive;varchar(4) record_num;int(8) unsigned zerofill

Re: Join question

2001-03-15 Thread Gerald L. Clark
Your two Title fields are not the same size. This could prevent a match. It will slow down joins in 3.22. Carl Schrader wrote: I have 2 tables with a common field of Title. Table 1 defined as: Name;varchar(60) Title;varchar(60) Year;varchar(4) Other;varchar(30) Other2;varchar(30)

Special Character \

2001-03-15 Thread mysql
Can someone tell me how to insert an selct back a directory into mysql using sql? I'm trying to insert and reselect c:\My Documents into a varchar field and I keep having a problem with the special character \ Jeff

Mysql_install_db

2001-03-15 Thread Olivier, Dave
To whom it may concern: When running, the /scripts/mysql_install_db, it starts off with preparing the tables, and then it says it is Installing the tables. That is all it does, it says the process is running and everything. Does it take a real long time for it to install the tables? If so how

Error writing file './mydb/mytable.frm' (Errcode: 28)

2001-03-15 Thread Ken Whitmore
Somehow, our MySQL server just started giving the error: Error writing file './mydb/mytable.frm' (Errcode: 28) whenever I try to create a table using the following: CREATE TABLE boundary ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT); Precisely where can I find the

Re: Special Character \

2001-03-15 Thread Michail A.Baikov
use \\ combination - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 11:55 PM Subject: Special Character \ Can someone tell me how to insert an selct back a directory into mysql using sql? I'm trying to insert and reselect c:\My

Re: Mysql_install_db

2001-03-15 Thread Gerald L. Clark
"Olivier, Dave" wrote: To whom it may concern: When running, the /scripts/mysql_install_db, it starts off with preparing the tables, and then it says it is Installing the tables. That is all it does, it says the process is running and everything. Does it take a real long time for it

Re: Error writing file './mydb/mytable.frm' (Errcode: 28)

2001-03-15 Thread Gerald L. Clark
Ken Whitmore wrote: Somehow, our MySQL server just started giving the error: Error writing file './mydb/mytable.frm' (Errcode: 28) whenever I try to create a table using the following: CREATE TABLE boundary ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT); Precisely

List your software with new feature-based search engine

2001-03-15 Thread BigSofte Vendor Services
Dear Software Manufacturer: We can help you make it much easier to promote your software on the Internet. Your company is invited to list its software products at no charge on BigSoftE, the first Internet Software Search Engine. Launching this month, Bigsofte provides detailed product

Re: Special Character \

2001-03-15 Thread mysql
The problem with the \\ is that it inserts it into the database as \\ and when it's retrieved it's a \\ - Original Message - From: "Michail A.Baikov" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 2:08 PM Subject: Re: Special Character \ use

problems with mysql table

2001-03-15 Thread Nuno Ferreira
Hi there I have a problem with one mysql table and i don't know how to solve it .. the table has some important stuff. when i make a select this is what happens mysql select * from imp_addr; ERROR 1030: Got error 127 from table handler mysql and isamchk isamchk

Re: Regexp matching

2001-03-15 Thread Jeremy D. Zawodny
On Thu, Mar 15, 2001 at 08:50:01AM -0800, Mike DeWolfe wrote: I'm having a problem with REGEXP : I have several rows that look like this : Health : health services : safety : physical abuse : women Health : health services : safety : rescue Health : health services : safety : sexual

Re: Failover and Replication [HOWTO]

2001-03-15 Thread Bogomolnyi Constantin
Hi , I posted a few considerations about fialover implementation , to the list , but i don't recived any feed back , well lets see what we have : But i write a bunch of perl scripts and now I use them in production and very happy with the result . Here what I have : Baiscly what I want is an sql

RE: problems with mysql table

2001-03-15 Thread Quentin Bennett
Hi, Try some of the more aggressive fixing options on isamchk - see the manual for details. Quentin -Original Message- From: Nuno Ferreira [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 March 2001 10:39 a.m. To: [EMAIL PROTECTED] Subject: problems with mysql table Hi there

Re: Failover and Replication [HOWTO]

2001-03-15 Thread Jens Vonderheide
Hi Bogomolnyi, I am really interested in your scripts. I don't have a use for them at this time, but I am planning to use a fallback system myself in the next few month. 5 pc , and I use it for a web cluster (10 pc) so I use 1 slave for 2 httpds Do you have a similar scheme for the web

RE: problems with mysql table

2001-03-15 Thread Nuno Ferreira
# isamchk -a -d -e -f -i -l -o imp_addr.ISM ISAM file: imp_addr.ISM Data records: 1223 Deleted blocks: 0 Recordlength:25 Record format: Packed table description: Key Start Len Index Type User time 0.00, System time 0.00 Maximum resident set

Install Questions/Problems

2001-03-15 Thread Terry Thomas
I'm trying to install mysql on my redhat 6.2 machine, i've done the groupadd, useradd, etc. when i ./configure --prefix=/usr/local/src/mysql it runs thru everything and then stops- just a blinking cursor, that leaves 3 processes running, when i try to run 'make' it says no targets and no

the ORDER BY bug fix in 3.23.35

2001-03-15 Thread Tani Hosokawa
According to the changelog, there's a bug in ORDER BY that was recently introduced but fixed in 3.23.35. 3.23.34 fixed a bug in bidirectional replication though, so I'm wondering what the specifics of the bugs were, since I want to do bidirectional replication, but don't want a serious ORDER BY

speed of INSERT DELAYED vs INSERT

2001-03-15 Thread Eduardo Dominguez
I implemented a mysql based user tracker. On every visit of a user I log some data to the DB. Experimenting with INSERTs I used DELAYED and benchmarked the page. An DELAYED insert takes aprox. 9 times more to execute than an insert. I am using PHP. When I call the query function it takes 9

'make test' fails merge test (Sol8,x86)

2001-03-15 Thread Sander
Hi, I've compiled mysql 3.23.33 but while doing a 'make test' the merge test fails (it passes all others). Any common reason for this? Thanks in advance. Sander - Before posting, please check:

3.23.33-3.23.34a crashing with panic from BDB handler

2001-03-15 Thread Scott McCool
I'm experiencing a problem where mysqld is crashing every time I run a particular query. The specific error from the client is: ERROR 1015: Can't lock file (errno: -30989) ERROR 2013: Lost connection to MySQL server during query The server error log is reporting: bdb: transaction has

  1   2   >