./myqld: Can't find file : './mysql/host.frm' (errno:13)
does anyone know how to solve this problem?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hi!
How can I print the results to the printer in
Windows2000 environment? Is there any MySQL command
for this purpose? How about the MySQL Control Center?
I have tried to search for an answer, but mostly for
the unix system. Is there any simple solution since I
am not a programmer?
Terence
The "111" is the error code that MySQL generates.
Check if your computer has a firewall, and make sure to enable port 3306
from external IPs
e.g. on redhat using ipchains-based firewall, add:
-A input -s 0/0 -d 0/0 3306 -p tcp -y -j ACCEPT
to your /etc/sysconfig/ipchains file (or however the b
OK I got files to upload to my MySQL server but now how do I retreive them
for distribution by email for instance.
When I do a query the filename looks something like:
/var/tmp//phptkYxkV
I'm not sure where that is but I need to retrieve that file and distribute
it...
Any suggestions would be g
On 1/1/03 2:31 PM, "Richard Nagle" <[EMAIL PROTECTED]> wrote:
> Well after 3 times installing mysql, finally
> got it working (tks to those whom help)
> now I need to take care of user and root.
> first root.
>
> mysql> mysql -u root mysql
>
> just want to confirm this is correct before I push e
Hi
I was looking for a reasonably heavyweight php application, there are some
lightweight ones and some half finished ones and some perl ones, but none
that were what I was looking for.
Any suggestions would be appreciated, no point in reinventing the wheel.
Peter
--
On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote:
>
> I am not sure if there is existing faq software (I've checked
> sourceforge and freshmeat without much luck)
Really?
That's a wheel I've seen re-invented many times. I know there's stuff
out there.
--
Jeremy D. Zawodny | Pe
Hi
Is '111' the IP it is trying to connect on?
If so it is an invalid IP.
If the IP is valid how are you trying to connect?
Peter
---
Excellence in internet and open source software
---
Sunmaia
Birmingham
U
I really need your help, I installed MySQL and I can
connect to it through localhost but when trying to
access it from outside I get:
ERROR 2003: Can't connect to MySQL server on 'IP'
(111)
Any suggestions?
Someone suggested that the problem is because the
server has 2 nics (2 ips set up).
Does
OK I got files to upload to my MySQL server but now how do I retreive them
for distribution by email for instance.
When I do a query the filename looks something like:
/var/tmp//phptkYxkV
I'm not sure where that is but I need to retrieve that file and distribute
it...
Any suggestions would be g
Hi
Like the look of the way its taking shape.
I am not sure if there is existing faq software (I've checked sourceforge
and freshmeat without much luck) we could use, or if someone can do a better
job :) but I have a content management system written, together with a lot
of the search functionali
Title: ÌØ´óϲѶ
×â
´º½Ú°ÙÍò´óÐж¯ ËÍ
¡¡
I'm not following this threath.. but..
Use PHP to fetch mail from a mailbox, insert all questions into a database.
Create a searchtool to search the database.
No need to have way to many ppl as author. If you want you could have some
ppl maintaining a list of keywords per question or remove a qu
Well after 3 times installing mysql, finally
got it working (tks to those whom help)
now I need to take care of user and root.
first root.
mysql> mysql -u root mysql
just want to confirm this is correct before I push enter.
mysql> update user set password=password('tko')
where user='root';
Hi Frank,
the full text search from MySQL is probably what you are looking for. You
can read more about it in the online documentation.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Ful
ltext_Search
Cheers,
Pieter
- Original Message -
From: "Frank Peavy" <[E
I recently found this web-based front end and am extremely impressed by
it. Among other things,it lets you bookmark your sql queries.
http://eskuel.sourceforge.net/
-bill
Richard Nagle wrote:
what would be the easy to use, gui front end for
mySQL 3.23.53 (for Mac OS X )
Thanks Again,
Richard
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
David,
> Sure; it's the least I can do. Look for mysql.justpickone.org to be
in
> the DNS tables by tomorrow. By then the
[EMAIL PROTECTED]
> mailing list will be ready for subscriptions, too.
Fine. http://mysql.justpickone.org/ works :)
> Now, what do we need to do to be able to update this F
Hello.
On Wed 2003-01-01 at 15:38:23 -0500, [EMAIL PROTECTED] wrote:
> If I am reading the documentation correctly, MySQL will not maintain a
> UNIQUE INDEX across the tables that make-up a merged table.
Correct. Although it is called a UNIQUE index, the MERGE table doesn't
hold it's own index an
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank --
...and then Frank Peavy said...
%
% >Even so, that still doesn't answer the question of how to have data of
% >different magnitude in the same table. If I have one class with one
% >person and another with two people, how would I have a sin
If I am reading the documentation correctly, MySQL will not maintain a
UNIQUE INDEX across the tables that make-up a merged table. Does anyone
have any tips for maintaining a UNIQUE INDEX across tables that make up
a merged table?
Is there an easier way than running a SELECT statement on all of th
Can anyone help me?
I get this whenever I run ./configure --prefix=/usr/local/mysql
"checking for termcap functions library... configure: error: No
curses/termcap library found"
then configure quits. I'm really new to linux, so please give me the
"lamans" version of it ;)
___
I was able to create the "gid" table with no problem under mysql 4.0.7
CREATE TABLE gid (
id INT(11) NOT NULL auto_increment,
groupname VARCHAR(128) NOT NULL,
passwd VARCHAR(128) NULL,
gidINT(11) NOT NULL,
username VARCHAR(128) NULL,
By looking at your query and table description, I guess you can try
something like:
SELECT cus.`Code` AS `Customer Code`,
cus.`Name` AS `Customer`,SUM((1-bil.direction)*bil.Total) AS Loan,
SUM(bil.direction*bil.Total) AS Credit
FROM customer AS cus,
bill AS bil
WHERE bil.`Customer` = cus.`ID`
GRO
alkaline has been around awhile. the model is similiar
to mysql in that they have a commercial version that sustains them,
and a free version that sustains the rest of us.
there is not a doubt that its better than the php script you refer to
below...
http://alkaline.vestris.com/docs/alkaline-faq/
Even so, that still doesn't answer the question of how to have data of
different magnitude in the same table. If I have one class with one
person and another with two people, how would I have a single record for
each which lists the client(s)?
Easy,
Your scheduling query results, as I said:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank --
...and then Frank Peavy said...
%
% David,
% Just some thoughts..
% See my comments below...
Thanks!
%
% >A scheduling, or a booking, eventually has to have a class type (private
% >or one of many groups -- so I suppose I could simply ma
Hi,
I have got 2 tables one of the is "customers" the other is "bill". In the
customers table i store my customers informations. In the bill table i store
my billings. if i take a bill bill.direction=0, if i give a bill
bill.direction=1. And now i must take a report Like This..
Customer Code
David,
Just some thoughts..
See my comments below...
A scheduling, or a booking, eventually has to have a class type (private
or one of many groups -- so I suppose I could simply make a group class
type 'private' and that type has only one slot), an instructor, a place,
a time slot, and the clien
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank, et al --
...and then Frank Peavy said...
%
% David,
% I am unsure if I followed your example completely, but maybe this might
% help. Not knowing your complete database structure, I am unsure if my
% comments will be entirely valid but here
David,
I am unsure if I followed your example completely, but maybe this might
help. Not knowing your complete database structure, I am unsure if my
comments will be entirely valid but here goes.
I think you could achieve your goal if you think of your groups as
containing one or many clients.
Hello All,
I have a need to build some user functionality (text search) that is
similar to the search functions available in most search engines. I would
like to have users input a search string and find the appropriate records
in MySql, for example:
database "software development" linux
Part
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I need, I think, some pointers to basic JOIN tutorials. I don't really
know how to approach this query. I should say early on that I don't
expect the list to write my code for me, though any help anyone can send
is VERY much appreciated;
Hello and hope that everybody on this list will pass a wonderful 2003 year,
Here's my worry:
I have 3 tables, one for genre, one for html and one for shockwave
html and shockwave have a foreign key genreID
I want to count for each genre how many html and shockwave entries have the
same genreID, s
To the MySQL group!Happy 2003 and have a safe holiday season...
Hopefully this got past the filter LOL
Chuck
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan, et al --
...and then Stefan Hinz, iConnect (Berlin) said...
%
% David,
%
% > see it dropped if they don't jump on it at the start.
%
% I agree. Will you set it up at http://justpickone.org/? (BTW, I like
Sure; it's the least I can do. Loo
Terence, Rich,
> > I have tried:
> > LOAD DATA LOCAL INFILE "lcopen1.txt" INTO TABLE lcopen;
> > but it shows:
> > ERROR 1148: The used command is not allowed with this
> > MySQL version
This is because of security issues, as the manual says:
In MySQL 3.23.49 and MySQL 4.0.2, we added some new o
James,
> something that can be based upon pages of htm and
> emails that exists, and that can sit under a few web pages
> using Htdig or alkaline or something...
Do these tools work better that the search tool (Mnogo search) at
http://lists.mysql.com/php/search.php? This thing sucks - I was looki
David,
> Oh, to be sure. And maybe we could even get the mysql.com folks to
> prominently list a pointer to the off-site FAQ if they don't want to
> maintain it or give out accounts to maintain it. I just wouldn't want
to
> see it dropped if they don't jump on it at the start.
I agree. Will you
Hi,
I'm trying to use to following HANDLER syntax :
HANDLER tbl_name READ index_name=(value1);
However I fail since I don't know what is 'index_name' for a PRIMARY KEY (I
already tried PRIMARY, `PRIMARY KEY`, and the column name without success).
Any idea ?
BTW, are HANDLER statements cached b
> Is the Max edition of 4.0.7 necessary for a server with RAID.
> Or can the standara edition be used?
By 'a server with RAID' you likely mean a server with a hardware
RAID array. In that case you can use any distribution. This is totally
independent of MySQL. Your only concern is to make your ope
> MyTOP says this particular slave has been up 47 days, 2 hours... It's had
> 56M queries, of those 4,559 were "slow"... Not being a MySQL expert, I'm
> not sure how to get slow queries/hour directly from MySQL.
You would use SHOW STATUS, but mytop did it for you :-)
> Do you mean using a load
42 matches
Mail list logo
