We have just launched http://www.freecomputerjobs.com
www.freecomputerjobs.com , a website where nationwide IT and computer
employers can post their jobs at no cost. Please take a minute to visit us,
create an account, and check back while the site continues to grow. Thanks.
--
View this messa
Jim Winstead wrote:
> On Thu, Jul 20, 2006 at 08:41:23AM +1200, Frank wrote:
>> Dear all,
>>
>> is it a desired feature that the embedded version of the client library
>> still tries to create a network connection when I pass a hostname into
>> connect?
>
> Yes, the embedded version also acts as
Andre,
Yes, I sort of bypassed the problem by installing
XAMPP. Works like a charm now.
Thanks.
Kay
At 03:32 PM 7/19/2006 Wednesday, Andre Matos wrote:
Hello Kay,
Have you solved the issue or you are still not ablle running MySQL and PHP
on Windows XP?
Which version are you running for PH
Our MySQL-based medical application has been running fine for 3 years.
Last week, mysqld-nt started jumping up to 100% CPU and staying there
until someone restarts the service. mysqlcheck found no errors in the
database. I dumped it to disk and read it back in to create a fresh copy
of the database
Hello,
If you have not already done so, you may also try the MySQL forum for UDFs
at:
http://forums.mysql.com/list.php?118
Thanks,
Jimmy Guerrero
Sr Product Manager
MySQL, Inc
> -Original Message-
> From: Yong Lee [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 19, 2006 6:10 PM
> T
Hi all,
I hope I have hit the right group for this question.
I would like to create a UDF that is configurable at run time. Similar to
how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF
to make use of configuration parameters that can be set at run time.
I'm w
Hi all,
I hope I have hit the right group for this question.
I would like to create a UDF that is configurable at run time. Similar to
how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF
to make use of configuration parameters that can be set at run time.
I'm w
In the last episode (Jul 19), Cheng-Lin Yang said:
> I'd like to know if it's possbile to make MySQL auth the account
> through system account via NIS? I want the user in my system who can
> automatically have their own mysql account by using the same password
> on the system. Please kindly help me
I'm far from an expert on the subject, but judging by a quick Google
search for 'NIS mysql backend', people have been able to do this via
OpenLDAP. I just thought I'd send you a starting point.
On 7/19/06, Cheng-Lin Yang <[EMAIL PROTECTED]> wrote:
Hi all,
I'd like to know if it's possbile to ma
On Thu, Jul 20, 2006 at 08:41:23AM +1200, Frank wrote:
> Dear all,
>
> is it a desired feature that the embedded version of the client library
> still tries to create a network connection when I pass a hostname into
> connect?
Yes, the embedded version also acts as a standard MySQL client.
> Is
Dear all,
is it a desired feature that the embedded version of the client library
still tries to create a network connection when I pass a hostname into
connect?
Is it possible to influence this behaviour, so that the API just ignores
settings like the hostname and the port and always connects t
On Wednesday 19 July 2006 01:07 pm, Jesse wrote:
> `ID` int(10) unsigned NOT NULL auto_increment,
> `CTID` int(11) NOT NULL,
the storage types aren't the same. change CTID to INT(10) UNSIGNED NOT NULL
and it should work.
--
Chris White
PHP Programmer/DBank
Interfuel
--
MySQL General Mail
There was a thread before about this... this is much better than connector
J's load balancing.
You can take machines out of production, add thhem back in, it's MySQL slave
aware, etc
On 7/19/06, Christopher G. Stach II <[EMAIL PROTECTED]> wrote:
Kevin Burton wrote:
> Hey Gang.
>
> I wanted to
Not sure there's a good way to do that ... here's one possible solution:
create a little extra table like so:
create table mytemptable
(mytemptable_id int not null auto_increment primary key,
table_id int,
key table_id_idx (table_id));
then insert your values for your IN clause into 'mytemptabl
Sure. Here is the information on both tables:
DROP TABLE IF EXISTS `karate`.`custtournaments`;
CREATE TABLE `karate`.`custtournaments` (
`ID` int(10) unsigned NOT NULL auto_increment,
`CustID` int(10) unsigned NOT NULL default '0',
`TournamentName` varchar(45) NOT NULL default '',
`Tourname
This is my ugly solution:
SELECT
MAX(IF(articles_attribs.attrib_key='content', articles_attribs.
attrib_value, '')) AS content,
MAX(IF(articles_attribs.attrib_key='description', articles_attribs.
attrib_value, '')) AS description,
MAX(IF(articles_attribs.attrib_key='keyword', articles_attribs.
at
I hate responding to my self on a list, but I don't think I outlined the
problem clearly enough:
The article table data looks like this:
select * from articles;
+++
| id | active |
+++
| 1 | 1 |
+++
and the articles_attributes table looks like this:
s
Çäðàâñòâóéòå, Fauzan.
Âû ïèñàëè 18 èþëÿ 2006 ã., 10:41:25:
FA> Hi All,
FA> I've tried to upgrade mysql from MySQL 4.1.12 to MySQL 5.0.22.
FA> Before upgrading, I have like below :
FA> # rpm -qa | grep mysql
FA> mysql-4.1.12-3.RHEL4.1
FA> mysql-server-4.1.12-3.RHEL4.1
FA> mysqlclient10-3.23.58-4
I have a sql query like SELECT * FROM table WHERE id IN (4,88,23);
Result order in ID is: 4,23,88
But I need to receive result in order 4,88,23. So how can I manage to receive
result in order LIKE IN() clause?
regards, okan
Dan Buettner wrote:
Dan T -
Well, if all your data files are MyISAM, then I only see one potential
problem, and that is the area of user permissions. I believe that
things in that area have changed around enough that if you simply
re-use those tables as-is (as-are?), you may have some difficult
On Wednesday 19 July 2006 10:25 am, Jesse wrote:
> MySQL Error Number 1005
> Can't create table '.\karate\#sql-304_9.frm' (errno: 150)
KEY `FK_custpoints_1` (`CTID`)
REFERENCES `custtournaments` (`ID`)
can you show us the column declarations for these two?
> Any idea why this is happening, and
Is it possible you're in the wrong database (different from
'custtournaments') when you issue this command?
No. I've tried in SQL Browser, EMS SQL Manager, and MySQL Command line,
making sure in each case that I have the karate database selected. I have
also re-typed it in MySQL Command line
Hi there,
I am trying to work through a DB design that is giving me some trouble with the
result sets. The situation is this:
I have a table called "articles" and a related table call "article_attributes" Within the table
"articles" I am maintaining basic info about an article, such as arti
Jesse, a stab in the dark here, with some info from the manual.
A foreign key constraint is in My Code erroneously coded,
If MySQL gives the error number 1005 from a CREATE TABLE
statement, and the error message string refers to errno 150, then
the table creation failed because a foreign key cons
I'm using MySQL 5 with InnoDB tables. I'm trying to create a foreign key,
but when I try, it's giving me an error. I've tried this with the
MySQLQuery Browser, and EMS SQL Manager 2005. I get the following error in
the Query Browser:
Error while executing query.
ALTER TABLE `karate`.`custp
You might possibly be able to set up a trigger on the log tables to
discard entries for all but those databases/tables you are interested
in ...
Just a thought.
Dan
On 7/19/06, David Felio <[EMAIL PROTECTED]> wrote:
Thanks. I could also get the same result with the existing query log
using gr
Thanks. I could also get the same result with the existing query log
using grep, but retrieving a little data from a large batch isn't the
issue. The issue is the overhead of logging ever single query to the
server when I only need a handful of tables. I know we can log
everything and retri
Kevin Burton wrote:
> Hey Gang.
>
> I wanted to get this out on the list and facilitate some feedback.
>
> http://www.feedblog.org/2006/07/announce_lbpool.html
>
What does this have over MySQL Connector/J's load balancing?
--
Christopher G. Stach II
--
MySQL General Mailing List
For list ar
Through judicious use of SQL you could easily get the log entries for
a specific table ... I haven't got 5.1.6 to check but if the log table
included database and table name columns, you're set.
select query_text from mysql.general_log where database_name = 'mydb'
and table_name = 'mytable' order
Right, sorry, this is 5.0.x (5.0.18 at the moment). Thanks for the
pointer on 5.1.6, though that looks like it has the ability to log to
a table instead of a file, not log access to a specific table.
David
On Jul 18, 2006, at 9:23 PM, Chris wrote:
David Felio wrote:
Is it possible to have
Hi all,
I'd like to know if it's possbile to make MySQL auth the account
through system account via NIS? I want the user in my system
who can automatically have their own mysql account by using
the same password on the system. Please kindly help me on this
problem. Thank you in advanced! :)
Regard
Tripp,
ibdata files never shrink. You can try this to free up space:
* Take a mysqldump of all tables that you may need,
* delete the ibdata files,
* Rebuild your tables by importing the dump.
Using innodb_file_per_table, will freed the disk space whenever you
run optimize table or del
Hi there,
I am trying to install/configure the Mysql Ver. 5.0.22-standard on a
SUN-Solaris 2.10 (SPARC) machine.
After having installed the SUN-package, I run the script "mysql_install_db"
using the following command (beeng connected as user 'mysql'):
NMS:mysql@ /opt/mysql/mysql/scripts/mysql
Best group member,
I have a problem. I was going to use FULL TEXT search for my Thai client. It
is working smooth with English text and wordings, the indexing and search
works fine.
The problem with Thai text is that words are not separated with a white
space as in English and other languag
On Tuesday, 18 July 2006 at 10:57:24 +0530, Kaushal Shriyan wrote:
> Hi ALL
>
> I would like to know following 2 things.
>
> 1) if i would like to take mysql incremental backup weekly
>
> cp /var/lib/mysql/ /backup/mysqlbak/
Others have already explained why this won't work. None of them have
add
35 matches
Mail list logo
