Re: help needed restoring crashed mysql

Am 30.11.2011 07:02, schrieb Hal?sz S?ndor: > 2011/11/29 23:19 +0100, Reindl Harald > MY only luck is that i recognized this years ago after PLAYING > with innodb and so i started with "innodb_file_per_table=1" from > the begin with the first production database > > And are then

Re: help needed restoring crashed mysql

2011/11/29 23:19 +0100, Reindl Harald MY only luck is that i recognized this years ago after PLAYING with innodb and so i started with "innodb_file_per_table=1" from the begin with the first production database And are then the table-files in the directories with "frm", or in

Re: help needed restoring crashed mysql

Am 30.11.2011 03:13, schrieb Karen Abgarian: > The concept is not difficult to explain. Most people do not expect a gas > tank > to shrink once the gas is consumed...right? yes, but the hard-disk is the gas tank and the data are the gas and yes, normally everybody would expect after deleting

Re: help needed restoring crashed mysql

>>> Hi... and some more stuff inline. >> >> Well, I would not base my database design on luck and playing. There >> should be good awareness >> of what the features do and what would be the plan to deal with file >> allocations should the database >> grow, shrink or somerset > > if you

Re: help needed restoring crashed mysql

Am 30.11.2011 01:11, schrieb Karen Abgarian: >> MY only luck is that i recognized this years ago after PLAYING >> with innodb and so i started with "innodb_file_per_table=1" from >> the begin with the first production database > > Well, I would not base my database design on luck and playing.

Re: help needed restoring crashed mysql

On Nov 29, 2011, at 11:50 AM, Claudio Nanni wrote: > > This is not to say that MySQL could not have more of the file management > features. For example, the ability to add or remove datafiles on the fly and > the > ability to detach tablespaces as collections of tables. > > That's where MySQ

Re: help needed restoring crashed mysql

Hi... there is stuff inline there. >> The logic behind this is probably that without innodb_file_per_table=1 >> and with several large ibdata files, the space IS freed up when one does >> optimize table or drop table. The space is freed up inside the database >> files and can be reused. > >

Re: help needed restoring crashed mysql

Am 29.11.2011 20:25, schrieb Karen Abgarian: > > On 29.11.2011, at 5:21, Reindl Harald wrote: >> why is this dumb "innodb_file_per_table=0" default since MOST PEOPLE >> have only troubles with it because they can not free space with >> "optimize table" with no real benefits? > > The logic behind

Re: help needed restoring crashed mysql

> > > This is not to say that MySQL could not have more of the file management > features. For example, the ability to add or remove datafiles on the fly > and the > ability to detach tablespaces as collections of tables. That's where MySQL(read InnoDB) got stuck actually, it never introduced a

Re: help needed restoring crashed mysql

On 29.11.2011, at 5:21, Reindl Harald wrote: > > ibdata1 does NEVER get smaller, this is normal and a hughe problem > in your case, only if you are using "innodb_file_per_table" which > is NOT default would retire the space after drop tables > > why is this dumb "innodb_file_per_table=0" defaul

Re: help needed restoring crashed mysql

Am 29.11.2011 14:08, schrieb Luis Pugoy: > Hello. I have the following problem. > > I was importing a large database to mysql using mysqldump. Unfortunately this > filled up the whole disk, and > mysqldump exited with an error that the table it is currently writing to is > full. Checking df -h

Re: Help needed with what appears to be a corrupted innodb db

Pito, can u show us the innodb parameters in the my.cnf file. regards anandkl On Sat, Jan 8, 2011 at 10:31 PM, Pito Salas wrote: > I am very new to trying to solve a problem like this and have searched > and searched the web for a useful troubleshooting guide but I am > honestly stuck. I wonde

RE: Help needed on query on multiple tables

lto:st...@astroh.org] > Sent: June 3, 2010 11:55 AM > To: Steven Staples > Cc: 'MySql' > Subject: Re: Help needed on query on multiple tables > > Thanks! That did it perfectly! > > Michael > > > On Jun 3, 2010, at 11:45 AM, Steven Staples wrote: > > &

Re: Help needed on query on multiple tables

Thanks! That did it perfectly! Michael On Jun 3, 2010, at 11:45 AM, Steven Staples wrote: > How about this? > > SELECT >`first_table`.`names` >, `first_table`.`version` >, (SELECT > COUNT(`other_table`.`names`) > FROM `other_table` >

RE: Help needed on query on multiple tables

How about this? SELECT `first_table`.`names` , `first_table`.`version` , (SELECT COUNT(`other_table`.`names`) FROM `other_table` WHERE `other_table`.`this_id` = `first_table`.`id`) AS 'count' FROM `first_table` WHERE `first_table`.`p

RE: Help needed

: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com >-Original Message- >From: Velen [mailto:[EMAIL PROTECTED] >Sent: Tuesday, May 13, 2008 11:28 AM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: Help needed > >Hi Jerry, > &

Re: Help needed

>; Sent: Monday, May 12, 2008 11:43 PM Subject: RE: Help needed > Your best bet would be to use a UUID: > > SELECT UUID(); > +--+ > | uuid() | > +

Re: Help needed

On Mon, May 12, 2008 at 8:31 AM, Velen <[EMAIL PROTECTED]> wrote: > Hi Arthur, > > Could you please tell this guy that it was not a virus and you tested it > without any problem? > One guy that is brave/crazy/stupid enough to run a binary on his machine that didn't have anything bad happen to him

Re: Help needed

I tested the program before running it and it is virus-clean. I ran it through AVG first and it's clean. I ran it in Windows. I don't know whether there is a Linux version. Arthur On Mon, May 12, 2008 at 11:31 AM, Velen <[EMAIL PROTECTED]> wrote: > Hi Arthur, > > Could you please tell this guy

RE: Help needed

Garris, Nicole [mailto:[EMAIL PROTECTED] >Sent: Monday, May 12, 2008 11:59 AM >To: mysql@lists.mysql.com >Subject: RE: Help needed > > Sorry, you can't prove uniqueness by running it against a hundred >thousand, million, or even a billion computers. (The billionth-and-first >co

RE: Help needed

EMAIL PROTECTED] Sent: Monday, May 12, 2008 8:32 AM To: Arthur Fuller Cc: mysql@lists.mysql.com Subject: Re: Help needed Hi Arthur, Could you please tell this guy that it was not a virus and you tested it without any problem? Thanks. Velen On Sat, 2008-05-10 at 20:59 +0400, Velen wrote:

Re: Help needed

ECTED] website: http://www.nusconsulting.com.au - Original Message - From: Arthur Fuller To: Velen Sent: Saturday, May 10, 2008 10:44 PM Subject: Re: Help needed On my main machine the PCID is 135184-45-4-10-1513-1. Hope it helps. Arthur On Sat, May 10, 2008 at 12:59 PM, Velen <[

Re: Help needed

On Sat, 2008-05-10 at 20:59 +0400, Velen wrote: > Hi, > > I'm testing a program and I need you assistance. > > Please unzip the file at http://www.biz-mu.com/PCID.zip and run the program. Please supply a Linux version of your virus so I can test. -- Daniel Kasak IT Developer NUS Consulting G

Re: Help needed to tune Innodb on ZFS (on Solaris)

Hi all, You can read this article, written by a SUN benchmarking guru (hi Dimitri :) ). Best regards. Web link : http://dimitrik.free.fr/db_STRESS_BMK_Part2_ZFS.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PR

Re: Help needed to tune Innodb on ZFS (on Solaris)

Il Wednesday 09 April 2008 19:40:32 Rob Wultsch ha scritto: > On Wed, Apr 9, 2008 at 5:51 AM, Nico Sabbi <[EMAIL PROTECTED]> wrote: > > The problem I have is that importing the same 7 MB sql dump > > takes 9 seconds if engine=Myisam and 98 when engine is Innodb. > > > > Is autocommit turned off? >

Re: Help needed to tune Innodb on ZFS (on Solaris)

On Wed, Apr 9, 2008 at 5:51 AM, Nico Sabbi <[EMAIL PROTECTED]> wrote: > The problem I have is that importing the same 7 MB sql dump > takes 9 seconds if engine=Myisam and 98 when engine is Innodb. > Is autocommit turned off? http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html " When import

Re: HELP needed for speeding up a query!

[ always cc the list so others can share the fix or make appropriate comments ] Nicholas Wyatt wrote: hi chris, thanks for answering! however, i do already have indexes on those columns. all my tables use the myisam storage engine. what are the differences you mentioned between these engines w

Re: HELP needed for speeding up a query!

Nicholas Wyatt wrote: Hello to all! has anybody got any ideas how i can speed up the following query? it's so awfully slow (about 1 second). the "test_item" table is the main problem. currently, it has about 108.000 entries. is it normal that it takes so long? and if it isn't, how can i optimi

Re: help needed to mount data from /var/lib/mysql

if i search for any process running i am getting following thing. [EMAIL PROTECTED] mysql]# ps -ef | grep mysqld root 18389 1 0 13:09 pts/300:00:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid mysql18422 18389 0 13:09 pts/300

Re: help needed to mount data from /var/lib/mysql

I am unable to start server after shifting to new location. i tried to start 'mysqld' but it was failed. A blank mysql.sock file is creating. Entries of log files are also not reporting any problem.

Re: help needed to mount data from /var/lib/mysql

Hi All, Thank you for u r reply. But i am unable to find my.cnf, is i need to create this file.

Re: help needed to mount data from /var/lib/mysql

Hello, You can change the MySQL data path in /etc/my.cnf by editing the configuration parameter "datadir" with new data path. Once you done the changes in my.cnf, reboot the MySQL server. Thanks, ViSolve DB Team - Original Message - From: "balaraju mandala" <[EMAIL PROTECTED]> To

Re: help needed to mount data from /var/lib/mysql

On 8/19/06, balaraju mandala <[EMAIL PROTECTED]> wrote: Hi Everybody, I need small help from you. In my Linux box i have limitation of Size in partition. I have only 5 GB space for /var. MySQL is installed in this partition only. I want to give another path like /home, where i have 120GB of spac

Re: Help Needed

If you do an INSERT and you generate an new number in an AUTO_INCREMENT field the new value generated can be retrieved using: *SELECT LAST_INSERT_ID();* You are not required to retrieve into the application and then use it back in another SQL statement... you can use user variables: *SELECT @lastG

Re: Help needed for SQL statement

Is this what you are looking for: SELECT clone_ids, COUNT(DISTINCT(gene_ids)) as count_genes FROM table_name GROUP BY clone_ids or SELECT clone_ids, COUNT(gene_ids) as count_genes FROM table_name GROUP BY clone_ids Hope this helps, Alvaro - Original Message - From: "Xiaobo Chen" <[EMAI

Re: Help needed regarding MySQL-C Libraries on Linux....

Hello. This is an output of diff user.c user.cpp. Which successfully compiles on my FC3 system using the following command: g++ user.cpp -I/usr/include/mysql -lmysqlclient I've changed the extension to 'cpp', so g++ could work with this file. Also #include was commented, and main now r

Re: Help needed regarding MySQL-C Libraries on Linux....

The same source that you compiled under VC++ may not work at all under linux. Especially since the header files will be different. Make sure you have the proper header files for linux installed. Also I did not see any linking flags during compilation. On 7/3/05, Ashok Kumar <[EMAIL PROTECTED]> wro

Re: Help needed regarding MySQL-C Libraries on Linux....

Ashok Kumar wrote: Dear Friends, I'm Ashok here. first i'll tell my sys configuration. 1.Redhat-Linux 9 2.Intel Pentium chipset 3.MySQL 4.1 with Development Libraries For this i've downloaded the MySQL4.1 under the specification "Linux x86 RPM downloads" from the site. In my system, the MySQ

RE: Help needed regarding MySQL-C Libraries on Linux....

Hi Prashanth, I'm happy to help u. i attached one 'C' code in the previous mail. just use that code for in vc++. Follow the procedure, 1.Create the new "win32 Console App." as a empty project and add the attached 'C' file to the project. 2.goto "Tools->options->Directories(tab)" and in that add

Re: Help needed with complex Query

[EMAIL PROTECTED] wrote: >>I pretty much have no idea how I can do this without nested queries (and >>to be frank not even how to do it with them) so I'd really appreciate >>any help! > > >>kind regards Philip > > > Try this as a starting point: > I think you were having two mental problems

Re: Help needed with complex Query

Unless you are keeping track of whether a widget in complete or not, there is no hope but to scan the entire table to determine if a widget is complete. That's something you don't want to do. You should mark a widget as complete when it is completed. This would mean checking if a particular wid

Re: Help needed with complex Query

Philip Lawatsch wrote: Hi, I'm trying hard to figure out how to perform a special query in mysql 4.0. I have one table "widgets" which has a column "widget-id" (int) and one column "number_of_parts" (int). And then I have another table "part_mapping" which has one column "widget-id" (int) and

Re: Help needed with complex Query

Philip Lawatsch <[EMAIL PROTECTED]> wrote on 06/06/2005 01:37:37 PM: > Hi, > I'm trying hard to figure out how to perform a special query in mysql 4.0. > I have one table "widgets" which has a column "widget-id" (int) and one > column "number_of_parts" (int). > And then I have another table "p

RE: help needed to create index

Asha <> wrote: > Is there a physical > limitation in the InnoDb table structure as to why it can't > support FullText indexes? http://dev.mysql.com/doc/mysql/en/fulltext-restrictions.html http://dev.mysql.com/doc/mysql/en/innodb-restrictions.html Peter Normann -- MySQL General Mailing List

Re: Help needed in creating primary key ,foreign key on a varchar datatype colum

I just checked the definition of CREATE TABLE in the MySQL manual and I didn't see anything that suggests that primary keys based on VARCHAR columns need to be treated differently than other column types in MySQL. However, when I tried to create

Re: Help needed in creating primary key ,foreign key on a varchar datatype colum

Dayakar, - Original Message - From: ""Dayakar"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, November 21, 2004 7:39 AM Subject: Help needed in creating primary key ,foreign key on a varchar datatype colum --=_NextPart_000_000B_01C4CFBA.91C9BA80 Content-Type:

Re: Help needed with MySQL C API-based client (segfault)

have you tried ? http://www.geocities.com/jahan.geo/mysql_c_by_example.html Ruben Safir Secretary NYLXS wrote: On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote: Hello, I need to write a simple C client for a project. I am using the MySQL C API. Attached is the code. It occassionally s

Re: Help needed with MySQL C API-based client (segfault)

On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote: > Hello, > > I need to write a simple C client for a project. I am using the MySQL C > API. Attached is the code. It occassionally segfaults with no visible > pattern. Could someone help me figure out why? Or any other comments on the

Re: Help needed with a select statement

What you want to do is "pivot your data into a crosstab report". This has been covered several times so you should be able to find more information if you search on either "pivot table", "crosstab" or "cross tab". Here's how to do it for a week's worth of dates, I will let you extend it to fit

Re: help needed!

Hi Dominic, > I think everyone is misunderstanding my problem as perhaps I didnt phrase it very well. > > I need to add a new autonumber field to my db, but I need to make sure when the numbers go into the field they are in the order of one of my other fields that is a date field. > > i.e. I have

Re: help needed!

Hi, (please reply to the list only) > Yes thanks but how do I then add a new auto number field and still keep the order? What order? What has an auto-number have to do with what order? Please explain your problem in detail - it might be completely clear to you, but we're outsiders :-) With reg

Re: help needed!

Hi, > I need to add a new auto field to my db, but I need to make sure the records are listed in order of one of the other fields first which is a date field. > > Any ideas how I do this would be greatly appreciated! "listing records" is in no particular order, unless you ask for an order. SELEC

Re: Help needed

* Unnar > I have a problem with this query > > Version MySQL 4.0.15-nt > > The query gets all articles written by author but excludes those articles > which are related to products > > SELECT DISTINCT > post.post_id, > post.title > FROM > c_posts post, > c_post_produ

Re: Help needed with MySQL C API-based client (segfault)

Here is the corrected version:) Take a look at Paul DuBois book. Don't use gets. Instead use fgets. That's safe. I didn't change your gets call:) hth, Ganbold #include #include #include #if defined(_WIN32) || defined(_WIN64) #include #endif #ifdef WIN32 #pragma comment(lib,"ws2_32") #inc

Re: Help needed with SQL...

<[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 26, 2003 10:56 AM Subject: Re: Help needed with SQL... > I've never seen opening a table twice and then doing a join back with > itself. Am I wording this correctly? Is that how to des

Re: Help needed with SQL...

> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 26, 2003 5:11 AM Subject: RE: Help needed with SQL... On 26-Feb-2003 [EMAIL PROTECTED] wrote: > Yes , I had use this query statement in my MySQL server, > But I have a qu

RE: Help needed with SQL...

On 26-Feb-2003 [EMAIL PROTECTED] wrote: > Yes , I had use this query statement in my MySQL server, > But I have a query about it. > Why are you use "WHERE a.groupname=b.groupname AND members.id=b.memberid > AND a.memberid=1"? > Can you give me a explain or give me a advise! > Sure. mysql> SELE

RE: Help needed with SQL...

From: Don Read [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 4:05 PM To: M Wells Cc: [EMAIL PROTECTED] Subject: RE: Help needed with SQL... On 26-Feb-2003 M Wells wrote: > Hi All, > > I'm having problems creating a query to return a recordset from the > following

RE: Help needed with SQL...

On 26-Feb-2003 M Wells wrote: > Hi All, > > I'm having problems creating a query to return a recordset from the > following situation: > > I have two tables, one which contains member details, and the other > which contains details re: the groups to which the member belongs. > > When a member l

Re: Help needed in mysql

Hello Inamullah, Thursday, October 24, 2002, 12:50:27 PM, you wrote: First of all don't send me your questions, send them to the mailing list. I don't privide private support. IK>Well, I have just installed mysql on both wndows n IK> Linux on the same machine and i wanted to ask how i IK> can

Re: help needed

Hi Sheela, At 01:49 2002.10.11. -0700, you wrote: >hi, >I am using mysql >while creating a table I want to give column >descriptioneither by using a query or GUI >ex >create table t1( >a bigint not null ' here i wamt to tell what for the a >is >) > >pl help me > >thanks >sheela You can add comm

Re: Help Needed

Pushpinder, Looks like a file permission problem. Which user do you have that runs the MySQL daemon (server)? Does this user have the ability to write to the directory you've specified as the data directory for MySQL? Kelly --- Pushpinder Garcha <[EMAIL PROTECTED]> wrote: > Hi > I have set up

Re: Help needed with fixed size table database design!

One mistake that I see happen a lot in database design is that people get stuck in visualizing the data in physical terms along with the labels we attach to them. You should try to think more generically. Freezer, box, building, tube, etc. are all just labels assigned to locations. In your cas

Re: Help needed with fixed size table database design!

Hi, On Fri, 2002-09-20 at 08:30, Csaba Kiss wrote: > this is my first mail to the mailing last, since I am new to the mysql > world. I would like to create a "cell-bank" mysql database. We freeze > down cells in small tubes. These tubes are stored in boxes and the > boxes are in big freezer

Re: Help needed with JOIN on 3 tables

iday, June 14, 2002 3:18 AM Subject: RE: Help needed with JOIN on 3 tables > This is what I found I will stop using Microsoft for development of > mysql. I was running the queries locally on my Win2k machine using the win32 > version of mysql. After screwing with it for several days I

RE: Help needed with JOIN on 3 tables

Hi SELECT b.* //all fields from builder FROM builder b //define tables and aliases , builder_category_link l , category c WHERE (b.builderID = l.builderID) //linking builder to link table AND (l.categoryID = c.categoryID)

RE: Help needed with JOIN on 3 tables

again. -Original Message- From: Ralf Narozny [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 12:28 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Help needed with JOIN on 3 tables Hiho hiho! bob wrote: >Hi, > >I'm very new to mysql and I'm having a pro

Re: Help needed with JOIN on 3 tables

Hiho hiho! bob wrote: >Hi, > >I'm very new to mysql and I'm having a problem getting my joins to work. I >have 3 tables: > >builder >category >builder_category_link > >The builder table has a an id field and then several other fields (name, >address etc) >The category table has an id field and t

Re: Help needed on query

You should be able to just use something like this: Select uid, username From tablename Where '$externalstringvar' like query; That's PHP syntax. You'll have to use whatever makes sense for your scripting or programming language in place of the $externalstringvar variable. The single-quotes ar

Re: Help needed on query

Hi, > Now I need a query which will take the values from column > 'query', treat them as patterns for matching and return > row(s) which match the given string 'blahblah'. In this > example, the matched data is obviously in second row. > (bla% matches blahblah) > Do I make any sense?

Re: Help needed with C program + Mysql

Hi. The char* to the field value will be NULL (in the C meaning), if the value is NULL (in the SQL meaning). The reason for your core dump is probably a missing check before you treat the NULL pointer as string. Bye, Benjamin. On Thu, Feb 28, 2002 at 03:23:01PM -0300, [EMAIL PROTECTED

RE: Help needed !!!

PROTECTED] Subject: Re: Help needed !!! On Fri, Jan 25, 2002 at 01:05:12PM +0530, Chetan Lavti wrote: > > I am going to use the MySQL version 3.23.47 for as our database. > The issue is which table type to use. > > I want that the database should be (memory-resident). I have tried &g

Re: Help needed !!!

On Fri, Jan 25, 2002 at 01:05:12PM +0530, Chetan Lavti wrote: > > I am going to use the MySQL version 3.23.47 for as our database. > The issue is which table type to use. > > I want that the database should be (memory-resident). I have tried > with the MyISAM tables which doesn't solves my purpos

Re: help needed on datetime functions

On Wednesday 05 December 2001 16:40, you wrote: > hi everybody > i want to take diff of datetime format columns. > Is it possible using direct '-' arithmatic.. > It gives result as: > > 2001-11-03 15:43:47 - 2001-11-03 15:42:21 = 126 > 2001-11-03 16:11:50 - 2001-11-03 15:48:00 = 6350 > > First row

RE: Help needed getting table headings into an outfile

formatting ok, but it just needs the table headings. Ideally we want to use one or more queries to do this, rather than using mysqldump. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 10 September 2001 11:38 am To: Andrew Murphy Subject: Re: Help needed getting table

RE: Help Needed Please

On 26-Aug-2001 [EMAIL PROTECTED] wrote: > Hi > > I need to set the max_allowed_packet to 16M. below is my > 01mysql-server.sh file. I use DBI and I know that I have to start this > before the DBI program and I did but if I use ./mysqld --help it shows > that my max_allowed_packet is still 1M. An

Re: Help Needed Please

Hi, use "mysqladmin variables" command to see current settings. I guess your mysqld does not read the config file you have edited. ;-) It happened to me me also few days ago. Remember mysqld looks for /etc/my.cnf and $DATADIR/var/my.cnf if I remember well. Maybe put the path to config file just

RE: help needed for replication : EUREKA

[EMAIL PROTECTED] > Subject: RE: help needed for replication > > > Already tried ... Not successfully. > Another idea ? > > > -Original Message- > > From: Stefan Hinz [mailto:[EMAIL PROTECTED]] > > Sent: Friday, July 20, 2001 7:51 PM > >

RE: help needed for replication

Already tried ... Not successfully. Another idea ? > -Original Message- > From: Stefan Hinz [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 20, 2001 7:51 PM > To: BALU Frédéric; [EMAIL PROTECTED] > Subject: Re: help needed for replication > > > Dear Frede

Re: help needed for replication

Dear Frederic, >localhost | jkasas | 1896f443280395b3 > And what I do and get : >mysql> GRANT SELECT ON MEMBERS.users TO jkasas@'localhost'; >ERROR 1133: Can't find any matching row in the user table Try GRANT SELECT ON MEMBERS.users TO jkasas@localhost (w/out quotes)! :)

Re: Help needed

Kim White wrote: > Could anybody tell me how to get rid of the following error on a php3 > request. "Warning: MySQL Connection Failed: Host 'hostname.co.za' is not > allowed to connect to this MySQL server in /var/local/irm/irm.inc on line > 83". > ---

Re: Help needed

You need to GRANT PRIVILEGES to the host and user that PHP connects from. Kim White wrote: > Hi > > Could anybody tell me how to get rid of the following error on a php3 > request. "Warning: MySQL Connection Failed: Host 'hostname.co.za' is not > allowed to connect to this MySQL server in /var/

Re: HELP NEEDED: Problems with SELECT in combination with HAVING

orm to the standard ? > > Regards > Thomas > > > -Original Message- > From: Hannes Niedner [mailto:[EMAIL PROTECTED]] > Sent: 26. juni 2001 17:42 > To: [EMAIL PROTECTED] > Subject: Re: HELP NEEDED: Problems with SELECT in combination with > HAVING >

RE: HELP NEEDED: Problems with SELECT in combination with HAVING 2

Niedner [mailto:[EMAIL PROTECTED]] Sent: 26. juni 2001 17:42 To: [EMAIL PROTECTED] Subject: Re: HELP NEEDED: Problems with SELECT in combination with HAVING Try SELECT robotId, max(startTime) as crit FROM RobotRun WHERE startTime >= '2001-06-26 00:00:00' AND endTime IS NOT NULL GROUP BY

RE: HELP NEEDED: Problems with SELECT in combination with HAVING

[mailto:[EMAIL PROTECTED]] Sent: 26. juni 2001 17:42 To: [EMAIL PROTECTED] Subject: Re: HELP NEEDED: Problems with SELECT in combination with HAVING Try SELECT robotId, max(startTime) as crit FROM RobotRun WHERE startTime >= '2001-06-26 00:00:00' AND endTime IS NOT NULL GROUP BY rob

Re: HELP NEEDED: Problems with SELECT in combination with HAVING

Try SELECT robotId, max(startTime) as crit FROM RobotRun WHERE startTime >= '2001-06-26 00:00:00' AND endTime IS NOT NULL GROUP BY robotId This should return the robotId and the most recent startTime labeled 'crit' for all records specified in the where clause. And have a look in the manual for

Re: Help needed with Query UPDATE INFO

would cause some VERY weird join results, and may be your problem. Try adding in the join clause in the where clause. - Original Message - From: "Bryan Coon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 27, 2001 2:52 PM Subject: RE: Help needed with

RE: Help needed with Query UPDATE INFO

Okay, here is the full monty from the database regarding the query in question, any suggestions on how to improve any of it are greatly appreciated! Also, if any more info is needed, just let me know. Thanks! Bryan QUERY: mysql> select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as

Re: Help needed with Query

Please do a "SHOW FIELDS FROM" and "SHOW KEYS FROM" on all tables involved so we can see what's going on here. Also, a warning, if desacription is indexed, by doing LIKE '%GABA%' with wildcard at beginning, it won't use index's. Would also help if you did an EXPLAIN on that query and sent that.

RE: Help needed with Query

hi. by skimming that query, the first thing that will take a long time is the 'description like "%GABA%"' part...that's a pretty inefficient method of searching due to the wildcard at the beginning of the string. if there are no indexes on the tables, you should probably add some. "show index fr

Re: Help needed on mysql!!

What do you mean by "better" ? Next time it hangs, check your disk freespace. When MySQL runs out of tmp workspace, it waits until some becomes available. [EMAIL PROTECTED] wrote: > > Help! > I have set up a web server with PHP4, RH7 and MySQL 3.23.32. > After surfing for sometime, the browse

Re: Help Needed

Hello Pat Well, I really feel stupid! Under the gun with this any I really don't have a clue. I also need to install some type of DBI foe windows2000 advanced server too and I'm now downloading a perl file off of mysql.com. I really have no idea working with windows. My main OS that I have been w

Re: Help Needed

Expected behaviour, look in your Tray on the Taskbar for a stoplight icon. Pat... - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 17, 2001 6:12 PM Subject: Help Needed > Hi > > I just downloaded MYsql for windows NT. I'm running it on Windows

RE: (+) Help needed

Slight correction, for some reason the query below does NOT work on my sample DB unless I quote the date values. This should work now: SELECT IP, Size, Date FROM your_table WHERE Date BETWEEN '2001-02-01' AND '2001-05-01'; > > so and i have Mysql table with > IP | Size

Re: (+) Help needed

Don't you think this has nothing specific to MySQL? Maybe you should read some books on SQL and the manual for MySQL? SELECT * FROM tablename WHERE datefield>'2001-01-11' AND datefied<'2001-02-12' Don;t ask how to correctly call the query in perl, read perldoc DBI perldoc DBD::mysql