Well thats the thing,
I did an more than one user that was allowed to connect TO 192.168.0.2 from
various hosts on my network
and all hosts can reverse lookup from my dns server.
no good
- Original Message -
From: "KH Chiu" <[EMAIL PROTECTED]>
To: "Poodle" <[EMAIL PROTECTED]>; <[EMAIL PRO
i can coneect from localhost
and all machines can see all machines
i made users with access from hosts
i made users with database access from hosts
still the same
- Original Message -
From: "Bryan Lipscy" <[EMAIL PROTECTED]>
To: "'Poodle'" <[EMAIL PROTECTED]>
Sent: Tuesday, February 1
does mySQL have
"rowid" or "rownum"
if yes please give an exampl
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
-
Before posting, p
> SELECT * FROM EventList ORDER BY 'EventDate', 'EventOrder' LIMIT 50;
I'm surprised you happened to get anything in order. Maybe the message got
simplified by the list manager, but did you really mean to order by a
constant string?
Why not:
SELECT * FROM EventList ORDER BY `EventDate`, `
That's exactly what I was looking for and the way I hoped it could be
done, only I hadn't seen anything about this 'exec' function.
Thanks. I should be able to figure it out myself but I will get back
with you if I need further help.
--
Loren McDonald
Gods Of Music Reviewer/Editor
[EMAIL PROTEC
Hi Ed,
>What query would I use to check for an existence of a table within a
>database?
SHOW TABLES LIKE '';
might help.
prosit
Klaus
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
My problem is that my fulltext searches run quite slowly.
I have a 2300MB table with 4.3M rows and an index (primarily a fulltext
index) of 1300M. My hardware is a dual Athlon MP1500+ with 2GB of memory.
I am running MySQL 4.0.10.
My my.cnf includes:
set-variable = key_buffer=16M
set-variable
Hello folks
(BIs it possible to install a MySQL server into the /home/*username*
(Bdirectory in a typical Linux Installation. If so
(B1. where to put those my.cnf files and set the global options for a
(Bparticular user.
(B2. How to connect to that database from a remote machine, knowing t
First, an update. After waiting a few days for a FULLTEXT index to build on
a 3.23.5* database, I updated the database server to MySQL 4.0.10 on advice
from Sergei Golubchik on this list:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:132146:200302:cdpckkcecgnggcboabda
The index rebuild took 'o
You should add a user who allow to connect from 192.168.0.2 before you can
connect to MySQL remotely.
Further more, make sure that your host can reverse lookup 192.168.0.2. This
can be done by add an entry in the /etc/hosts or create a DNS entry.
Regards,
> Just installed mysql nice one i thou
Dear all,
I am planning to offer a free service that allow users to use my server to
learn php and MySQL. I am a bit worry about if one of users (either
intentionally or unintentionally) get into infinite loop with insert
statement. It will quickly eat up the disk space and make my server
unfu
Sorry I am in a bit hurry and just post some hints on your question. It is
more than one way to do your job. One of the trival way is to use php
function 'exec'. This function can execute shell programs. It means that you
can execute mysqldump etc. and create dump file.
>From my experience, you
This is actually more a PHP question but since it refers to a MySQL
database I thought I would ask here.
I may not be looking in the right places but, I can't seem to find a way
to do a database backup through PHP (other than BACKUP TABLE, which I
don't want to use if possible)
What I mean is thi
Today I added --myisam-recover=FORCE,BACKUP,QUICK
However, replication seems to not honor that setting.
I have a master that can average 7000qps and last forever, and a slave
that can only last 12 minutes at 1/10 the qps. :(
Next, I guess, is to download the debug version from MySQL and see what
Hi,
This is my first post to this mailing list, so please forgive me if my
message is not structured in the correct format.
My query is this. Where a column used as a unique identifier for a
record contains the values 1,2,3,5. Is a mysql query possible that will
retrieve 4 as an available index
Just installed mysql nice one i though
set it all up read the nessasary docs nice one i thought
tried to connect remotly
[root@tasha root]# mysqladmin -h 192.168.0.2 version -uroot -ppassword
mysqladmin: connect to server at '192.168.0.2' failed
error: 'Lost connection to MySQL server during que
I solved the issue (eventually) by using a different control.
It seems the batch component interprets #'s differently than regular table and query
components. I'll use query components in the future.
Thanks anywaym,
Rob
> -Original Message-
> From: Stefan Hinz [mailto:[EMAIL PROTECTED
HI all
SOme questions ..
1- the index mode for FULLTEXT search use a stop word for emtpy the bad words
in index structure ? or only use ft_stop_word in query mode ?
2- My method for retrive de aproximate results of a query and the same query
ordery by weight is follow :
"Select count(id)
Robby,
> How can I get MySQL (via ZeosDBO in Delphi 5) to accept the #
> sign? Add extra quotes or a backslash before the character? Use double
> quotes? Some other method?
I know about nothing of Delphi and Zeos, but I'd try a backslash
before the # character. Here's what I get with the mysql
A few more tidbits:
* All slaves are running the static i686 linux build
(mysql-3.23.55-pc-linux-i686) under RH8.0 (since RH8 won't compile MySQL
without it dumping core).
* More log snippets:
030217 15:43:01 Slave: received 0 length packet from server, apparent master
shutdown:
030217 15:43:0
Howdy,
Running MySQL 3.23.54 on master, 3.23.55 on all slaves, I'm experiencing the
following situation:
slave1 & slave4 both receive 0 length packets from the server.
slave2 & slave3 both work fine.
slave1 & 2 are identical machines both in hardware and configuration
slave3 & 4 are different fr
yup, that was exactly it. Sorry about the simple question. I didn't
realize that was what group by does
Lewis
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Cc: "Lewis Watson" <[EMAIL PROTECTED]>
Sent: Monday, February 17, 2003 5:02 AM
Su
Greetings,
In trying the MySQL and Apache links found on the page
doc/en/Apache.html
I was trying the second option
Why when I tried the CustomLog "|mysql -host... option above it
didn't work ?
I like the second option over the first because the SQL database is
updated instantly a log entry
Hello,
I tried to insert a # as part of a field and got an error from the server
saying that I had an error in my SQL statement at line 1
"F:\\BL". The error number is (8000) and the value is supposed to be "F:\\BL#".
I understand that MySQL is interpretting that as a comment identifier. I
Stefan Hinz wrote:
It would be nice to extend the user permissions table to have per-user
limits like max_user_connections and the various timeouts applying
directly to specific user/host combinations.
As of MySQL 4.0.2, you can set some limits per user. Here's an excerpt
from my mysql.us
Michael,
> It would be nice to extend the user permissions table to have per-user
> limits like max_user_connections and the various timeouts applying
> directly to specific user/host combinations.
As of MySQL 4.0.2, you can set some limits per user. Here's an excerpt
from my mysql.user table:
sql,query,queries,smallint
I am in the process of designing a form and I am a little confused.
I would like to have a scrolling window, in which the user can
select multiple
items. For example, the scrolling window may contain operating
systems, and the
user has the ability to select multiple OS
At 04:58 PM 2/17/03 +0100, you wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query,queries,smallint
If you just reply to this message, and include
On Mon, Feb 17, 2003 at 02:33:05PM -0500, Michael T. Babcock wrote:
> It would be nice to extend the user permissions table to have per-user
> limits like max_user_connections and the various timeouts applying
> directly to specific user/host combinations.
Agreed. We've had a few circumstances
Server version 3.23.55-entropy.ch
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Apple PowerBook G3 running Mac OS X 10.2.4
I'm using the distribution provided at Marc Liyanage's site:
http://www.entropy.ch/software/ma
6@74 is obviously not a real email address but this is happening on a
fairly regular basis from this mailing list. I can't see the message so
I can't tell if it is spam or not but if you are not seeing your
messages on the group then you might want to see if your email client is
confused about who
It would be nice to extend the user permissions table to have per-user
limits like max_user_connections and the various timeouts applying
directly to specific user/host combinations.
Just a thought / suggestion.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. SQL
http://www.fibrespeed.net/~mbabc
On Monday 17 February 2003 04:20, Lewis Watson wrote:
> I have a table with three fields. In the first field I have a range of
> numbers 1-20; all repeated more than once. In the third field I have a
> number ranging from 1 to 20 in each row. I need to choose the
> lowest amount in the thi
I have encountered what appears to be a bug in MySQL regarding ORDER
BY related to a date field when also used in conjunction with
DATE_FORMAT() or UNIX_TIMESTAMP(). When these functions are applied
to my date field, MySQL ignores any included ORDER BY within the
query. I first noticed this bug
Hi,
Compilation of mysql 3.23.55 fails ONLY when using "--with-mysqld-ldflags=-all-static"
results in broken mysqld.
Segmentation fault?
Resolving stack trace:
0x808f4d4 _Z15handle_segfaulti + 404
0x81bc67a __pthread_sighandler + 122
0x81ceb4d __strtol_internal + 1421
0x8096cf6 _Z17add_fie
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jerry, et al --
...and then Jerry said...
%
% Is it just me or is everyone on the list getting junk/spam from naver.com ?
Haven't seen any, assuming you spelled it right. I just checked through
my entire mysql folder and have only your and Stefan's
Hi!
I have the same problem in my new Red Hat 8.0 / Athlon 1.8 GHz laptop.
If I build MySQL-4.0.10 from source with
./BUILD/compile-pentium-debug
it crashes in installing MySQL system tables. If I use a MySQL binary distro
to install the system tables, then the mysqld I built may crash in
mysql
Martin,
this bug in multi-table UPDATE on InnoDB tables was reported 3 weeks ago and
Sinisa has fixed it to upcoming 4.0.11.
Regards,
Heikki
Innobase Oy
sql query
..
Subject: Bug? Update on 3 tables crashes in InnoDB
From: Martin Thoma
Date: Mon, 17 Feb 2003 11:57:12 +0100
Ca
Ed,
> What query would I use to check for an existence of a table within a
> database? I'm currently writting a set of scripts in php. Is this possible
> with MySQL or do I need to create a condition within PHP?
In MySQL, you can issue:
SHOW TABLES [FROM your_database] LIKE 'your_pattern'
Wher
sql,query,queries,smallint
> HI all
I'm searching in how to generate a auto_increment number starting form 1
every year
I mean
ID DATE
1 2003
2 2003
1 2004
2 2004
etc
> maybe possible or I've to use some c code to make it possible ?
Yes, this is possible. U
Hello,
I've tried to rename a temporary table, and I got an error
ERROR 1017: Can't find file: './GOdevel/xgp.frm').
I guess it does not make too much sense to rename a temp table ... .
However,
I thought this might be worth mentioning.
regards,
Arne
not to be bounced: sql,
On 17-Feb-2003 [EMAIL PROTECTED] wrote:
>
> What query would I use to check for an existence of a table within a
> database? I'm currently writting a set of scripts in php. Is this possible
> with MySQL or do I need to create a condition within PHP?
>
> Thanks,
>
function tableexists($tbl) {
Hello,
When using the following on MySQL:
select count(xFld) from aTbl group by xFld;
I get twice the time it takes to process:
select xFld from aTbl group by xFld;
Can any one explain this and maybe help find a solution?
I'm using MySQL version 3.23.54 on NT and 3.23.41 on Linux, both
exhibi
Thanks for all the replies. I've got a hnadle on it now.
Ed
On Mon, 17 Feb 2003, Paul DuBois wrote:
> At 11:10 -0500 2/17/03, <[EMAIL PROTECTED]> wrote:
> >What query would I use to check for an existence of a table within a
> >database? I'm currently writting a set of scripts in php. Is this
At 9:32 -0600 2/17/03, Mayo, Chuck wrote:
Hi all,
Just jumped on the list, hoping someone can give me a hand. The query below
uses a join, I guess, to select records from table stat_1_1 based on
information in table stat. I'd like to be able to turn this query into a
delete query but only want re
At 9:32 -0600 2/17/03, Mayo, Chuck wrote:
Hi all,
Just jumped on the list, hoping someone can give me a hand. The query below
uses a join, I guess, to select records from table stat_1_1 based on
information in table stat. I'd like to be able to turn this query into a
delete query but only want re
There is an example in the php manual.
http://uk.php.net/manual/en/function.mysql-list-tables.php
chrisshaffer at bellsouth dot net wrote :
function mysql_table_exist($tableName)
{
$query = "SELECT COUNT(*) FROM $tableName";
$result = mysql_query($query);
$num_rows = @mysql_num_rows($resu
At 11:10 -0500 2/17/03, <[EMAIL PROTECTED]> wrote:
What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?
You can check the output of SHOW TABLES or
show tables from databasename;
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 17 February 2003 16:11
To: [EMAIL PROTECTED]
Subject: Checking existence of a table.
What query would I use to check for an existence of a table within a
database? I'm curre
What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?
Thanks,
Ed
mysql
-
Bef
mysql:ÄúºÃ!
Èç¹ûÄãÏÖÔÚÏëÕõÇ®µÄ»°£¬http://platinum-mails.ebiz-enterprises.com/?r=chenggong´ò¿ªºó×¢²á£¬×¢²áÓÐ$50£¬Ã¿½éÉÜһλÓÐ$15,$200Æð¸¶
[×¢Òâ]Ҫ׬Ǯ¾Í¿´°¡~ºÃ¶«Î÷~
׬ǮµÄºÃ·½·¨£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
²»ÂÛÄãÐŲ»ÐŶ¼²»·ÁÊÔÊÔ°É
·´Õý¶ÔÄãûËðʧ¡£Ö»ÒªÄãÓÐ̨µçÄÔ£¬Äܹ»ÉÏÍø¾ÍÐС£¶øÇÒÕâÖÖ·½
Hi all,
Just jumped on the list, hoping someone can give me a hand. The query below
uses a join, I guess, to select records from table stat_1_1 based on
information in table stat. I'd like to be able to turn this query into a
delete query but only want records removed from stat_1_1. Can anyone tel
>>> Inandjo
- delete from table1 where table1.field1 in (select distinct field2 from
table2)
<
>From what I've read subqueries are not yet supported. We worked around
this by converting the distinct list to a comma delimited list of
values. E.g.,
:::
Inandjo,
> - delete from table1 where table1.field1 in (select distinct field2 from
> table2).
Subselects (or nested queries) like that are supported as of MySQL
4.1. At this moment, you will have to compile 4.1 yourself; it's
expected to be out as a binary version in the next couple of weeks.
Th
thanx joe, i checked.
I just thought that there could be a way around this problem!
From: "Joe Stump" <[EMAIL PROTECTED]>
To: "Inandjo Taurel" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: How to write delete query??
Date: Mon, 17 Feb 2003 09:46:53 -0800
MIME-Version: 1.0
Received:
What you have there is a subselect, which are not supported in mysql 3.2x,
but I *believe* are supported in 4.0+ (gamma and 4.1alpha). Don't take my
word for it and check the docs first.
--Joe
--
Joe Stump <[EMAIL PROTECTED]>
http://www.joestump.net
"Label makers are proof God wants Sys Admins t
SQL SQL
hi all,
i have a query that works just fine on Dbase, but just crashes on mysql.
How can i write it in one statement for it to work both on Dbase and mysql?
the query:
- delete from table1 where table1.field1 in (select distinct field2 from
table2).
Thanx
_
On Mon 2003-02-17 at 12:14:12 +0100, [EMAIL PROTECTED] wrote:
[...]
Please disregard this mail. It was not supposed to go to the list.
(forgot to remove the CC that my mailer is set up to automatically
append for mails going to my -mysql address).
My apologies about that, Jason.
Bye,
B
On Solaris I always use :
/etc/rc3.d/S99mysqld stop
/etc/rc3.d/S99mysqld start
Jerry
- Original Message -
From: "Sunil Gavaskar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
Sent: Monday, February 17, 2003 2:50 PM
Subject: Re: mysql shutdown ha
Hi,
I have installed the 4.0.10-gamma with support from the openssl v. 0.9.7
on the Debian Woody:
mysql>status
...
SSL:Cipher in use is DHE-RSA-AES256-SHA
...
mysql>show variables like '%openssl%';
+---+---+
| Variable_name | Value |
+---+---+
Anybody can help this???
thanks
regards
sunil
Hi,
I am facing mysql shutdown process hanging problem on Solaris 5.8,
mysql 3.23.40
I am running our product Web NMS which uses MySQL DB, on solaris
machine.
While shutting down the application, except MySQL process, all other
process are kil
* Dee
> I have a table that contains ids for several other tables. Setup is as
> followed:
>
> +--+--+--+-+-+
> +
> | Field| Type | Null | Key | Default | Extra
> |
> +--+--+--+-
On Mon, 2003-02-17 at 12:57, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query,queries,smallint
>
> If you just reply
Sergei Golubchik wrote:
Which decision, putting all the indexes in one file, or rebuilding all
indexes whenever you ALTER TABLE or add an index? If the latter, I
agree with you. Modifying unrelated indexes or columns should not
force a rebuild of every index.
Of course not.
And it won't e
On Mon 2003-02-17 at 03:38:07 -0600, [EMAIL PROTECTED] wrote:
> Reply when you have a job, dumbass.
> I have a system that makes more in a week than you make in a year
> crashing because of this buggy piece of shit.
If a system supposedly making millions a year is unstable you are a
fool that you
* Lewis Watson
> I have a table with three fields. In the first field I have a range of
> numbers 1-20; all repeated more than once. In the third field I have a
> number ranging from 1 to 20 in each row. I need to choose the
> lowest amount in the third column for each distinct value in the
Hi,
If you only want to move database "Protein" (and not all your databses)
you can use symbolic links to do that.
You can move your database to the desired path (external drive) and
create a symbolic link in /var/lib/mysql/ to it like:
localhost:/var/lib/mysql# ln -s /desired_path/Protein Protei
Can somebody confirm this please?
Martin
Subject: UPDATE over 3 tables crashes in InnoDB
Description:
I have 3 InnoDB-tables with about 6000 records each:
customer 1:n orders 1:n invoices
When trying to make the following update:
update customer, orders, invoice
It would appear that MySql does table locking. Then I would like to ask
the
following:
> From what I've read,
> it would seem that SELECTS get a lower priority than INSERTS and UPDATES,
> meaning that if all 30 users
> insert into that table at the same time (given the way the stress test is
>
È«ÃæÖ§³ÖJSP/ASP/PHP/ASP.NETÆóÒµ½¨Õ¾¿Õ¼ä³ÏÑû´úÀí.
ÎÒ˾ÍƳöÆóÒµ½¨Õ¾×¨Óÿռ䣬ȫÃæÖ§³ÖJSP¡¢ASP¡¢PHP¡¢ASP.NET£¬ÏÖÕýÃæÏòÈ«¹ú¸÷µØ³ÏÑû´úÀí£¬ÀûÈó¿É´ï40%£¡
* ÉêÇëʱ´´ÍøÂçµÄ´úÀí£¬³ýÁË¿ÉÒÔÏíÊÜÈ«·½Î»µÄ»¥ÁªÍø²úÆ··þÎñ£¬»¹¿ÉÒÔÃâ·Ñ»ñµÃÓòÃû¡¢¿Õ¼ä¡¢ÖÇÄܽ¨Õ¾¡¢¶¯Ì¬IPµÈµÄÔÚÏß×¢²á´úÂ룬·½±ãÄú¼°Ê±¿ªÕ¹ÒµÎñ¡£
* Ì
On Mon, Feb 17, 2003 at 11:22:27AM +0200, Rob wrote:
> Thanks
>
> It would appear that MySql does table locking. Then I would like to
> ask the following:
Hi Rob,
I think that you missed some important details.
Taken from the manual:
"MySQL only supports table locking for ISAM/MyISAM
Thanks
It would appear that MySql does table locking. Then I would like to ask the
following:
We have a documents table in our Document Management System, which obviously
gets used quite a
lot :-). We're running stress tests on our application (which is a PHP,
Apache, MySql combo)
and we're fin
> Can I just check, does MySql v.3.23.52 do table locking or row locking?
If
> it only does table locking, are there any versions of mysql that do row
> locking?
Always Read The Fine Manual:
>From http://www.mysql.com/doc/en/Locking_methods.html:
"Currently MySQL only supports table locking fo
On Mon, Feb 17, 2003 at 11:00:37AM +0200, Rob wrote:
> Hi all,
>
> Can I just check, does MySql v.3.23.52 do table locking or row locking? If
> it only does table locking, are there any versions of mysql that do row
> locking?
Detailed in the fine manual:
http://www.mysql.com/search/index.ph
Hi all,
Can I just check, does MySql v.3.23.52 do table locking or row locking? If
it only does table locking, are there any versions of mysql that do row
locking?
Thanks
---
Rob
**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business Inn
Hi all,
Can I just check, does MySql v.3.23.52 do table locking or row locking? If
it only does table locking, are there any versions of mysql that do row
locking?
Thanks
---
Rob
**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business Inn
Hi!
On Feb 17, Brandon Young wrote:
> Hello, all. I have been staring at this problem for an entire day.
> Googling turns up very little in the way of helpful information for
> solving my problem.
>
> I started a new tutorial, and ran into a problem. When I attempt to add
> a new database, I
Hi!
On Feb 16, david wrote:
>
> Hi
>
> I have one table with 12 million records. I'm trying to create an index
> on one of the fields and it's taking hours ( over 6 so far)! Am I doing
> something wrong?
>
> The command I issued was
> create index title on article ( title);
>
> The table
The tables I am querying the most are quite small. I just query them a lot.
The system processes about 500k requests a day, and each request involves
multiple queries.
I have just enabled a bunch of logging to try and puzzle out what is going
on, but I can't see it being a help.. The same queries
Hi!
On Feb 16, Dan Nelson wrote:
> In the last episode (Feb 16), Michael T. Babcock said:
> > > At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote:
> > > > Well, MySql stores all its index information in one index file,
> > > > so when you add another index it has to rebuild the WHOLE file.
> > > > :
On Mon, Feb 17, 2003 at 01:37:59AM -0600, Jason Maskell wrote:
> Perhaps the subject will get someone to actually read this and offer even
> one reply with a suggestion?
I admit that the topic got my attention - perhaps not in the best way
though.
I can offer a few suggestions:
Provide m
81 matches
Mail list logo
