help needed on datetime functions

2001-12-05 Thread nimeesh patel
hi everybody i want to take diff of datetime format columns. Is it possible using direct '-' arithmatic.. It gives result as: 2001-11-03 15:43:47 - 2001-11-03 15:42:21 = 126 2001-11-03 16:11:50 - 2001-11-03 15:48:00 = 6350 First row is clear but i'm not getting second row's diff.. **((63)50)**

FW: compile errors

2001-12-05 Thread Gill, Vern
Anyone able to help with this? Or am I just stuck...? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 6:47 PM To: '[EMAIL PROTECTED]' Subject: compile errors trying to compile mysql-3.23.46, getting this error. Can't find any reference to

Re: Using c-isam calls to access MySQL ISAM data files

2001-12-05 Thread Sergei Golubchik
Hi! On Dec 05, Tobias Crush wrote: Hi All, We am currently investigating the possiblity of migrating a legacy app from Informix C-ISAM files to MySQL. To do this we are looking to be able to retain the core application code as unchanged as possible. What we want to do is be able to

Re: Why can't I get SORT BY to work with FULLTEXT?

2001-12-05 Thread Sergei Golubchik
Hi! First: please reply to the list, not directly to me. Then: I need a repeatable test case. That is CREATE TABLE ... INSERT INTO ... VALUSE (...),(...)... SELECT * FROM ... WHERE ... = it works SELECT * FROM ... WHERE ... ORDER BY ... = it does not On Dec 04, Mark J.

MySQL with LinuxThreads - CHECK TABLE causes crash in mysqld

2001-12-05 Thread Smirnov Konstantin
Hello list! We have a dual-CPU machine with FreeBSD 4.1.1 (well-known problem with MySQL, eh? ;)) Yesterday, after our server died 4 or 5 times during 8 hours, I compiled MySQL with LinuxThreads. It works pretty cool now, but two things annoy me very much: 1. MySQL dies when I try to CHECK TABLE

Re: Optimizing date queries

2001-12-05 Thread Emil Rasmussen
CREADE INDEX myDateField_Index ON tblTabel ( DATE_FORMAT(myDateField,'%Y%m%d') ); This may or may not work, but it's worth a shot, if you prefer your query in the format it was in before. It did not work with MySQL 3.23.32, it whould have been very nice, because i still have a problem

Re: Optimizing date queries

2001-12-05 Thread alec . cawley
CREADE INDEX myDateField_Index ON tblTabel ( DATE_FORMAT(myDateField,'%Y%m%d') ); This may or may not work, but it's worth a shot, if you prefer your query in the format it was in before. It did not work with MySQL 3.23.32, it whould have been very nice, because i still

Re: Optimizing date queries

2001-12-05 Thread Emil Rasmussen
I am not sure I quite understand your problem, but doen't the BETWEEN ... AND operator solve your problem? All you have to do is to format the limits in a way that MySQL understands to be a timestamp, and it should then do a proper date comparison. Nope, the BETWEEN AND operator does not

MySQL regional settings problem

2001-12-05 Thread [EMAIL PROTECTED]
I have a problem with my regional setting. I want to insert into my database a decimal number, using comma instead of dot like in this example: 11,45 not like 11.45 If possible, i wouldn't change my regional settings. Can you help me ? Thanks

problem with LIKE when I'm using Ukrainian

2001-12-05 Thread Andrew Kharchuk
Hello guys. I'm using mysql Ver 11.15 Distrib 3.23.38, for pc-linux-gnu (i686) at the server of my hosting provider. My English is bad but I'll try to describe my problem. I'm using ukrainian language filling the database. The next problem occured: when i'm using LIKE '$text' at the

Re: Optimizing date queries

2001-12-05 Thread Jason Wong
On Wednesday 05 December 2001 18:48, Emil Rasmussen wrote: I am not sure I quite understand your problem, but doen't the BETWEEN ... AND operator solve your problem? All you have to do is to format the limits in a way that MySQL understands to be a timestamp, and it should then do a

Query seem to be using the wrong index / InnoDB

2001-12-05 Thread Maciek Dobrzanski
Hi, This happens on MySQL 3.23.44 CREATE TABLE ttble ( `k1` varchar(100) NOT NULL default '', ... `k2` varchar(65) NOT NULL default '', ... PRIMARY KEY (`k1`, `k2`) ... ) TYPE=InnoDB When k1 is compared to a string with only one known letter... EXPLAIN SELECT * FROM

Re: help needed on datetime functions

2001-12-05 Thread Jason Wong
On Wednesday 05 December 2001 16:40, you wrote: hi everybody i want to take diff of datetime format columns. Is it possible using direct '-' arithmatic.. It gives result as: 2001-11-03 15:43:47 - 2001-11-03 15:42:21 = 126 2001-11-03 16:11:50 - 2001-11-03 15:48:00 = 6350 First row is

Re: Optimizing date queries

2001-12-05 Thread Emil Rasmussen
You have to include the full format to make it work, i.e. including the MMDD section of the MMDDHHMMSS format. The above query will probably yield no results because you have no data in the given range (year ). Yes i know, but i want the data from all years, months and days sorted

Re: Optimizing date queries

2001-12-05 Thread Emil Rasmussen
If your field is a standard MySQL DATE/TIME field then HOUR(myfield) will extract the hour portion from myfield. Thus you can have WHERE HOUR(myfield) = 14 Yes, that is what i am doing now, but that is really slow, because all the dates, have to converted to strings, before MySQL can

Re: Query seem to be using the wrong index / InnoDB

2001-12-05 Thread Dr. Frank Ullrich
Hi, how big is the result set in your 2 queries (compared to the number of rows in the table)? Seems that in the 2nd case the query was much more selective than in the first case. Therefore using an index in the first query might have been considered not advantageous. But try this also with

A mysql folder or a php build file

2001-12-05 Thread A . C . Young
Hi, I am looking to export a PHP/MySQL application I have written. As far as the MySQL side goes I am unsure if I should simply send a MySQL folder (copied from the MySQL/Data directory) or a php file that would create all the neccessary MySQL tables the first (and only) time it ran. I can

data missing when going into database ( +revious Segmentation error)

2001-12-05 Thread Ian Moss
mysql use protodel; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'access' Didn't find any fields in table 'document' Didn't find any fields in table 'document_access_log' Didn't

RE: RE: Very large table load/index questions

2001-12-05 Thread Barry Roomberg
MySQL - spam bypasser myisamchk --keys-used=3D0 -rq You can enable/disable keys from command line in 3.23. While that would disable the key before the load, how do I re-enable them afterwards? - Before posting, please

Re: Optimizing date queries

2001-12-05 Thread alec . cawley
WHERE myfield LIKE 'HH' However this query will probably not use your index either :) Yeah, it works, but still, it does not use my index as long as it is working with strings. But neat trick anyway. It sounds to me as if you need to change your table design. You want to

Re: 64bit mysql and gcc

2001-12-05 Thread Sinisa Milivojevic
Ian writes: Here is the 2.8 package I just downloaded from one of your mirror sites. [reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin ls mysqld mysqld* [reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin file mysqld mysqld: ELF 32-bit MSB executable

Re: Optimizing date queries

2001-12-05 Thread Marjolein Katsma
Emil, You might try to split the time stamp into separate date and time columns. That would allow you to cretae and use an index on time alone. At 14:24 2001-12-05 +0100, Emil Rasmussen wrote: WHERE myfield LIKE 'HH' However this query will probably not use your index either

Re: mailing list

2001-12-05 Thread Ken Menzel
Hi Sinisa and Colin, Sinisa the PR database (Problem/Resolution Database) for freebsd is a more formal version of http://www.mysql.com/doc/B/u/Bugs.html . In FreeBSD eash problem is assigned a number in a database tracking who submitted the bug, the date, the priority, and details about the

Re: BSDI 4.2 and Mysql

2001-12-05 Thread Ken Menzel
Hi Husri, you are low on memory (as the error says). try this, first remove the file config.cache from the mysql source directory then rerun config and add --with-low-memory to the list of commands: I use a shell scripte with this: rm config.cache CC=gcc CFLAGS=-O3 CXX=gcc \ CXXFLAGS=-O3

Re: data missing when going into database ( +revious Segmentation error)

2001-12-05 Thread Sasha Pachev
On Wednesday 05 December 2001 05:51 am, Ian Moss wrote: System: Linux proserver 2.2.14 #1 Sat Mar 25 00:45:35 GMT 2000 i686 unknown Architecture: i686 Basically its all a lie that linux is more stable than windoze. I've run mysql on pc's over the last year with no problems at all. The

Re: mailing list

2001-12-05 Thread Sinisa Milivojevic
Ken Menzel writes: Hi Sinisa and Colin, Sinisa the PR database (Problem/Resolution Database) for freebsd is a more formal version of http://www.mysql.com/doc/B/u/Bugs.html . In FreeBSD eash problem is assigned a number in a database tracking who submitted the bug, the date, the

Re: Optimizing date queries

2001-12-05 Thread Emil Rasmussen
It sounds to me as if you need to change your table design. You want to search by hours only, so you should have an hours column in your database. Either you should break the date up into DATE and TIME fields I have been thinking on doing that, but there was something about it, that i did

Re: MySQL with LinuxThreads - CHECK TABLE causes crash in mysqld

2001-12-05 Thread Ken Menzel
Hi Konstantin, You don't mention what version of MySQL you are using so I will assume that you are using the most recent. There were many problems with the threads libraries and even some compiler bugs on 4.1 and 4.2. The are resolved by 4.3 and 4.4 (and soon to be 4.5) Is there any chance

Re: Why can't I get SORT BY to work with FULLTEXT?

2001-12-05 Thread Mark J. Degallier
First: please reply to the list, not directly to me. Then: I need a repeatable test case. That is CREATE TABLE ... INSERT INTO ... VALUSE (...),(...)... SELECT * FROM ... WHERE ... = it works SELECT * FROM ... WHERE ... ORDER BY ... = it does not THIS QUERY WORKS:

Crash Replication Server

2001-12-05 Thread Graziano Raffaella
Hello list! I have installed MySQL 3.23.39 on Compaq Tru64 UNIX V5.1. I need to run two servers on the same machine, one as master and another as slave. The database used is InnoDB, I need to replicate only one database. I start successfully the master. When I start the slave it go up and down.

Re: 64bit mysql and gcc

2001-12-05 Thread Laurent Oget
On Wed, Dec 05, 2001 at 05:05:54PM +0200, Michael Widenius wrote: Hi! cut Yes; Our Solaris binaries are currently 32 bit. The main reason for this is that I haven't seen any reports that gcc should be able to produce production quality code on 64 bit sparc. the sun compiler does,

Re: command line question..

2001-12-05 Thread Denis A. Rudakov
Hello ! I often use that common scheme to parametrize my queries. #!/bin/bash #check parameters most commonly (only number of parameters) if [ $# !=NUMBER_OF_PARAMETERS_NEEDED ]; then echo Too few parameters;exit 1; fi # these are queries in my transactional procedure # $1...$N are

Load ODBC Data

2001-12-05 Thread TOMASSONI Dominique
Hello the list, Is it possible to import ODBC data into a mysql database ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Optimizing date queries

2001-12-05 Thread Emil Rasmussen
mysql ... which would prevent index usage. If your kind of query is frequent and slow, you could split your DATETIME column into two separate columns for DATE and TIME and put an index onto TIME. Ok, thanks for the help! Regards Emil -- Emil Rasmussen http://noget.net

RE: help with timestamp...

2001-12-05 Thread Rick Emery
If you need a timestamp that is automatically updated when a record is inserted, replaced, or updated, declare one field in the record as TIMESTAMP: create table mytable ( myvalue int default 0, mytime TIMESTAMP } INSERT INTO mytable VALUES( 123, NULL ); -Original Message- From:

RE: Problems compiling under Solaris 2.6

2001-12-05 Thread Matthew Darcy
Hmmm, Good thinking. However, the files needed (autoconf) is in /usr/local/bin - which is in my $PATH. a which shows autoconf so I know it can be seen without any problems. There is no ld.conf.so under solaris 2.6. Any more suggestions as I am having big problems with this. Thanks, Matt.

Re: Load ODBC Data

2001-12-05 Thread Denis A. Rudakov
Hello ! With M$ Query it's achieved just by executing any modification query (insert,update,create etc). Check the permissions for user from who the ODBC connections is performing. Goodbye. Dannis. On Wed, Dec 05, 2001 at 04:46:22PM +0100, TOMASSONI Dominique wrote: Hello the list, Is it

Re: [OT] Re: compile problems on Solaris8

2001-12-05 Thread George Horvath
Ok, I followed your advice and removed the soaris built gcc from sunfreeware and downloaded the source instead. How ever now I am getting this message when I try to compile gcc: # /usr/local/gcc-2.95.3/configure --prefix=/usr/local/gnu Configuring for a sparc-sun-solaris2.8 host.

Re: Crash Replication Server

2001-12-05 Thread Heikki Tuuri
Raffaella, try to compile the latest version 3.23.46 on your system with the gcc -g flag. MySQL AB does not have a ready binary on Tru64, so you have to compile yourself. If it still crashes, run the slave inside gdb and do bt full, so that we see where it crashes. Regards, Heikki

Error trying to create InnoDB database. HELP

2001-12-05 Thread Weaver, Walt
Okay, I've finally gotten around to trying to create an InnoDB database. I've configured MySQL on Linux Red Hat 6.2, mysql 3.23.44 with the --with-innodb parm. Everything installed wonderfully. When I start up mysqld, the datafiles and logfiles are created just fine. But, when everything is done

Re: problem with LIKE when I'm using Ukrainian

2001-12-05 Thread Carl Troein
Andrew Kharchuk writes: I'm using ukrainian language filling the database. The next problem occured: when i'm using LIKE '$text' at the 'SELECT SQL statement with some 2 letters in ukrainian letters in $text, mysql server regard them as another letter (it make no distinction between

Grtis!! Registe o seu dominio na Internet

2001-12-05 Thread WEB.PT FREE
REGISTE O SEU DOMNIO GRTIS Se tem um daqueles endereos complicados do tipo, http://www.endereo.pt/paginas_pessoais/~minha_pagina/index.html, aproveite esta oportunidade para criar um endereo mais simples e fcil de comunicar, do tipo, www.minha_pagina.web.pt, SEM PAGAR NADA. O WEB.PT Free

RE: Error trying to create InnoDB database. HELP

2001-12-05 Thread Weaver, Walt
Dammit, never mind. I figured it out. Maybe someday I'll be able to ask an intelligent question here... --Walt -Original Message- From: Weaver, Walt Sent: Wednesday, December 05, 2001 10:09 AM To: [EMAIL PROTECTED] Subject: Error trying to create InnoDB database. HELP Okay, I've

Re: Error trying to create InnoDB database. HELP

2001-12-05 Thread Mike(mickalo)Blezien
Did you run the 'mysql_install_db' script after installing MySQL?? the database 'mysql' should be located within the datadir, along with the other databases that are created. On Wed, 5 Dec 2001 10:08:38 -0700 , Weaver, Walt [EMAIL PROTECTED] wrote: Okay, I've finally gotten around to trying

RE: Error trying to create InnoDB database. HELP

2001-12-05 Thread Weaver, Walt
Yup, somehow I must've missed that. Thanks... --Walt -Original Message- From: Mike(mickalo)Blezien [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 10:22 AM To: Weaver, Walt Cc: [EMAIL PROTECTED] Subject: Re: Error trying to create InnoDB database. HELP Did you run the

Re: Error trying to create InnoDB database. HELP

2001-12-05 Thread Robert Alexander
At 10:08 -0700 2001/12/05, Weaver, Walt wrote: When I start up mysqld, the datafiles and logfiles are created just fine. But, when everything is done the following error appears: /usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host' doesn't exist This may be an obvious one,

User issues in installation. New beginner

2001-12-05 Thread Faizal Mangera
Hey people, I've just set-up mysql on a redhat version6.1 of linux. I am new to both. If i log into the machine as root I can run mysql. If I log into the machine as a normal user I can't run mysql. Is it a case of permissions in linux? I need to be able to run mysql through a telnet window on

Help with Auto Increment

2001-12-05 Thread Mysql List
Hi, How do I start an autoincrement field at a certain value, say 1000? I have a field as: ID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (ID) How do I modify it to start at 1000? These all generate errors: modify mytable ID AUTO_INCREMENT = 1000; modify mytable ID = 1000; modify mytable ID

Re: User issues in installation. New beginner

2001-12-05 Thread Mysql List
In General Terms: Most default linux installs do not allow root user to telnet in to the machine, this is good as a default. You need to add the user that you do logon as to the MySQL permissions. This can be found in the manual. To access your MySQL db from Access, all you need to do is install

Error on Start-up

2001-12-05 Thread Bernie Borgmann
Hi I get the following errors on start-up; 011205 12:53:25 mysqld started /usr/local/libexec/mysqld: File './melges-bin.1' not found (Errcode: 13) 011205 12:53:25 Could not use melges-bin for logging (error 13) 011205 12:53:25 /usr/local/libexec/mysqld: Can't create/write to file

[OT] Samba (was: User issues in installation. New beginner)

2001-12-05 Thread Rick Emery
Although Samba is not needed for what you need, I suggest that you install it. I use it to easily share files (without FTP) on my home systems: RH Linux 7.0, Win98 be prepared to tinker around with the samba configuration files, though. -Original Message- From: Faizal Mangera

Trying to determine bottleneck

2001-12-05 Thread Barry Roomberg
Sun 450 Solaris 7 3 CPU MySQL binary install 50 million record table. Initially tested on dual CPU Intel Linux, now trying on Sun. During index create (via alter), it copies the base file (as documented). It spins the CPU at about 31%, with 7 threads active. There is almost NO iowait (fast

Blocked Delivery of email from tseekee@pd.jaring.my

2001-12-05 Thread postmaster
BLOCKED DELIVERY OF EMAIL FROM [EMAIL PROTECTED] Our email scanner has detected a file type (or content) which we are not permitting through our systems. These namely include movies, executables and large pictures. Your email has been stopped. The intended sender will receive

Re: [OT] Re: compile problems on Solaris8

2001-12-05 Thread George Horvath
George Horvath wrote: Ok, I followed your advice and removed the soaris built gcc from sunfreeware and downloaded the source instead. How ever now I am getting this message when I try to compile gcc: # /usr/local/gcc-2.95.3/configure --prefix=/usr/local/gnu Configuring for a

Error 1045 - Access denied

2001-12-05 Thread Tyler Longren
Hello, I keep on getting 1045 - Access denied for user: [EMAIL PROTECTED] (using password: YES) errors. I'm connecting to this MySQL server from a remote site. I don't see any reason for this. I KNOW that my password is correct. In the user table, the Host is set to % for the mysql user.

How do I get started?

2001-12-05 Thread Joe Kaczmarek
I didn't know where else to turn, but I'm wondering the simple (and stupid) question of how do I get started using and learning MySQL. I recently switched to a hosting company that supports MySQL, but what do I need to get started using it and learning it? Does the MySQL only exist on a web

RE: How do I get started?

2001-12-05 Thread Rick Emery
go to http://www.mysql.com Get documentation, such as MYSQL Manual. Read it. No, you do not need MYSQL on your local system, but helps when testing, and learning. MYSQL is available for Unix/Linux and Windows systems. There ae many good books. The bible is Paul DuBois book, MYSQL. He often

RE: Error 1045 - Access denied

2001-12-05 Thread Carsten H. Pedersen
Hello, I keep on getting 1045 - Access denied for user: [EMAIL PROTECTED] (using password: YES) errors. I'm connecting to this MySQL server from a remote site. I don't see any reason for this. I KNOW that my password is correct. In the user table, the Host is set to % for the mysql

New binary installation problems.

2001-12-05 Thread David Hudgins
For some reason the binary install install of mysql on redhat linux is putting the database files in /var/lib/mysql instead of /usr/local/mysql/data. The data dir is present and holds mysql and test databases, but when we populated the data base the new databases where put into /var/lib/mysql.

select statement group by unusual results

2001-12-05 Thread chip . wiegand
I have a database with 12 tables. I am running a query to select certain fields from 3 of the tables, like this - select Title, Details, StartDate, City, State from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations where phpCalendar_Details.EventLocationID =

Re: New binary installation problems.

2001-12-05 Thread Philip Molter
On Wed, Dec 05, 2001 at 04:28:58PM -0500, David Hudgins wrote: : For some reason the binary install install of mysql on redhat linux is : putting the database files in /var/lib/mysql instead of : /usr/local/mysql/data. The data dir is present and holds mysql and test : databases, but when we

MYSQL-based commerce packages

2001-12-05 Thread rory o'connor
I'm looking for a new commerce package, something run of a MySQL database. it's gotta have bulletproof (well, as close as you can get) session management. I wonder what others on the list are using and like? input is appreciated! thanks!

Re: Upgrade MySQL

2001-12-05 Thread Arjen G. Lentz
Hi, - Original Message - From: Michael Tam [EMAIL PROTECTED] I am using MySQL 3.23.41 under Win2000. I wonder what is the easiest way to upgrade the MySQL to 3.23.46 with my existing data and grant table? From what I see is that I need to dump the data tables as files,

PHP + MySQL problem (strange behavior)

2001-12-05 Thread Javier Muniz
Hello, I'm having trouble determining what's going wrong with a MySQL query that I'm doing from PHP. I have a table with the following columns: id (int) name (varchar 20) starttime (int) duration (int) now, i have a row that has a starttime of 60, when i attempt to do the following update

Re: [PHP] Re: MySQL ORDER BY or PHP Sort? Oops.

2001-12-05 Thread DL Neil
René, I want to select about 25 rows from a table, and sort them by two criteria. First, by each row's Series field (Baby, Genesis, Super, Predator, Millennium are the various Series, and the order I'd like the rows in the array). Within each Series, I'd like the rows sorted by their Price

queries on particular table produce errors

2001-12-05 Thread Alex Pukinskis
Whenever I try to do anything with a specific table in my db, I get an error. Here's the list of tables: mysql show tables; ++ | Tables_in_acv2 | ++ | company| | group | | internet | | knowing| | person | | personality|

Auto-extending MySQL tablespace

2001-12-05 Thread Demirchyan Oganes-AOD098
Hello everyone, I've rewrote our existing our existing software to be compatible both for Oracle 8i and MySQL databases. I wanted to know, does MySQL support auto-extending of it's tablespace? I know how to manually do it, by adding data files, and restarting the server. Also, how could I

Re: select statement group by unusual results

2001-12-05 Thread DL Neil
Chip, I have a database with 12 tables. I am running a query to select certain fields from 3 of the tables, like this - select Title, Details, StartDate, City, State from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations where phpCalendar_Details.EventLocationID =

optimize for SELECTs on multiple large tables

2001-12-05 Thread Florin Andrei
I have this SQL query: SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \ tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123'; (well, maybe there are more than two columns selected, and maybe a little more than two tables, but you got the idea...) The tables have 5...10 columns, every column is an

RE: queries on particular table produce errors

2001-12-05 Thread Philippe Parmentier
group is a reserved word, use groups as table name -Original Message- From: Alex Pukinskis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 11:39 PM To: [EMAIL PROTECTED] Subject: queries on particular table produce errors Whenever I try to do anything with a specific

Re: select statement group by unusual results

2001-12-05 Thread chip . wiegand
DL Neil [EMAIL PROTECTED] on 12/05/2001 11:35:46 PM Internet mail from: Please respond to DL Neil [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: Re: select statement group by unusual results Chip, I have a database with 12 tables. I am running a query to

Re: optimize for SELECTs on multiple large tables

2001-12-05 Thread Robert Alexander
At 14:45 -0800 2001/12/05, Florin Andrei wrote: The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let it run over night, in the morning i still didn't got any results, so i killed the query). Hi Florin, It would help if you could also provide: the hardware and OS the

Re: queries on particular table produce errors

2001-12-05 Thread Robert Alexander
At 15:55 -0700 2001/12/05, Alex Pukinskis wrote: group is a reserved word, use groups as table name That being the case, how do I drop or rename a table called group? Try: ALTER TABLE 'group' RENAME new_table_name HTH, /Rob ~ Robert Alexander, Alpha

Turn off autocommit

2001-12-05 Thread Demirchyan Oganes-AOD098
Hi everyone, I'm using InnoDB tables, and I would like to turn the auto commit off. I do SET AUTOCOMMIT=0 in my.ini file. And when I restart the server, it won't start. Does anyone know why? Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900

Re: Trouble with InnoDB: Error message file errmsg.sys doesn't have enough messages?

2001-12-05 Thread Sergei Golubchik
Hi! On Dec 05, JW wrote: Using mysql-3.23.33-4 on SuSE Linux 7.1: root@fluorite:/usr/sbin uname -a Linux fluorite 2.4.0-64GB-SMP #1 SMP Wed Jan 24 15:52:30 GMT 2001 i686 unknown We've been using MySQL for a while and we're trying to test InnoDB. According the InnoDB page all we need to

Re: queries on particular table produce errors

2001-12-05 Thread Alex Pukinskis
On Wednesday, December 5, 2001, at 04:08 PM, Robert Alexander wrote: At 15:55 -0700 2001/12/05, Alex Pukinskis wrote: group is a reserved word, use groups as table name That being the case, how do I drop or rename a table called group? Try: ALTER TABLE 'group' RENAME new_table_name No

Re: [SLE] Trouble with InnoDB: Error message file errmsg.sys doesn't have enough messages?

2001-12-05 Thread JW
Well, I got around the problem by replacing the old mysql/english directory with a new one from the tarball. I hope that was an o.k. thing to do. At 04:35 PM 12/5/2001 -0600, you wrote: Using mysql-3.23.33-4 on SuSE Linux 7.1: root@fluorite:/usr/sbin uname -a Linux fluorite 2.4.0-64GB-SMP #1

Re: Trouble with InnoDB: Error message file errmsg.sys doesn't have enough messages?

2001-12-05 Thread Carl Troein
I don't think it's a version problem because the R PM was mysql-3.23.33-4 and the tarball is mysql-max -3.23.46-pc-linux-gnu-i686.tar.gz. 33 != 46 I'd be surprised if that's not the reason for the problems you're having, especially considering how much has changed since 3.22. //C - points to

Re: optimize for SELECTs on multiple large tables

2001-12-05 Thread Florin Andrei
On Wed, 2001-12-05 at 15:01, Robert Alexander wrote: At 14:45 -0800 2001/12/05, Florin Andrei wrote: The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let it run over night, in the morning i still didn't got any results, so i killed the query). the hardware and OS SGI

InnoDB: How to increase table/DB size after the fact?

2001-12-05 Thread JW
Hello, To use InnoDB you have to put how large of a file MySQL is allowed to make by putting an entry in /etc/my.cnf such as the one I used: innodb_data_home_dir = /var/lib/mysql/innodb innodb_data_file_path = indb1:200M;indb2:200M that of course gives us 400M total. I have not yet found in

Re: optimize for SELECTs on multiple large tables

2001-12-05 Thread Carl Troein
Florin Andrei writes: SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \ tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123'; The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let it run over night, in the morning i still didn't got any results, so i killed the query).

Re: select statement group by unusual results

2001-12-05 Thread DL Neil
Chip, I have a database with 12 tables. I am running a query to select certain fields from 3 of the tables, like this - select Title, Details, StartDate, City, State from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations where phpCalendar_Details.EventLocationID =

Re: queries on particular table produce errors

2001-12-05 Thread Carl Troein
Alex Pukinskis writes: mysql ALTER TABLE 'group' RENAME groups; ERROR 1064: You have an error in your SQL syntax near ''group' RENAME groups' at line 1 It should be ` (backtick) rather than ' (apostrophe/single quote). This is explained i the manual section on table/column names if I'm not

Re: optimize for SELECTs on multiple large tables

2001-12-05 Thread Arjen G. Lentz
Hi Florian, - Original Message - From: Florin Andrei [EMAIL PROTECTED] I have this SQL query: SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \ tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123'; (well, maybe there are more than two columns selected, and maybe a little more than two

[solved] Re: InnoDB: How to increase table/DB size after the fact?

2001-12-05 Thread JW
Ah, I finally found mention of this in the manual. Sorry to bother everyone. Thanks. --- Hello, To use InnoDB you have to put how large of a file MySQL is allowed to make by putting an entry in /etc/my.cnf such as the one I used: innodb_data_home_dir =

RE: queries on particular table produce errors

2001-12-05 Thread Jon Gardiner
I can't speak for other table formats but in MyIsam tables you can take your database down, rename the table's files (.frm .MYI .MYD), and restart the server. I'd make a backup if you are going to try it, though. Jon Gardiner. -Original Message- From: Alex Pukinskis [mailto:[EMAIL

Re: Error 1045 - Access denied

2001-12-05 Thread Tyler Longren
Hello, I created the entries by adding them manually to the table (not using GRANT). And yes, I did run FLUSH PRIVILEGES. Anything else I should try doing? The MySQL manual didn't really provide much help. Thanks! Tyler - Original Message - From: Carsten H. Pedersen [EMAIL

Slow results with SELECT's that return large numbers of results

2001-12-05 Thread Chris Withers
Hi, If I have a SELECT that returns a large number of results, say 1000, then returns the results for the SELECT takes much over an order of magnitude longer than if the results set had been, say, 100. Now, is there any way I can quickly return the length of the result set withotu actually

Re: unicode charset support ? (and MacRoman too )

2001-12-05 Thread Kundan Kumar
Hi all, I have written to this mailing lists twice before, but nobody seems responds. Please help, this charset problem is very disturbing. In my case I need to import text files with MacRoman encoding into mysql. I am working on Mac OS X. How do we get support for this encoding? Regards,

Re: optimize for SELECTs on multiple large tables

2001-12-05 Thread Arjen G. Lentz
Hi again Florin, - Original Message - From: Florin Andrei [EMAIL PROTECTED] SELECT event.cid, iphdr.ip_src, iphdr.ip_dst, tcphdr.tcp_dport FROM event, iphdr, tcphdr WHERE event.cid = iphdr.cid AND event.cid = tcphdr.cid AND tcphdr.tcp_flags = '2'; Your only search condition is

RE: need help

2001-12-05 Thread David Niu
Hi,All: I need your help, When I compile the Msql-Mysql-Modules, I got errors, I am running Redhat7.1 with perl5.6.1, the whole process is just as follows: [root@wappy local]# cd Msql-Mysql-modules-1.2218 [root@wappy

(Please Help!!!!) Loading data file with MacRoman CharacterEncoding

2001-12-05 Thread Kundan Kumar
Hi, Thanks for your clue. Please provide me with additional details as to how should I go about doing this (making Mysql use MacRoman encoding). 1)About compiling a particular character set with mysql, the manual says: MYSQL MANUAL: shell ./configure --with-charset=CHARSET CHARSET may be one

Re: Slow results with SELECT's that return large numbers of results

2001-12-05 Thread neeraj arora
Hi, I think indexing the column(s) can help you. But there are certain criteria before you use indexs (like number of duplicate values in the column ..blah blah..) u can find more on this page http://www.linux-mag.com/cgi-bin/printer.pl?issue=2001-06article=mysql i hope this will help you.

mysqlbinlog hangs

2001-12-05 Thread Wendell Dingus
Version 3.23.46-max on a dual Xeon RedHat 7.2 machine with all RedHat patches and their latest -smp kernel. I turned on binary logging on a particular database with binlog-do-db= and later try this: mysqlbinlog -uroot -pxxxyyy binlogfilename-bin.001 It shows me the inserts and deletes that

FW: compile errors

2001-12-05 Thread Gill, Vern
HELP!! Can someone PLEASE help me with this issue? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 12:47 AM To: '[EMAIL PROTECTED]' Subject: FW: compile errors Anyone able to help with this?

does mysql.sock come with a linux 323 installation

2001-12-05 Thread David Phoon
I'd like to know if mysql.sock comes with a linux installation as I have follwed the instructions to install linux but it always says ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) . but mysql.sock does not seem to be anywhere on my linux machine

C API hangs on full disk

2001-12-05 Thread Richard J. Sexton
mysql_query (connection, qbuf); seems to hang if the disk is full. Surely this isn't right. The command line utility reports disk full but my poor C program hangs never to return from this call. What's up with that? (FreeBSD/Whatever version of MySQL was current this summer) -- With

FOLLOW UP on column names not liked by odbc/php/access

2001-12-05 Thread mweb
Hello, On the same database, this query works: $SQL_Exec_String = INSERT INTO Multimedia (Titolo,Descrizione,Logo,Link) VALUES ('prova titolo','prova descrizione','.gif','prova link');; $cur= odbc_exec( $cnx, $SQL_Exec_String ); This one gives this error: ISQL_exec_String = Insert Into

Re: [PHP] FOLLOW UP on column names not liked by odbc/php/access

2001-12-05 Thread George Pitcher
Just a thought. 'Label' might be a reserved name on win as it is/was used to describe the name of a volume (drive). But then again, maybe not. George - Original Message - From: mweb [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, December 05, 2001 10:45 AM

Partial answer to FOLLOW UP on column names not liked by odbc/php/access

2001-12-05 Thread mweb
OOPS... of couse the query below doesn't work, it doesn't have the table name (see below however) ISQL_exec_String = Insert Into (Artista, Opera, Label, Anno, Nazione, CDNow, Autore, AutoreNome, Genere, GenereCustom, SulWeb, Autorizzato, Unico, VALUES ('prova2', 'inedita', 'ignota',

  1   2   >