I would suggest you build apache and php from source. instructions can be found at
http://www.php.net/manual/en/install.apache.php.
dan
* duo fu ([EMAIL PROTECTED]) wrote:
Dear Friends:
I have installed Apache 1.3.26, MySQL.3.23.51 successfully. However, I
failed to install tarball
I'm trying to figure out how to setup my first mySQL DB... I hope this
isn't too OT for this list.
The DB will serve several purposes, which I think will each go into a
different table w/in one DB.
Here's what I want to be able to accomplish:
pull up a listing of:
1) names and email addresses
Try - and I mean *try* :-)
SELECT Customers.* FROM Customers, Subscriptions
LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id
(Ordered_Items.productid = '23'))
WHERE Customers.id=Subscriptions.customerid
AND
coffee or some sleep
Peter Normann
-Original Message-
From: Jamie Tibbetts [mailto:[EMAIL PROTECTED]]
Sent: 18. juni 2002 22:21
To: Peter Normann; [EMAIL PROTECTED]
Subject: Re: Need help with a complex query
Try - and I mean *try* :-)
SELECT Customers.* FROM Customers
I am currently a web designer who's taught himself the necessary basics of
PHP and MySQL. I've reached a point where I can't figure out a complex
query.
I have a mailing list that customers can sign up for if they want to receive
Special Offer mailings when products go on sale. So when it's time
AND Subscriptions.listid='2'
AND Ordered_Items.orderid IS NULL
AND Orders.customerid IS NULL
AND NOT Customers.bad_email;
Peter Normann
-Original Message-
From: Jamie Tibbetts [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 18:23
To: [EMAIL PROTECTED]
Subject: Need help with a complex query
I am currently
Try - and I mean *try* :-)
SELECT Customers.* FROM Customers, Subscriptions
LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id
(Ordered_Items.productid = '23'))
WHERE Customers.id=Subscriptions.customerid
AND
To: Peter Normann; [EMAIL PROTECTED]
Subject: Re: Need help with a complex query
Try - and I mean *try* :-)
SELECT Customers.* FROM Customers, Subscriptions
LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id
Hello,
I have 2 tables(pics and outings)
pics
pic_id, tinyint
path, varchar
outings
outings_id, tinyint
pic1_id, tinyint
pic2_id, tinyint
pic3_id, tinyint
pic4_id, tinyint
When i try to do a join like this
mysql_query(SELECT * FROM pics inner join outings on
outings.pic1_id=pic.pic_id and
Mike,
With the way you have it written below, all of the pic1_id, pic2_id,
pic3_id, and pic4_id must be equal (because they all equal pic.pic_id).
Since this wasn't true for any of the rows, that is why you were
getting no results.
To get each picture value seperately, you will have to do
Thanks for the help. Got that to work no problem.
Mike
- Original Message -
From: Harrison C. Fisk [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]
Cc: mysql list [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 5:48 PM
Subject: Re: Need Help with JOIN
Mike,
With the way you have
I would like to set up a MySql database that will
store distance information for a milage lookup
program. The user will enter the origin city and the
destination city for some predefined trips. Then the
query will need to return the milage broken down by
state. For example, for an origin city
Does the library 'libmysqlclient.so' known to work
in a multi-threaded environment on Solaris?
I'm asking as in my C++ multithreaded program I get segmentation/bug error
from time to time.
Each of my threads is holding its own persistent connection.
I'm using MyODBC.
But even after I let each
Hi
I am working with Windows NT.
I want to install mysql on drive d.
Now i need to change the file my.cnf.
In the manual they write that i need to put this file in c:\
BUT what if i don't have drive C??
and if now i want to write some program that find out the drive that mysql
installed on.
how
Hello Everyone,
I haven't used SQL in a long time and I am having trouble designing the
query to get the result I need. I have 1 select query that looks like this:
SELECT WC.FIRST_NAME ' ' WC.LAST_NAME AS NAME, C.COMM_NO AS PHONE
FROM WRK_CNTRCTR AS WC, WRK_COMM_NUMBER AS C
WHERE WC.PERS_ID =
Memon, Michele would like to recall the message, Need help with query
result.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Having impossible problems installing MySQL.
Starting a project and don't want to use Oracle (cost is outrageous) or
anything on MSSQL (which performs like crap).
I keep getting errors involving resolveip when I install, or it just don't
work. When I try to run the ./configure command in Linux
Hi,
Any problem is an effect of the cause
so...
I keep getting errors involving resolveip when I install, or it just don't
work. When I try to run the ./configure command in Linux (7.1-7.3), it
kicks me back an error.
What error?
If I use the rpm installation, it seems to install
Hi,
I have a MySQL database with a table named CONNEXION. When i'm trying to do
something with the specific table, i have the following error:
ERROR1016:Can't open file: 'CONNEXION.MYD'. (errno: 145)
Please can anybody help me?
Thanks in advance
--
:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 9:16 AM
To: [EMAIL PROTECTED]
Subject: Re: Need help
Hi,
I have a MySQL database with a table named CONNEXION. When i'm trying to do
something with the specific table, i have the following error:
ERROR1016:Can't open file: 'CONNEXION.MYD'. (errno
Bertrand,
Tuesday, May 21, 2002, 4:15:37 PM, you wrote:
BT I have a MySQL database with a table named CONNEXION. When i'm trying to do
BT something with the specific table, i have the following error:
BT ERROR1016:Can't open file: 'CONNEXION.MYD'. (errno: 145)
BT Please can anybody help me?
://www.mysql.com/doc/R/E/REPAIR_TABLE.html
Gurhan
-Original Message-
From: Bertrand TACHAGO [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 9:16 AM
To: [EMAIL PROTECTED]
Subject: Re: Need help
Hi,
I have a MySQL database with a table named CONNEXION. When i'm trying to do
]
- Original Message -
From: migu1 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 1:54 AM
Subject: LINK2001, I need help
I desperately need to find a solution to this problem:
Winnt 4,0, service pack 6.0; Visual C++;mysql-max-3.23.49-win binary.
my.ini File:
[mysqld
]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 14, 2002 7:07 PM
Subject: LINK2001, I need help
I desperately need to find a solution to this problem:
Winnt 4,0, service pack 6.0; Visual C++;mysql-max-3.23.49-win binary.
my.ini File:
[mysqld]
basedir=D:/mysql
datadir=D:/mysql/data
1
Dear Adminers,
I'm want to migrate database from MS-SQL Server 7.0 to MySQL Server. But
i've some problem when implementing that systems.
My system give to the user to connect about more than 200.000 connections
on one time, but when i try only approx. 150, the MySQL stopping connection
on 99
I desperately need to find a solution to this problem:
Winnt 4,0, service pack 6.0; Visual C++;mysql-max-3.23.49-win binary.
my.ini File:
[mysqld]
basedir=D:/mysql
datadir=D:/mysql/data
1.-On prompt:
D:\mysql\binmysqld-nt --install
the current server installed: ...
I desperately need to find a solution to this problem:
Winnt 4,0, service pack 6.0; Visual C++;mysql-max-3.23.49-win binary.
my.ini File:
[mysqld]
basedir=D:/mysql
datadir=D:/mysql/data
1.-On prompt:
D:\mysql\binmysqld-nt --install
the current server installed: ...
Dear All,
My record id is 10 char long, all records are unique.
However, many of these ids consist of _. Trying to
print all matching records with first eight characters
of the id. For some weird reason, it's not working
properly. Any comments or help will be greatly
appreciated. Blow is
Hello,
I am new in mysql, and I am trying to set an reclication. I followed the
instruction in the manual but steel I have a problem.
The problem is that even the replication thread works on my slave it is
not doing eny updates. The master.info file is updating every minute
and there is not
Hi All!
Have any of you faced a similar problem and if so how did you fix it?
Please, recommend me something.
The code that I have written is :
$sth = $dbh-prepare(SELECT * FROM MY_TABLE);
$sth-execute || die $sth-errstr;
i've report this bug to php, they said it's not bug of php
but i've found the problem
* ALL is ok for SERVER, problem issue only by CLIENT(libmysql.a)
php-win-binary don't compile libmysql supporting GBK charset!
neight other multibyte charset.
also the one i compiled is linked with
Xuefer,
Monday, April 15, 2002, 8:55:08 AM, you wrote:
X mysql-4.01
X binary package
X windows
X also the same in linux source/binary package
X when SHOW VARIABLES
X got:
X -
X character_set gbk
X character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis
mysql:
mysql-4.01
binary package
windows
also the same in linux source/binary package
when SHOW VARIABLES
got:
-
character_set gbk
character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos
german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew
I m running a mysql-server 3.23.49 under suse 6.4 (kernel 2.2.14) and
myodbc 3,51 .. I have an mdb file and want to export the tables from
access 2002 to the mysqldb .. I can connect to the db and read the
tables .. but when I want to export them .. I get a syntax error ???
What is wrong
Hey All,
I am new to mysql and I need help debugging this peice of code for my site:
?php
$db = mysql_connect(db30.pair.com, net3dual, rosevilleX1);
mysql_select_db(rahs,$db);
$search = mysql_query(SELECT * FROM rahs);
while($num=mysql_fetch_array($search)) {
printf (div align
Hello Alex,
If the mysql query returns 0 then it will display the message like this
-Uma
On Fri, 1 Mar 2002, Alex Behrens wrote:
ABHey All,
AB
ABI am new to mysql and I need help debugging this peice of code for my site:
AB
AB?php
AB$db = mysql_connect(db30.pair.com, net3dual
: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
- Original Message -
From: Uma Shankari T. [EMAIL PROTECTED]
To: Alex Behrens [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 7:35 PM
Subject: Re: need help debugging!
Hello
Shankari T. [EMAIL PROTECTED]
ABTo: Alex Behrens [EMAIL PROTECTED]
ABCc: [EMAIL PROTECTED]
ABSent: Friday, March 01, 2002 7:35 PM
ABSubject: Re: need help debugging!
AB
AB
AB
AB Hello Alex,
AB
AB
AB If the mysql query returns 0 then it will display the message like this
AB
AB
AB -Uma
AB
AB
AB On Fri, 1
of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
- Original Message -
From: Uma Shankari T. [EMAIL PROTECTED]
To: Alex Behrens [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 7:59 PM
Subject: Re: need help debugging!
Hello Alex
PROTECTED]
Hello Alex,
If the mysql query returns 0 then it will display the message like this
-Uma
On Fri, 1 Mar 2002, Alex Behrens wrote:
ABHey All,
AB
ABI am new to mysql and I need help debugging this peice of code for my
site:
AB
AB?php
AB$db = mysql_connect(db30
any results);
}
?
- Original Message -
From: Alex Behrens [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 5:25 PM
Subject: need help debugging!
Hey All,
I am new to mysql and I need help debugging this peice of code for my
site:
?php
$db = mysql_connect(db30
PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 10:19 PM
Subject: Re: need help debugging!
Try adding this to your mysql_query() function.
$search = mysql_query()
or die(ERROR: . mysql_error() . ( . mysql_errno(). ));
this will tell you whether or not the query is dieing
i have installed
perl 5.6.1
mysql 3.23.48
DBI 1.18
Apache 1.3.6
Suse Linux 6.0
DBD-mysql-2.1011.tar.gz
there is following problem:
install_driver(mysql) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/i586-linux/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
stressing the box. Good luck
On Wed, 20 Feb 2002, Sundara Pandian wrote:
Date: Wed, 20 Feb 2002 10:33:02 +0530
From: Sundara Pandian [EMAIL PROTECTED]
To: SplitSlim [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Please, need help urgently
Hi,
It would be time consuming to understand why
Hi,
On Wed, 2002-02-20 at 14:44, SplitSlim wrote:
I need some help, this is a mission critical server and it has
CRASHED!
Details:FreeBSD on INTEL, MySQL v3.23.36 (FreeBSD Port)
020219 22:52:01 mysqld restarted
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you
I need some help, this is a mission critical server and it has
CRASHED!
Details:FreeBSD on INTEL, MySQL v3.23.36 (FreeBSD Port)
The server had to be rebooted, and when it came back up, my MySQL
server died. It's been working flawlessly for months (5 or 6), but
all the sudden mysqld will not
-
From: SplitSlim [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 10:14 AM
Subject: Please, need help urgently
I need some help, this is a mission critical server and it has
CRASHED!
Details:FreeBSD on INTEL, MySQL v3.23.36 (FreeBSD Port)
The server had
? stable or not? :)
Jean-Francois Dionne
- Original Message -
From: Jean-Francois Dionne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 14, 2002 7:25 PM
Subject: Need help about mysql order and index
Hi there, I hope someone will can help me... First, sorry for bad
]
To: [EMAIL PROTECTED]
Sent: Thursday, February 14, 2002 7:25 PM
Subject: Need help about mysql order and index
Hi there, I hope someone will can help me... First, sorry for bad
english :)
i'm french
First all I have those index in my table
Ok I can't seem to get this. Now is it possible to have MySQL on a other
computer and run the script.
In other words the perl script is on foo.com and MySQL database is on
foo2.com. What is need to make the script work. What I have in the
script is:
Configure.pl
sub configure {
On Thu, Feb 14, 2002 at 01:05:24PM -0500, Richard C Rossy wrote:
Ok I can't seem to get this. Now is it possible to have MySQL on a other
computer and run the script.
In other words the perl script is on foo.com and MySQL database is on
foo2.com. What is need to make the script work. What
Hi there, I hope someone will can help me... First, sorry for bad english :)
i'm french
First all I have those index in my table
+---+---+-++
--+-++--++--
+
I need to optimize the following query:
SELECT user, sum(in), sum(out) FROM stats WHERE from='20020205'
AND to='20020206' GROUP BY user;
In,out are bigint, user is varcher(20) and from,to are timestamp
And I want to speed up this type of query, but I have not been able to
to get it to use an
Hi my names is Francis Pena im trying to compile Mysql-3.23.48, when i
run ./configure is is the result
[jigax@RHL mysql-3.23.48]$ ./conf
loading cache ./config.cache
checking host system type... i686-pc-linux-gnu
checking target system type... i686-pc-linux-gnu
checking build system type...
Hello everyone, I need help.
I have these scripts that I load when I want to create new tables in the database.
I had DB1 full of data.
Then I created DB2 and forgot to change the database that I was working in, to DB2.
I loaded all .sql source files, and then I think you know what I'm
I am trying to install MySQL on a Mac OS X server (v 10.1). I have followed
the instructions in the online documentation, but I am having 2 problems.
Any advice on the problems or on where to get more information is greatly
appreciated.
1. I got mysql installed and running (using
I have a RedHat 7.2 machine going, and I'm getting the following error when I run
mysqltest after starting the MySQL Daemon...
Snip
mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (111)
Snip
First of all, I've
This very cryptic error message is what you get when you try to connect
to the mysql server and it's not running.
It should probably read: mysql_real_connect(): Failed because there
is no server running. Run a server and try again.
Anyway, if your machine is properly set up to run mysql on
: Thursday, January 03, 2002 1:02 PM
To: Rick Emery
Subject: Re: [PHP-DB] Re: Big Problem...Need Help Quick
With Drop Table command. and I think is MYISAM.
Thank you so much Rick.
Kelvin. ( man , I am really screwed this time. )
- Original Message -
From: Rick Emery [EMAIL PROTECTED
Unless he's got a recent backup he's USCWAP
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 1:04 PM
To: [EMAIL PROTECTED]
Subject: Big Problem...Need Help Quick
I apologize for cross post; however this poster is not on MYSQL list and he
Hello !
what I want to do is :
display all the NOT NULL fields of 1 row, this row being selected with
a key [ for example : tabID.login='john' ] .
I DO NOT KNOW IN ADVANCE WHICH FIELDS ARE SUPPOSED NOT NULL,
since it varies along with the key [ tabID.login='jack' would give other
NULL fields ]
hope you version came out better thn mine.. in my mail it was all out of
shape.. maybe could attach a text file.. doubt the list allows that
thoough alot dont
Upload it as your_code_name.txt to your website and send an URL to the list.
filter: mysql query sql
Bye,
B.
Hello.. of all days i have a project thats to be shown tomorrow.
i cannot get the dam thing to work
it should be simple i'd think
i would post code and all and if asked will
but it comes down to this.. i am using php 4 and mysql.. and doing math
i have say 40 entries in the database, 20 for
I think you need to post the code. The description of the
problem is a bit ambiguous.
_justin
Webmaster wrote:
Hello.. of all days i have a project thats to be shown tomorrow.
i cannot get the dam thing to work
it should be simple i'd think
i would post code and all and if asked will
the code is huge i'll post whats relevant. there may be a few irrelevant things in
there... but hell... if your willing to look i'm willing to post
i know what works so will skip down lower to prevent wasting your time
and if ya could please cc your responce to [EMAIL PROTECTED], though if
hope you version came out better thn mine.. in my mail it was all out of shape.. maybe
could attach a text file.. doubt the list allows that thoough alot dont
-- Original Message --
From: Webmaster [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Tue,
Hello.. of all days i have a project thats to be shown tomorrow.
i cannot get the dam thing to work
it should be simple i'd think
i would post code and all and if asked will
[snip]
Is the performance of your code data independent?
That is to say, if you remove (from the database) the set of
I need to remove a previous version of mysql and install the newest. When
trying to remove the previous version it complains about dependencies . I
don't know what to do about it, so I end up with a successful install of the
new version. Any help would be appreciated
rpm -e mysql-3.23.36-1
try just upgrading the RPMs using rpm -ivh
--
Kelly Firkins
[EMAIL PROTECTED]
I need to remove a previous version of mysql and install the newest. When
trying to remove the previous version it complains about dependencies . I
don't know what to do about it, so I end up with a
PM
Subject: Re: need help with mysql rpms
try just upgrading the RPMs using rpm -ivh
--
Kelly Firkins
[EMAIL PROTECTED]
I need to remove a previous version of mysql and install the newest. When
trying to remove the previous version it complains about dependencies . I
don't
:
MySQL conflicts with mysql-3.23.36-1
MySQL-server conflicts with mysql-server-3.23.36-1
- Original Message -
From: Kelly Firkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 10, 2001 4:20 PM
Subject: Re: need help with mysql rpms
try just upgrading the RPMs using
Raymond Norton wrote:
error: failed dependencies:
MySQL conflicts with mysql-3.23.36-1
MySQL-server conflicts with mysql-server-3.23.36-1
Yeah, the MySQL rpms are incompatible with the mysql rpms (which are done
by RedHat). Apparently the two camps each think the other's file system
Hi,
I have two tables:
mysql describe eventlog;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
| id |
I'm no expert in this in fact I just recently started playing with
joins, but here's one that I actually used for a recent shopprt cart
piece. I appologise if it wraps but the output is long...content
conatins the basic content info but product contains the list of prices.
Yes I could have
Hi,All:
I need your help, When I compile the Msql-Mysql-Modules, I got errors, I am
running Redhat7.1 with perl5.6.1, the whole process is just as follows:
[root@wappy local]# cd Msql-Mysql-modules-1.2218
[root@wappy
: Re: Need help with SELECT 2 tables from choice of 3
Why no have 3 tables:
Members
Data
TheseMembersAreOld
Members and Data are as you have them defined. TheseMembersAreOld
contains only the Member_ID field.
You then make the Member_ID field primary key on TheseMembersAreOld and
Members. You can
You can join all three tables together
select d.members_id, m.name, old.name from data as d
left join members as m on m.members_id=d.members_id
left join oldmembers as old on old.members_id=d.members_id
If the members_id belongs to an old member, all fields from the member table
Hi there
I need help :-)) If anybody could be so kind and help me...
I have 3 tables:
OldMembers
Memebers
Data
In Data there is a field Member_ID. Now in this field all members bigger than
100.000 are old ones and must be taken from the OldMembers table (both tables
are not using same data so
OldMembers
Memebers
Data
Why no have 3 tables:
Members
Data
TheseMembersAreOld
Members and Data are as you have them defined. TheseMembersAreOld
contains only the Member_ID field.
You then make the Member_ID field primary key on TheseMembersAreOld and
Members. You can then perform a very
Why no have 3 tables:
Members
Data
TheseMembersAreOld
Members and Data are as you have them defined. TheseMembersAreOld
contains only the Member_ID field.
You then make the Member_ID field primary key on TheseMembersAreOld and
Members. You can then perform a very fast joins.
Hm, thank you for
with Syntax/Query. Need Help Please.
G'Day All.
I'm trying to do the following in a query, in mySQL.
All my previous years of SQL has been on MS-SQL, and i'm having some
little
problems with tricky sql statements.
*
i'm trying to insert a new record if the name doesn't exist in the table
Hi.
On Tue, Nov 06, 2001 at 12:34:26AM -0700, [EMAIL PROTECTED] wrote:
In MSSQL I can aggregate various fields like the [totalRev] field listed
below:
Does anyone know if or how to do this in MySQL?
You can't. You only can do this in the SELECT clause or make a column
that your application
Following the instructions in the INSTALL-SOURCE file
I can get to the last instruction -
/usr/local/mysql/bin/safe_mysql --user=mysql
I get a No such file or directory file, which is
correct, I dont have safe_mysql anywhere on the system
Did I miss a step somewhere?
Running
I'm not sure, but isn't it supposed to be
safe_mysqld (notice the extra d at the end).
Not sure, just curious... (^^;;;
Nick
On Sat, 17 Nov 2001 13:12:14 -0800 (PST)
a a [EMAIL PROTECTED] wrote:
Following the instructions in the INSTALL-SOURCE file
I can get to the last instruction -
G'Day All.
I'm trying to do the following in a query, in mySQL.
All my previous years of SQL has been on MS-SQL, and i'm having some little
problems with tricky sql statements.
*
i'm trying to insert a new record if the name doesn't exist in the table. If
i insert, return ID, else return 0
I'm running MySQL ver 3.23.38 on Win98 platform and am trying to learn
to do backups. I'm trying the mysqldump command but I'm getting the
error:
Access denied for user '@localhost'
How do I specify a user for mysqldump?
Thanks,
Bryan
Hi,
I'm running MySQL ver 3.23.38 on Win98 platform and am trying to learn
to do backups. I'm trying the mysqldump command but I'm getting the
error:
Access denied for user '@localhost'
How do I specify a user for mysqldump?
mysqldump --user=username ... Try mysqldump --help for more
Hi John Kelly,
This is not a perfect solution but may be useful to you. But still with two
queries!
From Mysql prompt issue these two queries.
SELECT @maxcat := max(Category) FROM table
WHERE category = 'Sports:Football:Players' OR
category = 'Sports:Football' OR category = 'Sports';
Select
Hi, I have a MySQL table with a column that contains some of a web site
directory's category names in the format:
Sports:Football:Players
I am trying to build a query that that locates all records that match the
above category name OR if none exist its parent Sports:Football OR if none
exist
You need to use the LIKE command I think. The MySQL manual should give you
all the details. If you need further help I can just write the whole query
out for you. Or was the problem that you only want to worry about the
if..then stuff if needed? If so could you tell what your pulling back from
]
Cc: [EMAIL PROTECTED]
Sent: Friday, November 02, 2001 7:09 PM
Subject: Re: Need help with a query ...
You need to use the LIKE command I think. The MySQL manual should give you
all the details. If you need further help I can just write the whole query
out for you. Or was the problem that you
On Fri, Nov 02, 2001 at 06:15:08PM -0800, John Kelly wrote:
Hi, I have a MySQL table with a column that contains some of a web site
directory's category names in the format:
Sports:Football:Players
I am trying to build a query that that locates all records that match the
above category
Can someone help? Using Linux (Mandrake 8.0), I'm still having great
difficulties getting Apache and PHP installed/configured to interface the
MySQL database I'm using. I've repeatedly tried compiling PHP and Apache
from source, with no luck (I even used newer/older versions the several
My perl app that loads the tables reached 2gb and bang! It is only halfway
done! I had converted from Oracle which doesn't give a second thought as
long as the tablespace is large enough.
Has anybody turned on raid for the windows version?
Turning this feature on in Unix appears simple, but
Hi..
I have a problem running my MySQL server. After
running shellmysql_install_db when everything runs
fine then I tried to start the server with this
command shellsafe_mysqld
Then this error occurs.
starting mysqld daemon with databases from XX
mysql daemon ended
The manual didn't
jesse junsay writes:
Then this error occurs.
starting mysqld daemon with databases from XX
mysql daemon ended
The manual didn't say anything on how to solve this
problem. So I hope this will help.
That's not an error message. Error messages can be
found in the error log, which
Unless you ran it as
mysql_install_db --user=mysql
mysql does not own the databases.
do
chown -R mysql /usr/local/mysql
chown -R /var/lib/mysql
( Or whereever your database directory is )
jesse junsay wrote:
Hi..
I have a problem running my MySQL server. After
running shellmysql_install_db
Dave Lake wrote:
Hi Folks
I have used MySQL for some time and am just getting my head around PHP. I
looked across a number of PHP sites for some input on this but failing to
find an answer thought I would ask some MySQL users (surely many of you are
using PHP right? ;-) ) for help.
I
I've changed root's password via netscape with phpmyadmin and then
reloaded.
It's not possible to connect anymore. The system asked for a new
password but didn't accept the new one.
So, I've tryed to re-install mysql again
version : MySQL-3.23.38-1.i386.rpm on redhat Linux.
Now, when I try to
PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 18, 2001 15:21
Subject: need help to uninstall mysql
I've changed root's password via netscape with phpmyadmin and then
reloaded.
It's not possible to connect anymore. The system asked for a new
password but didn't accept the new one.
So
701 - 800 of 912 matches
Mail list logo