Re: % wildcard host permission not working

2008-04-24 Thread Erik Giberti
Did you FLUSH PRIVILEGES? I'd also check that the username and passwords are the same for each host entry, I've had problems if passwords were different for a shared username from different hosts. On Apr 24, 2008, at 8:58 AM, Adam Gerson wrote: I set up a user and entered % for the host. I

Re: Where are actual databases stored?

2008-02-08 Thread Erik Giberti
RedHat centric systems store them in /var/lib/mysql On Feb 8, 2008, at 2:55 PM, Riccardo Perotti wrote: Hi all: Our sistem crashed and we're trying to recover our data. The disc is fine but the OS is gone, so I'm trying to get at the actual mysql databases document. Does anybody know

What about binary files? [was: Re: transfer huge mysql db]

2008-01-29 Thread Erik Giberti
Documentation: http://dev.mysql.com/doc/refman/5.0/en/moving.html Erik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Storing Larger MySQL Backups

2008-01-16 Thread Erik Giberti
(or multiple CD-R's if so desired.) Does anyone have any feedback on this approach? Without laying out money for a higher capacity DVD/BlueRay drive or tape backup system, what options are you using for data retention? Thanks for your thoughts. Erik Giberti -- MySQL General Mailing List

Re: Performance problem - MySQL at 99.9% CPU

2008-01-09 Thread Erik Giberti
I'm on my resource load drop in 1/2. Freeing up those resources for other tasks (like MySQL.) Good luck! Erik On Jan 8, 2008, at 5:47 AM, Gunnar R. wrote: Thank you Erik! HDs are OK, a couple of GB free. Not that it's a lot, but I can't imagine it being too low for MySQL.. I'm aware

Re: Performance problem - MySQL at 99.9% CPU

2008-01-03 Thread Erik Giberti
that's particularly problematic, perhaps optimizing the indexes etc on the table might help with the performance. Also, make sure your HD's aren't full... that will kill performance very quickly if the needed disk space isn't there. Erik On Jan 3, 2008, at 3:44 PM, Gunnar R. wrote: Hello

Re: Assistance avoiding a full table scan

2007-09-26 Thread Erik Giberti
Brent, I tried this and it definitely boosted performance. On a test query that would take 2+ seconds to run with 20 id's - it ran in 0.002 seconds. Thanks everyone for your help and comments. Erik On Sep 21, 2007, at 2:01 PM, Brent Baisley wrote: As others have mentioned, mysql

Assistance avoiding a full table scan

2007-09-21 Thread Erik Giberti
the full table scan? Thank you in advance for your assistance. Erik Giberti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Vertical Tab problem

2006-07-14 Thread Saline Erik
Brent, Both worked like a charm. Thank you so much. I kicked myself for not thinking of CONCAT. Yes, Filemaker joy. Actually I have another word in mind. But with you help and expertise we are slowly walking away from Filemaker. Erik On Jul 14, 2006, at 7:02 AM, Brent Baisley wrote

Re: Field name DESC

2006-07-13 Thread Saline Erik
How about desc_ ? Erik On Jul 13, 2006, at 8:42 AM, Anthony wrote: Hello, i want to know how i can create a table with the feild name desc ? when i do: CREATE TABLE bank ( name varchar(50) NOT NULL default '', desc varchar(50) NOT NULL default '', ) the desc is badely interpreted

Vertical Tab problem

2006-07-13 Thread Saline Erik
ideas would be great. Erik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Sorting by relevance?

2005-05-09 Thread Erik Bukakis
I just learned a lot stuff at http://dev.mysql.com/doc/mysql/en/sorting-rows.html including sorting by number-to-text, text-to-number, names, specific values, etc. However, the document didn't mention on how to sort by relevance. For instance, someone search for Ang: COLUMN NAME: name COLUMN

Re: Sorting by relevance? [SOLVED]

2005-05-09 Thread Erik
Thank you Roger! :) This works well for me! ^_^ Thanks also to the other guys that I replied. :) Ang sabi sa akin ni Roger Baklund noong 06:12 AM 5/10/2005... This way and only four rows in the example is a bit vague, but maybe something like this could work for you: $crit = 'Ang'; # test case

A question on INTERVAL

2003-11-11 Thread Erik Osterman
like to avoid using approximate techniques such as using 86400 seconds for a day, since calculating months and years _accurately_ is very involved. P.S. DATE_SUB(created, INTERVAL subscriptions.term subscriptions.unit) had the same parse error. Regards, Erik Osterman -- MySQL General

RE: help on my query statement

2003-11-10 Thread Erik Osterman
(*) FROM TRANSACTION WHERE REGDATE Now()-INTERVAL 15 DAY GROUP BY WHAT Would let you know how many times WHAT happened 15 days ago. Regards, Erik Osterman http://osterman.com/ -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: Sunday, November 09, 2003 10

RE: Aliases

2003-11-10 Thread Erik Osterman
However, you can use HAVING. HAVING is post-processed, in a brute force method (no indexes can be used). Select invno, invdate, invamt, left(invdate,2) as month from salesfile HAVING month = '01' But I would use Roger's example since it can take advantage of indexes. Regards, Erik

RE: Aliases

2003-11-10 Thread Erik Osterman
From: Matt W [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 5:47 PM To: Erik Osterman; [EMAIL PROTECTED] No, Roger's method can't use an index. :-) But yes, using WHERE is better than HAVING. Ah... right indeed. In this case it wouldn't work. My mistake... :) To get

RE: Aliases

2003-11-10 Thread Erik Osterman
generalization: Indexes may be used where a function's input domain does not reside in the table itself. Unfortunately for David, he's still SOL. Let's see, what else am I neglecting? =) Regards, Erik Osterman http://osterman.com/ -Original Message- From: Leo [mailto:[EMAIL PROTECTED

RE: Update table with UNIX_TIMESTAMP

2003-11-08 Thread Erik Osterman
FROM_UNIXTIME( start, '%m/%d/%Y' ) as start_date FROM table; For more information go to http://www.mysql.com/doc/en/Date_and_time_functions.html Hope that helps, Erik Osterman http://osterman.com/ -Original Message- From: Ron McKeever [mailto:[EMAIL PROTECTED] Sent: Saturday, November

RE: Secure way of storing passwords in the database

2003-11-07 Thread Erik Osterman
($password); $password is the user's input password. Regards, Erik Osterman http://osterman.com/ -Original Message- From: David T-G [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 9:05 PM To: mysql users Cc: Luis Lebron Subject: Re: Secure way of storing passwords in the database

Full-text search on PDF, Word etc in TEXT colums?

2003-10-23 Thread Jan-Erik Öhman
on these documents. Q1: Is it possible to do full-text searches on PDF, Word, XML, HTML etc documents stored in TEXT columns? Q2: Is there a list of supported document formats for MySQL full-text search? Thanks for any help, Jan-Erik Öhman

Mysql replication with 2 masters and 1 slave

2003-06-22 Thread Erik Olsen
Is it possible for slave to connect to 2 different masters and have synchronized database from both? Planning to have one backup mysql backup server that's has to synchronize/backup 2 master server. Followed the manual and got master / slave up and running without problem. Can I use something

RE: Mysql replication with 2 masters and 1 slave

2003-06-22 Thread Erik Olsen
Yes. The idea was to backup 2 masters, 1 that is ours and 1 that is a costumer. The slave's job is just going to have a synchronised db of both servers db. The plan was to have it on a different place in case of fire. But I must find another solution then. Erik Olsen wrote: Is it possible

query

2003-03-12 Thread Erik DeBattista
? i would really appreciate a reply Erik DeBattista Systems Developer Webcraft Ltd. --CONTACT DETAILS--- www.webcraft.com.mt Email: [EMAIL PROTECTED] Tel: +356 21421540 Fax: +356 21419300

query

2003-03-07 Thread Erik DeBattista
? i would really appreciate a reply Erik DeBattista Systems Developer Webcraft Ltd. --CONTACT DETAILS--- www.webcraft.com.mt Email: [EMAIL PROTECTED] Tel: +356 21421540 Fax: +356 21419300

query re: Innodb Table Locks

2003-03-05 Thread Erik DeBattista
? i would really appreciate a reply Best Regards Erik DeBattista Systems Developer Webcraft Ltd. --CONTACT DETAILS--- www.webcraft.com.mt Email: [EMAIL PROTECTED] Tel: +356 21421540 Fax: +356 21419300

Re: MySQL IMAP Server

2003-02-09 Thread Erik Retz
Pretty sure dbmail can use mysql. www.dbmail.org -Erik --- Ben Clewett [EMAIL PROTECTED] wrote: Paul DuBois wrote: I believe the Horde IMP server uses MySQL: http://www.horde.org Thanks. Looking at this, I belive it's an IMAP clinet. Unless the web site is in error. I

make command problem

2003-01-31 Thread Erik Chavez Ortega
I was trying to install mysql on a mac g4 following the instructions provided by the followin link http://www.mysql.com/doc/en/Quick_install.html but when I got to the make command I got the following error: [localhost:~/mysql-4.0.4-beta] erix% make make: Command not found. I also found out

Zoombie threads when listing with show processlist.

2002-11-05 Thread Erik Zapien
| +-+-+---+---+-++---+-+ 5 rows in set (0.00 sec) Any ideas on this? Thanks in advance, --Erik Zapien

Fehler beim Zugriff von Java auf mysql datenbank

2002-10-25 Thread Lang, Erik
Handler.at org.apache.catalina.connector.warp.WarpConnection.run(WarpConnection.jav a: at java.lang.Thread.run(Thread.java:536) Wer kann mir helfen oder tipps geben wo ich eine antwort finden kann. Mit freundlichen Grüßen Erik Lang goetzfried ag - Ihr Projektpartner Windmühlstraße 14 60329

RE: problem with Linux

2002-10-08 Thread Erik N. Mullinix
Passwords match. If you add the user to your domain controller you will need to add the user to the local system group for administration. I don't know if this will fix the issue, however it should be a direction to go in. Erik Mullinix -Original Message- From: Mark Matthews [mailto:[EMAIL

slow-queries.log vs. explain

2002-09-03 Thread Erik Retz
I've been monitoring slow-queries.log to try and find querys that might be causing problems. I see the following logged: # Time: 020903 16:59:14 # User@Host: cfweb[cfweb] @ storm.centurytel.net [10.10.1.17] # Query_time: 47 Lock_time: 0 Rows_sent: 5 Rows_examined: 145240 SELECT

Failed on getting reply's on:: How to download a mssql db to mysql once a day

2002-08-01 Thread Lars Erik Petersen
who answered to this question could post it again since I'm in quite a hurry to solve this problem. Thanks again ps: I have subscribed correctly this time:) Sincerely Lars Erik Petersen Original message: Hi! Does anyone know how to copy/download a mssql db running

How to download a mssql db to mysql once a day

2002-07-30 Thread Lars Erik Petersen
a mssql into fully working mysql db by copy once a day? In advance, thank you! Sincerely Lars Erik Petersen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: getting totals with data

2002-06-18 Thread Erik Price
the LIMITed number of rows, whereas I'm trying to determine how many rows would be returned if I had not used LIMIT (the total hits part of displaying X through X of X total hits). Thanks for the pointers, Galen. Erik PS: to any who respond to this thread, please CC me as I have temporarily

is this query possible?

2002-06-14 Thread Erik Price
, then I'll use the value of sub2other to do what I want to do, and vice versa). But this just doesn't seem possible. I can always do it with two separate queries if need be, but it would be elegant to do it with one. Any advice? Thanks very much, Erik Erik Price Web Developer Temp Media Lab

Re: MySQL not starting ?

2002-06-14 Thread Erik Price
one hyphen before user? Try using two: [root]# safe_mysqld --user=root Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Re: is this query possible?

2002-06-14 Thread Erik Price
it. Erik On Friday, June 14, 2002, at 04:05 PM, Luc Foisy wrote: How bout SELECT main.id, sub1.other, sub2.other FROM main LEFT JOIN sub1 ON main.sub1fk = sub1.id LEFT JOIN sub2 ON main.sub2fk = sub2.id Luc mysql,sql -Original Message- From: Erik Price [mailto:[EMAIL PROTECTED

Re: Reconstructing SQL create table statements

2002-06-14 Thread Erik Price
the CREATE TABLE statements. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

mulitple uses of a foreign key

2002-05-29 Thread Erik Price
AND projects.canceler_id = people.people_id, or projects.finisher_id = people.people_id, depending on whether the project was finished or canceled. But I also need to be able to determine from the query whether the project was finished or canceled. Thanks! Erik Erik Price Web Developer Temp Media Lab, H.H

Re: Installing / Running

2002-05-27 Thread Erik Perrohe \(Computer Consultant\)
bunch of time isolating this (could not find anything obvious...) I solved the problem by creating a config file to explicitly set the socket path and made sure my config file was the last one looked at... Hope this Helps, -- Erik - Original Message - From: Gurhan Ozen [EMAIL PROTECTED

Re: random order by id

2002-05-19 Thread Erik Perrhoe \(Computer Consultant\)
To pick one item at random what you want is Select foo from bar Where ID = rand() * scale To order them randomly, I seem to recall that there was an example of how to do it in the mySQL manual. -- Erik Perrohe - Original Message - From: Per Andreas Buer [EMAIL PROTECTED

Re: Database and all backups lost at same time

2002-05-19 Thread Erik Perrhoe \(Computer Consultant\)
$120 US well worth the investment. Good Luck, -- Erik - Original Message - From: kibserv-FtS Setiqueue [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Saturday, May 18, 2002 1:44 PM Subject: Database and all backups lost at same time This is an odd one. I seem to have

Re: newbie mysql install

2002-05-19 Thread Erik Perrhoe \(Computer Consultant\)
into when setting up my Linux server is that something was screwy such that it was creating the socket in one location and looking for it in a different location. I solved this problem by overridding and explicitly setting the fully qualified path to the socket. -- Erik - Original Message

Re: MySql Client fails to connect

2002-05-19 Thread Erik Perrhoe \(Computer Consultant\)
attention to the section on security... making the server directly accessible is going to expose you to possible hacker attack, make sure you know what you are doing... Ciao, -- Erik Perrohe - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

Databases with Tables approaching several million

2002-05-15 Thread Erik Fears
to be fast, and would not be able to handle databases of large sizes and I'm just wondering if this is largely true or not. Thanks, Erik Fears - Before posting, please check: http://www.mysql.com/manual.php (the manual

Unicod problems

2002-05-14 Thread Svend Erik H. Jørgensen
, but doesn't that gives me a problem when searching on text fields? Anyone have a suggestion? How much space do you need for an UTF-8 encode string/char ? -- Svend Erik Høst Jørgensen mailto:[EMAIL PROTECTED] Pallas Informatik A/S http://www.pallas.dk Allerød

deleted tabels in innodb file

2002-05-01 Thread Svend Erik H. Jørgensen
file to the current database. InnoDB: Then MySQL thinks the table exists, and DROP TABLE will InnoDB: succeed. Is there anyway to restore the table design's ? Thanx !. -- Svend Erik Høst Jørgensen mailto:[EMAIL PROTECTED] Pallas Informatik A/S http://www.pallas.dk

Re: MySQL on OS X

2002-04-25 Thread Erik Price
/libSystem.B.dylib I'm running 10.1.3, with the Dec2001 Developer Tools installed. Perhaps it was provided by those, do you have them installed? Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED

Re: AW: MySQL on OS X

2002-04-25 Thread Erik Price
the precompiled binary, or build your own binary from source code - The MySQL binary on the web site, that is built for Mac OS X, does NOT need to be compiled, so you do NOT need the developer tools to use it Erik - what version of SQL (and installation method) have you used? I've successfully installed

Re: how to get support help?

2002-04-25 Thread Erik Price
problems for you, one that welcomes bitching when things don't go your way. In other words, do you want your money back? Erik On Thursday, April 25, 2002, at 12:11 PM, Clay Loveless wrote: At this point, I'd like to solicit tips on how I might get my support related concern addressed. It seems

Re: how to get support help?

2002-04-25 Thread Erik Price
questions/answers, I'm stumped on why a legitimate, undocumented problem doesn't seem to be a concern to anyone but me. Did you submit a bug report? http://www.mysql.com/doc/B/u/Bug_reports.html Erik PS: way off the subject, a platform that's getting as much publicity as Mac OS X Server Mac

Re: how to get support help?

2002-04-25 Thread Erik Price
that their problem was heard. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2002-04-25 Thread Erik Price
? If so, use that. It would look something like: /usr/local/mysql/bin/safe_mysqld --socket=/path/to/socket Good luck Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check

Re: Order by

2002-04-25 Thread Erik Price
save the extra processing cycles by doing it in the database? Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: table-building advice requested

2002-04-19 Thread Erik Price
of null values in my table. What do you think? Thanks for reading! Thanks even more if you can help me. Erik On Thursday, April 18, 2002, at 03:52 PM, Erik Price wrote: Hello, I was hoping to solicit some advice on the structure of the database I am building. Here

Re: Selecting Information Just Inserted

2002-04-19 Thread Erik Price
SELECT MAX() on that column. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

table-building advice requested

2002-04-18 Thread Erik Price
if this is really a good idea -- when I need to query for all records in printedfiles and categorize them, will I be able to use this source column? Or is there a better way I could be going about all of this... Thanks for any insight you can provide. Erik Erik Price Web Developer Temp

Re: time zones?

2002-04-12 Thread Erik Rantapaa
type as a convenient way to keep tabs on when a row was modified, if doing date arithmetic on the column is a concern. Erik Rantapaa [EMAIL PROTECTED] On Fri, Apr 12, 2002 at 09:26:33AM -0400, Bradley Brown wrote: I would like to second this notion if I may. I was up until midnight (EST) last night

Large datafiles

2002-03-27 Thread Svend Erik H. Jørgensen
? If i could use the last 2 gb on the partition, my problems would be solved for the next 4 months, any sugestions ? Im also considering installing a rh7.2 with the sgi xfs, anyone having any experiance with XFS ? -- Svend Erik Høst Jørgensen mailto:[EMAIL PROTECTED] Pallas

Large datafiles

2002-03-27 Thread Svend Erik H. Jørgensen
Well, if i'm usin ext2 with a blocksize on 4 kb, then the largest file should be about 4 gb, right ? -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: 27. marts 2002 12:16 To: [EMAIL PROTECTED] Subject: Large datafiles Svend, Wednesday, March 27, 2002, 12:30:28 PM,

Syntax question.

2002-03-06 Thread Erik Schwartz
Hi, Trying to figure out how to convert Sybase ASA syntax to MySQL. Need to select alpha ranges as in: SELECT * FROM table WHERE name LIKE '[A-Z]%' but this doesn't work. Appreciate your help, Erik Schwartz Systems Engineer InfoUSA 818-428-1040 [EMAIL PROTECTED] --- Outgoing mail

Can't restart MySQL after innodb table filled up

2002-03-04 Thread Erik Barker
:33:02 mysqld ended - I've also tried changing a few values in the my.cnf file including changing the number of threads to 1 and increasing the size of the DB to 600M. Is this a known bug? Thanks, -- Erik Barker Sr. Systems Engineer NetNation

bumping up table values

2002-03-04 Thread Erik Price
or UPDATE statements -- nothing this big yet. Is it normal to have a script that does all of this in different steps? Could I make better use of MySQL's resources? Thanks for your advice on these questions. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED

Re: another xml thread

2002-02-19 Thread Erik Price
on their point. But I did not have a second look, so I am not sure if I am mis-remembering. Yes, there was a lot of back-and-forthing. Thanks, Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before

another xml thread

2002-02-18 Thread Erik Price
the wrong tree, but storing data in flat files doesn't seem to be the only way to use XML. I don't plan on beginning this project for a couple of weeks at least, so it's not really important. Again, if this is an inappropriate question for the list, send me packing. Thanks, Erik

INSERTing duplicate values to a UNIQUE-indexed table

2002-02-04 Thread Erik Price
to be such a perfectionist? I would post code but this is all pseudocode right now b/c I haven't solved this dilemma yet -- all experimentation with this has been done from the mysql client. Thanks for your advice! Erik - Before posting, please

Re: INSERTing duplicate values to a UNIQUE-indexed table

2002-02-04 Thread Erik Price
I know about both options! Much appreciated, Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: [PHP] Mac OSX !?!?!?

2002-01-17 Thread Erik Price
compatibility with any operating system. It can be installed via Fink (http://fink.sourceforge.net) very easily, and is in fact required by many Fink packages. I must confess that I do not know much about it. Erik On Wednesday, January 16, 2002, at 08:01 PM, Richard Baskett wrote

INSERTing into joined tables?

2002-01-09 Thread Erik Price
as I can use the WHERE clause in an UPDATE statement. If anyone has a link to a tutorial on this very concept, that would be greatly appreciated as well! Thank you, Erik - Before posting, please check: http://www.mysql.com

Re: INSERTing into joined tables?

2002-01-09 Thread Erik Price
! Erik -Original Message- From: Erik Price [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:14 AM To: [EMAIL PROTECTED] Cc: Etienne Marcotte Subject: INSERTing into joined tables? Hello, everyone -- I have received a great deal of help from many members

Re: Watchdog für mysql in Perl?

2002-01-04 Thread Erik Price
the password as you type it [yet]). I'm sure that you could do a better script than this in Perl, which I don't yet know. I'm still learning how to write bash scripts (this is my second one that does anything useful) so if this code is amateurish, sorry. Erik On Friday, January 4, 2002, at 06:52 AM

ENUM -- integers or strings?

2002-01-04 Thread Erik Price
! Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED

Re: ENUM -- integers or strings?

2002-01-04 Thread Erik Price
is done, I can't test... conundrum? Erik On Friday, January 4, 2002, at 03:07 PM, Rick Emery wrote: What happened when you experimented? What were your results? -Original Message- From: Erik Price [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 2:03 PM To: [EMAIL

mysqlshow expands my argument

2002-01-02 Thread Erik Price
argument as a wildcard for filename expansion? Thanks for any help. Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

an example INSERT statement

2002-01-02 Thread Erik Price
can find this info would be helpful. The INSERT syntax page in the official documentation (http://www.mysql.com/doc/I/N/INSERT.html) doesn't address this specific circumstance, or if it does then I'm too dense to figure it out. Thanks! Erik

Re: are my queries bloated?

2001-12-10 Thread Erik Price
of the users in touch. I would love to take a class on this subject! -- Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Slow results with SELECT's that return large numbers of results

2001-12-06 Thread erik pearson
:Now, is there any way I can quickly return the length of the :result set withotu :actually returning the result set itself? : : :Chris : :(MySQL question, obviously ;-) Dunno if this was answered cause I'm on digest but, Try SELECT Count(*) from... erik st.m

Re: just moved from windows to linux mysql

2001-12-06 Thread Erik Price
with existing data, and backing up an existing database. I don't mean the ones in the mysql manual, I am looking for more of a made for dorks like me version. MySQL by Paul DuBois (New Riders). Sorry I don't have a web reference, but this book is very helpful. Erik

Re: are my queries bloated?

2001-12-06 Thread Erik Price
much relieved, thanks Rodney. I suppose there's nothing wrong after all but, it seemed like a lot of joins (more than I see in other examples). I guess I will get started with the PHP !!! -- Erik On Thursday, December 6, 2001, at 06:05 PM, Rodney Broom wrote: What you've got looks fine to me

Re: [PHP] Mac OSX and MySQL

2001-12-05 Thread Erik Price
this tutorial doesn't assume that you want to install MySQL. Any questions, email me. Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: [PHP] Re: Mac OSX and MySQL

2001-12-05 Thread Erik Price
you how to create a user. Erik PS: don't use System Preferences' Users to make dummy users for MySQL and other services. On Wednesday, December 5, 2001, at 10:04 AM, René Fournier wrote: I have to create a MySQL for my PHP scripts. How do I do this in Mac OSX? There are a bunch of command

Re: more than one possible column value

2001-12-04 Thread Erik Price
that (this project was much easier when the relationships were all one-to-one !! :-) . Thank you very much for your help, Etienne. -- Erik On Tuesday, December 4, 2001, at 01:23 PM, Etienne Marcotte wrote: hum I have an hard time understanding, but if I'm right: CREATE TABLE files( fileID

Re: more than one possible column value

2001-12-04 Thread Erik Price
questions. Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail

Re: mySQL in-memory configuration

2001-12-03 Thread Erik Price
I'm not sure, but you'd be in big trouble if your system lost power! -- Erik On Monday, December 3, 2001, at 10:50 AM, Banach, Timothy P wrote: Hello, Can mySQL be configured to run entirely in-memory? That is, can one configure it so that all the tables, data, etc. remain resident

Re: How To Install Under MacOS X?

2001-11-30 Thread Erik Price
prefer it over the GUI or binary installs. Feel free to contact me directly if you have a problem, I just got MySQL up and running on Mac OS X the other day. --Erik On Thursday, November 29, 2001, at 08:29 PM, Kundan Kumar wrote: Try installing by fink.. http://fink.sourceforge.net

Designing a database to track files

2001-11-30 Thread Erik Price
will work in the same fashion (by assigning each entry an INTEGER rather than a name). Thanks, -- Erik the office temp who was told to design a database and write a web front-end, with no experience in either - Before posting

Re: Designing a database to track files

2001-11-30 Thread Erik Price
for the tip about using single ticks. Sincerely, Erik On Friday, November 30, 2001, at 01:53 PM, Jens Vonderheide wrote: That's nearly correct. You could use SELECT files.file_name FROM files, divisions WHERE files.file_id = divisions.div_id AND divisions.div_name = 'divisions1'; Note

Re: Please redo this horrible web page

2001-11-28 Thread Erik Price
for FREE, this is something that you can pay for. You know, your suggestions are actually helpful, but the tone with which you deliver them invalidates you as a constructive critic. I think they call that sort of person a troll. Erik

Re: Please redo this horrible web page

2001-11-28 Thread Erik Price
a better way to spend it. So, while I can understand your frustration, I guess that begs the question -- do you want your money back? Erik On Wednesday, November 28, 2001, at 04:29 PM, john wrote: Erik, Thanks for your input. I had no idea of what a troll was. I have seen the term

PHP install w/MySQL difference question

2001-11-27 Thread Erik Price
and running I will do my best to never bother anyone again! -- Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

the official name of 3.23.45 source

2001-11-26 Thread Erik Price
directory over time. The 3.23.44 file was called mysql-3.23.44.tar.gz , but I don't want to make an assumption about the filename. Thanks! Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: the official name of 3.23.45 source

2001-11-26 Thread Erik Price
Thanks! I'll change the name from download.php to mysql-3.23.45.tar.gz in my source directory, and I'll remember the valuclick mirror. I'm assuming that's in N. America somewhere. Erik On Monday, November 26, 2001, at 11:29 AM, Mike(mickalo)Blezien wrote: Try here: ftp

Re: Mac OS X and MySQL 3.23.45

2001-11-26 Thread Erik Price
!! (No more flush tables ; kill -9 %1 or any of that!) My thanks to the developers for taking into account the needs of Darwin users in their work -- we won't be a minority for long! Erik - Before posting, please check

display size of integers

2001-11-26 Thread Erik Price
it being useful in combination with the ZEROFILL attribute, which would add leading zeros up to the display width if the number is fewer characters than the display width. Otherwise, it seems to serve little purpose. Would anyone mind shedding some light on this? Thank you, Erik

RE: Need to repair InnoDb tables

2001-11-25 Thread Erik
table. Erik -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 2:20 AM To: [EMAIL PROTECTED] Subject: Re: Need to repair InnoDb tables Brent, maybe you have moved .frm files around? If there is an orphaned .frm file for a table without

RE: does lmysqlclient.so exist in 3.23.44 ?

2001-11-24 Thread Erik Price
don't hear back about lmysqlclient.so then I'll just have to do it with the built-in MySQL support and worry about mod_perl later in the future. Erik --- Ravi Raman [EMAIL PROTECTED] wrote: Hi again. Why were you compiling php against the mysql source rather than using the built-in mysql

does lmysqlclient.so exist in 3.23.44 ?

2001-11-23 Thread Erik Price
it for my PHP4 Apache DSO compile. Thank you, Erik __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1

RE: argument to --with-mysql option for PHP

2001-11-22 Thread Erik Price
the 'make'. And I assume that this happened because the 'make' process could not find the lmysqlclient.so . Am I very far off the mark in this guess? Thanks to any who can help with this quandary! Sincerely, Erik Price --- Ravi Raman [EMAIL PROTECTED] wrote: You're right. ./configure --help

argument to --with-mysql option for PHP

2001-11-21 Thread Erik Price
' , but I wanted to make sure. Thank you, Erik Price PS: Just to re-clarify about my system, it is: Darwin 1.4.1 running beneath Mac OS X 10.1.1 Apache 1.3.22 with DSO capability enabled MySQL 3.23.44 (source install) installed in /usr/local/mysql = Microsoft e[X]tra [P]roprietary

  1   2   >