Re: Select records from remote machine.

You can do this by normal execution but with the -h parameter specfying the host mysql -u mysql -p -h - Original Message - From: Charitha To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 3:47 PM Subject: Select records from remote machine. Hello all, In mysql how can i select or

Select records from remote machine.

Hello all, In mysql how can i select or execute any command in the remote machine Thanx i advance. -- Regards, Charitha. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

Select records from remote machine.

Hello all, In mysql how can i select or execute any command in the remote machine Thanx i advance. -- Regards, Charitha. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.my

myisamchk: error: Found key at page 2472960 that points to record outside datafile ...

Hi all, Can someone tell me what this error mean ? myisamchk: MyISAM file /var/lib/mysql/radius/radacct.MYI myisamchk: warning: 1 clients is using or hasn't closed the table properly myisamchk: error: Found key at page 2472960 that points to record outside datafile myisamchk: error: Keypointers

FW: keymappings - PHP or MySQL?

Hi, At the moment im getting a difference in keymappings between what is typed into a field and what is stored in the database. I have an html form that gets a text string called $email and this is inserted into a VARCHAR database feild via php, the problem is when special characters are includ

Using multi-byte character set

Hi, I am using double byte character set (big5) under mandrake linux with MySQL everything seemed ok after building the DB and tables after some time of testing I found some characters cannot be inserted, like those characters include the back slash '\'. it was simply disappeared as MySQL tr

Finding relevance in results

Hi. I am working on a project using Perl and the DBI (which is irrelevant to the question) and I would like to get a percenteage of how relevant the results are to the query I've made. I have tried the Fulltext and match() methods, but they only give back a number from 1.6 to 3.8 (so far). So, the

help / MySQL 3.23.49 vs. BerkeleyDB 4.0.14?

hi all, i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's BerkeleyDB 4.0.14. i note the "--with-berkeley-db" options in configure, but am stumped as to if/how to allow support for the bdb 4.0.14 version. mysql (in configure, acinclude.m4 & aclocal.m4) seems to limit to bd

% of relevance in results

Hi. I am working on a project using Perl and the DBI (which is irrelevant to the question) and I would like to get a percenteage of how relevant the results are to the query I've made. I have tried the Fulltext and match() methods, but they only give back a number from 1.6 to 3.8 (so far). So,

[Fwd: How get the columns that are between an interval?]

oops, i've just sent it to mike. Sabine Richter wrote: > > Hello Mike, hello Silvia, > > I think, the statement you suggest, Mike, isn't right. It gives you only > patients who are over 1 year in hospital. That means, who came before > (or at) 2000-01-25 and left after (or at) 2001-01-30. I th

InnoDB's inner workings + checkpoints

Hello Heikki, I have read up on checkpoint activity and innodb and there are still a few points I don't understand: -what is the chronological sequence of events for a write into the innodb tablespace? -Is it: 1. An insert sql statement is issued from a mysql client. 2. The record is stored in

View warning messages?

I'm getting several warnings when populating a table with data from a file. Some records are skipped as well, and I haven't been able to figure out why. Is it possible to view these warnings? I searched the list archive and saw that as of April 2000 this "feature" of MySQL hadn't been implement

Mysql time zone problem

I am trying to get my time zone setup correctly with mySQL on a RedHat 7.2 box, so the select now(); query returns the correct time. The show variable command show that the time zone is being updated with the different values I enter, but the time is still coming up 4 hours off. I am trying to s

Re: mysql server question

What Operating System (WinNT / 2K / 98 / etc.) are you using? - Original Message - From: "Timothy Keefe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 28, 2002 10:18 AM Subject: mysql server question Hi, all, Two questions . . . 1. Windows is giving me the 1067 error

Re: mysql server question

What Operating System (WinNT / 2K / 98 / etc.) are you using? - Original Message - From: "Timothy Keefe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 28, 2002 10:18 AM Subject: mysql server question Hi, all, Two questions . . . 1. Windows is giving me the 1067 erro

Re: Can't start mysql-service on Win XP

If a trailing slash were required, mine would not work: [mysqld] basedir=d:/mysql datadir=d:/mysql/data language=d:/mysql/share/english skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable

help / MySQL 3.23.49 vs. BerkeleyDB 4.0.14? (fwd)

hi all, i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's BerkeleyDB 4.0.14. i note the "--with-berkeley-db" options in configure, but am stumped as to if/how to allow support for the bdb 4.0.14 version. mysql (in configure, acinclude.m4 & aclocal.m4) seems to limit to bd

ANNOUNCE: moodss-15.13

### CHANGES ### --- version 15.13 --- - added tool bar with nice icons (borrowed from KDE) - added View/Tool Bar menu to show or hide the tool bar - saved tool bar visibility state in moodss preferences save file - in HTML documentation, updated screen shots, documented module tables minimizin

Php query from sql

Hello everybody, I'm quite new with all this php mysql "cooperation thing" but somehow I already managed to set up mysql database and I'm able to also make query's based on any keyword... Now I wonder how to add to this basic query also option to select some concrete data. For example in the dat

docs for mysql rpms

Dear Mysql folks, If you install mysql-3.23.49 using a source tarball and compile it with gcc, the package contains documentation directories and manual directories. If you install mysql-3.23.49a using an rpm then there don't seem to be doc directories that come with the installation. I can'

Re: Update a table with data from another table?

Hi. You have analyzied the situation correctly. AFAIK, there is no way to do this with one query until sub-selects are going to be supported, and you have to use one of the work-arounds you described. Bye, Benjamin. On Sun, Apr 28, 2002 at 10:13:49AM -0700, [EMAIL PROTECTED] wrote: > I

RE: How to make the Win target from source?

Hi !! > -Original Message- > From: Dennis George [mailto:[EMAIL PROTECTED]] > Sent: Sunday, April 28, 2002 11:10 AM > To: MySQL List > Subject: How to make the Win target from source? > > > I downloaded mysql-3.23.49-win-src.zip. > > There are various files missing (e.g. Makefile) tha

How to make the Win target from source?

I downloaded mysql-3.23.49-win-src.zip. There are various files missing (e.g. Makefile) that would enable compiling with gcc. Has anyone out there made mysql from source on Win platform with gcc? I had been trying to compile my own client but was getting a lot of undefines at link time - the

Update a table with data from another table?

I'm wondering if there's a way to use the results of a SELECT in an UPDATE operation, the way that it's possible to do so with INSERT and REPLACE. This seems like it should be possible, but as far as I can tell, it's not. This comes up for me repeatedly, but the problem at hand is identifying the

InnoDB's inner workings and checkpoints

Hello (Heikki), I have read up on checkpoint activity and innodb and there are still a few points I don't understand: -what is the chronological sequence of events for a write into the innodb tablespace? -Is it: 1. An insert sql statement is issued from a mysql client. 2. The record is stored

Re: How get the columns that are between an interval?

Dra. Silvia Andreasi, SELECT * FROM table WHERE begin_date_column <=2000-01-25 and 2001-01-30<= end_date_column; begin_date_column and end_date_column have to be date type columns. Mike sql,mysql Dra. Silvia Andreasi wrote: > Hi, > > How can I get the columns between a given time interval

Re: How get the columns that are between an interval?

Should we assume that your tables have an existing column of type timestamp or date? On Sunday 28 April 2002 11:47 am, Dra. Silvia Andreasi wrote: > Hi, > > How can I get the columns between a given time interval? Something like: " > The patients admitted between january 25, 2000 and january 3

How get the columns that are between an interval?

Hi, How can I get the columns between a given time interval? Something like: " The patients admitted between january 25, 2000 and january 30, 2001" ?? I'm new to MySql and would like a suggestion from you... Best Regards Silvia --

Re: Can't start mysql-service on Win XP

Hi Jan, > > I suppose you already tried this: > http://www.mysql.com/doc/N/T/NT_start.html I did! > > This could be problems w/ your path or your my.ini (overwritten my > mysqladmin). mysqld-nt --help has the correct basedir (.\mysql\) Oh, what's that? In my.ini I just wrote "basedir=m

mysql server question

Hi, all, Two questions . . . 1. Windows is giving me the 1067 error, which states that the MySQL server is terminating unexpectedly. I guess I'm going to have to reinstall it, unless there's some way to troubleshoot what's wrong and then fix the problem. Has anyone ever encountered this? Coul

Re: Changing field size

To my knowledge, nothing would happen to the existing data, since you would be performing a "widening conversion." Michael On Sun, 28 Apr 2002, Anthony Rodriguez wrote: > I've a VARCHAR(4) field that I want to change to a VARCHAR(6) field. > > What would happen to the existing data in MySQ

IBM docs server and mysql manual

Hi, just a short note for the documentation: IBM moved their AIX documentation, and did not find it necessary to redirect this properly. The link in: http://www.mysql.com/doc/I/B/IBM-AIX.html refering to the uname command, should go from: http://www.rs6000.ibm.com/doc_link/en_US/a_doc_lib/cmds

Re: Can't start mysql-service on Win XP

Hi Sabine (again ;-) ) I suppose you already tried this: http://www.mysql.com/doc/N/T/NT_start.html This could be problems w/ your path or your my.ini (overwritten my mysqladmin). If it won't start anyway, put mysqladmin.exe to your autostart. regards, (Grüße) Jan - Original Message -

Re: mysql /bin directory

J. Flechnter, Here are some paths from an rpm install that I did with RedHat. /usr/share/mysql/ /etc/my.cnf /var/lib/mysql/ Mike J. Flechtner wrote: > Greetings, > >I am new to mysql. I have performed a fresh Red Hat install (7.2) > with all packages available. In an attempt to become m

Can't start mysql-service on Win XP

Hello, for the first time I installed Mysql 3.23.49 on win XP professional. I installed it with admin privileges, installed the service -so far everything seemed to be ok. But when I tried to start the service, it didn't start (failure number 1067). I don't have any idea, what that failure number

mysql /bin directory

Greetings, I am new to mysql. I have performed a fresh Red Hat install (7.2) with all packages available. In an attempt to become more familiar with mysql (performing numerous tutorials) there are many mentions of a /usr/local/mysql/bin directory. Since everything was installed via RPM th

SV: WHERE ignored

> -Oprindelig meddelelse- > Fra: Mike Hall [mailto:[EMAIL PROTECTED]] > Sendt: 28. april 2002 12:28 > Til: [EMAIL PROTECTED] > Emne: Fw: WHERE ignored > > > Corrupt index, hmm? I'll check that in a moment - thanks. After looking at your fault-free script, my best bet would also be a corru

parse errors when compiling clients using gcc 2.96

I receive the following parse errors when attempting to compile a client program on a Linux box using gcc 2.96: gcc -c -DMYSQL -I/var/src/mysql-3.23.49/include checkhttpd.c In file included from checkhttpd.c:9: /var/src/mysql-3.23.49/include/mysql.h:175: parse error before `1' /var/src/mysql-3.23.

Changing field size

I've a VARCHAR(4) field that I want to change to a VARCHAR(6) field. What would happen to the existing data in MySQL db? Thanks! Tony ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (t

Fw: WHERE ignored

Corrupt index, hmm? I'll check that in a moment - thanks. Probably a sensible idea to limit the query too - I think I'll order by date desc too just to make sure that recent mail gets sent. Cheers --Mike - Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Mike Hal

Re:  character

This character is a trademark character it looks like (TM) but as one superscript character. Ack, at 4/28/02, Gelu said: >Almost all machines who work with CPU know about ASCII character set >(http://www.asciitable.com/). >This character is ENTER(in ASCII - carriage return) or NEW LINE (in ASC

RE: Keeping track of db structure changes

> It's really not all that different that source code. For each > application I build, I tend to put the source code in our CVS > repository long with the $foo.sql file(s) to reconstruct the tables. > Just as there's nothing preventing me from deploying a new release of > an application before ch

Using multi-byte character set

Hi, I am using double byte character set (big5) under mandrake linux with MySQL everything seemed ok after building the DB and tables after some time of testing I found some characters cannot be inserted, like those characters include the back slash '\'. it was simply disappeared as MySQL treat

Re:  character

Hi, Almost all machines who work with CPU know about ASCII character set (http://www.asciitable.com/). This character is ENTER(in ASCII - carriage return) or NEW LINE (in ASCII - linefeed) and is NON-PRINTABLE. Don't have graphical representation. Using "LOAD DATA ...", MySQL accept all the char

RE: Problem with User Account - access denied

Isnt it GRANT ALL ON college.* TO someuser identified BY "somepassword"; -Original Message- From: J [mailto:[EMAIL PROTECTED]] Sent: Sunday, 28 April 2002 2:22 AM To: [EMAIL PROTECTED] Subject: Problem with User Account - access denied I created and user, like below, using mysql on m