Re: [MySQL] mysql/snort/webmin/permissions

Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. -- H | I haven't lost my mind; it's backed up on tape somewhere. +-

mysql/snort/webmin/permissions

Hi All, coupla questions. 1stly, I can access mysql from webmin and start it, along with being able to start/stop with service mysql start/stop from cli. I'm also following this tutorial, by Patrick Harper, http://216.239.57.104/search?q=cache:GHt0q9MF1coJ:www.infosecwriters.com/text_resources/p

Re: Help with LIKE

Hi Mevers, SELECT * FROM woorden WHERE LIKE % woord % It's not going to be efficient (at all) but you can do: SELECT * FROM woorden WHERE "foo" LIKE CONCAT('%', woord, '%') Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http:

Re: update a field with multiple value

Hello. > but what I want to do is UPDATE variableInfo SET variable='A, B' >WHERE variable is null; > when I use that command, mysql does not understand the syntax. >How to update a field with multiple value or with an array? Multiple values could hold the SET columns, But I think that th

Re: show all running queries on linux

Hello. See: http://dev.mysql.com/doc/mysql/en/show-processlist.html > How can I see the running queries on a linux comp? > "Reinhart Viane" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.N

Re: Replicating InnoDB tables in new database

Hello. See: http://dev.mysql.com/doc/mysql/en/moving.html "Andy Hall" <[EMAIL PROTECTED]> wrote: > Hi, > > I have tried the following process in order to try and replicate a database > with InnoDB files: > > 1. created a new database in PHPMyAdmin > 2. via command line, copied a

Re: Converting Integer values to date type

I got it working , thank you. I only could do what I wanted to do in multisteps however. I couldn't figure out the nested querying , and it's bugging me. Here's how I issued it. mysql> update tableDummy set newDate=(select str_to_date('(concat(DayVal,".",MonthVal,".",YearVal))','%d.%m.%Y')); And a

Re: Ghost Table

Please ignore this thread; I suddenly stumbled over the solution, even if I can't explain it. :) __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For

Re: Converting Integer values to date type

In the last episode (Mar 18), Mahmoud Badreddine said: > Hello, > I have a table with separate integer values for the day, month and year. > I would like to group them all under one field of type date. > I tried a few commands but I haven't captured the right syntax yet. > > so if the field names

Ghost Table

I've spent the last few days modifying my website, and when I published my files online, one of my tables was knocked out of commission. It was really bizarre - everything between the tags disappeared online. In other words, I didn't just lose everything related to PHP/MySQL, I couldn't even see

ERROR 2013: Lost connection to MySQL server during query

I've tried looking up this error code on www.mysql.org & via Google. I'm not sure it matters but if you look closely at the SQL below, you can see it is working on file "page_path.tab4". It has already successfully loaded files page_path.tab1 thru page_path.tab3 I seriously could use a CLUE on

Converting Integer values to date type

Hello, I have a table with separate integer values for the day, month and year. I would like to group them all under one field of type date. I tried a few commands but I haven't captured the right syntax yet. so if the field names are dayVal,monthVal and YearVal in talbeDummy I am doing the follo

Re: stopping server from pid file error

On Fri, Mar 18, 2005 at 11:02:50AM -0600, sharif islam wrote: > # mysqld_safe > Starting mysqld daemon with databases from /var/lib/mysql > STOPPING server from pid file /var/lib/mysql/mymachine.pid > 050318 11:01:31 mysqld ended > > [EMAIL PROTECTED] mysql]# ls -la /var/lib/mysql > total 40 > dr

Re: long PHP mysql_connect times [Resolved]

Hi Dan, It was the lack of a reverse DNS entry. I had the host resolved to an IP but now reverse arpa entry. I added the DNS PTR record and viola! Excellent. Also FWIW, you're not gaining anything by disconnecting after each query in your PHP code. Connect once at the beginning of the script,

Re: long PHP mysql_connect times [Resolved]

Thanks Jeremy! It was the lack of a reverse DNS entry. I had the host resolved to an IP but now reverse arpa entry. I added the DNS PTR record and viola! I would have never though of / figured that one out. Dan T On Mar 18, 2005, at 10:59 AM, Jeremy Cole wrote: Restating apache resets the issue

Re: long PHP mysql_connect times

Restating apache resets the issue i.e. the next pconnects takes 5 seconds. Quitting the browser has no effect. I am currently testing now to see if there is a time out issue i.e. if I wait 5 minutes will the delay reappear? FWIW, this sounds like a slow-to-respond DNS resolver. Are Apache an

Re: update a field with multiple value

Eko Budiharto <[EMAIL PROTECTED]> wrote on 03/18/2005 11:54:09 AM: > > Hi, > I am trying to to update one field with multiple value. > I tried with regulare "update" command syntax does not work. How to > update a field with multiple value. > > regular update syntax is this, UPDATE variableInf

Re: help on query/group by

"mel list_php" <[EMAIL PROTECTED]> wrote on 03/18/2005 10:35:30 AM: > Hi again, > > Thanks for the explanation about the join and the group by. > > I wanted to test your query (almost a simple copy/paste :-)) ). > > The first 2 queries are ok, but the third one still is too long : > mysql> CREA

Re: Replicating InnoDB tables in new database

On Mar 18, 2005, at 7:06 AM, Andy Hall wrote: Hi, I have tried the following process in order to try and replicate a database with InnoDB files: 1. created a new database in PHPMyAdmin 2. via command line, copied all the .frm files from the old database directory into the new database directory 3

stopping server from pid file error

# mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/lib/mysql/mymachine.pid 050318 11:01:31 mysqld ended [EMAIL PROTECTED] mysql]# ls -la /var/lib/mysql total 40 drwxrwxr-x 4 mysql mysql 4096 Mar 18 10:54 . drwxr-xr-x 22 root root 4096 F

Re: update a field with multiple value

Eko Budiharto <[EMAIL PROTECTED]> wrote on 18/03/2005 16:54:09: > > Hi, > I am trying to to update one field with multiple value. > I tried with regulare "update" command syntax does not work. How to > update a field with multiple value. > > regular update syntax is this, UPDATE variableInfo S

Re: long PHP mysql_connect times

On Mar 18, 2005, at 4:16 AM, Daniel Hawker wrote: Curiouser and curiouser said Alice... When you say *it seems to be the first connect* do you mean in a page, ie the first connect/disconnect takes ages but then any subsequent connects are fine) Exactly. If I use pconnect the first one takes on ave

update a field with multiple value

Hi, I am trying to to update one field with multiple value. I tried with regulare "update" command syntax does not work. How to update a field with multiple value. regular update syntax is this, UPDATE variableInfo SET variable='A' WHERE variable is null; but what I want to do is UPDATE var

MySQL SNMP OIDs

[ This is my second e-mail, the first I forgot to CC me. Please CC me, I am not subscribed ] Are there SNMP OIDs avialble to get MySQL qps, inserts ps, etc? Luis -- GnuPG Key fingerprint = 113F B290 C6D2 0251 4D84 A34A 6ADD 4937 E20A 525E pgppLI1O5jxLy.pgp Description: PGP signat

MySQL SNMP OIDs

Are there SNMP OIDs available I can use to query MySQL qps, inserts ps, etc? Luis -- GnuPG Key fingerprint = 113F B290 C6D2 0251 4D84 A34A 6ADD 4937 E20A 525E pgp7JOjsc3R2E.pgp Description: PGP signature

RE: Erroneus column using MAX() and GROUP BY

You could probably use a subquerry to backtrack the clienthistory_id. SELECT v.clienthistory_id, (SELECT MAX(historyvlan_time), historyvlan_vlan FROM pe_historyvlan as v join pe_clienthistory using (clienthistory_id)

Re: show all running queries on linux

In the last episode (Mar 18), Reinhart Viane said: > How can I see the running queries on a linux comp? "SHOW [FULL] PROCESSLIST". And you don't need to be running Linux; it's a standard mysql command. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list arch

Re: 5.0.2 alpha crashes with Query Browser

ï imminent Dictionary imÂmiÂnent (Äm'É-nÉnt) adj. About to occur; impending: in imminent danger.   - Original Message - From: "Lily Wei" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Francisco Tapia" <[EMAIL PROTECTED]> Cc: Sent: Thursday, March 17, 2005 11:47

RE: Help with LIKE

Maybe you better do something like: SELECT * FROM woorden WHERE % woord % LIKE -Oorspronkelijk bericht- Van: Mevershosting.nl [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 18 maart 2005 16:11 Aan: mysql@lists.mysql.com Onderwerp: Help with LIKE Dear list, I need some help on this, I hav

Re: help on query/group by

Hi again, Thanks for the explanation about the join and the group by. I wanted to test your query (almost a simple copy/paste :-)) ). The first 2 queries are ok, but the third one still is too long : mysql> CREATE TEMPORARY TABLE tmpSynDrug( KEY ( nameID (20)) ) SELECT nameID, max( syn ) AS d

Different Tables in different drives and directories?

I have a need *ideally* to take the MySQL tables that I have and put certain ones in other directories and/or drives. I'd like to put certain tables within a client sub directory and thereby provide access to download the raw files and do such on a user by user basis by placing the tables belon

Help with LIKE

Dear list, I need some help on this, I have a DB with one table The table (woorden) contains 1 field (woord) varchar(255) What i would like to be able to do is. SELECT * FROM woorden WHERE LIKE % woord % so i need the fields in the table which fit into the string i submit. example: The st

Re: Help with a JOIN query please

"shaun thornburgh" <[EMAIL PROTECTED]> wrote on 03/17/2005 06:46:22 PM: > Hi, > > I have ( among others ) three tables in my database: Claims, Expenses and > Mileage. A claim can contain many expense entries and many mileage entries. > I am using the follwing query to show the total expenses

Re: 5.0.2 alpha crashes with Query Browser

that pretty much explains why it's been happening ;) Thanks :) On Thu, 17 Mar 2005 22:34:08 +0100, Martijn Tonies <[EMAIL PROTECTED]> wrote: > Francisco, > > > Maybe it's my setup... but: > > > > whenever I try to login to use the mySQL query browser, it instantlly > > turns off the 5.0.2 alpha

Re: Replicating InnoDB tables in new database

"Andy Hall" <[EMAIL PROTECTED]> wrote on 18/03/2005 12:06:30: > Hi, > > I have tried the following process in order to try and replicate a database > with InnoDB files: > > 1. created a new database in PHPMyAdmin > 2. via command line, copied all the .frm files from the old database > directory

Re: help on query/group by

Responses embedded below "mel list_php" <[EMAIL PROTECTED]> wrote on 03/18/2005 05:57:29 AM: > Hi Shawn, > > Thank you very much, I'm impressed by the time you took to answer me, and > the quality of the reply!!! > I forwarded the answer to my friend. > I'm wondering, I knew the mechanism of t

Re: Re: lost connection DURING query?

  Hi , You can try one simple thing. Wherever in ur code u try to run mysql_query(), check the last error value using mysql_errno(). If the value is 2013, then connect to the mysql server again and try running mysql_query again. I hope this solution works for u. Regards, Sapna On Fri, 18 Ma

Optimize JOIN for more speed speed

Dear MySQL-ians, I am running a query on our database that join several tables. All tables have 2421500 rows and can be joined based on their id. SELECT a.id, a.B_00_29, b.R_00_29, c.NIR_00_29, d.SWIR_00_29 FROM vgt.B as a INNER JOIN vgt.R as b using (id) INNER JOIN vgt.NIR as c using (id) INNER

Re: Ms Sql unique identifier field

There is the UUID() function (added in 4.1.2). http://dev.mysql.com/doc/mysql/en/miscellaneous-functions.html However you cannot make a field's DEFAULT value a function (yet) so you will need to use UUID() in your INSERT and UPDATE statements where appropriate. Shawn Green Database Administrat

Replicating InnoDB tables in new database

Hi, I have tried the following process in order to try and replicate a database with InnoDB files: 1. created a new database in PHPMyAdmin 2. via command line, copied all the .frm files from the old database directory into the new database directory 3. changed all the ownership and permissions 4.

Re: show all running queries on linux

Reinhart Viane wrote: How can I see the running queries on a linux comp? If you have a fairly standard config, with a log file defined -- prompt> grep '^log=' /etc/my.cnf | sed 's/log=//g' | xargs tail -f If there's no log file in /etc/my.cnf, start by putting one there :-) HTH! -- Hassan Schroeder

Re: lost connection DURING query?

Hi; I'm using Apache 2.0 + MySQL 4.1 + PHP 4.3.10 for a site. The database server and web server are on different machines. I get this Error "lost connection DURING query" when I try to access some of the web Pages. I have been through this thread. http://lists.mysql.com/mysql/181322 I tried

Which one of these two queries would be fastest?

Assuming everything is properly indexed. (1) INSERT INTO my_table_1 (field1, field2) SELECT DISTINCT field1, field2 FROM my_table_2; or (2) INSERT IGNORE INTO my_table_1 (field1, field2) SELECT field1, field2 FROM my_table_2; Is there anything to say about this in a general sense, or does it al

Re: Ms Sql unique identifier field

AUTO_INCREMENT is not the same as newid(). Frankly, something like newid() would be very useful in MySQL. -- Chris. - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Thursday, March 17, 2005 5:53 PM Subject: Re: Ms Sql unique identifier field Hello. You should

Re: Authenticating a User to MySQL

Hello. See: http://dev.mysql.com/doc/mysql/en/access-denied.html Asad Habib <[EMAIL PROTECTED]> wrote: > I just installed MySQL 4.1 on Mac OS X Panther Client. I am now having > trouble authenticating users(root, admin) to MySQL. I am able to start > MySQL but not using a specific

Re: Ms Sql unique identifier field

Hello. You should think about AUTO_INCREMENT. See: http://dev.mysql.com/doc/mysql/en/example-auto-increment.html [snip] Hi! i have a question: FIELD IN MS SQL SERVER FiledName: uiAutID DataType: unique identifier DefaultValue: newid() how i can describe the some colu

Re: Help with a JOIN query please

Hello shaun, May be with subselects you can do what you want: SELECT C.*,(select SUM(E.Amount) from Expenses E where E.Claim_ID = C.Claim_ID)AS Amount, (select SUM(M.Mileage) from Mileage M where M.Claim_ID = C.Claim_ID) AS Mileage FROM Claims C WHERE C.Claimant_ID = '1' st> Hi, st> I have

Re: help on query/group by

Hi Shawn, Thank you very much, I'm impressed by the time you took to answer me, and the quality of the reply!!! I forwarded the answer to my friend. I'm wondering, I knew the mechanism of temporary tables, but as I've never used it I was trying the left join way. Here is a summary of my questions

show all running queries on linux

Hey list, How can I see the running queries on a linux comp? Thx Reinhart

Re: Problem: Slow "LOAD FILE" performance with innodb

Andreas, - Original Message - From: "Andreas Ahlenstorf" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, March 18, 2005 11:47 AM Subject: Re: Problem: Slow "LOAD FILE" performance with innodb Heikki Tuuri schrieb: Creating the indexes after the import will only slow

Help with a JOIN query please

Hi, I have ( among others ) three tables in my database: Claims, Expenses and Mileage. A claim can contain many expense entries and many mileage entries. I am using the follwing query to show the total expenses and mileage per claim for a particulare user: SELECT C.*, SUM(E.Amount) AS Amount, S

Re: Problem: Slow "LOAD FILE" performance with innodb

Heikki Tuuri schrieb: > Creating the indexes after the import will only slow down the operation. > MySQL recreates the whole table at CREATE INDEX. That's new to me, but good to know (always this urban legends...). Does that only apply to InnoDB or to MyISAM too? Regards, A. -- MySQL General

RE: Authenticating a User to MySQL

Hi Asad, Do not put a space between the -p and password. You don't have to put the password in on the command line as the mysql client will prompt you for it. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417