Re: Replication question

On 24/07/2013 19:52, Rick James wrote: 4) 3 tables from the slaves are to be replicated back to the master NO. However, consider Percona XtraDb Cluster or MariaDB+Galera. They allow multiple writable masters. But they won't let you be so selective about tables not being replicated. Here

Replication question

implementation...? Thanks in advance for any advice/pointers! Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: (real) silly question about variables...

| +++-+-+ | 0.8187706152151997 | 0.8187706152151997 | ciao| ciao| +++-+-+ Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Having trouble with SQL query

Hi Nitin Thanks - I tried that and got 0 rows... I have spent more time on describing my problem -- see below hopefully this will make the issue more clear... Rich I have a MySQL database with a menu table and a product table. - The products are linked to the menus in a one-to-many

Having trouble with SQL query

this sufficiently and I TYIA for any guidance Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

[GIG] $500 For Site Speed Improvement

Hey folks! This gig just popped up on our system, thought it could be some easy money for anybody out there who knows Ruby/Rails and how to optimize queries! http://gun.io/contracts/67/improve-site-speed-for-startup Thanks! -- Rich Jones Director, Gun.io

MySQL v5.5.12 on Mac OSX - Server won't start...

... TIA Rich

RE: Any easier way to compare mysql schema of 50 databases?!

I just used mysqldiff for a project, and was successful. -Original Message- From: Uma Bhat [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2008 7:51 PM To: Andy Shellam; mysql@lists.mysql.com Subject: Re: Any easier way to compare mysql schema of 50 databases?! Thank you all, guys!!

encode/decode question

need to encrypt the data, simply obfuscate it to prevent accidental, unintentional use. Any ideas appreciated. Thank you. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Select Last X rows

an offset in LIMIT, is there a way to ask for the last 10 rows directly? Cheers Rich in Toronto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Select Last X rows

. If I use the latter, park it into a compound data structure, there's overhead, so I thought I'd chase up the db to see if there was anything I could solve it with. Rich in Toronto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Select Last X rows

where ... order by last_update desc limit 10) as tbl order by tbl.last_update; Rich in Toronto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

peformance help: preventing 'using temporary; using filesort'

filesort | | 1 | SIMPLE | t2| ALL | NULL | NULL | NULL | NULL | 1351 | | ++-+---+---+---+--+-+--+--+--+ -- rich -- MySQL General

Select Primary Key

Hi folks. How can I select primary key from a table? I can't find any syntax out of show fields from tablename, and the 'key' field = PRI. Just seems to be a bit much. Any takers? Cheers Rich in Toronto (cold) -- MySQL General Mailing List For list archives: http://lists.mysql.com

Update field concactenation

Hi folks. Boy do I have an interesting one for you today. This list is great. Can I update a record using a typical update query, and have a field be updated to: previous value of the field + (something I want added to the end) so field 'flavours' starts out as: vanilla chocolate

Two Tables Comparator

Hi folks. Any suggestions on the following? If a student signs up for classes, I don't want them viewing those classes so they can choose them again. So I want to take out their 'signups' from the master class list. select classnumber, classnumbersignup from classes, signups

mysql crashes on drop database?

server, I can certainly destroy the data directories and re-import all of the data, but it seems counter-intuitive to wipe over everything and reinstall. Isn't there some sort of repair facility to fix up the innodb table space? Or at least validate that it's ok? Thank you! Regards, Rich

RE: MS Access gives error no. -7776.

it gives error and on some it not gives any error. I have installed WinXP with SP2, Access 2003 with JET 4 sp 8. Also this error does not occurs when I used SQL server 2005 express edition I am tring to use seperate forms for dataentry. Thanks again CPK On 7/3/06, Duzenbury, Rich [EMAIL

RE: Unknown tables

-Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Monday, June 12, 2006 1:48 PM To: MySQL List Subject: Unknown tables When I do a SHOW TABLES in MySQL, it shows me a list of tables. But when I try to do a select * from countries, I get the error ERROR 1146

Re: Finally Working...wow

Never mind. This actually posted to the wrong list. I don't know how that happened. Must have been cause I was tired. Sorry about that. On May 24, 2006, at 9:19 PM, sheeri kritzer wrote: Rich for what? is SELECT host,user,password FROM mysql.user; showing you cleartext passwords

Finally Working...wow

Hi folks. Me again. I finally got this all up and running under crypt of 'cleartext'. So, even though I am going to be on the same box as the server, how do I set up an MD5 or password entry? MYSQLCrypt password() MYSQLCrypt

[5] Starting Up General Query Log

Mac OS X 10.4.6 (Tiger), MySQL 5.0.21. Hi folks. I'm needing to start up my general query log to see what's ticking me off. I've looked into safe_mysqld but it's confusing as ... something that's confusing. Anybody know how I can easily turn this thing on for a day, then turn it off?

Re: [5] Starting Up General Query Log

On May 19, 2006, at 12:01 PM, sheeri kritzer wrote: Yes. idea #1 -- reply all, including the list. idea #2 -- what's in the error logs? Check that the user that runs mysql has permission to write to the file and that /var/log exists. Rich Fortnum [EMAIL PROTECTED] Toronto -- MySQL General

RE: Backups with MySQL/InnoDB

database as of April 2, 2005 at 8:42 am' and have it create a new instance on a user defined port, then restore the closest previous full, then apply the binlogs up to the correct point in time. Thanks. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: mysqlmanager logging?

-Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Thursday, May 04, 2006 3:12 PM To: Duzenbury, Rich Cc: mysql@lists.mysql.com Subject: Re: mysqlmanager logging? Can the program write to /var/lib/mysql/mysqlmanager.log? check permissions. # su

RE: mysqlmanager logging?

-Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 3:00 PM To: Duzenbury, Rich Cc: mysql@lists.mysql.com Subject: Re: mysqlmanager logging? su - mysql touch /var/lib/mysql/mysqlmanager.log see if that helps; maybe having the file

RE: blank user names in user table (SOLVED)

-Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 2:37 PM To: Duzenbury, Rich Cc: mysql@lists.mysql.com Subject: Re: blank user names in user table Rich, anonymous access means that ''@host has access. That is, blank at host

blank user names in user table

attempts with the mysql client have so far been in vain. How can I ask mysql to log connection attempts by users so I can see if any of these ID's are actually in use? Thank you. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: innodb file per table

-configured the my.cnf on the backup server, and I see that the directory size went from 58G to 45G, so there was a nice space savings. Thanks for the advice. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

innodb file per table

is the correct way to reclaim the 12G? Thanks! Regards, Rich Duzenbury -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Combining ansi and theta joins bug?

on agentrelationships.agentidchild = a2.agentid Is there some known bug about combining theta and ansi style joins in the same query? As I say, this works on a 4.1 server, and it will be troublesome to convert all of the old queries in order to upgrade. Thank you. Regards, Rich Duzenbury -- MySQL General

mysqlmanager logging?

logging? Thanks for any help you can offer. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: ~ How to install 3 instances of mysql~

# same for second instance mysql --socket=/srv/mysql/lx20sock create user 'root'@'%' identified by 'password' grant all on *.* to 'root'@'%' identified by 'password'; use mysql; update user set password=password('password') where user='root'; flush privileges Regards, Rich -Original Message

RE: MySql Error Number 1130

the (incorrect) socket? Thank you. Regards, Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 12, 2006 6:00 PM To: mysql@lists.mysql.com Subject: Re: MySql Error Number 1130 When you are trying to connect to port 3307, for example

RE: MySql Error Number 1130

. Thanks. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySql Error Number 1130

-Original Message- From: Barry [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 9:41 AM To: mysql@lists.mysql.com Subject: Re: MySql Error Number 1130 Duzenbury, Rich wrote: localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut

replication, sort of (5.0.18)

server to be one day behind the production server, not real time mirrored, so maybe replication isn't the right thing, I am not sure. I am using the innodb storage engine for most things, though there are a few myIsam tables. Advice appreciated. Thank you. Regards, Rich Duzenbury -- MySQL

RE: MySql Error Number 1130

Interesting. I have never heard of that option. LX09:/home/rduz/backup # mysql -p -h. --port=3307 Enter password: ERROR 2005 (HY000): Unknown MySQL server host '.' (1) Perhaps it no longer functions? Thanks. Regards, Rich -- MySQL General Mailing List For list archives: http

MySql Error Number 1130

, and I've restarted the server several times, to no avail. I am running out of things to try, and hoping someone can see my (what is most likely) obvious error. Thank you. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Delete Duplicates

Hi there. Any quick way of killing duplicate records? Cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Compound Insert Statement

Hi folks. I come to the list with another compound question. My middleware allows me to build any syntax for the actual sql statement, so I'm trying to minimize the work done to insert several records at one try. I currently have multiple insert statements, but can't find any reference to

Update Multiple Records

Hi folks. I want to set the status of 5 records to 'completed'. how do I go about that without having to prepare 5 different instructions? update myTable set status = 'completed' where id=10 OR id=20 OR id=30 OR id=40 OR id=50 I'm trying to reduce the number of instructions. Cheers --

offset or skip_count

Hi folks. I'm wanting to provide some safety for a search. I'll be grabbing about 45 fields, and perhaps thousands of records, so that I can build an xml file using my middleware. How can I structure an SQL statement so that I can jump through records 100 at a time? Do I use offset or

Tiger 4.1.15 Issues

Hi folks. Just installed 4.1.15 on OS X (Tiger 10.4) and am having issues. With permissions, have they changed since 4.1.14? It seems 4.0.x had the following permissions on the data folder: 775 for root/wheel Now, what works for me on this new version, is: 770 for mysql/wheel Also,

Re: Tiger 4.1.15 Issues

Another developer told me his data folder had root/wheel as user/group. Also 775 as the permissions. Just changed it to 700 and it works. As for the kayak issue, it's Safari. It doesn't want to see the web sharing on the very same machine it's on. Very temperamental. Cheers Michael Stassen:

Re: Terrible MySQL Administrator

Hi Scott. Thanks for the reply. Saying that I deleted the crontab was incorrect. I should have said that I deleted the line where that crontab schedule was entered. Anyway, it hasn't shown up as I did a crontab -e, which would have reloaded it, so perhaps it worked. Cheers Scott Haneda:

Terrible MySQL Administrator

Hi folks. Since I installed MySQL Administrator on OS X and tried to put a schedule in for a backup, the thing simply won't go away. It sends an email into my mail app in the terminal on a daily basis and it's driving me mad...slowly...bit by bit. Can someone suggest how I get rid of these

Re: Function to show when a field's value was last updated

Unfortunately that would have to be designed into the system into a field. When updated, the instructions would be to instruct that field to update. Cheers Mark: I need it some info to help a client defend against a legal challenge. Is there a MySQL function that will allow me to ascertain

Re: automatic backups not working MySql Admin

If you open your terminal, you'll see some error messages waiting for you. Apparently it's buggy. I turned off my admin backups. Cheers John Doneker: Is this because this free software doesn't supply this functionality? Or could it be a bug? Is there another answer? -- MySQL General

MySQL Administrator Cron Errors

Hi folks. Downloaded the new Admin for OS X. I set a weekly cron and for some reason, it's emailing my terminal Mail app saying it couldn't load a profile. It's not the address I told it to send it to, and I don't quite get why it can't load a profile. Having just tried to back up my tables

Joins Tutorial Anywhere?

Hi folks. Any chance on a tutorial from joins? I find them totally confusing and I know there's some power in them, so I need to learn them. Having asked that, another question arises...do my field names in different tables within the same database have to overlap (same field name) in order for

Re: Joins Tutorial Anywhere?

Thanks Shawn. My naming convention (table_field) is more for my middleware development. Much easier to see what to grab that way. It started when was doing embedded inlines (pre-joins) and found the reference to 'id' was confusing. Anyway, thanks for the join tutorial links, folks.

Re: dynamic value like excel

] Rich Allen Dare Do -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Locking Methods

Hi there. I started a different thread on this, but then I realized I might not have to use InnoDB for this. Let me explain what I wish to achieve. I want to create records in an established table. I then want them locked (either by locking the whole table or by individual record) so that they

Re: SCO issue

. MySQL AB doing work for SCO is one thing, partnership would be much a different matter which would then lead me to agree that looking at Pg would be a good idea. Hopefully MySQL AB will make all this clear one way or the other ... Rich Allen Dare Do

InnoDB Record Lock Command

Hi there. I am looking for the syntax to lock individual records in an InnoDB table. I can't seem to find anything outside of locking full tables. Any urls out there? Cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: InnoDB Record Lock Command

something along the lines of: mysql select * from table where column = value lock in share mode On Sep 5, 2005, at 4:01 PM, Rich wrote: Hi there. I am looking for the syntax to lock individual records in an InnoDB table. I can't seem to find anything outside of locking full tables

views in 5.0.11

. is this a known issue? running mysql on mac os x 10.4 thanks Rich Allen Dare Do -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: all user command

mysqladmin processlist On Jul 26, 2005, at 5:21 PM, Joeffrey Betita wrote: hello what command should i type to see all the user connected to the database. thank you very much. Rich Allen Dare Do -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQLDump - Command line password

have you looked at using a my.cnf file? eMac:~ hcir$ mysqldump test /temp/test.sql eMac:~ hcir$ ls -l /temp/test.sql -rw-r--r-- 1 hcir staff 78893008 Jul 19 16:47 /temp/test.sql contents of ~/.my.cnf [client] user= username password= password # actual username and

Re: How do you become a MySQL DBA

do to help develope DBA skills? Right now I have very little data that goes beyond 2 tables, so my query skills are withering. Rich Allen A kidney transplant saved my life, plese consider being an organ donor. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Tiger - MySQL --- any news ???

i am running 4.1.9 binary on tiger without any trouble Your MySQL connection id is 1 to server version: 4.1.9-standard - hcir On May 23, 2005, at 1:03 PM, Kevin Victor wrote: I would like to know if there is any existing solution for running MySQL on Tiger. I dont see a binary version for

Re: Can someone explain???? strange query!!

with address and zipcode, not the line with first_name and so forth. How did it find that row when the fields are NULL? I believe it isn't. Do the query with \G instead of ; on the end so that you see what values are in which columns. -Rich -- Rich Lafferty

mysql syntax

I'm used to doing something simple such as the following in sql server: SELECT u.Username, p.UserID FROM Users u LEFT JOIN Person p ON u.UserID = p.UserID However, I'm not seeing the same results in MySQL. I don't get all the recs in the users table and NULLs in the userID

RE: mysql syntax

) THis will return both the matching recs from the user table and NULLs from the person table in sql server, but is what I cant get to work in mysql... _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 19, 2005 3:14 PM To: Rich Brant Cc: mysql@lists.mysql.com

Re: Group By - Is there a way to set which rows values are used for the fields not in the Group By clause?

, itemname from viewvisitor where ownerid = 2 GROUP BY concat( app, itemid ) ORDER BY totalcount; Rich Carr wrote: Is there a way to set which rows values are used by the GROUP BY clause for the fields that are not in the GROUP BY clause? In this following select statement the group by and order work

Re: Group By - Is there a way to set which rows values are used for the fields not in the Group By clause?

Thanks again! Dan Bolser [EMAIL PROTECTED] wrote:On Tue, 12 Apr 2005, Rich Carr wrote: Hi Dan, Thanks very much! First, I can't figure out how to reply to this so that it shows up in the MySQL list. How does one do it? erm... if you hit 'reply all' or answer yes to 'reply to all' it should

Group By - Is there a way to set which rows values are used for the fields not in the Group By clause?

), lastviewtime DATETIME NOT NULL, viewcount INT, itemname VARCHAR(40), PRIMARY KEY master(app, visitorid, itemid), INDEX (ownerid), INDEX (lastviewtime), INDEX (viewcount) ); Thanks!!! Rich - Do you

change a column type and innodb foreign key constraints

and then reestablish the foreign keys. Could anyone confirm or advise of a better solution? cheers Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

access two like tables with one query

iH i have a database that i only have READ access to (i am not the creator). there are tables with stats data that are created each day; ie data3_1_2005 and 'data3_2_2005. each table has the same layout. create table data3_1_2005 ( port char(8), tmval int, val int ) how can i create a single

Re: mysql vs postgresql

On Fri, Feb 25, 2005 at 06:43:50PM +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: Don't you think it is childish to link to documentation from 2003? I've never seen a child do anything like you describe. -Rich -- Rich Lafferty

Re: wikipedia down, slashdot covering, mysql mentioned

because it can't survive a fire. -Rich -- Rich Lafferty --+--- Ottawa, Ontario, Canada| Save the Pacific Northwest Tree Octopus! http://www.lafferty.ca/|http://zapatopi.net/treeoctopus.html [EMAIL PROTECTED

Re: wikipedia down, slashdot covering, mysql mentioned

/words/2004_mysqlcon/mysql-slides.pdf for an overview. (My kit at the same facility was hit too, and recovered correctly, for what it's worth. :-) At least this mailing list has progressed beyond Why didn't they have a UPS?, I suppose. :-) -Rich -- Rich Lafferty

Re: Backup User

a command that puts your password in the output of 'ps'! Command lines are always public information. Put the password for mysqldump in the running user's ~/.my.cnf instead, and tighten the permissions on *that* file. [client] password=Your password goes here -Rich -- Rich Lafferty

Re: set auto_increment does not work?

can duplicate what I saw then it might be worth following up with MySQL AB after testing in the latest MySQL release. -Rich -- Rich Lafferty --+--- Ottawa, Ontario, Canada| Save the Pacific Northwest Tree Octopus! http

Re: one hour is/is not 60 minutes, that's the question...

| ++ 1 row in set, 1 warning (0.00 sec) ^^ Did you check the warning (with SHOW WARNINGS)? -Rich -- Rich Lafferty --+--- Ottawa, Ontario, Canada| Save the Pacific Northwest Tree Octopus

Re: Need help with SELECT

); This approach won't give you a row for Event 3 since it doesn't exist in EventFiles. I'm sure this can be solved with a little work. Sorry I didn't you the same column names as you did, but I was in a hurry. A report writer or even ACCESS makes these cross-tab reports trivial. Regards Rich -- MySQL

Odd MySQL error

that it had to do with the mysql process and/or the limits set upon the mysql user account, but that was all speculation. Ideas, Comments, Suggestions are all more than welcome! -Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

best way to restore remote database

need to retrore the tables individually. What's the command to restore all the tables at once? 3. Can I use control center to accomplish this, or deos it have to be done via the command line? Thanks! Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: On the licensing once again

not giving you right now :-). -Rich -- Rich Lafferty --+--- Ottawa, Ontario, Canada| Save the Pacific Northwest Tree Octopus! http://www.lafferty.ca/|http://zapatopi.net/treeoctopus.html [EMAIL PROTECTED

Re: Large 30 GB Database

i have one MySQL dB that is currently about 26Gb, properly indexed searches are very quick - hcir On Jul 28, 2004, at 4:23 AM, matt ryan wrote: Should I even attempt this using mysql? Has anyone played with this much data in mysql? I've got two 100 gig databases in mysql, and slave replication

Re: MySQL and Macs

iH any machine running OS X can run MySQL, this link http://dev.mysql.com/downloads/mysql/4.0.html has a Mac OS X version with a package installer - hcir On Jun 29, 2004, at 5:14 PM, Jim Carwardine wrote: Im new to the list and new to mySQL. Im a Mac user and would like to set up a DB on my

Re: How to monitor that slave is not working because of user rights?

time every, say, 30 seconds or a minute. On the slave, read that row and compare the current time to the value in it; if they're more than, say, twice the update period off, you know that updates aren't getting replicated. Cheers, -Rich -- Rich Lafferty

Re: load data infile

sounds like --safe-mode has been turned on, check your my.cnf files - hcir On Jun 10, 2004, at 7:18 PM, Nik Belajcic wrote: I have a strange problem importing data from a text file. There are 1353 rows in the text file (generated by a Perl script) but only 1000 get imported into MySQL. I am

Re: Query question

Garth, good catch! - hcir mysql - hcir On May 24, 2004, at 1:05 PM, Garth Webb wrote: On Mon, 2004-05-24 at 11:32, John Nichel wrote: Rich Allen wrote: iH this should work test select * from xt; ++---+ | id | field | ++---+ | 1 | 0 | | 2 | 0 | | 3 | 7 | | 4 | 8

Re: Query question

iH this should work test select * from xt; ++---+ | id | field | ++---+ | 1 | 0 | | 2 | 0 | | 3 | 7 | | 4 | 8 | | 5 | 7 | | 6 | 0 | | 7 | 6 | | 8 | 7 | | 9 | 8 | ++---+ 9 rows in set (0.00 sec) test select count(distinct(field))

Alter table primary key and foreign keys

the data in forecast before altering bom_mstr and I get the same result. Anyone seen this before or have any idea??? Thanks, Rich

RE: Alter table primary key and foreign keys

The error log shows nothing when the binary dies. I can't rebuild the child table - anything that touches the child table after the alter stops the binary. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 2:07 PM To: 'Rich Schramm

Re: Problem running MySQL on MacOS X.3

ps should show you something like the following: Jupiter:~/desktop hcir$ ps uax | grep mysql root 291 0.0 0.118644 1072 ?? S 3May04 0:00.06 sh ./bin/safe_mysqld --user=mysql mysql 338 0.0 2.551720 19872 ?? S 3May04 10:17.86

Re: Perl Modelues

. Kirti -Original Message- From: Rich Allen [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 6:02 PM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]' Subject: Re: Perl Modelues you can install Perl modules with $ perl -MCPAN -e shell cpan install [module::name] - hcir mysql - hcir

Re: Perl Modelues

you can install Perl modules with $ perl -MCPAN -e shell cpan install [module::name] - hcir mysql - hcir On Apr 7, 2004, at 10:57 AM, Kirti S. Bajwa wrote: Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL

my.ini file for two instances of MySql - need help

Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both running. What do I need to add to the

RE: my.ini file for two instances of MySql - need help

] To: 'Rich Brant' [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: my.ini file for two instances of MySql - need help Date: Mon, 12 Jan 2004 10:55:21 -0600 Here is an example of what I used: [mysqld] # set basedir to your installation path basedir=C:/mysql # set datadir to the location of your data

RE: my.ini file for two instances of MySql - need help

Ok, Thanks Tobias! I'm all set. And I actually found the relevant info in the manual. Sorry for the bother, all. From: Tobias Asplund [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: 'Rich Brant' [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: my.ini file for two instances of MySql

Re: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

except MYSQL the program is installed in the C:Program files- EASY PHP1.7- MYSQL. I recieve the following error, Can't connect to MySQL server on 'localhost' (10061) Do I need to change the port setting? or do I need to install in the C:/ folder? any advice is muchly appreciated. rich

finding equations intersections

I have a simulation of moving objects that interact with each other. If I store the object positions as coordinates, I think I will need at least one database call for every object to determine intersections. [for N objects there are N database calls] I'm wondering if I could do the same thing

SQL and evaluating expressions

Can SQL statements evaluate expressions? I want to store thousands of equations, and return a subset when I plug in a value. For instance, if I stored the following two equations: x = y + 5; x = 100 / y; I might want to query for all records whose x is less than 10 when y is equal to 3. I'd

RE: SQL and evaluating expressions

Okay, after reading the MySQL manual I figured out how to get what I want. Can anyone advise me where to send such newbie questions in the future so that I would get a response? I realize my question was a SQL database question and not a MySQL-specific database question, but I figured the

Re: hostname

127.0.0.1 is always localhost, perhaps you could make this change in your scripts - hcir use MySQL is there a way to find out which host I am connected from? My CGI script checks privileges of users based on host names they came from. But their hosts some times are detected as IP. E.g. when

Re: MySQL access issue

this link from the mysql docs should help http://www.mysql.com/doc/en/Resetting_permissions.html - hcir Kind of an oddball question but I'll try to make it as clear as possible. We have a Solaris server, that we have root access to. It houses mysql db's and information. I was not the admin for

  1   2   >