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

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

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,

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 down

show all running queries on linux

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

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

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: 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

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

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: mysql@lists.mysql.com Sent: Thursday, March 17, 2005 5:53 PM Subject: Re: Ms Sql unique identifier field

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

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

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

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

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

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)

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

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 temporary

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 into the

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 mySQL

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 and

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 string LIKE % woord % so i need the fields in the table which fit into the string i submit. example:

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

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

RE: Help with LIKE

Maybe you better do something like: SELECT * FROM woorden WHERE % woord % LIKE string -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

Re: 5.0.2 alpha crashes with Query Browser

imminent Dictionary imminent (m'-nnt) adj. About to occur; impending: in imminent danger. - Original Message - From: "Lily Wei" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "Francisco Tapia" [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, March 17, 2005 11:47 AM Subject:

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

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)

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

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

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

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

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 SET

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

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

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 CREATE

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 variableInfo SET

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

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

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: 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

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

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

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 tbody/tbody tags disappeared online. In other words, I didn't just lose everything related to PHP/MySQL, I

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 are

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

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

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 all the

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.NET

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 this

Re: Help with LIKE

Hi Mevers, SELECT * FROM woorden WHERE string 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:

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,

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.