RE: MySQL Help Needed Please

Well, I read, played around and updated it (I guess) Now, when I try to start mysql with this command (same as before), it gives me that: # /usr/local/bin/safe_mysqld --user=mysql & [1] 71491 # Starting mysqld daemon with databases from /usr/local/var 030104 23:01:55 mysqld ended [1]Done

Re: mysqldump ERROR 1064

On Sun, 2003-01-05 at 00:00, David & Angela Ehmer wrote: > Hi > > I am having problems generating the mysqldump file. I have tried a range of > options and carefully studied several tutorials I have on using this > command. Each time I get the following errror. > > ERROR 1064 you have an error

Re: Full text search

full text search is different than pattern match. If you want to return stef, you have to use pattern match. Qunfeng --- "Steffan A. Cline" <[EMAIL PROTECTED]> wrote: > Am I missing something on mysql full text search? > > > I was using a simple statement like > select firstname from contacts

mysqldump ERROR 1064

Hi I am having problems generating the mysqldump file. I have tried a range of options and carefully studied several tutorials I have on using this command. Each time I get the following errror. ERROR 1064 you have an error in your SQL syntax near 'mysqldump -u root -p adrienne netno_db >sql.du

Optimize Table usage

Hello, I am trying to write a process to optimize several tables in a database by using the OPTIMIZE TABLE command in a query. I have a couple of questions that I can't get an answer to in the documentation: 1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE TableName command? 2)

Unistall Source

Hi. How do I unstall a source tarball (tar.gz) of mySQL? (or any prog for that, I need to uninstall Emacs too) I installed Mysql-3.23.51, but the install docs dont seem to work for that, and I finally found a working src for .54, so I wanna take out the old one. Thanks in advance Tyler

Full text search

Am I missing something on mysql full text search? I was using a simple statement like select firstname from contacts where match(firstname,lastname) against ('steffa'); I am actually looking for "steffan" but wanted to see what it would return. Now, if I search for the full name "steffan" it fin

Question - SELECT

How do I correct this SQL code: 2 tables there, lcopen: id, bank, unit_price_us, order_cbm lcreceive: id, amount_us, due_date SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where lcreceive.due_date < current_date AS receive, # # the abo

Re[2]: Access control lists on rows?

if MySQL implemented db view objects.. then this functionality could be done.. Could create a view as select * from table where then grant a user access to the View, not the table so they can only get the filtered resultset. This is how some larger db systems, like Oracle do it. I forget

Re: How to Unlock a row?

At 7:07 +0800 1/5/03, Clyde wrote: Clyde, - Original Message - From: ""Clyde"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, January 04, 2003 11:47 AM Subject: How to Unlock a row? Hi, Using MySql with InnoDB files you can lock rows for update. Eg select *

[ANNOUNCE] Struts Training in NYC and DC in January

Increase Your Struts Productivity - Attend the BaseBeans Public Struts Training We have a 11 hour public class in DC and in NYC in January. Washington DC Class -- January 18th 2003 NYC Class -- January 24th 2003 This class is taught by baseBeans Engineering, the company voted to have the be

Re: How to Unlock a row?

Clyde, - Original Message - From: ""Clyde"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, January 04, 2003 11:47 AM Subject: How to Unlock a row? > Hi, > > Using MySql with InnoDB files you can lock rows for update. > Eg select * from customer where cusomerID=1 f

Re: Access control lists on rows?

At 14:39 -0800 1/4/03, Steven Nakhla wrote: I know I can restrict a user's access to a table with the GRANT command. However, is there any way to restrict a user's access to individual rows within a table? Not with MySQL's grant tables. You have to control this kind of thing through applicatio

Access control lists on rows?

I know I can restrict a user's access to a table with the GRANT command. However, is there any way to restrict a user's access to individual rows within a table? For example, if I were using a SQL table to hold binary data (utilizing it like a filesystem, for example) could I restrict a user from

Re: How to Unlock a row?

Clyde, - Original Message - From: ""Clyde"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, January 04, 2003 11:47 AM Subject: How to Unlock a row? > Hi, > > Using MySql with InnoDB files you can lock rows for update. > Eg select * from customer where cusomerID=1 f

Re: MySQL Help Needed Please

Anton, >ps -ef | grep mysqld >got nothing Because the MySQL SERVER isn't running! >Though I can do: ># mysql -u root -p With this command, you start the MySQL Monitor (that's the SQL command line CLIENT tool that comes along with MySQL) and tell it to connect to a MySQL SERVER running on localh

RE: Hiding the password

Unless someone else knows differently I don't think any amount of know-how from a visitor to the site will allow them to view the script itself unless some mishap happened to the web server and it stopped parsing the script and just diplayed the contents or if it didn't recognize the tags for some

RE: MySQL Help Needed Please

Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin)

second response to Larry Brown's second post for general perusal andcomment

Hi! (for filter: Mysql queries query longint) Oh no, the people who log in cannot modify scripts. That would be suicide. . . They log via something I made that maintains an md5 hash (quite a long one) which is their "log-in flag" maintained via a cookie while they are logged in. It also requi

Re: MYSQL + ASP Getting Started

If you're asking what I think you're asking, no. You can't store your MySQL queries the way you can with Access or SQLServer (views/stored procedures). Your ASP scripts have to build the queries they need by themselves. -bill John Berman wrote: Hi I have on line access databases and I query t

RE: Hiding the password

When someone hits a php page the server runs the script executing the login and password and just sends results to the users. (unless I'm mistaken) So the user can't see that login name and password. If they view the source it just shows the html the script generated. So is the application you

Re: response to Larry Brown copied for general info. . .

Hi! (MySql, sql, queries for filter) I may be misunderstanding some things. Here is what I am thinking and doing. I believe that people can find out my id and password because I use scripts to permit people to enter information or delete information. I have a little housing registry and also a

RE: Russian in MySQL ?

Yeah, that's what I meant to say ;-))) Best Regards, Anton -Original Message- From: Konstantin Sorokin [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 11:49 AM To: [EMAIL PROTECTED] Subject: Re: Russian in MySQL ? On Sat, Jan 04, 2003 at 11:17:41AM -0800, Anton Zavrin wrote

RE: Hiding the password

First, why are we conceding that "everyone can find out your id and password"? Your hosting company has your site separated from other customers' sites right? So we are just talking about the development team for your site being privy to this information. Second, if you are referring to the staf

Re: Hiding the password

- Original Message - From: "wcb" <[EMAIL PROTECTED]> To: "Mark" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 7:51 PM Subject: Re: Hiding the password > It isn't at all difficult to grasp. Please carefully (and exercising a > certain amount of patience)

Re: Russian in MySQL ?

On Sat, Jan 04, 2003 at 11:17:41AM -0800, Anton Zavrin wrote: > I don't know about UTF-8, but most Russian web sites run Cyrillic > Windows encoding or KOI8-R ^ cp1251 (aka windows-1251) you mean ? :) among MySQL charsets it is known to be cp1251. -- Konstantin Sorokin

RE: Hiding the password

In perl, a. setup dsn in a separate module (sep.pm) with a method "connect(parameters to setup db...)" make sure the directory is not under the webserver doc path sub connect { return (DBI->connect ($dsn, "$user","$pass", {

root is missing after RPM installation

MySQL 3.23.54a RedHat 7.3 Hi All, the RPM installation script indicates that the password for 'root' should be setup via 'mysqladmin -h root password 'new_password_here'' but I cannot connect with user 'root'. It's look like 'root' is not created by the installation. 'test' works fine, ie mysql

RE: Russian in MySQL ?

I don't know about UTF-8, but most Russian web sites run Cyrillic Windows encoding or KOI8-R If you need some help with translation or writing on Russian using English characters let me know... Best Regards, Anton -Original Message- From: Paul Reilly [mailto:[EMAIL PROTECTED]] Sent: Sa

Russian in MySQL ?

I have a website which gets data from MySQL. The website is in several languages. I'm now working on Russian, and we have the translations, but I can't seem to get it into MySQL. I have a few questions which I hope someone can help with: 1) I see from research I must run another instance of MyS

Re: aide

Demba, the list language is English, so please don't post in French. I will try to answer your question, anyway. > Que dois je faire pour lancer MYSQL afain de > l'utiliser sans problème sous Windows 98. Did you make sure that the MySQL _server_ is up and running? The error you're reporting is

Re: is it a bug?

Luca, > the result was: ",1,2,.,n". > but today doesn't works anymore > now the result is ".n" where n is the last max(id) value in the result set. I did a similar query on this table; mysql> DESCRIBE gehalt; +---+--+--+-+-+---+ | Field | Type

Re: Hiding the password

It isn't at all difficult to grasp. Please carefully (and exercising a certain amount of patience) read my post and the previous post upon which my post was based. We are acknowledging that EVERYONE can find out your id and password. The question reformulated is: "Given that one's MySql environ

Re: Hiding the password

- Original Message - From: "wcb" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 6:41 PM Subject: Re: Hiding the password > Perhaps gurus can comment on what I'm suggesting here - if the database is > set up so that only "localhost" can access it, then

Re: Hiding the password

Hi! Perhaps gurus can comment on what I'm suggesting here - if the database is set up so that only "localhost" can access it, then you can use a php or PERL script to allow people from elsewhere to cruise in and make queries as your script allows. As long as your script is set up to be secure (fo

transaction support in mysql3.23.54-win

hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is "transactions not supported". please advice me on how i

mysqlbug

platform. OSX 10.2 ( jaguar) when I try to compile the source distro, i get: sql_udf.cc:57:19: dlfcn.h: No such file or directory sql_udf.cc: In function `void init_syms(udf_func*)': sql_udf.cc:88: `dlsym' undeclared (first use this function) sql_udf.cc:88: (Each undeclared identifier is report

Re: Hiding the password

It is exactly the same thing with a PHP script. If someone has and account on that server, they can login and read the php file. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: "Brent Bailey" <[EMAIL PROTECTED]> To: "Benjamin Pflugmann" <[E

Re: Hiding the password

Well, I guess the best solution would be to use a Windows server. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Octavian Rasnita" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, De

Re: comparision in the datetime field

Use: select * from table where date_col between 'xxx' and 'yyy'; You need to replace XXX and YYY with the dates you want like '2003010430' for January 04, 2003, 11:11:30. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: "aman raheja" <[

aide

Bonjour Messieurs, J'ai téléchargé MYSQL a partir d'Internet et j'ai installé sous Windows 98 en monoposte (pas de réseau). Quand je lance C:\MYSQL\BIN\MYSQL.EXE, j'obtiens l'erreur suivante : ERROR 2003: Can't connect to Mysql server on 'localhost' (10061). Que dois je faire pour lancer MYSQL

Re: MySQL Help Needed Please

Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49

is it a bug?

hello, I have a problem in mysql 4.0.7 this piece of code worked until version 4.0.4 SELECT @ID:=''; SELECT @ID:=CONCAT(@ID,',',MAX(ID)) FROM WF_Users GROUP BY GUID; SELECT @ID; the result was: ",1,2,.,n". but today doesn't works anymore now the result is ".n" where n is the last max(id) va

Re: Field \ Table Types - Beginner

John, > My data is made of Names, Dates and occasionally images. From the web > side the vast majority of queries will be made on the surname so I'm > thinking that I should create a full text index on the surname field ? > as that will enable fast searching on the field ? You will only want to d

Re: LOAD DATA LOCAL

Egor, >> Any hints how to make LOAD DATA LOCAL work in spite of this >> "improvement"? > Stefan, currently I have no Windows box on hands, to check it out on Win32, but I > remember that it works for me at least on 4.0.6 with local-infile=1 in > my.cnf. as far as I remember from MySQL trainings

Re: auto increment question

Kevin, > I have a table with an ID column and a viewed column. I would like the > viewed column to increment by one each time the row is updated. > Stats > === > ID > views UPDATE Stats SET Views = Views + 1 WHERE ID = (selected row) Or is there more behind this question? Regards, -- Stef

Re: PHP and MySQL bug

Nuno, > $r=MYSQL_QUERY("SELECT n,u,m,h FROM d WHERE id='$id'"); > > /* Some code including "mysql_num_rows" and "mysql_fetch_array($r, > MYSQL_NUM)" > And the another query: > */ > > MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); > > /* i don't know why but this doesn't work!*/ It doesn't wor

Field \ Table Types - Beginner

Hi Well I searched the web for answers first but there is so much its hard to know were to start I'm creating a Genealogical Database and want to start right and ensure my basic table and fields are correct (I see that I can a large variety of table types) My data is made of Names, Dates and occ

re: comparision in the datetime field

At 15:07 +0200 1/4/03, Egor Egorov wrote: On Friday 03 January 2003 19:25, aman raheja wrote: I have a datetime field in one of my tables in the MySQL database. Can I do something like return all records between two certain dates, say between Nov 02, 2002 and Nov 07, 2002. SELECT .. WHERE m

Re: LOAD DATA LOCAL

Jon, thanks for trying to help! > Not much help I know, but you are not the only person having this problem. Okay, all you striving folks from MySQL on this list! When are you going to solve this? (The LOCAL feature is not essential to me, but it's a pain in the neck to encounter issues like thi

Re: Re: Order by does not use an index when it should.

On Sat, Jan 04, 2003 at 03:25:00PM +0200, Victoria Reznichenko wrote: > On Saturday 04 January 2003 14:53, harm wrote: > > > > Your order by will not use your weg_2 index because, as you stated, > > > weg_2 index is on (col1, col2, col3, nr) as a group so it wont be used > > > for the individual c

RE: PHP and MySQL bug

I'd like to try and see if I can find the problem as I write with PHP for MySQL quite a bit. However, without the specifics of how the script is running as is, I can't tell where the problem is. Write a quick script in complete detail that does what your post is doing and I'll look for anything.

re: Re: Order by does not use an index when it should.

On Saturday 04 January 2003 14:53, harm wrote: > > Your order by will not use your weg_2 index because, as you stated, > > weg_2 index is on (col1, col2, col3, nr) as a group so it wont be used > > for the individual columns as you need > > > > try to create a separate index on just the nr column,

Re: auto increment question

Yes you have neither triggers or stored procedures. Instead you'll have to remember to use the same code everywhere in your app that can update the table: Update mytable SET col1 = 'somevalue', col2 = 3456, col3 = now(), Viewed = Viewed + 1 hth, Arthur - Original Message - From:

re: deleting tables with same prefix !

On Friday 03 January 2003 19:14, aman raheja wrote: > How can I delete all tables starting with prefix 'abc' in the MySQL > database (there > are about 200 such tables). > Wild cards? Nope. You should use list of all tables in the DROP TABLE command if you want to do it only with MySQL. > Or if

re: How to Unlock a row?

On Saturday 04 January 2003 11:45, Clyde wrote: > Using MySql with InnoDB files you can lock rows for update. > Eg select * from customer where cusomerID=1 for update > > I assume these locks are release when the the records selected are actually > updated (or the connection is terminated). But ho

re: LOAD DATA LOCAL

On Friday 03 January 2003 22:38, Stefan Hinz wrote: > I use 4.0.7-max-nt on a Win2K box, and whatever I do, I cannot use LOAD > DATA LOCAL (keep getting error 1148). I tried: > > - Starting the server with --local-infile=1, and with --local-infile. > - Starting the mysql client with --local-infile

re: comparision in the datetime field

On Friday 03 January 2003 19:25, aman raheja wrote: > I have a datetime field in one of my tables in the MySQL database. > Can I do something like return all records between two certain dates, say > between Nov 02, 2002 and Nov 07, 2002. SELECT .. WHERE mydatefield BETWEEN '2002-11-02 00:00:00' A

Re: Order by does not use an index when it should.

On Fri, Jan 03, 2003 at 08:24:17PM -0500, Brian Lindner wrote: > harm, > > Your order by will not use your weg_2 index because, as you stated, > weg_2 index is on (col1, col2, col3, nr) as a group so it wont be used > for the individual columns as you need > > try to create a separate index on ju

PHP and MySQL bug

Dear Sirs, I'm using PHP and MySQL to make my programs. But I think I discovered a bug in PHP or in MySQL (I don't know!). In one of my files I have the following: MYSQL_CONNECT("localhost", "**user**", "**pass**"); mysql_select_db("be"); $r=MYSQL_QUERY("SELECT n,u,m,h FROM d WHERE id='$id'");

RE: MYSQL + ASP Getting Started

Hi I have on line access databases and I query them using ASP - I often create the initial in the access dbase and then use asp on the query and again this method works well. I have recently upgrade the database format to mysql but am still using ASP which I assume is ok ? Can I create queries w

How to Unlock a row?

Hi, Using MySql with InnoDB files you can lock rows for update. Eg select * from customer where cusomerID=1 for update I assume these locks are release when the the records selected are actually updated (or the connection is terminated). But how do you release these record locks if you do not w

RE: MySQL Help Needed Please

I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[EM