Re: help on setup

> Hi All, > > First I am brand new to the list. I have looked at all the FAQ and the docs > on mysql.com for this one. > > I have set up mysql before on 2 different machines with no problems so I am > not new at this. > > I am setting up a cluster of servers. 3 web, 1 development and 2 database >

help on setup

Hi All, First I am brand new to the list. I have looked at all the FAQ and the docs on mysql.com for this one. I have set up mysql before on 2 different machines with no problems so I am not new at this. I am setting up a cluster of servers. 3 web, 1 development and 2 database servers. I am i

Re: Version 4 Schedule RE: Roadmap

On Sat, Jan 19, 2002 at 09:51:39AM +0200, Emmanuel van der Meulen wrote: > Hello all, > > On 19 January 2002 09:28, Jeremy Zawodny wrote; > > > > On Sat, Jan 19, 2002 at 09:22:38AM +0200, Emmanuel van der Meulen wrote: > > > Hello all, > > > > > > To both above topics there have been answers, tha

Re: permission to lock tables

On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote: > Hi All, > > I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a > few minutes ago there is a strange problem I've never had in mysql > version 3: > > mysql> lock table .develop.Pseq read; > ERROR 1064: You have

FYI - Kylix2 and MySQL 4.0.1 Max - works

I have this stuff... http://sourceforge.net/projects/directsql I had to make only a very small change in their demok, Char() typecast in one .pas file, globally, and presto... As this is a native .pas type of interface to MySQL I feel comfortable helping fix it no problemo, going forward. F

permission to lock tables

Hi All, I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a few minutes ago there is a strange problem I've never had in mysql version 3: mysql> lock table .develop.Pseq read; ERROR 1064: You have an error in your SQL syntax near '.Pseq read' at line 1 Any idea what's wrong

debian smp

hi, I have a new dual cpu server with debian 2.2.19 smp kernel and with 1G ram. my question is: need i apply the threads-patch or the fork-patch from mysql manual 2.6.1 before i compile my kernel and the mysql source? (i use max 500 connections). cheers, ati -

Off-topic: AOL Red Hat???

A front-page article in this morning's Durham (NC, USA) Herald-Sun reports: "AOL Time Warner Inc. is in talks to buy Red Hat Inc., a prominent distributor of a Linux-based computer operating system, an acquisition that would position the media giant to challenge archrival Microsoft Corp., acco

Re: Help with Database structure..

> We thought about having one massive file for all this data, BUT, we archive > something like 100,000 articles a day. We store articles for 6 months, so > this table would very quickly have 18,000,000 rows. Now, we need to select > a group of articles based on source and date. We also need to

Help with Database structure..

I need some help with a database design question: To summarize our design (I'll spare you a lot of the details.) We collect text files from 20,000 different sources every day. The actual file is stored as a text file. Each source has its own table which contains a list of the text files, dat

Re: error

Look in archive: http://www.geocrawler.com/archives/3/8/2001/6/0/6076299/ - Original Message - From: "Saulius Kavoliunas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 19, 2002 9:14 PM Subject: error > Hello mysql, > > I have a problem with starting mysql, I'm u

Re: Auto-starting mySQL on a Macintosh

There is a link at http://www.entropy.ch/software/macosx/mysql/ for a startup items package. This will cause MySQL to start when you restart the Mac OS X system. On 1/19/2002 3:07 PM, "Antonio Flores Aldama" <[EMAIL PROTECTED]> wrote: > Hello I need help to startup My SQL in my OS X Server 10.

Auto-starting mySQL on a Macintosh

Hello I need help to startup My SQL in my OS X Server 10.1 box.. Some idea of what can I do? Greetings Antonio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

tunneling mysql client connections with ssh

Hy all, i am just trying to tunnel a mysql client connection via ssh. i am behind a firewall that doesn't let mysql connections through to the outer world. But i can do ssh to the host i want connect to. Tunneling http port 80 with the command ssh [EMAIL PROTECTED] -L 8:localhost:80 gives

Re: Column Alias Bug??

Steve, Thanks for this. I took another breeze through but didn't spot it - at least what I had in mind. Somewhere I've seen a short pithy summary/list, giving the sequence. Had a flip through the book too, but failed to spot it. Hence the request. Never mind, I'll spot in again one day, and then

Re: Column Alias Bug??

> Somewhere there's a 'table' or list showing the sequence that the various clauses >are evaluated/executed. Is it > in the manual or in your book Paul? If it's online, it would be useful to know where >so that a link can be added > to answers to such questions... > > Anyone remember where?

Code Contrib: Simple powerful hotcopy

Dear Group: I have been doing a lot of experimenting with a rather huge database, and I need to recover from mistakes when necessary. I need to make live copies. After spending too long trying unsuccessfully to load DBD::mysql and DBI.pm on my machine (for mysqlhotcopy), and and wasting a lot

RE: LOAD DATA INFILE Problem

Sorry, my fault, realised the file I was writing for VB was cocking it up. I was adding chr(13) at the end, but the FileSystemObject write method seemed to be putting the carriage return in too, so MYSQL didn't get the newline character. I changed to use the Print command in VB instead just wri

LOAD DATA INFILE Problem

Stupid problem this one no doubt. I have a find in mysql\bin called words.txt The file contains tab separated values with a newline character at the end: 225 20 Residence 73.563.580 187.5 225 20 Planibel195.5 63.579.5289 When I do LOAD DA

error

Hello mysql, I have a problem with starting mysql, I'm using winXP and when I try to start mysql on administrative tools\services I get a box with an error 1067, nothing else is written :(, what is the problem can you suggest me waht to do. Tkank you, -- Best regards, Saulius

Re: Why does DISTINCT take so long time ??

Anvar had some very good explanations about the time it takes to run the queries. ##Here are some work arounds: ##If you need to have these columns (mot, date, numresponse) in the group by clause, ##try putting an index on each of them to speed it up. mysql>>alter table searchhardwarefr3

Problem Upgrading

Friday, January 18, 2002, 10:36:46 PM, you wrote: Ieoen> I had 3.23.41 installed. It came with Rh7.2. I had some mistakes in initial Ieoen> start up . So I thought i would reinstall it. I downloaded the rpm for Ieoen> 3.23.47. And ran the rpm installation. I am not sure if it did the whole Ieoen>

no umlauts in mysql client

sascha, Friday, January 18, 2002, 12:18:43 PM, you wrote: sm> help! I upgraded to the most recent version of mysql client (3.23.47) under sm> SuSE linux 7.1. sm> now the client does not accept any 8-bit characters any more - any special sm> character input is discarded (from the keyboard and f

Installing of MySQL on redhat 7,2

Nasser, Friday, January 18, 2002, 12:01:02 PM, you wrote: NR> By the way I run my application which should run on MySQL, I get the error NR> message which includes that libmysqlclient.so.6 NR> could not find!!! NR> What I have down wrong? How did you install MySQL? Have you installed the rpm p

console hang.

Larry, Thursday, January 17, 2002, 12:45:49 AM, you wrote: LB> I am running MySQL on Redhat and when I use the script that comes with MySQL LB> (mysql.server) or safe_mysqld the command runs and starts the server. LB> However; the prompt does not return. I have to switch consoles. (bash) LB> D

Re: ID in table

DL, Friday, January 18, 2002, 1:25:11 AM, you wrote: DN> KISS principle! ... You can also examine the -A option of myisamchk. -A, --set-auto-increment[=value] Force auto_increment to start at this or higher value If no value is given, then sets the

MySQL and PHP on a RaQ Server

James, Friday, January 18, 2002, 8:11:09 AM, you wrote: JR> We have a RaQ4i 400MHz server with 512MB of RAM running PHP4.03p1 JR> and MySQL 3.23.43 if memory serves correctly. JR> We are looking at bringing on a client who uses 1 MySQL database JR> and PHP to host a news site s

Re: MySQL on RH7.0 Alpha permissions don't work? Second try

John, Saturday, January 19, 2002, 12:18:26 AM, you wrote: JD> I tried putting passwords on the grant statements, but I can't log in as a JD> different user using a password -- it never authenticates. And as any other JD> user than root it won't let me access any tables. Are you sure you are

can login only as root

Hello Luie, Saturday, January 19, 2002, 11:03:23 AM, you wrote: LdS> REALFROM: "Luie delos Santos" <[EMAIL PROTECTED]> LdS> HOUR: 2002011911 LdS> hello all, LdS> I recently installed mysql on a RedHat7.2 box. I was able to login to it as *root*. LdS> I created another user (user1) using "GR

Premature end of script

Hi, I'm trying to use phpmyadmin 2.2.3 on a debian 2.2 box with Mysql 3.22.32, php 3.0.18, and apache 1.3.9-14. After installing phpmyadmin per Documentation.txt and creating the standard user, I get a "premature end of script headers: /usr/lib/cgi-bin/phpadmin/index.php3" This is from the /v

I *HAD* a problem running the setup - but found a solution, thought i'd share it with you!

Hi! I downloaded your mySQL for windows (32-bit). I unziped the files into the directory named just the same as the file had (mysql-3.23.47-win). When i then tried to run the setup.exe i got an error saying "can't run 16-bit windows program". This was an extremely irritating thing, since i the

Re: Full Text Search with and without index - possible bug?

Hi! On Jan 19, Gordan Bobic wrote: > Hi! > > The part that I thought could be a "bug" was the one you didn't quote. I still remeber that part, there's no need to explain it again :-) > > It's not a "known" bug as the code is rather new. > > Can you create a test case for this ? > > Possibly,

Re: can login only as root

check out the docs at http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#GRANT Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Bu

Re: Version number after '!' : what is the good syntax ?

Hi, Ok, it's 40001 according to #define MYSQL_VERSION_ID 40001 ;) Regards, Jocelyn - Original Message - From: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 19, 2002 3:03 PM Subject: Version number after '!' : what is the good syntax

Re: can login only as root

Luie: Here is a grant script we use ... check the syntax against the query you were using: USE mysql; GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'userpwd'; GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'userpwd'; GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]

Version number after '!' : what is the good syntax ?

Hi, I'm wondering what is the good syntax with version number after '!' with MySQL 4 : Should I use : /*!40001 SQL_CALC_FOUND_ROWS */ or /*!401 SQL_CALC_FOUND_ROWS */ Thank you ! Regards, Jocelyn Fournier Presence-PC - B

Re: Full Text Search with and without index - possible bug?

Hi! > > 1.1) Full Text Search can, according to the manual, be performed without > > the FTS index, but it is slower. > > 1.2) MySQL can only use 1 index per join per table. > > > > => This means that if I specify the USE INDEX (some_non_fulltext_index), > > the FTS will be performed without the

Re: Column Alias Bug??

> >Is this a bug? I can't find an answer to this question in FAQs or archives. > > > >CREATE TABLE aa ( a int); > >INSERT INTO aa VALUES (1),(2),(3),(2),(4),(5),(1),(6),(3); > > > >the following : > >mysql> select a,count(*) as z from aa where z>1 group by a; > > > >displays this error: > >ERROR

Understanding throughput with JDBC

Hello all, Could anyone please assist me to understand this. I want to understand where the time is going to and whether there is something I can do about it, with the following query when using JDBC; Here is the table declaration; CREATE TABLE Memberships ("EMAIL CHAR(60) NOT NULL,

job application

Dear Sir/Madam, I am looking for a telecommute job as a Java or C Programmer anywhere in the world. As a first step, I enlose my resume. I will consider any offer from you. I am ready even to pay part of my future income to you, if you find me a job. Thank you in advance. Sincerely Yo

job application

Dear Sir/Madam, I am looking for a telecommute job as a Java or C Programmer anywhere in the world. As a first step, I enlose my resume. I will consider any offer from you. I am ready even to pay part of my future income to you, if you find me a job. Thank you in advance. Sincerely Yo

Suse V/S Redhat - mysql performance difference.

Hi list, I have 2 servers 1 running redhat 7.2 and the other running suse 7.3. the hardware config is : RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz). Suse 7.3: Low end server (Ultra SCSI 2, PIII 850 MHz, 256 MB RAM). Now i expect to see the suse server go faster than RH, but i am h

Re: Compiling problem: error in type_info1.hh

Hi! Try adding : using namespace std; Are you using VC++ 6.0 ??? That port is not intended for other versions of VC++. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Develo

Re: Compiling problem: error in type_info1.hh

I downloaded these files but there are still some errors when I run the program: Thanks for the help Configuration: prog - Win32 Debug Compiling... prog.cpp c:\sqlplus\include\type_info1.hh(39) : warning C4800: 'int' : forcing value to bool 'true' or 'fals

Re: Porting from MS SQL to MySQL

You could design your app using a database abstraction so you can port your app from one database to another. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

can login only as root

hello all, I recently installed mysql on a RedHat7.2 box. I was able to login to it as *root*. I created another user (user1) using "GRANT all to user1 identified by 'password';", but when I tried to login as *user1*, access denied message is displayed. I've tried *flush privileges* but I'm st

Help: Innodb warning operating error number 3

I got this error when I was trying to get INNODB working on my machine: I am using mysql version 4.0.1 alpha = Regards, Investorclb __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -

RE: innodb and vbulletin 1.1

I work for vBulletin and have some input on this. First off, you really should look into upgrading to version 2.2.x, as not only are there many new features, but there have been a number of performance enhancements done that may help your situation. You also might want to take a look at the vBul

innodb and vbulletin 1.1

Hello, I have a few questions. First I work on a very high traffic site that uses vbulletin 1.1 to run its bb. The bb is very high traffic around 60-200 concurrent users. We are starting to run into some serious locking issues, and I am thinking about converting the high use tables(maby all)