ISAMCHK utility - MySQL server - 3.21.33b

2002-05-15 Thread Sheni R. Meledath
Hello: Can anybody help me out to repair my database & tables using ISAMCHK utility. The MySQL server version is 3.21.33b installed on BSD server. Many thanks Sheni Details of the problem that we are facing now: We are facing a serious problem with the MySQL server installed on our web serve

RE: Re: Insert dates with PHP

2002-05-15 Thread domi
Hi ! You said anything about connecting to mysql. You need to go through 2 steps before mysql_query(). These are mysql_connect() mysql_select_db() please check the URL below, everything is explained very clearly. http://www.php.net/manual/en/function.mysql-query.php You could also tell us

Systems of a high degree of availability

2002-05-15 Thread maxim
Hi, all -- Best regards, maxim mailto:[EMAIL PROTECTED] Hi, all Links to the information are necessary. Master/slave the architecture. Implementation of the system of a high degree of availability on a basis master/slave. Implementation of a control m

invalid order when use 2 fields in ORDER BY

2002-05-15 Thread Com.Sci. Webadmin
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: invalid order when use 2 fields in ORDER BY Description: I try to show data by use "SELECT ... ORDER BY ...", but sometime! I get wrong order list when I try use 2 field in ORDER BY cause How-To-Repeat: I show 2 results, they use

RENAME TABLE and locking

2002-05-15 Thread Florin Andrei
I'm using MySQL-3.23.49a I use MySQL to replace plain text log files. The logging happens in a table named "current". Every midnight, at 00:00:00, i perform a table rotation with this command from a cron job: CREATE TABLE new RENAME TABLE current TO $date, new TO current where $date is yes

Re: UTF-8 national characters

2002-05-15 Thread Son Nguyen
I've been storing data in UTF8 Unicode (Vietnamese) format in mySQL database. I didn't see any problem of for doing any SELECT statement at all. Son Nguyen --- "John D. Stein" <[EMAIL PROTECTED]> wrote: > All, > > I can't seem to find anything about character code sets supported

Re: Insert dates with PHP

2002-05-15 Thread Defryn, Guy
I did forget to mention that I was using that format. So it must be something else?? Guy -Original Message- From: Uma Shankari T. [mailto:[EMAIL PROTECTED]] Sent: Thursday, 16 May 2002 4:09 p.m. To: Defryn, Guy Cc: [EMAIL PROTECTED] Subject: Re: Insert dates with PHP you have to en

Re: Insert dates with PHP

2002-05-15 Thread Uma Shankari T.
you have to enter ur date as in this format -MM-DD for example: 2002-04-04 Hope this will work Uma On Thu, 16 May 2002, Defryn, Guy wrote: DG> DG> DG>I am working with PHP for the first time and I need a form DG>To insert some details and a date. DG> DG>When I check the mysql database

Insert dates with PHP

2002-05-15 Thread Defryn, Guy
I am working with PHP for the first time and I need a form To insert some details and a date. When I check the mysql database the date is displayed as -00-00 Here is my php script: Everything else works fine. When I enter the date into mysql itself it works fine. Thanks

Re: Re: Age calculation

2002-05-15 Thread Pae Choi
You probably need a computational module that calculates age with leap year calculation support. :-) Pae - Original Message - From: "Kittiphum Worachat" <[EMAIL PROTECTED]> To: "Nick Stuart" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 6:38 PM Subject: Re: R

Re: Databases with Tables approaching several million

2002-05-15 Thread Arjen Lentz
Hi Erik, On Thu, 2002-05-16 at 07:50, Erik Fears wrote: > I'm looking for a solution to a database problem I'm having. The > current implementation is a file based database of roughly 57 > million entries. I'm wondering if anyone has had any experience running > a mysql based database with 50-10

Re: how to turn off query logging in mysql, redhat linux

2002-05-15 Thread 龔惠樑(Borus.Kung)
it was started when machine was started check /etc/rc.d and in mysql manual 2.1.1 if u don't need it now, just stop the server and start it like "./bin/safe_mysqld &" but u have to modify rc.d anyway for next time your server start dont log anymore. Borus - Original Message - ±H¥óªÌ: "

how to turn off query logging in mysql, redhat linux

2002-05-15 Thread Tom Blumer
Hello I am trying to turn off the query log in mysql on redhat linux. It generates huge log files (in /var/lib/mysql/hostname.log) that I dont need, and impacts performance. safe_mysqld was run with --log, and it seems like I want to turn that off but I cant find any script or config file whe

Re: INSERT INTO not working

2002-05-15 Thread Sven Bentlage
1. delete any whitespaces between the column name and the "=" and the values. 2. try using columnname="value" That works for me. On Thursday, May 16, 2002, at 09:59 AM, Daniel Lim wrote: > > Hi there, > I have MySql version: 3.23.36 running on RedHat 7.1, it has been > w

Re: Temp Table size?

2002-05-15 Thread Michael Grover
Michael Grover wrote: > > This simple query: > > create temporary table mike select * from wy > union all > select * from ks; > > will cause the following error: > > "[root@localhost:3306] ERROR 1114: The table '#sqla08_3_1' is full" > > what's wierd is I only have a "#sqla08_3_0" table in

Re: Re: Age calculation

2002-05-15 Thread Kittiphum Worachat
Hi, Nick Stuart,All >Please refer to http://mysql.com/doc/D/a/Date_calculations.html it covers >datecalculations and has specifics on Age calcs. > >-Nick > >> Hello, mysql, >> >> How to get > >Age from field date-time that contain dateofbirth and then >> display as xx year yy month zz > >days. >>

how to turn off query logging for mysql on redhat linux

2002-05-15 Thread Tom Blumer
Hello I am trying to turn off the query log in mysql on redhat linux. It generates huge log files (in /var/lib/mysql/hostname.log) that I dont need, and impacts performance. safe_mysqld was run with --log, and it seems like I want to turn that off but I cant find any script or config file where

Re: UTF-8 national characters

2002-05-15 Thread Joel Rees
Sven Bentlage asked > Is there a way to get UTF-8 national characters sets working when you > only have user access to a database (it's my ISP's)? Whether you use the my.cnf/my.ini configuration file or the startup parameter, it's a startup option. You have to have access to one or the other.

Database size

2002-05-15 Thread Bennie Warren
I am new to MySQL to begin with. I am running syslog messages to a DB. It sends anywhere from 3500 to 5600 per minute. I then use PHP to look at the data. The DB machine is a Dual 1Ghz processor with 1Gb Ram. The problem is the speed of lookups. The DB has about 7 million rows and is continually g

INSERT INTO not working

2002-05-15 Thread Daniel Lim
Hi there, I have MySql version: 3.23.36 running on RedHat 7.1, it has been working fine for sometimes until a day ago when the INSERT into for new record appeared to return OK status but upon verifying the record isn't there? This is an example; To insert new record: mysql> INSERT into userd

Re: Alter table

2002-05-15 Thread Mark
- Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Mark" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:24 AM Subject: Re: Alter table > Hi. > > Please start a new thread next time, instead of replying to a > completely unrelated topic. T

Re: UTF-8 national characters

2002-05-15 Thread Sven Bentlage
Is there a way to get UTF-8 national characters sets working when you only have user access to a database (it's my ISP's)? (I know this is going to upset some people, but I do not have any time left and RTFM won't help me right now..) Can anyone of you send me a list/link to a list (or even be

RE: insert into multiple tables??

2002-05-15 Thread Lopez David E-r9374c
Guy No. Requires multiple inserts. David > -Original Message- > From: Defryn, Guy [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 15, 2002 4:55 PM > To: [EMAIL PROTECTED] > Subject: insert into multiple tables?? > > > > > Is it possible to insert data into different tables with o

insert into multiple tables??

2002-05-15 Thread Defryn, Guy
Is it possible to insert data into different tables with one insert statement. For example , I have one form on my web page and the data needs to go into different tables( first 5 entries to table A and the rest to table B)? Mysql --

Re: Column Header/ Column Description

2002-05-15 Thread Mark Matthews
- Original Message - From: "Orr, Steve" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 6:09 PM Subject: RE: Column Header/ Column Description > Metadata in the database is NOT a bad idea! It's a basic part of the > relational model, Codd's 4th rule. (E. F. Cod

RE: UTF-8 national characters

2002-05-15 Thread Roger Baklund
* John D. Stein > I can't seem to find anything about character code sets supported by > MySQL. The only thing I found was a note about adding support > for sorting > on Unicode at http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html. > > What character sets does MySQL support? Is Unicode the de

Re: Alter table

2002-05-15 Thread Mark
- Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Mark" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:24 AM Subject: Re: Alter table > Hi. > > Please start a new thread next time, instead of replying to a > completely unrelated topic. T

Re: Load data command?

2002-05-15 Thread Colin Faber
Hi Joshua, what exactly did you try? LOAD DATA INFILE seems to be working on my box ;-) Joshua Richards wrote: > > Hi, > Could anyone please tell me how I could load a text file into a specific > column in mysql. > I tried LOAD DATA INFILE but didn't work > > Thanks, > > J.Richards > >

RE: Alter table

2002-05-15 Thread Roger Baklund
* Mark > Can some please help me? > > I created a MySQL table with newsgroup articles in them, and > indexed them on > article_num, > > article_num int unsigned not null primary key > > But now, as I found out that searching on message_id, using a WHERE clause > tends to get very slow. So, I was w

Re: Alter table

2002-05-15 Thread Benjamin Pflugmann
Hi. Please start a new thread next time, instead of replying to a completely unrelated topic. Thank you. It sounds as if you want ALTER TABLE your_table ADD INDEX( message_id ) It is probably enough to only index some part of that field and save a lot of space: ALTER TABLE your_table ADD INDE

UTF-8 national characters

2002-05-15 Thread John D. Stein
All, I can't seem to find anything about character code sets supported by MySQL. The only thing I found was a note about adding support for sorting on Unicode at http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html. What character sets does MySQL support? Is Unicode the default for national cha

Re: MySQL 3.23.44 not using indexes

2002-05-15 Thread Myk Melez
Michael Widenius wrote: >You can check if the index are ok with CHECK TABLE; If this says the >index is ok, they are not corrupted. > Apparently this doesn't work in all cases. "CHECK TABLE" told me everything was fine, but dumping the data to a dump file via mysqldump and then re-importing i

RE: Column Header/ Column Description

2002-05-15 Thread Orr, Steve
Metadata in the database is NOT a bad idea! It's a basic part of the relational model, Codd's 4th rule. (E. F. Codd is the originator of the relational model.) While no one has implemented all 12 of Codd's rules, this is pretty basic/easy. Here's the 4th rule: "The database description is repres

Re: Column Header/ Column Description

2002-05-15 Thread MikeParton
Haven't found any open source ERD editors out there. BUT, realized that Visio has ERD diagramming capability, out of the box. Visio seems pretty prevalent around enterprises. If you look, you might find it and can describe your data model using one of several de acto standard methofologies. -

Alter table

2002-05-15 Thread Mark
Can some please help me? I created a MySQL table with newsgroup articles in them, and indexed them on article_num, article_num int unsigned not null primary key But now, as I found out that searching on message_id, using a WHERE clause tends to get very slow. So, I was wondering whether I can c

RE: Simple SQL

2002-05-15 Thread Roger Baklund
* Peter Sampson > Maybe it doesn't work because I'm using a SQL wizard in Ultradev, I'll try > your code in the HTML/ASP part of the webpage > > The table structure is > Month > Headline > Image > Caption > Content Peter, you say you're not a programmer, and I'll try to explain a little about the

Re: Column Header/ Column Description

2002-05-15 Thread Mark Matthews
- Original Message - From: "Keith C. Ivey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 4:54 PM Subject: Re: Column Header/ Column Description > On 15 May 2002, at 16:06, Mark Matthews wrote: > > > I'm interested in hearing what databases you have used that

Load data command?

2002-05-15 Thread Joshua Richards
Hi, Could anyone please tell me how I could load a text file into a specific column in mysql. I tried LOAD DATA INFILE but didn't work Thanks, J.Richards - Before posting, please check: http://www.mysql.com/manual.php

Re: Error writing file

2002-05-15 Thread Bradley Brown
Thanks very much. Bradley Gurhan Ozen wrote: > Hi Bradley, > Use perror program to see what the error code means.. > > # perror 28 > Error code 28: No space left on device > > Seems like you ran out of space.. > > Gurhan > > -Original Message- > From: Bradley Brown [mailto:[EMAIL PROTE

Re: Max vs. InnoDB?

2002-05-15 Thread Heikki Tuuri
Vaclav, MySQL-Max and MySQL/InnoDB as referred to at www.innodb.com are the same product. Innobase Oy does not distribute or sell directly MySQL-Max. All distribution and sales are done through MySQL AB. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and fo

Re: Simple SQL

2002-05-15 Thread Mark
- Original Message - From: "Peter Sampson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 9:06 PM Subject: Simple SQL > SQL beginner using Macromedia Ultradev. Can you help? > > Please be gentle I'm not a programmer! > > I am using > > Select DISTINCT Month >

Re: Column Header/ Column Description

2002-05-15 Thread Keith C. Ivey
On 15 May 2002, at 16:06, Mark Matthews wrote: > I'm interested in hearing what databases you have used that have this > functionality? SQL server and Oracle do not, for example. MS Access does. Also, it seems a bit inconsistent that MySQL has metadata (the comment) associated with each table,

Re: Assertion failure with mysql-3.23.49a/InnoDB

2002-05-15 Thread Heikki Tuuri
Michael, the assertion below looks like table corruption. Please check with CHECK TABLE your tables. If some is corrupt, dump, drop, and reimport it. The symbols file was forgotten from .49a and we cannot resolve the stack trace. You might want to try .50 in which the symbols file exists. I als

Databases with Tables approaching several million

2002-05-15 Thread Erik Fears
Hello, I'm looking for a solution to a database problem I'm having. The current implementation is a file based database of roughly 57 million entries. I'm wondering if anyone has had any experience running a mysql based database with 50-100 million entries ? I was told that mysql was optomized t

RE: Column Header/ Column Description

2002-05-15 Thread mike markovich
Most of my database work has been on DB2/400. (This the native database for IBM's AS/400 series.) The reason this is important to me is because I'm transferring data from DB2/400 to MySQL. The MySQL database is optimized for reporting purposes. Most users will access the data via ODBC and, a

Re: Fw: Simple SQL

2002-05-15 Thread Gabriel
This was addressed privately, but that's not a big deal. :) (I forgot to hit reply-all. :P) Peter Sampson wrote: > So i change the properties of Month to Integer in tblNews? Say you have two tables: mysql> show tables; ++ | Tables_in_test | ++ | MonthNames

Re: Simple SQL

2002-05-15 Thread Peter Sampson
This is the error: Microsoft][ODBC Microsoft Access Driver] ORDER BY clause (ID) conflicts with DISTINCT. This is the code used: "SELECT DISTINCT Month FROM tbl_LatestNews ORDER BY ID" Table Structure: Month, Headline, Image, Caption, Content I - Original Message - From: Gurhan Ozen

RE: Error writing file

2002-05-15 Thread Gurhan Ozen
Hi Bradley, Use perror program to see what the error code means.. # perror 28 Error code 28: No space left on device Seems like you ran out of space.. Gurhan -Original Message- From: Bradley Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 5:01 PM To: [EMAIL PROTECTED]

Re: Simple SQL

2002-05-15 Thread Peter Sampson
Maybe it doesn't work because I'm using a SQL wizard in Ultradev, I'll try your code in the HTML/ASP part of the webpage The table structure is Month Headline Image Caption Content I can have many entries with the same month. Distinct makes a page with Click here for "MONTH" news. Clicking on "

RE: Simple SQL

2002-05-15 Thread Gurhan Ozen
Peter, Please give us more insight on this. Is the column where you store dates (or months) is a date datatype column?? If yes you can just do SELECT ... FROM table_name ORDER BY MONTH(column_name); It'll help to see your table structure to help you. Thanks. Gurhan -Original Message- F

RE: Column Header/ Column Description

2002-05-15 Thread Gurhan Ozen
That's why there is a seperate area called "documentation" . why let MySQL software run slower and/or eat up more memory space with a useless feature. You can always document your specifications in a document, it doesn't have to be stored on the tables themselves. If you really want that documenta

RE: Column Header/ Column Description

2002-05-15 Thread Paul DuBois
At 13:54 -0700 5/15/02, mike markovich wrote: >Paul, > >Thanks for responding. The ability to document columns, tables, >databases, etc. seems pretty important to me. Why is this not an >issue to others? Am I approaching this issue the wrong way? Your >thoughts would be appreciated. > >Mike

Re: Column Header/ Column Description

2002-05-15 Thread Mark Matthews
>- Original Message - > From: "mike markovich" <[EMAIL PROTECTED]> > To: "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, May 15, 2002 3:54 PM > Subject: RE: Column Header/ Column Description > > Paul, > > Thanks for responding. The ability to document columns, t

Fw: Simple SQL

2002-05-15 Thread Peter Sampson
So i change the properties of Month to Integer in tblNews? Create another table called MonthNames? Now I'm lost a bit, please can you clarify? I can populate the MonthNames table with jan feb march etc Please can you clarify the next bit, I not familar with n JOIN ON n Month? >

Error writing file

2002-05-15 Thread Bradley Brown
Hey all, I'm attempting to create a new table within a database. I have tried from the mysql client and also from dbtools. Here is the error message I am receiving: ERROR 3: Error writing file './path_to/file.frm' (Errorcode: 28) I am trying to add the table as root. I have checked the file

RE: Column Header/ Column Description

2002-05-15 Thread mike markovich
Paul, Thanks for responding. The ability to document columns, tables, databases, etc. seems pretty important to me. Why is this not an issue to others? Am I approaching this issue the wrong way? Your thoughts would be appreciated. Mike -Original Message- From: Paul DuBois [mailto

Newbie asks error 1036 table read only?

2002-05-15 Thread Bill Flanagan
Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM tables on which I am unable to do updates or inserts. I get error message #1036 'Table is read only.' I am able to sign on to the database through the root, set myself up as a superuser in the user table, and have been able to s

Re: Is there MySQL version 4.0.2 ?

2002-05-15 Thread Paul DuBois
At 9:59 -0600 5/15/02, Colin Faber wrote: >Hi, > >as far as I know the only way that can be correct is to have one of the >committers rename the files them selves that have duplicate names. Since >windows isn't smart enough to realize that "ABC" doesn't mean "abc". > >Good luck getting it working

Re: Column Header/ Column Description

2002-05-15 Thread Paul DuBois
At 11:48 -0700 5/15/02, mike markovich wrote: >Hi All, > >What is the convention for documenting the contents/purpose of a >column in MySql? There is none. > Most databases I have worked with had a way where text could be >entered for each column that described the purpose and or contents >

Re: Temp Table size?

2002-05-15 Thread Colin Faber
Hi Mike, Possibly out of available memory. (Or disk space assuming that's what it's hitting) Mike Grover wrote: > > When I create a temp table, If I put to much in it, > I get a "Temp Table [Table name] is Full" error. > > I changed my tmp_table_size to a ver large number. > > Still same err

Re: empty?

2002-05-15 Thread Paul DuBois
At 15:40 -0400 5/15/02, Amy Zediak wrote: >I have my MySQL database up and running, but its empty...did i miss a >step? > >Thanks >Amy Do you mean: - Your server is up and running, but there are no databases at all - Your server is up and running, and there is a database named "mysql" but it

RE: Simple SQL

2002-05-15 Thread Roger Baklund
* Rodney Broom > From: Peter Sampson <[EMAIL PROTECTED]> > > Select DISTINCT Month > > FROM tblNews > > > > The problem is that the months are shown alphabetical not in > > calendar order. > > I'm assuming that your months are stored as names like: > > January, February, March > > or > >

Re: empty?

2002-05-15 Thread Colin Faber
Hi amy, No the database(s) them selves are empty until populated with tables, and data. Amy Zediak wrote: > > I have my MySQL database up and running, but its empty...did i miss a > step? > > Thanks > Amy > > - > Before po

Re: MySQL & SYBASE

2002-05-15 Thread Ken Menzel
Hi Chris, Dear Sir/Madam seems a little formal for a public mailing list! Anyway, we use perl scripts to transfer information from Microsoft SQL server (which was and is somewhat compatable with SyBASE) use the freeTDS sybase/mssql drivers to mysql. I modeled the databse with ErWIN first then

Temp Table size?

2002-05-15 Thread Mike Grover
When I create a temp table, If I put to much in it, I get a "Temp Table [Table name] is Full" error. I changed my tmp_table_size to a ver large number. Still same error, Any Ideas? This is windows 2000 MySQL 4.01 Config Loaded Form my.ini in winnt dir. Show Variables for server shows new tmp_

a date for 3.23.50 declared as stable ?

2002-05-15 Thread David BORDAS
Hi list, i know that 3.23.50 is a pre-released version. But if someone can tell me when this version will be declared as stable so i will upgrade my linux production servers running redhat 7.2 and gcc 2.96 with the tar.gz build mysql. Thanks David filter : sql,query --

empty?

2002-05-15 Thread Amy Zediak
I have my MySQL database up and running, but its empty...did i miss a step? Thanks Amy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: Simple SQL

2002-05-15 Thread Rodney Broom
From: Peter Sampson <[EMAIL PROTECTED]> > Select DISTINCT Month > FROM tblNews > > The problem is that the months are shown alphabetical not in calendar order. I'm assuming that your months are stored as names like: January, February, March or Jan, Feb, Mar If so, I think that sorting

Re: Best book on MySQL

2002-05-15 Thread Jeff Kilbride
Thanks for the insight. --jeff - Original Message - From: "Mike Grover" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 6:07 AM Subject: RE: Best book on MySQL > Mainly what hooked me on mySQL was the static record layout for MyISAM > tables. > > I have to imp

Simple SQL

2002-05-15 Thread Peter Sampson
SQL beginner using Macromedia Ultradev. Can you help? Please be gentle I'm not a programmer! I am using Select DISTINCT Month FROM tblNews The problem is that the months are shown alphabetical not in calendar order. How can I change this? ---

Column Header/ Column Description

2002-05-15 Thread mike markovich
Hi All, What is the convention for documenting the contents/purpose of a column in MySql? Most databases I have worked with had a way where text could be entered for each column that described the purpose and or contents of the column. It seems to me that this is something that should happe

Re: Best book on MySQL

2002-05-15 Thread Jeff Kilbride
Hi Mike, Thanks. I appreciate the insight. I think I remember the "sweeping" maintenance of the tables from the stuff I read at the Firebird sourceforge site -- called "vacuuming", right? That seemed like a serious pain in the butt. Also, I couldn't find any easy solutions for replication, which

Assertion failure with mysql-3.23.49a/InnoDB

2002-05-15 Thread Michael Bacarella
I've gotten this same assertion failure twice. I'm very confident in this machine's stability since it has survived 36 hours worth of CTCS, so I'm not going to look for a hardware problem just yet. At first I thought it may have been the glibc issue with threads overwriting each other's stacks b

Re: Pre-release of MySQL 3.23.50

2002-05-15 Thread Michael Widenius
Hi! Trying to catch up with some old emails... > "Ireneusz" == Ireneusz Piasecki <[EMAIL PROTECTED]> writes: Ireneusz> Hi. I'm running on linux box 6.2 with glibc 2.1 and i compiled from src.rpm Ireneusz> mysql. Ireneusz> The compiler is gcc 2.95.2. Ireneusz> So, the new version of mysql

Re: MySQL 3.23.44 not using indexes

2002-05-15 Thread Michael Widenius
Hi! > "Myk" == Myk Melez <[EMAIL PROTECTED]> writes: Myk> Steven Roussey wrote: >> Are the tables defined the same on both servers? >> Myk> Yes, the tables are defined exactly the same. >> Is the data the same? >> Myk> Just about. The data on the working server is a copy of the databas

Re: mysql error

2002-05-15 Thread Colin Faber
Hi Tristan, Both the client and the server must have that option enabled. You must also have the right setup in your grant tables to load files. Try loading it locally (with out the LOCAL flag) and see if that helps. Tristan Trio wrote: > > Hello, > Am new to mySQL. I had installed mySQL ve

bug in multi-table delete in MySQL-4.0.2 ?

2002-05-15 Thread Jocelyn Fournier
Hi, I'm just testing the new multi-table delete in MySQL-4.0.2 and I wonder if I'm doing something wrong with this query : mysql> DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.num

Re: Dateformat

2002-05-15 Thread Georg Richter
On Wednesday, 15. May 2002 14:54, Mattias Persson wrote: > query above. The manual says > > %v Week (1..53), where Monday is the first day of the week. Used with '%x' > %u Week (0..53), where Monday is the first day of the week > > When is there a week 0? Hi, Week = 0 only is valid for %u. %v

Re: checksum errors

2002-05-15 Thread Michael Widenius
Hi! > "Melvyn" == Melvyn Sopacua <[EMAIL PROTECTED]> writes: Melvyn> I don't get the checksum errors anymore - after I changed the table def. Melvyn> However - myisamchk is not doing a good job with the large keys (restored Melvyn> them by LOAD TABLE hardware FROM MASTER which produced th

Re: MySQL & SYBASE

2002-05-15 Thread Eberhard Lisse
Perl is your friend. el In message <[EMAIL PROTECTED]>, "Ch ristopher E. Aston" writes: > Dear Sir/Madam, > > An odd question. Can a SYBASE database and a MySQL database interact? That > is, can routines be written that, at a specified time or time intervals, > syncronize specified data between

DBI connect (help)

2002-05-15 Thread Taylor Lewick
Hi all, I am trying to connect to my mysql database with a perl script... I can connect from commnad line both passing a password or at password prompt... I can connect successfully with the following line in my script.. my $dbh = DBI->connect("DBI:mysql:database=mysql;host=localhost", "root", "p

Re: mysql.sock difficulties

2002-05-15 Thread Mark
- Original Message - From: "Scott J. Pearson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 7:13 PM Subject: mysql.sock difficulties > I installed one version of MySQL but had to reinstall MySQL. > Thus, I manually deleted the first installation, > including /

mysql.sock difficulties

2002-05-15 Thread Scott J. Pearson
I installed one version of MySQL but had to reinstall MySQL. Thus, I manually deleted the first installation, including /tmp/mysql.sock. The second installation mysteriously did not install another copy of mysql.sock. Gerry-mandering the configuration through the following line avails nothing: ./

MySQL & SYBASE

2002-05-15 Thread Christopher E. Aston
Dear Sir/Madam, An odd question. Can a SYBASE database and a MySQL database interact? That is, can routines be written that, at a specified time or time intervals, syncronize specified data between these two databases? An comments or opinions would be appreciated. Thanks -chris Christopher E.

Re: sql, query

2002-05-15 Thread MikeParton
As an addendum to my last message: If you want to do db dev through the GUI, I would suggest the MyCC from MySQL AB over dbTools. MyCC provides more in the way of server process and variable exposure within the GUI itself. Mike - Original Message - From: "Anne Hall" <[EMAIL PROTECTED]

Max vs. InnoDB?

2002-05-15 Thread dvorakv
Hello list, what's the difference and relation between MySQL-Max and the stuff at www.innodb.com? Both technically and license-wise... Thanks. Vaclav Dvorak [EMAIL PROTECTED] IDAS, s.r.o.http://www.idas.cz - Before postin

Re: sql, query

2002-05-15 Thread Anne Hall
Here is my message again: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the

Re: download mysql GUI

2002-05-15 Thread MikeParton
Without knowing what you need to be able to do in a MySQL GUI: I have MyCC 0.8.2 from MySQL AB and dbTools 1.0.13 from www.dbtools.com.br. I like both. MyCC is alpha and a little finicky at times...but easy to use. dbTools is interesting and has a lot of potential. HTH Mike - Original

Re: Is there MySQL version 4.0.2 ?

2002-05-15 Thread Colin Faber
Hi, as far as I know the only way that can be correct is to have one of the committers rename the files them selves that have duplicate names. Since windows isn't smart enough to realize that "ABC" doesn't mean "abc". Good luck getting it working under windows ;-) Viliam Batka wrote: > > Hi ,

download mysql GUI

2002-05-15 Thread Anne Hall
Hi: I am trying to download GUI for mysql server, however, there are several choices at the site, would you please give some advise of which one I should download please? Regards, Anne Hall IntelliSTAR(sm) Providing High-Tech, High-Touch services for over 6 Years! http://www.intellistar.net 40

Very new to windows version - question about host and server

2002-05-15 Thread Norris, Joseph
Group, I have been using (very happily) mysql on unix boxes. I am in a new job and there is not a unix box in sight!!! ouch! This is a windows 2000 shop. Here is the situation and I am looking for any and all suggestions: 1) I have mysql, apache, perl, etc running on my own box and I have

Re: Re: MySQL database files

2002-05-15 Thread Victoria Reznichenko
Augey, Wednesday, May 15, 2002, 4:25:15 PM, you wrote: AM> Those files got so big that I had no more space on my hard drive and AM> queriess would stop returning without any message telling me what was AM> going on. All for the log files? Doesn't that seem like something that AM> should be c

Re: gcc for newer mysql versions - what's needed exactly ?

2002-05-15 Thread Egor Egorov
j.random.programmer, Wednesday, May 15, 2002, 3:00:26 AM, you wrote: jrp> Can someone (who knows this sort of thing) give a jrp> layman's introduction to the interplay between jrp> various gcc versions and various mysql versions jrp> (3.49, 3.50, 4.01 etc) ? I have some linux boxes jrp> and don

Re: Best book on MySQL

2002-05-15 Thread mos
At 04:34 PM 5/14/2002, you wrote: >I'd be interested in how both of you compared them. > >Thanks, >--jeff Jeff, I'm using MySQL for a webserver and didn't really want to use Firebird (Interbase) for that type of application. It is my feeling that IB requires more maintenance than MyS

Re: building mysql-4.0.1 (libtool question)

2002-05-15 Thread Taylor Lewick
Okay, I believe the problem I am having is make is having some problemsis in libmysql.c when the getenv fucntion is used. I commented out the following lines in libmysql.c and then the program errored in the next line with getenv. Anyone have a workaround for this code on HP-UX 11.00? if (!p

Reset Master command ignores max_binlog_size variable

2002-05-15 Thread Andre Stahl
Hi all, Were running replication on our Prod. DB (3.23.42 on SuSE 7.0) since a half year. Our way to rotate the binlog files was to stop all software inserting data into the Prod. DB and then reset the master and the replication server. This works fine but produces a downtime of aprox. 10 minutes

Reset Master ignores max_binlog_size variable

2002-05-15 Thread Andre Stahl
Hi all, Were running replication on our Prod. DB (3.23.42 on SuSE 7.0) since a half year. Our way to rotate the binlog files was to stop all software inserting data into the Prod. DB and then reset the master and the replication server. This works fine but produces a downtime of aprox. 10 minutes

make test]

2002-05-15 Thread Amy Zediak
after running "make test" i received 3 errors relating to rpl01, 4, and and 7. This error message is displayed: AT line 6: query 'slave stop' failed: 1199: This operation requires a running slave, configure slave and do SLAVE START At line 6: query 'load data infile '../../std_data/words.d

RE: Encrypting with PASSWORD() function

2002-05-15 Thread adam nelson
of course, the safe way is to always reset the password when such a thing happens. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 10:48 AM To: [EMAIL PROTECTED] Subject: Re: Encrypting with PASSWORD() function Walter, Tuesday, May 1

building mysql-4.0.1 (libtool question)

2002-05-15 Thread Taylor Lewick
I am trying to build mysql-4.0.1 from the source... When it gets to libtool it is having problems finding gcc... How can I cahnge the path to the full path of the gcc compiler? Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath.

  1   2   >