I am attempting to use Redhat's update to get the latest version of
php-mysql. Howeever, each time I try it prompts:
Unresolvable chain of dependencies:
MySQL-bench 4.0.21-0 requires MySQL-client
Running rpm -qa | grep MySQL gives me:
MySQL-client-4.0.21-0
... and a host of other
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:
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
://www.toadsoft.com/toadmysql/toad_mysql.htm
MySQL Query Browser:
- http://dev.mysql.com/downloads/query-browser/index.html
Both of these tools will allow you to export a record set as a comma
delimited file.
Good luck!
Regards,
Adam
Eve Atley
I'm not sure how best to proceed in dumping
a record set as a comma
delimited file.
Good luck!
Regards,
Adam
Eve Atley
I'm not sure how best to proceed in dumping data from 1 database and
getting a copy of the export, in order to transfer it to another
server. I usually use phpmyadmin to do an export, which nicely creates
a .zip file
I'm not sure how best to proceed in dumping data from 1 database and getting
a copy of the export, in order to transfer it to another server. I usually
use phpmyadmin to do an export, which nicely creates a .zip file of
everything. I managed to get it connected with Mysql Control Center, but am
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
I can't tell you how *glad* I am to get this running! Big hugs to you,
Shawn!
It's running beautifully. My only question is, after I run the queries,
I notice it won't let me create the temporary table again (saying
'tmpCandidates' already exists). Do I just need to then log out of my
client
more help.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Eve Atley [EMAIL PROTECTED] wrote on 10/25/2004 12:48:43 PM:
I can't tell you how *glad* I am to get this running! Big hugs to you,
Shawn!
It's running beautifully. My only question is, after I run the
queries
Sorry for the delay in this. Still having problems with this one.
The second query is going to produce one row for every resume. Based on
your results, I assume you have 1000 resumes that have candidates
associated with them.
Let's say I have 256 resulting rows for table 'resume', Section_ID
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 Atley [EMAIL PROTECTED] wrote on 10/22/2004 12:43:26 PM
I think we're on to something. I've got one table importing data
correctly, resume to resume_erp. However, 'candidate' to 'candidate_erp'
appears goofy. I get the following error:
[mysql.loosefoot.com] ERROR 1062: Duplicate entry '1185' for key 1
With the following queries, query 3 being the
What is the definition of resume_erp (what is the result of: SHOW
CREATE
TABLE resume_erp) ? What that error is telling you is that you are
Glad you added more info, or I would have been asking you, 'what do you
mean by definition?' :)
CREATE TABLE `resume_erp` (
`Candidate_ID` int(10) NOT
I am attempting to copy data from 1 table into another, based on certain
criteria. I have set up the following queries, but am unsure if they
will function properly:
#This pulls back all data for matching candidates with keyword from
RESUME and CANDIDATE
SELECT * FROM wow.resume r INNER JOIN
I am attempting to copy data from 1 table into another, based on certain
criteria. I have set up the following queries, but am unsure if they
will function properly:
#This pulls back all data for matching candidates with keyword from
RESUME and CANDIDATE
SELECT * FROM wow.resume r INNER JOIN
Based on Shawn's tips, I revised the query to read thusly:
SELECT *
FROM wow.resume r
INNER JOIN wow.candidate c
ON c.Candidate_ID = r.Candidate_ID
WHERE r.Section_ID = '1'
AND MATCH (r.Section_Value) AGAINST ('+peoplesoft' IN BOOLEAN
MODE);
INSERT INTO wow.resume_erp
I have a resume form that picks consultants by state (such as an html guru
in California, or an SAP expert in Alabama). But what if I want to pick from
ANY state?
When I put in criteria, the SQL comes back like so...
SELECT SQL_CALC_FOUND_ROWS * FROM resume INNER JOIN candidate WHERE
My query:
SELECT * 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;
Is it possible to do a multiple insert statement like so?
INSERT INTO wow.candidate_erp
(Candidate_ID,
Then I need help getting on the right track here. What I really want to do
is something like the following:
INSERT INTO wow.resume_erp (Candidate_ID, Section_ID, Section_Value) SELECT
* FROM wow.resume r WHERE r.Candidate_ID = '13103';
INSERT INTO wow.candidate_erp
(Candidate_ID, Vendor_ID,
?
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
-Original Message-
From: Eve Atley
You will likely want to read this:
http://us4.php.net/mysql
In PHP 5, MySQL is no longer enabled by default, nor is the MySQL library
bundled with PHP. Read this FAQ for details on why. Because of this,
Windows users will need to enable php_mysql.dll inside of php.ini and either
copy
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 PROTECTED]
I want to copy rows of data from a query result to another table. How do I
accomplish this? Here's my example for further explanation...
I have 2 tables, candidate and resume. I have 2 other (currently empty)
tables, exact duplicates, candidate_erp and resume_erp. In resume_erp will
be
The question:
Is there anything in MySQL that will allow me to determine, accurately, the
last auto-incremented field from a particular database, so I can then insert
based upon this into another table? What if 2 users input at the same time?
Please see the 'long explanation' for further
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:
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 unsubscribe:
I think this is an easy question...I've set up a SQL statement like so:
SELECT resume.Section_Value, candidate.Location FROM resume, candidate WHERE
resume.Section_ID = '1' AND MATCH (resume.Section_Value) AGAINST ('html')
AND candidate.Location LIKE '%CA%' OR 'California'
--
Hello all,
I am stuck on the best way to proceed in order to make a SQL query efficient
and quick searching through a very large (near million and growing)
database. I am working with MySQL 3.23.58 and using PHP to construct a
dynamic query, based on HTML form input. Please let me know if you
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 list
While in PHP you can try something like this...
$date_added = $row['date_added'];
$date = date(M d, Y, strtotime($date_added));
echo $date;
H and i do work in PHP as well, I believe, if you want to add the hour and
seconds. Check out the 'date' function in PHP for info.
I'm attempting to follow instructions at the MySQL AB site:
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
...in order to reset a lost root password. I am using the Complete MySQL
package from Server Logistics (www.serverlogistics.com) for Mac OS X
Panther.
I've read the
Not specifically a MySQL question, but my boss has a lending library, and I
found a book here titled Principles of Data-Base Management by James
Martin, publish date of 1976. I thought I might peruse this to get a
background on DB Mangement, but the publishing date concerns me. Has anyone
read
Hi. I had a MySQL DB set up and recently added a field 'order' to allow for
exceptions in a web site menu heirarchy. Fields should be ordered by 'order'
field first where it does not contain 'NULL', and then by field 'title'. I
had this previously:
select * from navigation WHERE id =
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:
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 archives:
Hi,
I've been following the list to get a better grip on MySQL, and have been
hearing a lot about indexing. I'm beginning to think I should have indexed
some of my tables in the past. Can anyone point me in the right direction as
to the purpose of indexes, why they are used, the benefits, and
I have a large email database that has been translated into a CSV, simply
like this:
[EMAIL PROTECTED];[EMAIL PROTECTED]; (etc.)
I need to get this into SOME format. I have tried Access, which said it was
too large - so I am trying my mysql. I created a table with fields ID, and
email. I just
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]
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:
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
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 PROTECTED
I've been trying to install a later version of MySQL (4.0.16). The Redhat
default install is 3.x, and using rpm -e fails to remove the default
packages due to 'dependencies'. How can I safely and successfully uninstall
the default mysql packages (server and client) so I can start fresh?
Thanks,
I have had some help on my mysql install woes, and here's the latest.
rpm -qa | grep MySQL - this just hung and never returned anything (see
below)
# service mysqld start
or
# service mysql start - these just returned a new command prompt, so
couldn't tell whether or not they worked. I checked
After some trouble with rpm, I managed to create a file of installed
packages. Redhat 9 says I have installed:
MySQL-client-4.0.1-2
perl-DBD-MySQL-2.1021-3
mysql-3.23.58-1.9
mysql-server-3.23.58-1.9
And I am not having any luck with these...starting them, installing them,
compiling them. I have
Well, RedHat 9 says mysql is *already* installed. But I can't start it. And
when I attempt to configure it using mysql_install_db, it says to run make
install on it first. When I try to ./configure, it says it can't be found.
(i know gcc exists) When trying make make install, it says nothing to
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
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
47 matches
Mail list logo