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.

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 where

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

2008-01-29 Thread Erik Giberti
MySQL 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
aller segments so I can distribute the data over 2 DVD-R (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

Re: Performance problem - MySQL at 99.9% CPU

2008-01-09 Thread Erik Giberti
dependent on your code etc) but I have seen on a shared host machine 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 tha

Re: Performance problem - MySQL at 99.9% CPU

2008-01-03 Thread Erik Giberti
t) and see if there is one query 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.

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,

Assistance avoiding a full table scan

2007-09-21 Thread Erik Giberti
is to avoid 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

Vertical Tab problem

2006-07-13 Thread Saline Erik
er v in it. Any 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]

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 '', )

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

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 T

A question on INTERVAL

2003-11-11 Thread Erik Osterman
wonderful date & time functions to accomplish what I am trying to do? I'd 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.un

RE: Aliases

2003-11-10 Thread Erik Osterman
urate 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 [mai

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 wor

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.

RE: help on my query statement

2003-11-10 Thread Erik Osterman
UNT(*) 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, 2

RE: Update table with UNIX_TIMESTAMP

2003-11-08 Thread Erik Osterman
le; or even... SELECT 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:[E

RE: Secure way of storing passwords in the database

2003-11-07 Thread Erik Osterman
=SHA1("$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 stor

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

2003-10-23 Thread Jan-Erik Öhman
INST ('database'); Only that I whish to load documents (PDF, Word, XML, HTML etc) into the TEXT column using LOAD_FILE(file_name) or similiar. And be able to do full-text searches 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

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

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 e

query

2003-03-12 Thread Erik DeBattista
the table lock? 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

query

2003-03-07 Thread Erik DeBattista
the table lock? 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

query re: Innodb Table Locks

2003-03-05 Thread Erik DeBattista
the table lock? 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

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

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 t

Zoombie threads when listing with show processlist.

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

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

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 ru

How to "download" a mssql db to mysql once a day

2002-07-30 Thread Lars Erik Petersen
way I can get 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

Re: getting totals with data

2002-06-18 Thread Erik Price
lts that are handed to the PHP script and turned into HTML low) would yield 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 f

Re: Reconstructing SQL create table statements

2002-06-14 Thread Erik Price
tch. Just chop off the contents if you only want the CREATE TABLE statements. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysq

Re: is this query possible?

2002-06-14 Thread Erik Price
t way to do 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 > >> -Orig

Re: MySQL not starting ?

2002-06-14 Thread Erik Price
mysqld ended Are you really only using 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 post

is this query possible?

2002-06-14 Thread Erik Price
"sub1other" column is NULL in one record, 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? T

mulitple uses of a foreign key

2002-05-29 Thread Erik Price
project_id = 8 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 Develo

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" <[EM

Re: MySql Client fails to connect

2002-05-19 Thread Erik Perrhoe \(Computer Consultant\)
cular 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]>

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 Me

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

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 P

Databases with Tables approaching several million

2002-05-15 Thread Erik Fears
l was optomized 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/manu

Unicod problems

2002-05-14 Thread Svend Erik H. Jørgensen
g in MySQL, 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.palla

deleted tabels in innodb file

2002-05-01 Thread Svend Erik H. Jørgensen
ving the .frm 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 ht

Re: Order by

2002-04-25 Thread Erik Price
e best way to sort your data. Most likely you'd do a similar thing as above in PHP, so why not just save the extra processing cycles by doing it in the database? Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] -

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

2002-04-25 Thread Erik Price
fic socket location at compile time? 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] --

Re: how to get support help?

2002-04-25 Thread Erik Price
e person, though you're correct -- this does not reassure them that their problem was heard. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http

Re: how to get support help?

2002-04-25 Thread Erik Price
hat are essentially "RTFM" > 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 p

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 conce

Re: AW: MySQL on OS X

2002-04-25 Thread Erik Price
e two different ways to put MySQL on your Mac OS X system: Install 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 i

Re: MySQL on OS X

2002-04-25 Thread Erik Price
to /usr/lib/libSystem.dylib, which is a link to /usr/lib/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

Re: LAST_INSERT_ID()

2002-04-23 Thread Erik Price
ill end up with a result for each row in that table, unless you use a WHERE clause. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.m

Re: Selecting Information Just Inserted

2002-04-19 Thread Erik Price
hy this function is better than doing 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 ma

Re: table-building advice requested

2002-04-19 Thread Erik Price
uot; file_id or a "user" file_id. It doesn't seem very smart to have a setup like this. So I think I should go with the big "files" table and just have some columns that apply to some kinds of files and not to others. Is this done? I'm just hesitant to have a l

table-building advice requested

2002-04-18 Thread Erik Price
ntedfiles ADD COLUMN source ENUM('files', 'userfiles') to qualify the file_id as belonging to either a "files" record or a "userfiles" record. But I am wondering if this is really a good idea -- when I need to query for all records in "print

Re: time zones?

2002-04-12 Thread Erik Rantapaa
TIMESTAMP data 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 unti

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,

Large datafiles

2002-03-27 Thread Svend Erik H. Jørgensen
eaked ? 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] P

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] --- Ou

bumping up table values

2002-03-04 Thread Erik Price
ed "prefix" and the new bumped-up "base" value, telling user what to label the CD (i.e., "45:109"). This seems like a lot of steps, and almost a kludge to me. But then, this is the first web application I have written ever, and up until now all of the database

Can't restart MySQL after innodb table filled up

2002-03-04 Thread Erik Barker
is causing the crash 020304 11: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 B

Re: another xml thread

2002-02-19 Thread Erik Price
they were talking, but kept > insisting 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 Develop

another xml thread

2002-02-18 Thread Erik Price
ng up 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 pack

Re: INSERTing duplicate values to a UNIQUE-indexed table

2002-02-04 Thread Erik Price
d compatible with a version of PHP that -might- pay attention. Hope all is well with you, Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.co

Re: INSERTing duplicate values to a UNIQUE-indexed table

2002-02-04 Thread Erik Price
ySQL processes data. But now 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.

INSERTing duplicate values to a UNIQUE-indexed table

2002-02-04 Thread Erik Price
the second one is that I think it is somewhat tasteless to execute code that will knowingly error -- or should I just stop trying to be such a perfectionist? I would post code but this is all pseudocode right now b/c I haven'

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

2002-01-17 Thread Erik Price
gned for future 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, Richar

Re: Spam

2002-01-10 Thread Erik Price
Here's a solution: Send mail to <[EMAIL PROTECTED]> Doing this will generate an auto-reply. When you get it, hit "reply" and "send" in your mail client. That way you won't get any more spam. Erik On Thursday, January 10, 2002, at 12:15 PM, Patrick

Re: INSERTing into joined tables?

2002-01-09 Thread Erik Price
he way that "mysqlshow" outputs the data. In reality, each column is a UNIQUE index (-not- a PRIMARY KEY). For some reason, that's what mysqlshow gives instead of UNIQUE. Thanks for the input, though! Erik > > -Original Message- > From: Erik Price [mailto:[EMA

INSERTing into joined tables?

2002-01-09 Thread Erik Price
ast_name) VALUES ("$firstname", "$lastname") but... to keep it all together... is lost on me... and then later to have UPDATE statements to do the same thing! Although I suspect this may be easier as I can use the WHERE clause in an UPDATE statement. If anyone has a link to a tutoria

Re: ENUM -- integers or strings?

2002-01-04 Thread Erik Price
But until the PHP 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: Frida

ENUM -- integers or strings?

2002-01-04 Thread Erik Price
hether or not ENUM returns an integer or string), but now that I think about it, does it really matter for the purposes of my example here? Wouldn't this PHP code be able to take a string or an integer as an argument to the "switch" statement? Thanks for any advice anyone can gi

Re: Watchdog für mysql in Perl?

2002-01-04 Thread Erik Price
tored anywhere (though I don't know how to write a script that "hides" 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 th

an example INSERT statement

2002-01-02 Thread Erik Price
es, I would use a join statement. How would I go about writing an INSERT statement that joins several different tables together? Even a pointer to where I can find this info would be helpful. The "INSERT syntax" page in the official documenta

mysqlshow expands my argument

2002-01-02 Thread Erik Price
is mysqlshow treating my 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

Re: are my queries bloated?

2001-12-10 Thread Erik Price
needed a way to keep track of projects and image files. I really am hoping to take this to a new level eventually, a sort of web-based "workspace" that will include message boards and other functionality to keep all of the users in touch. I would love to take a class

Re: MySQL graphical front-end for Mac OSX

2001-12-07 Thread Erik Price
I haven't used it but a lot of people recommend PHPMyAdmin. Especially if your MySQL server is hosted by a company that doesn't give access to a shell account. Erik On Thursday, December 6, 2001, at 08:07 PM, René Fournier wrote: > Does anyone know if such a thing exists?

Re: are my queries bloated?

2001-12-07 Thread Erik Price
.com' " bit first after the > WHERE, > that will also make it clearer for you to read. Is this just for my own personal clarity? I was under the impression that the exact order of the JOINs wouldn't matter v

Re: are my queries bloated?

2001-12-06 Thread Erik Price
feel 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

are my queries bloated?

2001-12-06 Thread Erik Price
Or am I doing something weird, am I "not getting" this relational database concept? I hope I haven't gone about this all wrong! Thank you so much to any who can give me some advice, or confirm that I'm doing okay. Sincerely, Erik Price ---

Re: just moved from windows to linux mysql

2001-12-06 Thread Erik Price
offer up some links to a quicky tutorial on > loading a database 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

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

Re: Help with Auto Increment

2001-12-05 Thread Erik Price
LOAD DATA, you can insert a fake record with no values *except* ID, and specify ID = 999 . I got this information from "MySQL" by Paul DuBois (p. 93). I had just read that part of the book yesterday. Recommended! -- Erik On Wednesday, December 5, 2001, at 01:16 PM, Mysql

Re: [PHP] Re: Mac OSX and MySQL

2001-12-05 Thread Erik Price
.html It tells 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

Re: [PHP] Mac OSX and MySQL

2001-12-05 Thread Erik Price
add the "--with-mysql" configure option because 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

Re: more than one possible column value

2001-12-04 Thread Erik Price
y further before asking any more 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 <[E

Re: more than one possible column value

2001-12-04 Thread Erik Price
per combination! Okay, I will just have to be very careful about 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

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 a

Re: Designing a database to track files

2001-11-30 Thread Erik Price
. And also 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 >

Designing a database to track files

2001-11-30 Thread Erik Price
| | || | | || | | ++---+---+ I'm trying to give the name "division1" and get the name "picture1" back. W

WAY OFFTOPIC: Re: How To Install Under MacOS X?

2001-11-30 Thread Erik Price
t is taken from NeXT. (anyone care to clarify?) -- Erik On Thursday, November 29, 2001, at 11:53 AM, Todd Williamsen wrote: > I am going to take a stab at this... > > Since MacOS X is actually an open sourced kernel, I would assume you > could use the Linux or Unix version to i

Re: How To Install Under MacOS X?

2001-11-30 Thread Erik Price
ce code. I used to think that was hard core, but now I 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

Re: Please redo this horrible web page

2001-11-28 Thread Erik Price
money back, and found 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 wh

Re: Please redo this horrible web page

2001-11-28 Thread Erik Price
ey have provided the documentation, mailing list, archives, and the software itself 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

PHP install w/MySQL difference question

2001-11-27 Thread Erik Price
ory? Thanks to any who can help me -- and I apologize to those who are becoming annoyed with these questions! Once I get this up and running I will do my best to never bother anyone again! -- Erik - Before posting, please c

Re: Mac OS X and MySQL

2001-11-26 Thread Erik Price
ly have a fully-supported desktop Unix implementation with plenty of open-source AND commercial software available. I guess I'm biased, though. Don't knock it if you haven't used it, OS X/Darwin is awesome. Erik On Monday, November 26, 2001, at 05:20 PM, Paul DuBois wrote: >

  1   2   >