Some more info on what I don't have.

2002-03-21 Thread Louise
The site is a search engine site similiar to ooh-canada.com (not that I am plugging their site...lol) but it is the best way to describe mine. I have adcycle on it- that doesn't work. I have link sql which doesn't work. There is e-classifieds that doesn't work. Subscribe Me pro doesn't work Auto

How to connect to mysql databases

2002-03-21 Thread amol sonaikar
Hi all . I am on a Linux 6.2 client and accessing MySql directly on the server. I have connected to server using Telnet. I am at mysql> prompt and when I say show databases ; it showing me the databases over there. However how can I connect to these databases. I used connect comand but it's n

Re: Some more info on what I don't have.

2002-03-21 Thread Sherwin T. Ang
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Louise, Well first of all is that, did you change host providers? well if so, have you made a backup/dump of your database in your old host? if so, are u sure that your new host supports PERL DBI which is needed for you to do database connectio

Re: JBuilder6 and mm.mysql-2.0.11

2002-03-21 Thread TAKAHASHI, Tomohiro
Hi, Lonnie Wormley wrote: > > >>Is this the correct file to have in your class path? > >>addpath /home/launi/JBuilder6/lib/mm.mysql-2.0.11/mm.mysql-2.0.11-bin.jar > > > > Yes, please add it into jdk.config. :) > > > I have it in there and it still does not work. I have it in my > .bash_profi

about mysqldump

2002-03-21 Thread Chetan Lavti
Hi, I want to know, whether the recovery from the file created using mysqldump, will also recover the foreign key between the tables. because when I am doing this it doesn't seems like that.. when I am doing recovery I am loosing all the foreign keys of by database tables. please, tell me it is a

no umlauts in mysql client

2002-03-21 Thread smantscheff
>Description: mysql (the client program) does not accept umlauts. It does not react to keystrokes with ä,ä,ü,ß. Neither can I enter umlauts using batch input files. This is independent from the database to which mysql connects. The databases store umlaut chars in text fi

about mysql C api's

2002-03-21 Thread Chetan Lavti
hi, I am using InnoDB table type.. I have done almost all the operation through the api's as connect,insert,delete, update, close connection etc, Now, I have one problem, I know that there is one api for Shutting down the MySQL Server i.e. int mysql_shutdown(*mysql) I want to know whether there

MS Access to MySQL conversion

2002-03-21 Thread andy thomas
We have a Unix server which in addition to running MySQL is also a fileserver for a group of MS Windows PCs (using samba) and it would be useful to be able to convert the Microsoft Access .mdb files put there by users directly to MySQL, or at least to .csv format. Does anyone know of such a utili

Error message

2002-03-21 Thread Egor Egorov
mysql, Wednesday, March 20, 2002, 11:02:01 PM, you wrote: mmlu> In my mysql .err file I get a lot of the following error... mmlu> "Aborted connection 121031 to db: ..connection details... (Got an error mmlu> reading communication packets)" mmlu> What does this mean, and is it bad, and what d

LOAD DATA

2002-03-21 Thread Egor Egorov
Klym, Thursday, March 21, 2002, 6:55:36 AM, you wrote: K> I am running the latest stable version: 3.23.49a K> but when I use the LOAD DATA command I get the error below: K> mysql> load data local infile "theme.txt" into table theme; K> ERROR 1148: The used command is not allowed with this MySQ

How to connect to mysql databases

2002-03-21 Thread Victoria Reznichenko
amol, Thursday, March 21, 2002, 10:17:53 AM, you wrote: as> Hi all . I am on a Linux 6.2 client and accessing MySql directly on as> the server. I have connected to server using Telnet. I am at mysql> as> prompt as> and when I say show databases ; it showing me the databases over as> there. Ho

Fw: Access denied on use mysql;

2002-03-21 Thread Victoria Reznichenko
Kathy, Wednesday, March 20, 2002, 7:27:31 PM, you wrote: KR> I cant figure out how I have lost access to 'mysql' (default) database. When KR> I attempt to use mysql on my Linux machine I get the error message "ERROR KR> 1045: Access denied for user: 'root@localhost' (Using password: NO)" Kathy,

Re: Load Data only loads 1 record

2002-03-21 Thread rupert cutler
On Wednesday, March 20, 2002, at 10:40 PM, Jimi Oleksiak wrote: > Why doesn't mysql read the whole file? and how can I find the "Warnings: > 1"? > > Think I can help with the first - depending how your text file was generated it may use carriage return (ASCII 13) or line feeds (10) at the e

Re: Fw: Access denied on use mysql;

2002-03-21 Thread Liyju Janardhan
Hi, Check whether ur mysql is running using the following command. $/etc/rc.d/init.d/mysqld status if the reply is running... then type 'mysql' (if you have anonymous login) otherwise type 'mysql -u root -p' If you don't get the mysql prompt then you will have to add an user using mysqladmi

Re: How to connect to mysql databases

2002-03-21 Thread amol sonaikar
There is still error I did as per your say at mysql> use test; but the error it gave was ERROR 1044: Access denied for user: '@localhost' to database 'test' even if I do something like this mysql> mysql -u amol test -p ERROR 1045: Access denied for user: 'amol@localhost' (Using password:

Re: Java to MySQL connection

2002-03-21 Thread Liyju Janardhan
which Driver your using? which Operating system your using? If your using linux, as far as I know there is now odbc support. You have to downlaod mm.mysql driver. If your are using windows you will have to create a dsn name for the your selected driver. --- Chris Stewart <[EMAIL PROTECTED]> wr

exanging vars between form/php/javascript

2002-03-21 Thread savaidis
First in generally: How is possible to exange vars between a form/php/javascript? I have fetch the data from a MySQL query and I need to pass the $line from a form to a new php script to show the record in details in one whole page. I have put a with onMouseOver but I'll but rather a form there

Re: MySQL clients hang when network to server is disrupted!

2002-03-21 Thread Sinisa Milivojevic
On Wed, 20 Mar 2002 16:00:15 -0800 Lance Welsh <[EMAIL PROTECTED]> wrote: > It is a big problem for us, and I can only imagine for anyone using > MySQL, when a mysql client hangs on an established connection to > the mysql server because the network to the server is disrupted > (such as someone p

RE: Java to MySQL connection

2002-03-21 Thread sean . odonnell
there is odbc support on linux, you can find a link the the myodbc drive for mysql on mysql.com -Original Message- From: Liyju Janardhan [mailto:[EMAIL PROTECTED]] Sent: 21 March 2002 03:30 To: Chris Stewart; [EMAIL PROTECTED] Subject: Re: Java to MySQL connection which Driver your usi

outer joins: tried some sql code myself but doesn't work - should be easy i think ?

2002-03-21 Thread Van Overbeke, Tom
Hi, I sent a message to the list earlier today about a problem with an outer join. I tried some stuff myself and checked the archives, but no message described my syntax problem with mysql, so I turn to the list again for some helpful soul to help me: I have two tables that i want to link via an

What is Returned from a query that a record isnt there

2002-03-21 Thread jim and lois flaherty
Hello , I have a user DB , My perl script on my redhat box scans a drive for users files , and I want to email, the user to remind them they have a file that they havent used in months my problem when the script comes accrosed a new user I want them to be added to the DB and send me an email sta

ER Program

2002-03-21 Thread Ricardo Striquer Soares
i am looking for a ER Design Freeware tool, i'd like to konw if does someone here knows about something like that, the tool name and, if possible, the url for download. currently i am using a DDT (Database Design Tool) V1.5, however i think it's too simple with that i can not create indexes, i sa

how to do when the table files become bigger and bigger

2002-03-21 Thread Buding Chen
Hi, all: I am doing a project that we will insert a lot of data to mysql every day, so the table files will become bigger and bigger, it will not only take a long time to query,but also lead to the file size limits. So how to resolve it? Are there some artiles related? Thanks for any help.

Re: outer joins: tried some sql code myself but doesn't work - should be easy i think ?

2002-03-21 Thread Jon Barker
>I came up with the following sql statement, but I still don't see any >records that are missing in table active_monitors, I assume i am abusing the >'join syntax' but I don't know how to fix it: > >select D.monitor, D.endpoint ,A.monitor >from endpoints_defined_monitors D >left outer join active

Re: How to connect to mysql databases

2002-03-21 Thread Liyju Janardhan
what is the output of "show database" command --- amol sonaikar <[EMAIL PROTECTED]> wrote: > Hi all . I am on a Linux 6.2 client and accessing > MySql directly on > the server. I have connected to server using Telnet. > I am at mysql> > prompt > and when I say show databases ; it showing me th

Re: How to connect to mysql databases

2002-03-21 Thread Liyju Janardhan
Do the folowing mysql>show grant for root@localhost; mysql>grant all on test.* to root@localhost identified by 'password'; $mysqladmin reload --- amol sonaikar <[EMAIL PROTECTED]> wrote: > There is still error > > I did as per your say > at mysql> use test; but the error it gave was > ERROR

Re: Inserting records with null foreign keys?

2002-03-21 Thread Heikki Tuuri
Rick, this is fixed in 3.23.50. I changed InnoDB so that it ignores foreign key checks on keys containing SQL NULL values. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news

http auth in phpmyadmin help!

2002-03-21 Thread Mike Yrabedra
I am having a heck of a time trying to get phpMyAdmin to work with 'http or cookie' authentication. I have created the stduser/stdpass like the docs say, but still nothing. Can anyone give any tips/tricks to make this work?? TIA mysql -- Mike Yrabedra [EMAIL PROTECTED] http://www.macsur

What is "Com_change_db"

2002-03-21 Thread Michael Widenius
Hi! > "hisol" == hisol writes: hisol> I executed mysqladmin extended-status. hisol> There was "Com_change_db" head. But I can't understand what it means. hisol> I know "Com_xxx" means number of times "xxx" command executes. But hisol> what does change_db mean? This is number of times '

Re: http auth in phpmyadmin help!

2002-03-21 Thread Jim Philips
What kind of box are you on? UNIX? Windows? What happens when you try to access the page? Provide some details. On Thu, 2002-03-21 at 08:52, Mike Yrabedra wrote: > > > > I am having a heck of a time trying to get phpMyAdmin to work with 'http or > cookie' authentication. > > I have created t

Re: Re: ER Program

2002-03-21 Thread Bernhard Doebler
- Original Message - From: <[EMAIL PROTECTED]> To: "Bernhard Doebler" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 1:58 PM Subject: Re: Re: ER Program > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter yo

Boolean Fulltext in 4.0.2 bug

2002-03-21 Thread Alexander Belyaev
Hello, CREATE TABLE IF NOT EXISTS test ( id mediumint(6) unsigned NOT NULL DEFAULT '0' , txt text , PRIMARY KEY (id) ); #insert. 4 rows ALTER TABLE test ADD FULLTEXT findind (txt); select * from test where match(txt) against('+sony -playstation' in boolean mode) (25 rows returned

delete vs delete quick

2002-03-21 Thread Viraj Alankar
sql Hello, I'm confused as to what 'delete quick' does and when to use it. The manual states: If you specify the word QUICK then the table handler will not merge index leafs during delete, which may speed up certain kind of deletes. What does this actually mean? Viraj. --

scheduled job

2002-03-21 Thread Okan CIMEN
Hello, I am planning to call a scheduled (lets say 08:00 am every weekday) batch job at MySql, but I do not want to use operating systems scheduled task nor crontab. Is there a function that mySql supports like Oracle's jobs? Regards Okan --

RE: how to do when the table files become bigger and bigger

2002-03-21 Thread Rick Emery
What is the problem you wish to resolve? Define it. -Original Message- From: Buding Chen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 6:33 AM To: [EMAIL PROTECTED] Subject: how to do when the table files become bigger and bigger Hi, all: I am doing a project that we w

nothing technical....

2002-03-21 Thread Gurhan Ozen
Thought some might be interested in such articles. Seems like Oracle's got caught red handed scrambling:) http://reuters.com/news_article.jhtml?type=technologynews&StoryID=725126 Just for the filter: MySQL rocks :) Gurhan -

Please Assist

2002-03-21 Thread melias
Attempting to set up Payment Gateway Database and attempting mysql.bat file. When it runs, we are getting the following error message D:\INSTALLS\MYSQL\MODS>d:\mysql\bin\mysql -t 0d:\mysql\bin\mysql -t 0d:\mysql\bin\mysql -t 0http://www.mysql.com/manual.php (the manual) http://lists.mysq

Re: major performance disparities with mysql/php - SOLVED

2002-03-21 Thread Henry Hank
I found the problem. My production server is running mysql 3.22.29, and I needed to use a SET SQL_BIG_TABLES=1 in many places to prevent a "full temp table" condition. The new server is running 3.23, and once I removed the SQL_BIG_TABLES=1 from the script (and allowed mysql to use memory instea

RE: scheduled job

2002-03-21 Thread Gurhan Ozen
Hi, No there is not.. You have use crontab with a batch file to do that. Gurhan -Original Message- From: Okan CIMEN [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 9:27 AM To: [EMAIL PROTECTED] Subject: scheduled job Hello, I am planning to call a scheduled (lets say 08:00

sqlbindcol

2002-03-21 Thread Shiva Shankar Chetan
Hi, I am trying to get the following to work but it returns invalid values. SQLINTEGER size; SQLExecDirect (hstmt, "Select 8", SQL_NTS); SQLBindCol(hstmt,1, SQL_C_ULONG, &size,0,NULL); I tried various datatypes for size but I always get some invalid values. Is the above correct or do I need

Re: Re: ER Program

2002-03-21 Thread Marjolein Katsma
At 15:12 2002-03-21, Bernhard Doebler wrote: >- Original Message - >From: <[EMAIL PROTECTED]> >To: "Bernhard Doebler" <[EMAIL PROTECTED]> >Sent: Thursday, March 21, 2002 1:58 PM >Subject: Re: Re: ER Program >> >> Look out for the Czech Program Case Studio. Looks interesting - but it's

Re: MySQLl performance on Linux versus XP/W2K

2002-03-21 Thread Scalper
Probably Linux, but it is also pretty spunky on my WinXP machine. Craig At 08:30 PM 3/20/2002 -0800, you wrote: >Is MySQL 3.23/4.01 faster on Linux (RH 7.2) or Windows XP/2000 with the same >hardware? Thanks. > >David > > >- >B

help with index/query

2002-03-21 Thread Salada, Duncan
I am hoping I can get some help with a difficulty I am having with a table of mine. I am going to give a lot of background info, so please bear with me. First, let me say that I using 3.23.49. Now some info about the table. It currently has 5687391 rows. There are 3 columns in the table: ID (i

Betr.: ER Program

2002-03-21 Thread J van Dijk 'BV Kunststoffenindustrie Attema'
Try this: Microsoft VisioModeler 3.1 (FREE) on msdn.microsoft.com/downloads jvd >>> "Ricardo Striquer Soares" <[EMAIL PROTECTED]> 21-3-02 13:21:20 >>> i am looking for a ER Design Freeware tool, i'd like to konw if does someone here knows about something like that, the tool name and, if possib

server startup error on linux

2002-03-21 Thread Rance Hall
Ok, I guess Im gonna have to do this again I have a Slackware 8.0 distro with the apache, php, and mysql install pkgs off of the cd I am logged in as root (not su'ed to root) and run the mysql_install_db script I run it with or without the --user=mysql qualifier in either case the databases

Re: server startup error

2002-03-21 Thread Gerald Clark
The group is not really important, as long as mysql owns the data directory and its contents. You can check /etc/group and see if you have a mysql group, or a group to which mysql is a member. Rance Hall wrote: > Folks: > > I think you are on the right track with that Gerald.. > > I deleted al

Re: Boolean Fulltext in 4.0.2 bug

2002-03-21 Thread Sergei Golubchik
Hi! On Mar 21, Alexander Belyaev wrote: > Hello, > > CREATE TABLE IF NOT EXISTS test ( > id mediumint(6) unsigned NOT NULL DEFAULT '0' , > txt text , > PRIMARY KEY (id) > ); > > #insert. 4 rows > > ALTER TABLE test ADD FULLTEXT findind (txt); > > select * from test where match(t

MY SQL Installation Problem

2002-03-21 Thread Egor Egorov
Suresh, Thursday, March 21, 2002, 6:48:47 AM, you wrote: SRS> I am getting following error msg when I try to install SRS> MySQL using rpm -i My* SRS> error: MySQL-3.23.49a-1.i386.rpm cannot be installed SRS> error: failed dependencies: SRS> data-showtable is needed by SRS> Msql-Mysql-DBI

RE: Inserting files from command prompt

2002-03-21 Thread Victoria Reznichenko
Stembridge, Thursday, March 21, 2002, 12:05:31 AM, you wrote: Seoen> The problem isn't inserting table schema/data - I know how to do that. Seoen> I'm referring to the process of inserting an actual FILE (txt, .bat, .jpg) Seoen> via command line. And of pulling it out and giving it a name (te

Re: rpms for redhat 6.2

2002-03-21 Thread Victoria Reznichenko
Shamit, Wednesday, March 20, 2002, 7:49:50 PM, you wrote: SK> Hi, can any one suggest where I can get latest MySQL rpms for redhat 6.2 SK> with glibc 2.1x... the new rpms .49+ are all for glibc 2.2+ If you use glibc 2.1x you should compile by yourself. Note: compilation by yourself requires att

scheduled job

2002-03-21 Thread Egor Egorov
Okan, Thursday, March 21, 2002, 4:27:15 PM, you wrote: OC> I am planning to call a scheduled (lets say 08:00 am every weekday) batch OC> job at MySql, but I do not want to use operating systems scheduled task nor OC> crontab. Is there a function that mySql supports like Oracle's jobs? There is n

Re: Adding Columns to table

2002-03-21 Thread alan4100
mysql Allon, Thanks for the clear and simple example regarding keys. You may notice mysql at the top left corner because without it your letter will bonce back like others (users). eek!

log files

2002-03-21 Thread Victoria Reznichenko
Pål, Wednesday, March 20, 2002, 5:52:58 PM, you wrote: PW> I have: PW> mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386) PW> and wonder about the log file /var/log/mysqld.log PW> shouldn't that include failed connections?? You can find mysqlds log in the file 'your_hostname.err' or '

Character Set Problem in MySQL!

2002-03-21 Thread [EMAIL PROTECTED]
Actually I hadn' t this kind of problem. But now I can' t display turkish characters in mysql queries. Can anyone help me? Edakom Internet Sorumlusu Gokce Akkaya - Before posting, please check: http://www.mysql.com/man

Re: Adding Columns to table

2002-03-21 Thread alan4100
mysql Thanks, Colin for the reference to winmysql..etc. By the way, do you also get this email at your personal email address besides mailing list? It looks like you have to check at this mailing list site, because almost all personal emails have been bounced back. I only reply notes to [EM

Re: help with index/query

2002-03-21 Thread Gerald Clark
what about select Url from table where Ref = 'foo' Salada, Duncan wrote: >I am hoping I can get some help with a difficulty I am having with a table >of mine. I am going to give a lot of background info, so please bear with >me. First, let me say that I using 3.23.49. Now some info about the

Re: Access denied on use mysql;

2002-03-21 Thread alan4100
mysql Hello Kathy, How have you made out with access to mysql?

RE: server startup error on linux

2002-03-21 Thread Andreas Frøsting
> I assume that the mysql daemon is looking for one of those > owned by mysql. > > The server will start if I send the --skip-grant-tables option > > Who wants to run a database with no grant tables Find out where your databases are located. Think /var/db/mysql is the default. Go there an

Re: Adding Columns to table

2002-03-21 Thread alan4100
mysql I tried to d/l winmysql from this website: http://www.winmysql.com/page4.html as freeware, but it did not respond. Guess it is busy. Will try again, later. But would you or others suggest me to put it in a separate folder from MySQL folder after the d/l?

large blob inserts fail even when setting max-allowed-packet to 64M

2002-03-21 Thread rbohn
>Description: using mysql 3.23.41 when attempting to insert a large file (around 17 MB) into a longblob field i get the following error ERROR 2006 at line 1: MySQL server has gone away our mysqld init script contains the following line:

Re: nothing technical....

2002-03-21 Thread Francesca Shiekh
One more reason to stick to MySql! For those interested, another article here: "Oracle Pricing called into question" http://www.eweek.com/article/0,3658,s=1884&a=24365,00.asp At 09:42 AM 3/21/2002 -0500, Gurhan Ozen wrote: >Thought some might be interested in such articles. Seems like Oracle's g

Re: delete vs delete quick

2002-03-21 Thread Dan Nelson
In the last episode (Mar 21), Viraj Alankar said: > sql > > I'm confused as to what 'delete quick' does and when to use it. The > manual states: > > If you specify the word QUICK then the table handler will not merge > index leafs during delete, which may speed up certain kind of > deletes. Nor

RE: server startup error on linux

2002-03-21 Thread Andreas Frøsting
> I assume that the mysql daemon is looking for one of those > owned by mysql. > > The server will start if I send the --skip-grant-tables option > > Who wants to run a database with no grant tables Find out where your databases are located. Think /var/db/mysql is the default. Go there an

Query syntax help

2002-03-21 Thread rory oconnor
I'm trying to figure out a query that will tell me the total number of people in our house email file that physically opted out in the last week. I'm a bit of a mysql newbie as you can tell... This is the general concept, though it doesn't seem to work: select count(id) from contact # my

MysqlDump (Possible bug?)

2002-03-21 Thread Warren van der Merwe
Hi I recently ran a mysqldump of a bunch of information. When the mysqldump extracted the dates, it extracted them in South African format (dd/mm/), I am guessing this was picked up from somewhere, so when I then ran the dump through mysql to reimport the information all the dates where impor

Re: please, show me!

2002-03-21 Thread Chuck \"PUP\" Payne
If you are using KDE, there a great gui mysql program called kmysqladmin, that you can download and install and have running within second, it comes all versions of Sues and a great guy to work with. I know that on the website there is a tar ball and a Red Hat version. Use google.com to find it.

ANN: EMS MySQL Manager 1.67 released

2002-03-21 Thread Igor Brynskich
Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.67) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.67

Re: still no umlauts in mysql --experts help needed

2002-03-21 Thread Egor Egorov
sascha, Wednesday, March 20, 2002, 12:52:41 PM, you wrote: sm> Am Mittwoch, 20. März 2002 11:24 schrieben Sie: sm> > I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. sm> > mysql does not let me enter german umlauts, though. I tried to start it sm> > with "mysql --default-cha

Re: Access denied on use mysql;

2002-03-21 Thread Kathy Reyes
I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by "password"; it gave me the message Unknown C

logrotate problem

2002-03-21 Thread Slawomir Orlowski
Hello there! I have added recently administrative user to mysql database: #mysqladmin -u root password someposword since then I'm getting every day such e-mail from logrotate demon: Subject: errors rotating logs Message: errors occured while rotating /var/lib/mysql/mysql.log mysqladmin: connec

database and web servers

2002-03-21 Thread Klym
Is it possible to have your web server and your MySQL server running at different geographic locations? I'm wondering if I can run my own MySQL server here at home on Linux and have my web site use PHP to connect to it and extract data. Is that a bad idea for security and speed? thanks --

Re: rpms for redhat 6.2

2002-03-21 Thread Gabriele Carioli
Hi! > Hi, can any one suggest where I can get latest > MySQL rpms for redhat 6.2 with glibc 2.1x... > the new rpms .49+ are all for glibc 2.2+ I had the same problem. There are four possible solutions: a) The obvious but annoying one: upgrade to RH72... b) The less likely one. Upgrade RH62 to

RE: Query syntax help

2002-03-21 Thread Rick Emery
AND date >= "2002-03-17"; -Original Message- From: rory oconnor [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 10:49 AM To: mysql "list (choose midget) Subject: Query syntax help I'm trying to figure out a query that will tell me the total number of people in our house email

RE: Query syntax help

2002-03-21 Thread Roger Baklund
> I'm trying to figure out a query that will tell me the total number of > people in our house email file that physically opted out in the last > week. I'm a bit of a mysql newbie as you can tell... > > This is the general concept, though it doesn't seem to work: > > select count(id) from conta

Rotation of binary logs on replication master?

2002-03-21 Thread Guy Davis
Just wondering if any Linux users of MySQL out there had written a logrotate configuration file for dealing with MySQL binary logs on a replication Master. I want to rotate these logs (6.5 GB now) as some are over a month old. However, I don't want to confuse any of the replicating slaves. Any

Getting Found Count When Using Limit

2002-03-21 Thread Fletcher Sandbeck
I am trying to get the full found count from a query while using LIMIT to return just a portion of the found records. I can use two queries in a row to get first the found count, then the found records, but that takes twice as long as performing either query by itself. SELECT COUNT(*) FROM datab

libmysqlclient & libstdc++ question.

2002-03-21 Thread zxcv
OS: Compaq Tru 64 4.0F Compiler: GNU GCC 3.0.4 - libstdc++.3.0.4 MySQL 3.23.49 MySQL Protocol 10 - libmysqlclient.so.10.0.0 After upgrading apache/php with the new 3.23.49 libs all of my previously working 'C' mysql applications have died. This is okay on one hand cause I am moving them to 'php'

Re: Server startup error on Linux

2002-03-21 Thread Rance Hall
I issued the chown command as indicated by Andreas but it doesnt help I still get the "Table mysql.hosts doesnt exist" I know that all the tables created by mysql_install_db are infact owned by mysql but the server daemon still cant find them what next? _

RE: Query syntax help

2002-03-21 Thread Daren Cotter
What you had looks fine except the date...change what you had to: AND date >= '2002-03-17'; # date needs quotes around it Should work. -Original Message- From: rory oconnor [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 8:49 AM To: mysql list (choose midget) Subject:

Re: database and web servers

2002-03-21 Thread Christopher Thompson
On Thursday 21 March 2002 11:28 am, Klym wrote: > Is it possible to have your web server and your MySQL server running at > different geographic locations? I'm wondering if I can run my own MySQL > server here at home on Linux and have my web site use PHP to connect to it > and extract data. Is

Re: database and web servers

2002-03-21 Thread Gabriel Ricard
As long as you've got a fat pipe on both ends speed could be ok. But, then again, you never know. Some backhoe in Nebraska could cut your sweb server off from your database. Of course you'll want it to be secure as well. MySQL 4 has support for SSL. I suppose you could setup an ssh port redire

Re: Access denied on use mysql;

2002-03-21 Thread alan4100
mysql Kathy, I see..

Status of InnoDB support.

2002-03-21 Thread Gabriel Ricard
I was just perusing the Innobase Oy site and read that they've declared MySQL/InnoDB 3.23 stable (it actually says they did this in February). I read somewhere on the MySQL site a while ago stating that InnoDB wasn't included in the non-Max distribution because it was still considered beta. I

Re: Rotation of binary logs on replication master?

2002-03-21 Thread Shawn McCool
/usr/local/bin/mysql -hhostname -uusername -ppassword -e "flush logs;" Guy Davis wrote: >Just wondering if any Linux users of MySQL out there had written a >logrotate configuration file for dealing with MySQL binary logs on a >replication Master. > >I want to rotate these logs (6.5 GB now) as so

Can you Change Nulls in the MySQLDump from \N?

2002-03-21 Thread David M. Peak
Is there a way to tell MySQL to put a blank space instead of \N in the tab-delimited files when it does a dump? I'm working on a MySQL to SQL Server migration and having problems with the output files. I'm doing this all in batch fellas so I'm not finding a good search and replace utility. (perl

Re: Access denied on use mysql;

2002-03-21 Thread Kathy Reyes
Now I have a different problem. When I type mysql it gives me the message Access denied for user: 'root@localhost' (Using password: NO) how do I get it to use the password. When I type mysql -u root -p I get in... - Original Message - From: "alan4100" <[EMAIL PROTECTED]> To: "Kathy Re

Load Data Command

2002-03-21 Thread Michael Kaiser
Using the following inserts data from a text file into a particular MySQL table: LOAD DATA LOCAL INFILE "file.txt" INTO TABLE whatever; Is there any way to do this, but instead of inserting, it's updating? Michael Kaiser LivingLegend.net [EMAIL PROTECTED] "Many folk like to know beforehand wha

Re: Access denied on use mysql;

2002-03-21 Thread Gerald Clark
Grant all on mysql.* to 'root'@'localhost' identified by "password"; What version MySQL are you running? You need 3.23 for GRANT to work. Kathy Reyes wrote: >I just gave up, everything that I tried did not work. > >I killed mysql and then >started with safe_mysql --skip-grant-tables >then I

Compile time issue?

2002-03-21 Thread Aragon Arcanas
Hello, I have compiled mysql-3.23.49 from source distribution on a NetBSD 1.5.2 (sparc) box. Everything compiled fine, no-errors. Installed fine, no-errors. Starts and Stops fine no-errors. But when I go to run mysql or mysqladmin I get the following error: # /usr/local/mysql/bin/mysql

Re: Getting Found Count When Using Limit

2002-03-21 Thread Allon Bendavid
Tough thing to do. Fortunately we thought this through for you in jTalk. Keep your eyes peeled for a formal announcement next week. -Allon On 3/21/02 11:04 AM, "Fletcher Sandbeck" <[EMAIL PROTECTED]> wrote: > I am trying to get the full found count from a query while using LIMIT to > return >

Re: JSP or PHP?

2002-03-21 Thread Ken Anderson
Klym wrote: > > I have built a MySQL database for a web based survey. I am trying to decide > between JSP and PHP for my programming interface. The reason I am > considering Java is because I have some Java experience. What would you > recommend for someone like me who is starting out? If you

Re: logrotate problem

2002-03-21 Thread sascha mantscheff
in the postrotate section, you have to add the user and password parameters to mysqladmin: mysqladmin -u someuser --password=somepassword flush-logs s.m. Am Donnerstag, 21. März 2002 19:23 schrieben Sie: > Hello there! > > > I have added recently administrative user to mysql database:

Re: Load Data Command

2002-03-21 Thread Mark Horton
If the table has a unique key then add the REPLACE keyword. This will update the columns with new values if the key already exists and add the row if it doesnt. --Mark Michael Kaiser wrote: > Using the following inserts data from a text file into a particular MySQL > table: > > LOAD DATA LOC

--skip-networking causes daemon to shutdown immediately after startup?

2002-03-21 Thread Eric Reuss
Apologies for sending what may well be a "duh" problem, but I've run out of web- and documention-based resources... System: I'm running MySQL 3.23.47 on OS X 10.1.2. Symptoms: When I try to run safe_mysqld with --skip-networking (or with the option set in a my.cnf file), everything starts

Re: JSP or PHP?

2002-03-21 Thread Mark Stringham
http://www.cqhost.com/ I have a JSP app hosted there and they are pretty good. They also provide a MSQL DB Mark -Original Message- From: Ken Anderson <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Thursday, March 21, 2002 2:39 PM Subject: Re: JSP or PHP? >Klym wro

Error 1067: the process terminated unexpectedly

2002-03-21 Thread Simon Tienery
Can anyone help please! I am unable to start the service on WIN2K since I installed version MySQL-3.23.38. I have tried altering the my.cnf and my.ini files and I have tried running the service as the administrator user. But I am getting the same error message above each time. Any suggestions

Re: Getting Found Count When Using Limit

2002-03-21 Thread Fletcher Sandbeck
On 3/21/02 at 12:51 PM, Allon Bendavid wrote: > Tough thing to do. Fortunately we thought this through for you in jTalk. > Keep your eyes peeled for a formal announcement next week. Actually, easy thing to do through the APIs or most third-party languages that let you access MySQL. I'm looking

Re: Status of InnoDB support.

2002-03-21 Thread Heikki Tuuri
Gabriel, MySQL-Max-3.23 is now officially stable both in the opinion of MySQL AB and Innobase Oy. It is listed as stable both in the MySQL online manual and on the MySQL AB website front page. The reason for separate MySQL-3.23 and MySQL-Max-3.23 is commercial: there are different support and em

Re: Access denied on use mysql;

2002-03-21 Thread alan4100
mysql Kathy.. Check version of mySQL for me. Did you said after typing mysql -u root -p, you get in fine? Then you type mysql? then access denied... Is this in a sequence? - Original Message - From: "Kathy Reyes" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]>; "mysql" <[EMAIL

RE: Error 1067: the process terminated unexpectedly

2002-03-21 Thread Gregory Junker
have you tried running the server in standalone from the command prompt, to get some more output from the startup sequence? > -Original Message- > From: Simon Tienery [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 21, 2002 4:40 PM > To: [EMAIL PROTECTED] > Subject: Error 1067: the pro

  1   2   >