php-mysql install on redhat

other things. mysqld is also running. Should I scrap this plan, and just install from source via AB Mysql? Or is there another way? I'm wondering if my versions are incompatible with one another. Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

RE: where is my my.cnf files??

What you need to do is rename one of the .cnf files - such as my-small.cnf - to my.cnf and copy it into your /etc/ directory (on Linux, Windows directory in Windows). - Eve -Original Message- From: Hiu Yen Onn [mailto:[EMAIL PROTECTED] Sent: Thursday, December 09, 2004 3:28 PM To

Best learning path to DBA?

I am an web designer / php programmer / unofficial network administrator with a well-rounded technical background - but, as they say, a jack of all trades (expert in nothing). If I were to pursue a DBA path, what would be a good way of going about it? School, books, etc... - Eve -- MySQL

RE: Trying to dump from GUI client

General Subject: Re: Trying to dump from GUI client Eve, >From the command line you can use `mysql`, command line tool that ships >with MySQL. You would want to use the SELECT ... INTO OUTFILE 'file.txt' FROM ...; See the MySQL manual for more information on this: - ht

RE: Trying to dump from GUI client

;@'%' (Using password: YES) ...even though I am logged in via the client. -Original Message- From: Adam [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 7:04 PM To: [EMAIL PROTECTED]; MySQL General Subject: Re: Trying to dump from GUI client Eve, >From the c

Trying to dump from GUI client

wn MySQL Server Host 'mysql.loosefoot.com' (0)". I've changed *nothing* in my connect script, and as mentioned, I can connect to the database via other means. What would you suggest as the least painful solution? Thanks, Eve -- MySQL General Mailing List For list archiv

MySQL 4.0.20 for full-text searching with match against

We are switching web servers, and they have installed Mysql 4.0.20. One of our apps uses full-text boolean text searching with MATCH AGAINST. I wanted to ensure this version of MySQL supports it, or if I need a newer version of MySQL. Can someone verify? Thanks, Eve -- MySQL General Mailing

RE: Determining if query will work

tting something like 'sappy' when what I really want is just 'sap', nothing preceeding and nothing following? Thanks, Eve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 12:54 PM To: [EMAIL PROTECTED] Cc: Mysql Sub

RE: Determining if query will work

then log out of my client (MySQL Control Center) and back in to get rid of that temp table? As I'll need to change what it searches for (ie baan, peoplesoft, etc.). Or is there a query I can put in at the end of the queries to destroy the temporary table once through with it? Final query se

RE: Determining if query will work

p (Candidate_ID, Section_ID, Section_Value) SELECT SQL_CALC_FOUND_ROWS c.Candidate_ID FROM wow.tmpCandidates tc INNER JOIN wow.resume r on r.Candidate_ID = tc.Candidate_ID; - Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Determining if query will work

c.Def_Rate, c.Def_Rate_Unit, c.Other_Country, c.Currency_id, c.Interview_Availability, c.Interview_Contact, c.US_Experience, c.Location_Country FROM wow.tmpCandidates tc INNER JOIN wow.resume r on r.candidate_ID = tc.Candidate_ID INNER JOIN wow.candidate c ON c.Candidate_ID = tc.Candi

RE: Determining if query will work

ant, it's trivially simple to add the INSERT (...) clause to the beginning of it to get the results to go into a table instead of to your client. Keep me informed on your progress, please. Thank you for being so patient. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Eve

RE: Determining if query will work

>the candidate table. If that's truly the case, why do you need to JOIN to >the resume table? See above. :) Resume material is boolean-searched, then I have to copy that Candidate_ID from *both* tables 'candidate' and 'resume' into 'candidate_erp' an

RE: Determining if query will work

nothing entering into the database candidate_erp. The third resulted in ERROR 1136: Column count doesn't match value count at row 1. >Yes, you were close. May I suggest a little reading? I'll give those links a look, though often the reading in there seems a bit thick! - Eve

Determining if query will work

Country, Currency_id, Interview_Availability, Interview_Contact, US_Experience, Location_Country) SELECT SQL_CALC_FOUND_ROWS * FROM wow.resume r INNER JOIN wow.candidate c; Am I on the right track? Please read further for the kind of data returned, if nec

Determining if query will work

Country, Currency_id, Interview_Availability, Interview_Contact, US_Experience, Location_Country) SELECT SQL_CALC_FOUND_ROWS * FROM wow.resume r INNER JOIN wow.candidate c; Am I on the right track? Please read further for the kind of data returned, if nec

Do I need to add all states to an IN?

on is filled in with all states? If so... what's the proper structure to list all states in this statement? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Multiple Insert Statement?

nt at row 1. The query "INSERT INTO wow.resume_erp (Candidate_ID, Section_ID, Section_Value) SELECT * FROM wow.resume r WHERE r.Candidate_ID = '13103';" is impractical when my results are over 400. Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Multiple Insert Statement?

te_erp (Candidate_ID, Section_ID, Section_Value) INSERT INTO wow.resume_erp (Candidate_ID, Vendor_ID, etc.) SELECT SQL_CALC_FOUND_ROWS * FROM wow.resume r INNER JOIN wow.candidate c; Or do I have to break out the INSERT statements seperately? Thanks! - Eve -- MySQL General Mailing List For

RE: Mysql and PHP

This is also very useful: Getting PHP 5 to work with MySQL http://www.phpbuilder.com/board/showthread.php?s=&threadid=10246585 - Eve -Original Message- From: Greg Donald [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 11:10 AM To: nestor(earth) Cc: [EMAIL PROTE

RE: Mysql and PHP

copy libmysql.dll into the Windows system directory or make it available to the PATH. For compiling, simply use --with-mysql=[DIR] where [DIR] points to your MySQL installation directory." - Eve -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15,

RE: Copying rows based on query result to another table?

ult to another table? try INSERT INTO other_table ( field1, field2, etc) SELECT SQL_CALC_FOUND_ROWS * FROM wow.resume r INNER JOIN wow.candidate c WHERE r.Section_ID = '1' AND MATCH (r.Section_Value) AGAINST ('+BAAN' IN BOOLEAN MODE) AND c.Candidate_ID = r.Candidate_ID Peter

Copying rows based on query result to another table?

te_ID I notice that MySQL CC and MySQL Query Browser both have the ability to export to a file (ie. CSV), but it doesn't appear they will import neatly into the tables candidate_erp and resume_erp. Thanks in advance, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.c

another insert/select for multiple tables... (or, determining previous auto-increment ID)

#x27;candidate'. Following this insert, insert is required for 6 rows of data into table 'resume': Candidate_ID must be 10700 / Section_ID = 1 / Section_Value = some form data from textbox Candidate_ID must be 10700 / Section_ID = 2 / Section_Value = some form data from a different textbox etc. until Section_ID 6. How would I go about setting this up for resume, now that it's set up for candidate? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

What is overhead and what causes it?

As a newbie to MySQL, can folks explain to me what is 'overhead', and what causes it? (I sometimes get a very small overhead on 1 table and feel the urge to optimize it.) Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Best method to export Excel data into MySQL?

What would be the best method (using free tools, or Office suite) to export an Excel spreadsheet into a format suitable for import into MySQL? I am on a PC platform. Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Assistance with SQL syntax: pulling duplicates back

hp Over 10 years of HTML experience. 2 years networking administration. -- I can't decide if this is my code, or the SQL syntax. Would it be possible, based on this statement, to have pulled back duplicates from the same record? - Eve -- MySQL General Mailing List For list ar

Full text for keyword(s) search?

If I want to search for a word (or multiple words) in a field on one table, searching through at least a thousand records (and growing daily), should I be using full text or something else to make this search faster? I'm using MySQL 3.23.58. Thanks, Eve -- MySQL General Mailing List For

Best way to construct query for 1M records DB?

make this faster and/or more efficient, based on the way I'm handling it? How long would this search take for so many records? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: sql function for timestamp

#x27; function in PHP for info. - Eve -Original Message- From: Chinchilla Zúñiga, Guillermo [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 11:54 AM To: J S; [EMAIL PROTECTED] Subject: RE: sql function for timestamp In MySQL you can do that with: DATE_FORMAT DATE_FORMA

Reset lost password on Server Logistics Mac OS X install

nfiguration and OS done a successful reset of a root password and is willing to share their steps? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Principles of Data-Base Management

embly languages. :) Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Need correct 'order by' syntax where field does not contain "NULL"

statement to allow for ORDER by order where 'order' does not contain 'NULL', and then title? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Randomly selecting from table

Is it possible to randomly select from all entries in a table, but have it be 2 different ones each time? If so, what documentation should I be looking at? I am using PHP and MySQL together, if this helps. Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com

RE: Saving file into database

>Is there an advantage to storing the PDFs directly into the database? I'm also curious how large this would make a database. Is there any space saved through this method, or would they still be the same size as the original PDF? - Eve -- MySQL General Mailing List For list archiv

More on indexes?

efits, and when one should index? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Transferring comma-delimited list imto mysql table

d, Access choked. My intent is to pull all these from MySQL and into Outlook. If MySQL isn't the app to use, perhaps another solution can be recommended. Thanks so much, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Sequrity question or am I paranoid?

Speaking of MySQL database security, what are some key things to keep in mind, other than changing the root password? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Require greater than 255 in varchar?

I have a large chunk of text I've attempted to put into a varchar field, and it chopped off a chunk of it. If I need to enter text that is greater than the default 255, what choice should I use instead? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysq

RE: So, how do you REALLY install MySQL in Mac OS X (Panther)?!

This one actually installs a preference pane that allow you to manipulate settings, start/stop server, and change root password. It's quite nice. - Eve -Original Message- From: sulewski [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 7:25 AM To: Eve Atley Cc: [EMAIL PROT

Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?!

I successfully used the packages from Server Logistics for this task, installing PHP, Apache and MySQL first on my 10.2.8 Jaguar, then on my 10.3.2 Panther G4. http://www.serverlogistics.com/mysql.php - Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Removing default MySQL install

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

RE: Installing MySQL on Linux, HELP!

read manuals, taken advice, but nothing comprehensive to get things to work. I would prefer to install a version of at least 4 for a server. Any help is appreciated! Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: Installing MySQL on Linux, HELP!

rver-3.23.58-1.9 postgresql-server-7.3.4-3.rhl9 Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installing MySQL on Linux, HELP!

stall", it says nothing to be done. Now I think I'm just goofing things up. Ran a 4.0.1 rpm, and it said it installed; but still nothing. Then ran another one, and now it says dependencies are missing. I am following instructions from http://www.brtnet.org/linux/lamp.htm. - Eve -

Using BETWEEN or <= >=

I am attempting to construct a select statement in which I can find values between two fields: start, and end. I have tried using "BETWEEN" and comparing with <= and >=, but neither meet success. Can someone please set me straight? This is meant to be in a PHP page, but I'm assuming the syntax is

Optimizing a cross-reference table: tips?

doing? I would have thought this would be a faster way of searching. Is there another way of setting up this cross-reference table? I am no database guru. ---- Eve Atley

Php query from sql

Hello everybody, I'm quite new with all this php mysql "cooperation thing" but somehow I already managed to set up mysql database and I'm able to also make query's based on any keyword... Now I wonder how to add to this basic query also option to select some concrete data. For example in the dat

duplicate records, auto-increment problems, question

;s off-topic. Not sure the script is the cause of all this, but will post if you think it's relevant. Thank you all for your time. Eve - Before posting, please check: http://www.mysql.com/manual.php (the manual)