Re: BSDI 4.2 and Mysql

Ok, thanks Carlos M. Gutierrez I got another error as below: mysql\""-DHAVE_CONFIG_H -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c sql_yacc.cc sql_yacc.yy:

Re: help with timestamp...

> At 11:25 PM 12/4/01 -0700, *Himerus* wrote: > >Can anyone give me a good link on how to put in a timestamp on a form > >that inserts directly into a sql database??? I keep trying it, but it's > >only coming thru as 00 , so on. I enter my timestamp as a unix timestamp in an INT field

Re: Mac OSX and MySQL

At 22:24 -0700 2001/12/04, René Fournier wrote: >The migration continues... > >Now I have to get my mysql database running under MySQL 3.23.46 on >OSX 10.1.1. I've dumped the structure and contents of the database >(on Windows) into a text file, and now I'd like to recreate it in >the new enivr

how to import oracle db to mysql

hi there, how to import oracle db to mysql. can somebody help me. regards srinivas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Re: help with timestamp...

Hi, Depends on what type of timestamp you are looking at. But in general, you use the mysql built in function: now() and if you want to convert that into unix_timestamp, unix_timestamp(now()) will do the trick. mysql> select now(); +-+ | now() | +--

help with timestamp...

Can anyone give me a good link on how to put in a timestamp on a form that inserts directly into a sql database??? I keep trying it, but it's only coming thru as 00 , so on. Thanks. Newbie Jake. - Before posting,

BSDI 4.2 and Mysql

Hi, Got the below error messages when i run make command: - OS : BSDI 4.2 - MYSQL : mysql-3.23.46 / mysql-3.23.40 - Machine : intel base. Anybody can help us. gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include -I..-O3 -DDBUG_OFF -D__BSD__ -DHAVE_BROKEN_REALPATH -c resolve_stack_

Mac OSX and MySQL

The migration continues... Now I have to get my mysql database running under MySQL 3.23.46 on OSX 10.1.1. I've dumped the structure and contents of the database (on Windows) into a text file, and now I'd like to recreate it in the new enivronment. I think I can use the mysql admin tools via co

Re: Settings

Hi, Take a look at the files: -rw-r--r-- 1 root other 2534 Oct 11 22:40 my-huge.cnf -rw-r--r-- 1 root other 2512 Oct 11 22:40 my-large.cnf -rw-r--r-- 1 root other 2496 Oct 11 22:40 my-medium.cnf -rw-r--r-- 1 root other 2211 Oct 11 22:40 my-small.cn

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

Hi, - Original Message - From: "AJ" <[EMAIL PROTECTED]> > > > 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

Re: Keeping track of database changes

"Philip Molter" <[EMAIL PROTECTED]> wrote: > 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 ar

Using c-isam calls to access MySQL ISAM data files

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 develop a new front end that accesses the data

Re: MySQL access denied from localhost

Hi, - Original Message - From: "mweb" <[EMAIL PROTECTED]> > 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" Lo

databases without passwords

hey, I was wondering if it was possible to have a database that has users - but no passwords. Furthermore, I'd like the default user that starts up with mysql to be the unix/winnt user. (The database that I'm using is not mission critical - its more a 'scratchpad' database than anything else)

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,

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

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: 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

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'

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

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,

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

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'

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

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

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

[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: 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

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

[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

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

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

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

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

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

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.

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

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

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

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 --

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

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: 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: 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

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: 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

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: 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

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: 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: 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: 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: 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: 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: 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?

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: 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 > >

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

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

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: 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

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: 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

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

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

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.

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

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

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

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: 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

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

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

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: 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

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

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

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

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

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: 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: 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: 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] >

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: 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

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: 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? --

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: 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...

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: 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

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: 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

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: 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: 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: 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

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

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

  1   2   >