Re: MySQL Password

mysqladmin password secret should work if not then mail i'll work out a bit and reply. -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2

The 2GB Memory Limit, AWE, and HEAP tables

I've read a lot about the 32-bit/malloc-induced 2GB memory limit on MySQL for the innodb_buffer_pool_size. Does this apply to HEAP table size as well? In other words, if I have enough RAM can I set max_heap_table_size 2 GB and have a 2GB heap table sitting in memory? I've used AWE with innodb

Re: max_allowed_packet error

No, nothing of the sort in the my.cnf file. :( - Original Message - From: Dathan Vance Pattishall [EMAIL PROTECTED] To: 'Tina Motaye' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 8:33 PM Subject: RE: max_allowed_packet error Do you have a waittimeout set in you're

how to initialize a new Innodb file (without server restart)

Hi Mysql fans ;-), does anybody know how to initialize a new added Innodb file without restarting the server ? Best regards -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General

Which is better: big SQL statement or bigger db?

I need to have a user input a city and have MySQL pull up any records with that city OR nearby cities (within 10 mi). Which of the following would be the most efficient way to do this: Case A: When a user enters a city, an array of nearby cities is created so that an SQL statement like the

Re: MySQL Password

I m sorry ,try the earlier solution posted by someone else i.e to restart mysql server with grant tables disabled.and then reset the password. that;s the only method given in the documentation 2 at mysql.com,though i cdn't get it working. again sorry for misdirections harsh On Wed, 2 Jul

Re: MySQL Password

Hi harsh, perhaps I made a litttle mistake (havent done it recently ). try the --skip-grant-tables option for safe_mysqld like this safe_mysqld --skip-grant-tables That should be doing it. Best regards Nils Valentin Tokyo/japan 2003 7 2 17:02harsh : I m sorry ,try the earlier solution

Re: Which is better: big SQL statement or bigger db?

Hi, May the following sql statement is more efficient. SELECT * FROM bc_posts WHERE post_citysoundex IN('A265','A415',.) Armand motorpsychkill wrote: I need to have a user input a city and have MySQL pull up any records with that city OR nearby cities (within 10 mi). Which of the

InnoDB logfile question

Hello Heikki other Mysql Fans ;-); Does anybody know which requests or data the below logfils actually keep ?? If I understood correct than they are all in binary format (not readable in a text editor. log.01 ib_arch_log_00 ib_logfile0 ib_logfile1

Re: A quick help

harsh [EMAIL PROTECTED] wrote: Two databases data1 data2 data1 has table1 and data2 has table2 both the tables have uid field common I want to list out common uid's from table1 annd table2 Tried many commands as i understood from documentations but somewhere i m always wrong.

Re: how to initialize a new Innodb file (without server restart)

Nils Valentin [EMAIL PROTECTED] wrote: does anybody know how to initialize a new added Innodb file without restarting the server ? You can't. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __

Re: privileges not updating

me [EMAIL PROTECTED] wrote: i have a strange thing going on - i'm trying to update privileges on some databases but it doesn't happened - even after flush privileges - according to the manual the changes with GRANT an REVOKE should take effect immediately but they don't. i'm using command

Re: Persistent annoying slave binlog corruption...

Michael Loftis [EMAIL PROTECTED] wrote: Recently, and pretty consistently our slave's relay logs have been getting garbage that is not in the master. The symptom is usually a truncated query with a few characters of garbage. The solution for now is to change master to to the errored

Re: MySQL Password

Well its not your fault,its actually confusing the documentation says run the mysqld command with the skip-grant-tables option but there is no such command available (atleast in my box) i found the command hidden in /usr/libexec/mysqld but that 2 gives error. safe_mysqld is indeed the command

Re: InnoDB logfile question

Nils, - Original Message - From: Nils Valentin [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:04 PM Subject: InnoDB logfile question Hello Heikki other Mysql Fans ;-); Does anybody know which requests or data the below logfils actually keep

Re: Which is better: big SQL statement or bigger db?

* [EMAIL PROTECTED] Case A: ... This statement would probably be much larger (upto 150 lines) and would query one table without additional joins. Case B: Here, when a user enters a city, the soundex of it is created and then queries a table that contains every city in the db PLUS all

specific records

Hi, Let's say I have 1000 records in a 'table'. I want to select rows from 6 to 11. How can I do this? Regards, Maciej Bobrowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB logfile question

Hi Heikki, 2003 7 2 18:10Heikki Tuuri : Nils, - Original Message - From: Nils Valentin [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:04 PM Subject: InnoDB logfile question Hello Heikki other Mysql Fans ;-); Does anybody know which

Re: MySQL Password

Hi Harsh, Hi MySQL AB ;-) I agree this section could be made a bit clearer. Is this hint big enough for MySQL AB ;-) ?? Best regards Nils Valentin Tokyo/Japan 2003 7 2 18:08harsh : Well its not your fault,its actually confusing the documentation says run the mysqld command with the

Re: how to initialize a new Innodb file (without server restart)

Hi Egor, Thanks for the straight and short answer. Much appreciated. Best regards Nils Valentin Tokyo/Japan 2003 7 2 17:44Egor Egorov : Nils Valentin [EMAIL PROTECTED] wrote: does anybody know how to initialize a new added Innodb file without restarting the server ? You can't. --

Re: specific records

SELECT * FROM tablename where column5 AND column12; Best regards Nils Valentin Tokyo/Japan 2003 7 2 18:26Maciej Bobrowski : Hi, Let's say I have 1000 records in a 'table'. I want to select rows from 6 to 11. How can I do this? Regards, Maciej Bobrowski -- --- Valentin Nils Internet

Re: specific records

Let's say I have 1000 records in a 'table'. I want to select rows from 6 to 11. How can I do this? SELECT * FROM tablename where column5 AND column12; No, no. I have no numerical fileds in the table. Your example is not good. Even if I could add the 'id' column to the table, then when I will

Re: specific records

SELECT * FROM tablename LIMIT 5, 6 Me fail English? That's unpossible ###___Archon___### - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Maciej Bobrowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 4:47 PM Subject: Re: specific records SELECT *

Re: specific records

O.K. I found the way: select * from tablename limit 5,6; it will select 6 records counting from 6. Let's say I have 1000 records in a 'table'. I want to select rows from6 to 11. How can I do this? SELECT * FROM tablename where column5 AND column12; Best regards, Maciej Bobrowski --

Re: specific records

Maciej Bobrowski wrote: Let's say I have 1000 records in a 'table'. I want to select rows from 6 to 11. How can I do this? SELECT * FROM tablename where column5 AND column12; No, no. I have no numerical fileds in the table. Your example is not good. Even if I could add the 'id' column to the

Re: InnoDB logfile question

Nils, InnoDB writes to ib_logfiles all tablespace modifying operations (= mini-transactions), whether they belong to a successful or an unsuccessful transaction. In crash recovery we redo everything, then roll back based on undo logs inside the tablespace. The best reference is Gray and Reuter:

Re: specific records

Actually, this will *not* necessarily work. Without an ORDER BY clause, the database is free to return records in any order; after some deletions insertions, your select below may return different records, in a different order. I would recommend adding an explicit record number to the table,

Re: max_connections being ignored/overridden?

Gary Huntress [EMAIL PROTECTED] wrote: I have some simple user quotas set to help balance my server load. I think I've implemented them properly because people do whine to me when they reach the query limit. I have max_connections set to 200, but right now I'm watching connections for 1

Re: MySQL Password

Nils Valentin [EMAIL PROTECTED] wrote: I agree this section could be made a bit clearer. Is this hint big enough for MySQL AB ;-) ?? What exactly is not clear enough for you? --skip-grant-tables is option of mysqld, not safe_mysqld. safe_mysqld is the script that runs mysqld. 2003? 7?

Re: specific records

Maciej Bobrowski [EMAIL PROTECTED] wrote: Let's say I have 1000 records in a 'table'. I want to select rows from 6 to 11. How can I do this? Use ORDER BY and LIMIT clauses: http://www.mysql.com/doc/en/SELECT.html -- For technical support contracts, goto

RE: Date query optimization

Hi Karl- I often use a unix timestamp value for my dates (an unsigned mediumint is adequate) and index that. However, using date/time functions in the where clause does have a significant impact on the execution times, even when the index is used and the EXPLAIN output appears the same. See

Weird Query results.

Version 3.23.56, for pc-linux on i686 When I issue query as such... SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz%; I get a result that has as it's first record, a record where the Name field data IS LIKE zz% but the actual output has that field blank as in the example below

Re: MySQL Password

Hi Victoria, I enclose a sample. http://www.mysql.com/doc/en/Resetting_permissions.html ... 2. Restart mysqld with the --skip-grant-tables option. ... How would you understand this ? restarting mysqld or starting safe_mysqld ?? Don't get me wrong the manual is not bad, but it leaves a lot

Can't start MySQL on Mac OS X

Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and

LOAD DATA INFILE syntax

Hi all, I'm quite new in mysql. Despite i've read a part of the doc, i can't fix my prob. Here is my question: I want to convert a DBASE IV file into mysql table: 1) Have i to convert the dbf into flat file then use the LOAD DATA INFILE cmd ? or 2) Can i directly use the LOAD DATA INFILE cmd

Re: Replication problem: Slave not starting

Andrew Staples wrote: I've setup my my.cnf file on the slave as: [mysql.server] user=mysql basedir=/var/lib socket=/var/lib/mysql/mysql.sock server-id=2 master-host=206.xxx.xxx.xxx master-user=replicateuser master-password=replicatepassword Master.info is: tux-bin.001 3109 206.xxx.xxx.xxx

Problem with mysqlimport.

Hi all, I've just started using mysql and I'm sure that my all problems are something todo with my oracle-ness, so please bear with me if I use case-insensitive table names or somthing ;) Ok. I've been using the mysql interactive command-line interface for a few days now, and there's no problem

Re: RedHat 9 - MySQL 3.23.56

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 25 Jun 2003, Luc Foisy wrote: Something interesting that may be my problem This is a known working install # mysql --version mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686) # find /etc/rc.d -name *mysql /etc/rc.d/init.d/mysql

Re: defunct mysql threads

Does the client close the connection before exiting? Joshua Shapiro wrote: Hello, I am running the binary mysql 4.0.13 pclinux i686 with a linux 2.4.19 kernel. I have the problem that every time a client connects to the server and then exits, a defunct thread is left behind. Eventually

Re: Can't start MySQL on Mac OS X

If you did not shutdown the server prior to the upgrade, you could have left mysqld running, even after its socket was removed. Use ps to see if mysqld is still running, and kill it if necessary. Todd O'Bryan wrote: Something bad has happened. MySQL was up and running on my machine, but now

Re: LOAD DATA INFILE syntax

1 will work. 2 will not work. 3 Use dbf2mysql. ( It should be in the downloads section on mysql.com ) fab wrote: Hi all, I'm quite new in mysql. Despite i've read a part of the doc, i can't fix my prob. Here is my question: I want to convert a DBASE IV file into mysql table: 1) Have i to

Re: Problem with mysqlimport.

Idries Hamadi wrote: Hi all, I've just started using mysql and I'm sure that my all problems are something todo with my oracle-ness, so please bear with me if I use case-insensitive table names or somthing ;) Ok. I've been using the mysql interactive command-line interface for a few days now,

Re: Can't start MySQL on Mac OS X

Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on

Re: MySQL Password

Nils Valentin [EMAIL PROTECTED] wrote: Hi Victoria, I enclose a sample. http://www.mysql.com/doc/en/Resetting_permissions.html ... 2. Restart mysqld with the --skip-grant-tables option. ... How would you understand this ? restarting mysqld or starting safe_mysqld ?? Start

Re: Weird Query results.

Jeff McKeon [EMAIL PROTECTED] wrote: Version 3.23.56, for pc-linux on i686 When I issue query as such... SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz%; I get a result that has as it's first record, a record where the Name field data IS LIKE zz% but the actual output

What is mysql.soc and where is it located

Hi, The following message appeared when I installed mysql server on Linux,,, [2] 10804 [1] Exit 1 ./bin/mysqld -user-mysql [EMAIL PROTECTED] mysql]$ Starting mysqld daemon with databases from /var/lib/mysql 030701 19:59:18 mysqld ended And also sometime the message can't

Re: freebsd 5.1 + mysql 4.0.13

Richard, Welcome to the wonderful world of FreeBSD. FreeBSD-5.1 is not release code. It is alpha quality (thought pretty good quality as Alpha goes). I understand that the website doesn't make this abundantly clear on the homepage. FreeBSD 4.8 is the current production quality code. It will

replicating FLUSH LOGS

Under MySQL 3.23, FLUSH LOGS was replicated. Under 4.0.13, this appears to no longer be the case. Was this intentional? Could it be put back the way it was? We do backups by, at a time of low usage, (1) FLUSH LOGS on the master, (2) Dump the master database, (3) repeat 1 and 2 until there were

Upgrading MySQL on RedHat 9

I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to go from the version that came with the distro (version 3.23.54) to the latest (verion 4.0). Just thought I'd post to get a heads-up on any known issues or prerequisites. I just hate it when I try something like this and

RE: MySQL/INNODB speed on large databases

Thanks to everyone who has helped and/or made suggestions so far. I'll try to provide some answers to your further queries and report back on some testing I've done. Jeremy asked for explains of some of the problem queries: Here is a particularly troublesome one that gets ran quite a lot: mysql

Count Rows?

Is there a simple MySQL command that will give a Row Count (# of records) WITHOUT running a select (huge database) Thanks! Roy

RE: Count Rows?

If your table is MyISAM, then SELECT COUNT(*) FROM tablename Will return a rowcount without a major performance hit as the rowcount is stored and a table scan is not needed. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Roy W [mailto:[EMAIL PROTECTED] Sent:

possible query #2

Hello dear all, on MySQL 3.23.54 i have a table that list the number of user-time days like: 35 whellbased on curdate() function can i able to make a select wich display the sum (150-35) where 150 is date_format(curdate(), '%j') in a format like (%d/%m/%y) ? this kind of query is

RE: Weird Query results.

Vitoria, Thanks for the feedback. I should have done this first but it turns out that there are actually bad records with: MobileName LIKE Mystery solved... Thanks, Jeff McKeon IT Manager Telaurus Communications LLC [EMAIL PROTECTED] (973) 889-8990 ex 209 ***The information contained in

Re: What is mysql.soc and where is it located

Check the error log in your mysql data directory. This should explain why mysqld ended. suboh wrote: Hi, The following message appeared when I installed mysql server on Linux,,, [2] 10804 [1] Exit 1 ./bin/mysqld -user-mysql [EMAIL PROTECTED] mysql]$ Starting mysqld daemon with

More tables or more joins

I am working on a program that is essentially a contact management tool for multiple users. There are currently about 200 users and will be over 1000 eventually. Each user may have between 10 and 500,000 contacts. Where it gets interesting is that each user needs to have the ability to

Re: Can't start MySQL on Mac OS X

OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: Todd O'Bryan [EMAIL PROTECTED]

Re: More tables or more joins

You don't want to have a separate table for each user. That would cause a maintenance nightmare. Try normalizing your data user table -- user_id cont_id user_name Contract lookup cont_id Cont_Name Contract Column Lookup -- col_id col_name

OS X downloads

There are two sets of binary downloads at mysql.com for Mac OS X. They're different sizes, but both say OS 10.2. Is that a typo? Is one of the two for OS 10.1, and could I have downloaded the wrong one and could that be the reason I can't get mysql to start? Todd -- MySQL General Mailing List

Re: More tables or more joins

I appreciate the idea of normalizing, but those tables wouldn't meet the spec. There would also have to be a column value table at the very least. Also, why would you have user_id and cont_id in both the user_table and the contract table. Also if you read my post you would see that I am

RE: More tables or more joins

Well, lets say that you suddenly remember that you need column X in the user table. In the normalized model you have to do one ALTER TABLE statement. In the design you have in place you need n ALTER TABLE statements where n = the number of users. It can also be easier to program against and manage

Newbie SELECT problem

Hello everyone, I have the following select statement SELECT DISTINCT sessionID, userID, date, time FROM sti_tracking WHERE userID = 999 What I want is to have only records with the userID of 99 and where the sessionID is distinct (meaning only on of each session id). Neither sessionID nor

problems with insert method on INNODB tables

I have the wierdest problem an I am at a loss. The insert function, as for the code underneath, partially works. I say partially, as I can see that the primary key is actually incremented. But sometimes the new record fails to show in the table, and when it does other records are removed. The

RE: More tables or more joins

If you want to add another column name, just insert a new record into Contract Column Lookup -- col_id col_name Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop

Having MySQL Server and databases on different computers

I am wondering if it is possible to run MySQL Server on one computer on a LAN, but have all the databases be stored on another computer on that LAN (such that the other machine is like a data repository that the MySQL server machine can access when needed without having to store any of the

Re: More tables or more joins

Jackson Miller wrote: I understand that having this many tables is crazy, but I don't understand why it is not better. Several reasons. One is complexity, another is administration. Using one table per user is nasty because it's too complicated. You have 200 tables to keep track of, each

RE: Newbie SELECT problem

Well, it is important to remember that SELECT DISTINCT simply restricts that the WHOLE ROW is distinct, therefore it takes into account all columns, not just the sessionID column, when deciding if a row is distinct. One way to do this would be to do SELECT sessionID, userID, date, time FROM

Re: Newbie SELECT problem

Tim Winters wrote: Hello everyone, I have the following select statement SELECT DISTINCT sessionID, userID, date, time FROM sti_tracking WHERE userID = 999 What I want is to have only records with the userID of 99 and where the sessionID is distinct (meaning only on of each session id).

RE: Having MySQL Server and databases on different computers

Well, if we are talking about a one to one relationship between MySQL and repository, you can always share the folder the data files will be stored in using NFS or SMB, and then just adjust the datadir entry in the my.cnf file appropriately. The performance of such a solution will probably be

Re: Newbie SELECT problem

Hello everyone, I have the following select statement SELECT DISTINCT sessionID, userID, date, time FROM sti_tracking WHERE userID = 999 What I want is to have only records with the userID of 99 and where the sessionID is distinct (meaning only on of each session id). Neither

Convert Row Data to Coulmns which are not duplicated (Left Joins and Group BY)

I have multiple tables and require to retrieve data from the tables. Though this is quite achieved, what problem i see is that two of my result sets are stored in a table as rows and i would like to retrieve them as columns. The query that i am executing is... --- SELECT

Re: Can't start MySQL on Mac OS X

Check your permissions in /usr/local/mysql, I think the package leaves some incorrectly set. The exact problem is usually logged in /usr/local/mysql/data/hostname.err this file is invaluable Cheers! --s On Wednesday, July 2, 2003, at 09:24 AM, Todd O'Bryan wrote: OK. I've verified that no

Re: Having MySQL Server and databases on different computers

I think a network filesystem would add a LOT of latency, perhaps you need a SAN type solution? This way the data could be off on some other device, possibly accessible to more than one host. --s On Wednesday, July 2, 2003, at 10:11 AM, Mike Hillyer wrote: Well, if we are talking about a one to

Re: privileges not updating

On Wednesday, July 2, 2003, at 04:42 AM, Victoria Reznichenko wrote: me [EMAIL PROTECTED] wrote: i have a strange thing going on - i'm trying to update privileges on some databases but it doesn't happened - even after flush privileges - according to the manual the changes with GRANT an REVOKE

RE: Newbie SELECT problem

Hello, Very sorry to everyone about the confusing message. I should have read it over again before pressing send. First of all I'm looking for userID 999. A typo in the message not in the code. The table is set up like this. Table name sti_tracking hitID (primary key) (autonumber) userID

Re: Newbie SELECT problem

Tim Winters wrote: So what I want to be able to do is single out a user (999) and retrieve all the sessions he was involved in. But I don't want duplicate session numbers (one is enough). Make any more sense? Yes. The solution I posted earlier should work. Bruce Feist -- MySQL General

Re: Newbie SELECT problem

select sessionID,userID,date,time from sti_tracking where userID=99 group by sessionID; hope that works ,though i didn't clearly got your question,may be some expert suggest better regards harsh On Wed, 2 Jul 2003, Tim Winters wrote: Hello everyone, I have the following select statement

Re: License?

I would recomend reading up on the copyright laws in your country. publishing and distribution are legally defined terms. IANAL but IIRC publishing means to create a copy of something on a medium and distribution means to deliver that medium to someone else. These concepts get tricky in a

mysqld_multi fails on Solaris 8

Hello, Has anyone had success using the mysqld_multi startup script at boot on Solaris 8? I can start mysqld manually, but not automatically at boot time. Any help or advice is apprciated. Thanks a lot, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: NFS or replication?

Steven, Don't use NFS, bad idea. You can do the master writer/multi reader, but it's always been a problem making sure every reader is up to date. You need to have a way to verify this manually. If your really going to max out your platform there's other platforms to look at, but the costs

Re: simplify query?

What you want to do is reduce the query. Logic is reduced using similar rules to algebra. Think of or operations as addition and and operations as multiplication and you can manipulate them using the same rules as you do in algebra. select * from t where (a and b) or (a and c); where a, b

Re: Unexpected empty table performance problem with MySQL and InnoDB

Hi, I wanted to post a follow-up question to the inquiry below.  I've done some more research since my last post and now think that the performance problem is related to something other than uncommitted transactions.  More specifically, I think the culprit is the lack of timely synchronization

Table Name as UserName with a Blank Password

I recently stumbled onto the ability to log into a mysql server from the command line with any table name, and a blank password. ie: mysql -u mysql My root account has a password set, and a few users with limited access but I haven't done much else as far security goes. I've tried this on a

The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe [1] 22717 $ The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows:

replication / table copy question

Hello, I have two mysql databases running on different hosts - the database are similiar in structure. I would like to copy specific tables from one db to another db on a scheduled basis. Is there a command to replicate a table from one db to another on a different host? TIA -roy -- MySQL

Re: Unexpected empty table performance problem with MySQL and InnoDB

Alex, why you do not look with SHOW INNODB STATUS if there are dangling transactions which could still see the delete-marked rows? Purge cannot remove them then. The main InnoDB thread tries to run a full purge even when the server is active. This snippet is from srv0srv.c of 4.0.14:

RE: Newbie SELECT problem

Table name sti_tracking hitID (primary key) (autonumber) userID sessionID date time pageName this might work select userID,sessionID from sti_tracking where userID=999 group by sessionID; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

I found that file in /usr/libexec/mysqld hope that helps -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003 [EMAIL PROTECTED]

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

Do what it says: cd /usr/local/mysql ./bin/mysqld_safe and see if that's any better. Todd On Wednesday, July 2, 2003, at 05:18 PM, [EMAIL PROTECTED] wrote: Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe [1] 22717 $ The file

Re: Newbie SELECT problem

Tim: Assuming that in your ealier posting the 99 was supposed to be 999, then the solution given by Mike Hillyer is excellent and should work. However, when I read your new posting, I seem to get confused. The scenario sounds totally different - excuse me - from the earlier one and would

Re: Newbie SELECT problem

Tim: Assuming that in your ealier posting the 99 was supposed to be 999, then the solution given by Mike Hillyer is excellent and should work. However, when I read your new posting, I seem to get confused. The scenario sounds totally different - excuse me - from the earlier one and would

Re: Newbie SELECT problem

Tim: Assuming that in your ealier posting the 99 was supposed to be 999, then the solution given by Mike Hillyer is excellent and should work. However, when I read your new posting, I seem to get confused. The scenario sounds totally different - excuse me - from the earlier one and

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

Make sure the permissions on the file are set to executable. Assuming your platform is some *nix variant, login as root or owner. Change to the directory where your mysqld is located (/usr/local/mysql/libexec) and execute the following command: chmod 755 * This will ensure the binaries and

Re: Can't start MySQL on Mac OS X

I figured out what happened, though I don't know when it happened... I had screwed up the permissions for the /tmp/ directory, so the mysql user could not create the socket it needed there. A well-placed chmod and things are back in working order. Thanks to all for the suggestions, Todd --

RE: MySQL/INNODB speed on large databases

For the first query below--if you really run it often enough to mess with indexes, and it really has a limit 1 or a small limit--an index on (VoidStatus, InstNum) ought to avoid having MySQL create a big temporary table and then sort it. In addition, you could add to the index any of columns in

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

That's exactly what I had to do as well. I wouldn't even start in rc.local unless I put in exactly what is shown below. Ed On Wed, 2 Jul 2003, Todd O'Bryan wrote: Do what it says: cd /usr/local/mysql ./bin/mysqld_safe and see if that's any better. Todd On Wednesday, July 2,

RE: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

Todd, It didn't help. Here is the message: $ cd /usr/local/mysql $ ./bin/mysqld_safe The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. $

Possible OT: ADONewConnection Error

Anyone here familiar with the following error: ADONewConnection: Unable to load database driver '' Fatal error: Call to a member function on a non-object in /wwwroot/htdocs/webdev/nubiint/includes/pnAPI.php on line 486 I get this error when trying to configure multisites in my postnuke site. I

Re: replication / table copy question

On Wed, Jul 02, 2003 at 02:28:38PM -0700, Kevin wrote: Hello, I have two mysql databases running on different hosts - the database are similiar in structure. I would like to copy specific tables from one db to another db on a scheduled basis. Is there a command to replicate a table from

Re: InnoDB logfile question

Uups must have forgotten to copy the list ;-) Thanks Heikki, Also I dont fully understand the resulting context yet, I appreciate the reply. Best regards Nils Valentin Tokyo/Japan 2003 7 3 00:07Heikki Tuuri : Nils, at the lower level all mini-transactions always succeed. They all have

  1   2   >