Problem with the autoincrement

I have a problem with the autoincrement. I have a table with a lot of registers, and the table have a field with auto_increment, but know this field don`t make the increment and always return to us the same number, one more big that the number that the autoincrement have to return. I have pass the

MySQL Service could not be started

I have tried to install MySql in a Windows NT Workstation, but in the end of installation occurs an error, that follows: -- DlgcacWinName:_INS5176._MP - Application Error The instruction at "0x" refe

mysqladmin reload not rebuilding GRANT information

>Description: We found that, if you alter the permission tables (user) & /etc/hosts (so that it can do IP-address-to-hostname mapping for the hosts named in "user") & say "mysqladmin reload", mysql doesn't pick up the changes - you have to shut it down totally & restart it. I think this is new be

Re: MySQL Service could not be started

Francisco: Sounds like you have a corrupted file ... perhaps something happed while you were downloading or unzipping. I would download the Windows binary again, unzip it and re-install. Before you try to start the service, make sure either c:\my.cnf or c:\winnt\my.ini are in place ... you need

Re: 64bit mysql and gcc

Ian writes: > I would be more than happy to. Could you point me in the direction > of the binaries? The ones that I have found have been 32bit DBs. > > IW. > > > What makes you think that our Solaris 2.8 binaries are 32bit ?? -- Regards, __ ___ ___ __ / |/ /_ __/ _

RE: MySQL Service could not be started

Hi, I had the similary same problem whit MySQL deinstallation. In fact in some case it seems that MySQL cannot desinstall as good as well. So you have to force it or to re-install your system in case of no solution. You will see in "add/delete programs" that even if you've just desinstall it it's

Re: IRIX 6.5.4f thread problem

[EMAIL PROTECTED] writes: > >Description: > After installing mysql-3.23.46-sgi-irix6.5-mips (precompiled binaries), and >getting the safe-mysql to start the daemon successfully, I can't connect to the >server. Every command I try to execute dies with the following message: > > ./mysqladm

reliability on the server

Hallo, i would like to know if there is a reliability mechanism inside mysql. I have a server on a machine and several clients that access to the server My problem is to find a way to assure that if the Data base machine go down, i assure however the services to the clients. thanks in advance Or

Connecting to mysql server in a remote site and using LOAD command

Dear All, I have Mysql server installed at remote site which i need to connect to. I have tried this from my local computer but didn't work; c:\mysql\bin>mysql -h myhost -u myusername -pmypassword I will also like to use LOAD command to load a text file from my local computer to the database o

auto increment

Hi there I have an auto increment table that starts with number 1,2,3, and so on...but now it had reach 500 then for the 501 i like to have a new format numer let say A1 (for 501) how can i do this ?? with out change the used number before (1,2.) thanks in advance --

Some questions to the pre-sale technical support of MySQL

Hi, we already use Databases in our full distributed environment, but we are looking for alternatives, especially for an SQL Database system with a fail-save synchronous master - slave replication architecture. I searched on the internet pages of www.mysql.com, but could not decide the funct

Re: mySQL++ store() return value

Mike Gleason Jr Couturier writes: > Hello all ! > > I'm creating a program that let the user do any > query (select, update, insert) on a connection... > But I think that when we store() the query, the > function returns different values based on the type > of query (insert, select..). How can I

Re: porting mysql to ibm os/390 open edition

Peschko, Edward writes: > hey, > > I was wondering if you had any plans to port mysql to os-390, and the open > edition environment there. I think it would be > a really cool idea, considering that most shops that have a IBM mainframe > are looking for ways to leverage it in the unix world witho

Using sequence_number as field name

>Description: using the field name sequence_number in two tables and doing a join on sequence_number gives NULL as an output in the sequence_number field of one of the tables. >How-To-Repeat: mysql> select users.sequence_number,jba_customers.sequence_number from users,jba_customers mys

Persistent Download Errors

Hi there, I have tried to download mySQL 3.23.45 for Windows from several different mirror sites, using MSIE6 and Netscape Navigator 4. The downloaded .zip file is always around 5.5 MB, not the required 11MB. When I try to unzip it with WinZip I get the "not a valid archive" error message. Can y

THANKS for: Failing to connect to MySQL via unixODBC/PHP

Thanks to all who helped with this problem. As it turns out, it was much stupider than one could suppose, just yet another demonstration that nobody should code more than a very few hours in a row... The odbc_connect statement is nested in the whole PHP code in such a way (thanks to include, requ

Re: start MySQL on RedHat problem

$mysqladmin [-u root] password [yr-pass] or not, uninstall (rpm -e) it and install again :) Trong Phuc At 12:40 PM 12/4/01 +0800, Tri Tran wrote: >I never run mySQL on this Linux box before and now it keep saying that > >error: 'Access denied for user: 'root@localhost' (Using password: YES)' > >w

RE: Multilingual support in MYSQL

Hi, > > We have been initiating a project which requires development of multilingual > database. > > I need information on multilingual support of MySQL. Initial requirement is > of Hindi (India) Language. > > Waiting for an early an dfavourable reply. > > Warm Regards > > Hemant K Agrawal

Re: Connecting to mysql server in a remote site and using LOAD command

Make sure you have permissions to connect to the remote site from your current server or host. Permissions need to be set for that user to connect from your server host - Original Message - From: "Hamzat Kamal" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 03, 2001 8:2

RE: SHOW TABLES; show nothing

These areI thinkpre-built Dunno for sure. # rpm -qa | grep -i glibc compat-glibc-6.2-2.1.3.2 glibc-devel-2.2-5 glibc-common-2.2.4-13 glibc-2.2.4-13 # mysql --version mysql Ver 11.6 Distrib 3.23.28-gamma, for pc-linux-gnu (i586) # rpm -qa | grep -i gcc gcc-2.96-69 kgcc-1.1.2-40 Although

Re: Granting Access in MySQL

Demirchyan Oganes-AOD098 writes: > Hello everyone, > > I'm trying to grant rights to several user accessing my database. > Right now I'm using their individual IP addresses to grant them privileges. Which >works fine. > This way I have to assign user name and password to each and everyone of th

Optimizing date queries

Hey Does anyone have some optimization tips for this query: SELECT count(id) FROM tblTabel WHERE fieldName != '' AND DATE_FORMAT(myDateField,'%Y%m%d') = 20011120; It does not use the index i have created, so it scans the entire table, which is a bit to slow. The problem off course is, that MyS

Re: SHOW TABLES; show nothing

Hi. On Mon, Dec 03, 2001 at 08:20:44PM -0800, [EMAIL PROTECTED] wrote: > Well, according to several subsequent messages, including > http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:67549:ololjemolklapaobokil; > > that does NOT appear to be the problem, as it also happens on other distros, > with o

RE: 64bit mysql and gcc

> -Original Message- > From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] > Sent: 04 December 2001 12:47 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: 64bit mysql and gcc > > > PFIZER GLOBAL RESEARCH AND DEVELOPMENT > --

RE: auto increment

You can't, except programmatically. That is, -Original Message- From: Yamin Prabudy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 3:04 PM To: [EMAIL PROTECTED] Subject: auto increment Hi there I have an auto increment table that starts with number 1,2,3, and so on...

MySQL access denied from localhost

I know this is a probably a FAQ, and have read http://www.mysql.com/doc/A/c/Access_denied.html, but everything looks OK to me. If I look at the mysql db from the monitor I get all the privileges OK for user "testuser" (see below, and still (from PHP UnixOdbc on Apache) get thist message when I

Re: Optimizing date queries

On Tuesday 04 Dec 2001 13:49, Emil Rasmussen wrote: > Hey > > Does anyone have some optimization tips for this query: > > SELECT count(id) FROM tblTabel WHERE fieldName != '' AND > DATE_FORMAT(myDateField,'%Y%m%d') = 20011120; > > It does not use the index i have created, so it scans the entire ta

access denied for user:

(Debian Linux 2.2) trying (logged in as the owner of the database): mysql guestbook.sql (database is palced in my home directory) I get: access denied for user: '@localhost' to database 'guestbook.sql' What is going wrong? --

Re: mysqladmin reload not rebuilding GRANT information

[EMAIL PROTECTED] writes: > >Description: > We found that, if you alter the permission tables (user) & /etc/hosts > (so that it can do IP-address-to-hostname mapping for the hosts named in > "user") & say "mysqladmin reload", mysql doesn't pick up the changes - > you have to shut it down totally &

Re: Some questions to the pre-sale technical support of MySQL

Hofhauser, Bela writes: > Hi, > > we already use Databases in our full distributed environment, but we are looking for >alternatives, especially for an SQL Database system with a fail-save synchronous >master - slave replication architecture. > I searched on the internet pages of www.mysql.co

Very large table load/index questions

I'm trying to understand the most efficient load sequence possible. I've got 2 large tables. Each is about 50 million rows, taking about 20GB of disk space. My disk is accessed via fibre channel, and can read/write about 40 MB per second. My system is a dual PIII 850, running Linux 2.4.2-2smp

Re: Problem making myodbc on Solaris 8

The same error occurs with 2.50.39. Has anyone successfully made MyODBC on Solaris8 using gcc 2.95?? Matt Dougherty Venu wrote: > Hi, > > > -Original Message- > > From: Matthew Dougherty [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 03, 2001 11:06 AM > > To: [EMAIL PROTECTED] >

RE: Load data infile

remove your line termination and it will not look for this non-existing data and run through the whole file. john -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 10:11 PM To: [EMAIL PROTECTED] Subject: Load data infile Be struggling

Re: Load data infile

Thanks john, After some further checking, the files that I was trying to load back into the db where sent to me from a MAC, and had some strange C/R's in it, causing the file be formatted improperly! After fixing that, all the files loaded into the db fine! :) thx's >>On Tue, 4 Dec 2001 08:45:

Re: mysqladmin reload not rebuilding GRANT information

Sinisa Milivojevic writes: > > We found that, if you alter the permission tables (user) & /etc/hosts > > (so that it can do IP-address-to-hostname mapping for the hosts named in > > "user") & say "mysqladmin reload", mysql doesn't pick up the changes - > > you have to shut it down totally & rest

Re: Optimizing date queries

> SELECT count(id) > FROM tblTabel > WHERE fieldName != '' AND > ( > myDateField >= 2001112000 AND > myDateField < 2001113000 > ); Thank you, that was defiantly part of the solution! I had created an index on both fieldName og myDateField, but MySQL did not use that. But creating an ind

killed by SIGSEGV

Hello list, I've got a problem with mysql being killed by signal 11 (segmentation violation). It gets killed on average every 4 days, and on that day it will on averate get killed 4 times. Sometimes it will be as many as 8 times, sometimes only once (see below for log). I've read 'Debugging a My

unable to assign desired memory

Hi, I have a box with 1gig ram which i am using as my mysql server. however when i try to assig about 600megs to the innodb buffer pool it reports that, InnoDB: Fatal error: cannot allocate 524304384 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 211

Re: mysqladmin reload not rebuilding GRANT information

Carl Troein writes: > > > Does this mean that mysqld keeps its own cache of hostnames, > and that it never checks to see if it has gone stale? If so, > one might have to shut down and restart the server at regular > intervals (once an hour or whatever) if one relies on host > names (maybe not a

Re: Hacked Servers

mysql at hotchilli.co.uk wrote: >We have 2 Redhat 6.1 servers and MySQL 3.22.32 and both boxes >appear to have been hacked on Friday last and MYSQL client just hangs >when connecting to the localhost MYSQL server. >MySQL is running on both boxes and suffer the same problems. >We have Intrusion s

unicode & mysql?

Hi! I want to keep unicode text strings as data in a SQL database and I search for a proper free DBMS. Of course unicode data can be stored as binary data but in a char, varchar column? I need to insert, get unicode strings into/from databases not modified/altered by locale configs. I need to cr

Re: killed by SIGSEGV

On Tuesday 04 December 2001 07:57 am, matt wrote: > I've got a problem with mysql being killed by signal 11 (segmentation > violation). It gets killed on average every 4 days, and on that day it > will on averate get killed 4 times. Sometimes it will be as many as 8 > times, sometimes only once (s

Re: Very large table load/index questions

Hi! On Dec 04, Barry Roomberg wrote: > I'm trying to understand the most efficient load sequence > possible. > > I've got 2 large tables. Each is about 50 million rows, > taking about 20GB of disk space. > > My system is a dual PIII 850, running Linux 2.4.2-2smp #1 SMP. > Memory: 1GB. > > The

Re: killed by SIGSEGV

Matt it would help to know: Your platform: Linux? What version? your kernel? Which MySQL version? Did you compile it your self? Using what options? What is your my.cnf? Are you running low on resources? Many time a signal 11 indicates a Harware/memory problem are you running ECC memory? You

Probably something very simple...

Greetings! I am having a real silly problem - probably something simple I've forgotten. I have been running mysql 3.23.39a on both Windows and Solaris for 5 months now, no problems. I just upgraded the windows machine to mysql 4alpha, and had a problem with passwords. I have one key user datab

Re: compile problems on Solaris8

Michael Widenius wrote: > > Hi! > > > "Michael" == Michael Stassen <[EMAIL PROTECTED]> writes: > > > > Michael> * everyone who has reported this was using the precompiled binary of gcc > Michael> (either 2.95.2 or 2.95.3) from Sunfreeware to build MySQL for Solaris 8 > Michael> spar

conditional delete query

Hi All, I'm having trouble forming a delete query that removes rows from a table based on a condition that requires joining 3 tables (including the table to delete from). The SELECT query that identifies the rows to delete is: SELECT folder_items.folder_id, folder_items.item_id FROM folders, fo

Fixed MYSQL password problem!

I fixed the problem I just posted with MySql new installs "not seeing" my passwords. I had simply forgotten to flush the permissions after I set the password. "mysqladmin -u root flush-privileges" Cheers, -Richard - Before

Re: killed by SIGSEGV

On Tue, 4 Dec 2001, Ken Menzel wrote: > Your platform: Linux? What version? your kernel? Sorry, I should have included this information in my first post. The hardware is a Dell 2550 poweredge with a 1GHz Intel 3, 500MB ECC RAM, 2 SCSI disks in RAID and some intel NICS. The OS is GNU/Linux 2.

Re: Very large table load/index questions

Hi Barry, It is, indeed, faster to load the data then create the indexes. Instead of 'disable' and 'enable', you could try: - ALTER TABLE DROP index (or drop the table and create it without indexes.) - load your data - ALTER TABLE ADD index HTH, /Rob At 09:40 -0500 2001/12/04, Barry Roomberg

Select with Left Joins

Perhaps this is obvious, but I have a SELECT (with many LEFT JOINs) that I would expect to return results, but it does not. If I make one change in the order in which tables are used, the SELECT works: The SQL that doesn't work is: --- SELECT T1.patentNumber, T1

Re: Very large table load/index questions

I've always thought it would be great if there was a way to drop an object but keep the meta data so I can recreate objects without having to store the ddl somewhere. alter table drop index retain metadata Would be helpful. Dave On Tue, Dec 04, 2001 at 11:19:43AM -0500, Robert Alexander wrote

Problem with GROUP BY ... DESC

Hello: I'm new to the list and have a question. I upgraded from version 3.22 to this version: Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686) The problem that has cropped up I have is that in all GROUP BY column DESC statements, the DESC is now not being recognized, and the query is being

Re: compile problems on Solaris8

I hate to show my ignorance but I am unfamiliar with "SFW version of gcc that comes with Solaris 2.8". Could you clue me in? By the way, it is correct that I am using gcc 2.95.3 from the sunfreeware binary distribution. It's been a pain for several applications. (OpenSSH, etc). Matt. George

Re: porting mysql to ibm os/390 open edition

Joshua J. Kugler writes: > Not being familar with OS/390, could you explain (briefly) the difficulty? > > j- k- > > -- > Joshua Kugler, Information Services Director > Associated Students of the University of Alaska Fairbanks > [EMAIL PROTECTED], 907-474-7601 > POSIX compliancy on so

Re: Very large table load/index questions

Hi! On Dec 04, David Turner wrote: > I've always thought it would be great if there was a way to drop an object but > keep the meta data so I can recreate objects without having to store the ddl > somewhere. > > alter table drop index retain metadata > > Would be helpful. That's what ALTER T

Size of table's MYD file?

Why is it that when I delete records from a table in the database, the size of the table's MYD file does not get smaller. It's still the original size. Do I have to flush the table to get the accurate size? Thanks Nissim Lugasy 216-433-2708 [EMAIL PROTECTED] ---

Re: Very large table load/index questions

Thanks, but I'm looking at having this for all objects drop table mytable retain metadata; etc Dave On Tue, Dec 04, 2001 at 06:52:17PM +0100, Sergei Golubchik wrote: > Hi! > > On Dec 04, David Turner wrote: > > I've always thought it would be great if there was a way to drop an object but > >

RE: Size of table's MYD file?

Shrinking the database immediately would be too slow for most purposes. When you delete a record the database flags it as ready to be recycled. Inserts will always try to recycle a deleted slot where possible. If you delete a really big block of records and want to reclaim the disk space you can

Re: mysqladmin reload not rebuilding GRANT information

Sinisa Milivojevic writes: > Yes, that is so. > > But you do not have to restart MySQL. Just run: > > FLUSH HOSTS D'oh. I should've read the manual before posting. Sorry. To those who hasn't seen it already, I wish to point out that section 5.5.5 has some useful information about MySQL's host

Re: Size of table's MYD file?

On Tue, 04 Dec 2001 12:53:33 -0500, Nissim Lugasy <[EMAIL PROTECTED]> wrote: >>Why is it that when I delete records from a table in the database, the size >>of the table's MYD file does not get smaller. It's still the original size. >>Do I have to flush the table to get the accurate size? run

Re: Size of table's MYD file?

Nissim Lugasy writes: > Why is it that when I delete records from a table in the database, the size > of the table's MYD file does not get smaller. It's still the original size. > Do I have to flush the table to get the accurate size? OPTIMIZE TABLE is what you want. But doing it after each a

Re: Optimizing date queries

On Tuesday 04 Dec 2001 14:58, Emil Rasmussen wrote: > > SELECT count(id) > > FROM tblTabel > > WHERE fieldName != '' AND > > ( > > myDateField >= 2001112000 AND > > myDateField < 2001113000 > > ); > > Thank you, that was defiantly part of the solution! > > I had created an index on both fi

Re: more than one possible column value

hum I have an hard time understanding, but if I'm right: CREATE TABLE files( fileID smallint unsigned auto_increment, filename varchar(36) not null, primary key (fileID) ) CREATE TABLE types( typeID smallint unsigned auto_increment, typename varchar(36) not null, typeext char(4) not null unique,

Re: Very large table load/index questions

Hi! First: please reply to mysql-list and not directly to me. Then: On Dec 04, Barry Roomberg wrote: > > Hi! > Hi back. > > > Why do you need RAID ? Are you using ext2fs ? > > With 2.4.2 you can use reiserfs, which does not have 2GB file limit. > > Using ext2fs right now. Heard a lot of reise

Re: Optimizing date queries

> > Does anyone have some optimization tips for this query: > > > > SELECT count(id) FROM tblTabel WHERE fieldName != '' AND > > DATE_FORMAT(myDateField,'%Y%m%d') = 20011120; > > > > It does not use the index i have created, so it scans the entire table, > > which is a bit to slow. > > > > The pro

Re: more than one possible column value

I understand now. There needs to be a table in between "files" and "types". This allows me to assign two different rows in the "types" table (say, JPG and JPEG) to the same row in the "files" table, or two different rows in the "files" table to the same row in the "types" table. This seems l

BDB table handler crashing during select

>Description: I started using BDB tables in a php program with mysql-3.23.36 that comes with redhat7.1. The php program uses a database of 3 myISAM tables to read the schema of the BDB tables and dynamicaly generate select/update/insert queries on the BDB tables. The BDB tables form another da

Re: porting mysql to ibm os/390 open edition

On Tue, Dec 04, 2001 at 03:08:11PM +0200, Sinisa Milivojevic wrote: > Peschko, Edward writes: > > hey, > > > > I was wondering if you had any plans to port mysql to os-390, and the open > > edition environment there. I think it would be > > a really cool idea, considering that most shops that ha

Coredump when running scripts/mysql_install_db

Hello, I was trying a normal installation on a HP UX 10.20 based HP 9000/712. The log looks like this: ___ Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepa

Re: killed by SIGSEGV

On Tue, Dec 04, 2001 at 04:40:23PM +, matt wrote: > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc > GCC: Reading specs from > /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.2/specs > gcc version 2.95.2 19991024 (release) > Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS

Re: killed by SIGSEGV

Hi Matt, Thanks for the detailed response regrading the SIGSEGV. I am stumped, the compiler and hardware sound fine. The defaults on MySQL are very stingy (A good thing).I think this is time for a linux expert, (I run FreeBSD). My first suggestion would be to come up to a much more curr

Re: more than one possible column value

On Tuesday, December 4, 2001, at 01:23 PM, Etienne Marcotte wrote: > CREATE TABLE filetypes ( > fileID smallint unsigned not null, > typeID smallint unsigned not null, > unique index (fileID,typeID), > unique index (typeID,fileID) > ) One question, though. Do I have to construct indexes in bot

Re: more than one possible column value

well I index both because it enables to pull data without even reading on the table.It reads only in the B-Tree index since it's both numeric. There is a section on mySQl optimization in the mySQL guide on the webpage. If you want to find all files that have this or that extension, mySQL will u

MyODBC and Accents

I'm programmer of ASP, I'm initiating the use of the data base MySQL with ASP, but I noticed that driver MyOBDC 2.50.39 it correctly does not return the accents from the words. Somebody can help me? Thanks! Marcelo Busana --- WebDeveloper UNIDAVI --

Access Denied Errors

Hi.. I'm using mySQL with Avantgo For a while we kept getting an access denied error: access denied for user '@' to database '' The avantgo support person told me how to go into the mysql database and we looked at the users table and saw that there was a password for 'root'. We had been u

RE: MyODBC and Accents

Hi, > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 04, 2001 12:05 PM > To: [EMAIL PROTECTED] > Subject: MyODBC and Accents > > > I'm programmer of ASP, I'm initiating the use of the data base MySQL > with ASP, > but I noticed that d

RE: Select with Left Joins

This is operating as it should. The order of the left joins sets the precedence of the selection. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 10:55 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Select with Left Joins Per

odbc driver

hello i need help i have a database in mysql. i use an outside program that connect to the databas through odbc (dsn) and make graphs. the program worked very good for months but at the last week something disrupted. when i tried to make graph from one specific table, i receive an error message.

maximum keyfile length significantly less than 8TB?

The mysql manual claims that MyISAM is essentially limited only by the filesystem for how large tables can be. Yesterday, inserts to one of my tables began failing with error 136 (keyfile full) although the file is only around 17 gigabytes. There appears to be some undocumented limitation that f

mailing list

Hi folks, I was wondering if anyone has given any thought to doing a questions@ list and possibly a PR system much like the freebsd project does? So as to lessen the amount of redundant information on this list? ps sql, select, database

RE: odbc driver

Hi, > -Original Message- > From: avital raz [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 04, 2001 12:56 PM > To: [EMAIL PROTECTED] > Subject: odbc driver > > > hello > i need help > i have a database in mysql. > i use an outside program that connect to the databas through odbc

Re: Coredump when running scripts/mysql_install_db

A couple of others have reported this in the last month. I reported what I believe to be the same problem on Mon, 29 Oct 2001 with mysql 3.23.43 built from source with gcc 2.95.3 according to the instructions in the manual. I believe the problem is that enabling largefile support, as is done in

Upgraded server, MySql Crashes with old databases

Need MySql 3.21 for Win2000 I have some old databases from MySql 3.21 and I want to move these to MySql 3.23, but the server just crashes. I've tried to start the MySql with --old-protocol, but no changes. My plan is to install MySql 3.21 on my PC to get the databases, but there is no download

[OT] Re: compile problems on Solaris8

On Tue, 4 Dec 2001, George Horvath wrote: > Michael Widenius wrote: > > > > Hi! > > > > > "Michael" == Michael Stassen <[EMAIL PROTECTED]> writes: > > > > > > > > Michael> * everyone who has reported this was using the precompiled binary of gcc > > Michael> (either 2.95.2 or 2.95.3

Problem with ASP + mySQL

Dear all, I am having the following problem with ASP + mySQL Actually, when executing the following Query: SELECT Min(Col1), Col2 FROM Table1 GROUP BY Col2 I get an empty recordSet, while executing the following query doesn't return an empty recordSet: SELECT Col1,Col FROM Table1 GROUP BY Col1

Re: Problem making myodbc on Solaris 8

Can anyone make a suggestion of what the following lines are trying to do in Makefile in the first place? DEPS_MAGIC := $(shell mkdir .deps > /dev/null 2>&1 ||:) -include $(DEP_FILES) This does not appear to me to be appropriate syntax and it's probably independent of the compiler or make progra

[OT] Re: compile problems on Solaris8

Matt, According to Sun , gcc 2.95.3 is included on the "Solaris Software Companion CD" which is part of Solaris 8, Update 07/01. There are links there to download the entire CD or individual packages from it. I have not tried it, but I assume t

Re: BDB table handler crashing during select

On Tuesday 04 December 2001 12:00 pm, [EMAIL PROTECTED] wrote: > The concept of a transaction is important to my app because the number of > queries and the number of tables > to be modified during a particular transaction is not easy to calculate. It is > obtained from the result of > the que

Re: Problem with GROUP BY ... DESC

On Tue, 4 Dec 2001, AJ wrote: > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686) > > The problem that has cropped up I have is that in all GROUP BY column DESC > statements, the DESC is now not being recognized, and the query is being > returned in ascending order. If I use ORDER BY... DESC th

Keeping track of database changes

We've got a fairly critical database system that we're setting up and we need to know if there's an easy way to track changes made to the database (hopefully at a fairly low level). In essence, what we want, is a log of what fields and values are changed by the primary key on each table, includin

Fwd: Re: Problem with GROUP BY ... DESC

> > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686) > > > > The problem that has cropped up I have is that in all GROUP BY column DESC > > statements, the DESC is now not being recognized, and the query is being > > returned in ascending order. If I use ORDER BY... DESC that works fine. > >I'

innodb vs myisam optimizations

I'm converting a table to innodb from myisam in mysql 4.0 and I was wondering why it takes sooo long to do a SELECT COUNT(*) In the old MyISAM table, it's quick: mysql> select count(*) from forecast; +---+ | count(*) | +---+ | 194698187 | +---+ 1 row in set (0.00 sec) In

Re: 64bit mysql and gcc

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 SPARC Version 1,

Can a function be called as a default?

3.23.43 It would be handy to be able to call a mysql built-in as a column default. The reason this would be handy is that I could then go to my umpteen tables and just add one column and suddenly I could know who is changing each record. Otherwise, I have to go to my umpteen x umpteen inser

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

If I run this query it works: SELECT * FROM products WHERE (MATCH (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('anystring')) But if I run this query it does not: SELECT * FROM products WHERE (MATCH (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('anystring')) ORDER BY 'item_no'

Re: innodb vs myisam optimizations

Hi! On Dec 04, Gurupartap Davis wrote: > I'm converting a table to innodb from myisam in mysql 4.0 and I was > wondering why it takes sooo long to do a SELECT COUNT(*) MyISAM stores total number of rows in MYI file header. It's read into memory when table is opened. So for SELECT COUNT(*) FROM

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

Hi! On Dec 04, Mark J. Degallier wrote: > If I run this query it works: > SELECT * FROM products WHERE (MATCH > (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('anystring')) > > But if I run this query it does not: > SELECT * FROM products WHERE (MATCH > (title,short_desc,long_desc,spec_

Re: Problem with ASP + mySQL

I think the query should be as below SELECT Min(Col1) as Col1, Col2 FROM Table1 GROUP BY Col2 then somewhere in your page, response.write(rs("Col1")) Thanks ST Ooi Malaysia - Original Message - From: "Jimmy44 --" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 0

Settings

What information would you need to recommend the initial settings for a MySQL server. We are about to deploy a new server and move our website over to the server and I would like to have a somewhat optimized configuration from the start. Let me know what you need, and I'll provide it. Thanks,

  1   2   >