My /etc/my.cnf does not have this option? Is this something I can add?
What is the correct syntax?
Best regards,
Michael
Dominik Klein <[EMAIL PROTECTED]>
03/15/2006 09:33 AM
Please respond to
[EMAIL PROTECTED]
To
mysql@lists.mysql.com
cc
Subject
Re: How to build a client?
> I get
I have mysql-max-5.0.19-solaris10-sparc-64bit installed and running fine.
I have at times used the OLD PASSWORD ro resolve some issues but during my
build of php-5.1.2, no luck.
Here is the last part of the config.log with the errors.
"config.log" 639 lines, 31250 characters
ld: warning: file /
I get various errors from my php based applications and php building that
all refer to the need to upgrade my mysqlclient. I have not found
instructions on where to get the client software to build or upgrade a
client.
This system is a Solaris 10 SPARC system.
Best regards,
Michael
The info
word to get
>
> in.
>
> > Thanks
> >
> > Running on Win2k Advance Server.
>
> You could try following the installation instructions in the manual
> http://dev.mysql.com/doc/refman/4.1/en/windows-installation.html
>
> Shawn Green
> Database Administrato
issue on the server?
>
> I think it's a system configuration issue on the XP machine. I believe the
> XP firewall is getting in your way.
>
> > Btw, I can run the same java program from other machine in Solaris
>
> system
>
> > to connect the database as the user 'root'. Does this imply that it's
> > administration issue?
>
> Network administration, not MySQL administration (yet).
>
> > Thanks for your kind help and patience.
> >
> > Xiaobo
>
> My pleasure!
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
>
--
Sean Peters
Senior Programmer, WIREData Inc.
[EMAIL PROTECTED]
"The software required Windows 2000 or better, so i Downloaded Linux"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
of data. As it seems that
UUID's are becoming the preferred internal ids, are there any plans for UUID
column optimizations in MySQL?
--
Sean Peters
Senior Programmer, WIREData Inc.
[EMAIL PROTECTED]
"The software required Windows 2000 or better, so i Downloaded Linux"
--
MySQL
all tables for this system.
Should i be using BINARY() columns ?
Thanks much
--
Sean Peters
Senior Programmer, WIREData Inc.
[EMAIL PROTECTED]
"The software required Windows 2000 or better, so i Downloaded Linux"
--
MySQL General Mailing List
For list archives: http://lists.
behave this way.
Note: The application htat i need this for is driven by Perl with the DBI /
DBD::MySQL
Thanks much
--
Sean Peters
Senior Programmer, WIREData Inc.
[EMAIL PROTECTED]
"The software required Windows 2000 or better, so i Downloaded Linux"
--
MySQL General Mailing Lis
I suddenly have lost the ability to connect to the MySQL server from my
remote host and can not figure out what is wrong. I have searched for
the last couple of days and cannot figure out why.
I am running MySql 5.0.0 on Linux Suse 9.1
I normally connect to MySQL from Windows XP Pro using eit
the expression.
This is very easy in Perl, is there any way to do it in MySQL?
thanks much
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ch of things, but not the mysql_config
executable. I'm rather confused by this.
Perhaps i should go back to installing source distros.
Anybody seen anything like this?
thanks much
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
were
deleted?
without doing a 'Select count(*) FROM Child' before and after the delete?
Im writing a utility that sometimes deletes records, and we'd like to know how
many from each table, and i'd like to take advantage of the cascade on
delete.
thanks
sean peters
[EMAIL PR
e Active_Data table.
Neither idea seems very good to me.
Any suggestions?
thanks much
sean peters
[EMAIL PROTECTED]
mysql, query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2
Is this normal? I am running on Solaris 5.9
This is creating a serious problem for my upgrade. I have the drive space, but
i'll need to reconfigure the drives. I think that will work.
Im just pretty surprised.
any thoughts?
thanks
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailin
; DB is
on a separate physical drive from 'metadata'
Any thoughts?
need more info, let me know?
am i being too anal?
thanks much
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Im having some difficulty with the perl DBI/DBD in conjunction with a MySQL
upgrade. Here's the situation:
On the DB server machine, i have MySQL 4.1.3beta running for testing
upgrading, but MySQL 4.0.2 is also running (production).
I can connect locally on the DB server through various client
y server; consider upgrading MySQL client at connect_test.pl line
19
All the connect_test.pl tries to do is create a db connection to each server
separately.
Any insight would be greatly appreciated
thanks much
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archiv
ieve that my build
configuration took effect properly. Does any of this make sense?
Still completely lost.
thanks
sean peters
[EMAIL PROTECTED]
*** Here's some my.cnf data, if it really matters ***
Here is part of the /var/mysql-4.1.3/my.cnf file:
[client]
port= 3307
socket = /t
4.1.3/my.cnf file:
-rw-r--r-- 1 root other 2042 Aug 12 18:08 my.cnf
and the permissions & ownership are identical to that for /etc/my.cnf
I am at a loss
thanks much.
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
wholly reasonable. I'd
guess there are a myriad of similar little issues. Any thoughts on how to
minimize this problem.
Just wanted to bring this out.
thanks
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
peters wrote:
> Hi all,
> still building 4.1.3
> I am now getting an error in make test like this:
>
> ERROR: ... At line 136: Result length mismatch
> (the last lines may be the most important ones)
> Below are the diffs between actual
t'
---
> Grants for [EMAIL PROTECTED]
> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
This looks somewhat trivial, but i cant get beyond it to finish the test.
make does not understand the --force directive, so the advice in the error
wont work.
uction server
without disturbing the 4.0.2 that is already running.
Thanks again.
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
arate physical drives mounted in subdirectories
of [datadir], so each physical disk holds separate databases. There will also
be smaller DBs on the physical drive that [datadir] is on.
Am i understanding all of this correctly?
thanks much
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing
ld use the same
server.
So am i correct in thinking that i wont be able to use mysqld_multi for
running two different server versions? This shouldn't be a problem, I dont
think i'll need it. Just wanted to check if im missing something.
thanks
sean peters
[EMAIL PROTECTED]
--
MySQL
n server.
Most of what i've been reading about running multiple servers on the same box
has seemed a bit confusing.
thanks much
sean peters
[EMAIL PROTECTED]
On Monday 09 August 2004 12:51, you wrote:
> Global settings go in /etc/my.cnf. Server-specific settings go in that
> serv
hanks much
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
out having foreign key support for a
number of years, so this probably isnt that bad.
Anyone else run into similar issues?
Any thoughts?
thanks much
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
?
thanks
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
much
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a null, so i am looking for
general performance & maintenance concerns.
For certain columns i am completely sold on not using nulls, for others, i
cant see any conceptual reason to favor either way, so i thought i'd tap you
all for some insight.
Thanks much.
Sean Peters
[EMAIL PROTECTED]
-
o run statistics on, each having between
1.5 million and 25 million rows.
Any advice on how to best accomplish this would be great.
thanks much,
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
ated.
I swear that i've seen a solution to this somewhere, but for the life of me i
have not been able to find the answer (now that i need it)
Thanks much,
sean peters
[EMAIL PROTECTED]
filter fodder: mysql, query
--
MySQL General Mailing List
For list archives: http://lists.mysql
ss.
Im not sure what other info to provide, ask and i'll tell
thanks much,
sean peters
[EMAIL PROTECTED]
filter buster: mysql, query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
omecooked).
I'm not arguing that this behaviour is a bug, i am more interested in knowing
why this behaviour is the way that it is.
thanks much,
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
y users will raise a major stink if i
tell them that the date is the first, but it actually isn't, so the display
functionality for the system will check the date validity flag, and if
invalid, only display the month and year.
The flag field is there for exactly this purpose.
thanks
sea
malization, etc. but i haven't come
up with a better solution.
Also note that this is for a data warehouse, and myself and 1 other programmer
are the only people who manipulate the data.
thanks in advance
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: ht
nks much,
sean peters
[EMAIL PROTECTED]
BTW: i have posted a similar question to perlmonks under the title "DBI bind
params & column defaults"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
figure out if it is
wise to upgrade mysql yet.
thanks much,
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and C for each
record in A, but if not, this returns nothing.
So, short of querying each table, i cant come up with a good solution to my
problem.
If there were only 2 tables, a LEFT JOIN would work fine, but both B and C
want to be left joined to A, which i dont know how to do.
thanks
sean p
; SELECT A_data, B_data, C_data
> FROM A LEFT JOIN B ON A.A_ID = B.B_ID LEFT JOIN C ON A.A_ID = C.C_ID
> WHERE A.A_ID = 4;
>
> > -Original Message-
> > From: sean peters [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, October 01, 2003 12:07 PM
> > To
good solution to my
problem.
If there were only 2 tables, a LEFT JOIN would work fine, but both B and C
want to be left joined to A, which i dont know how to do.
thanks
sean peters
[EMAIL PROTECTED]
---
mysql, query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
Hi all,
i've been trying to follow the Innodb upgrade that will allow setting up
multiple separate blocks of disk for different databases, where the admin has
the ability to put databases in specific tablespaces.
There has been a bit of talk here, but whenever i go to the MySQL or Innodb
web si
Hi all,
A few weeks ago, someone mentioned that Innodb would soon have multiple
tablespaces available under MySQL. I saw that Innodb.com shows this on their
to do list. Is anyone aware of the status of this upgrade, or a site that
would have details regarding the upgrade?
thanks
--
MySQL Gen
Hi all, i've been weighing the pros and cons of running multiple concurrent
mysqld's on one server, to have better control over what databases are on
what physical disks.
System: 4 processor sun box running solaris with eighteen 36Gb drives.
The situation is that i have a bunch of databases on
omes, i'll surely upgrade so
our internal programs will run faster.
thanks much
On Wednesday 13 August 2003 17:04, you wrote:
> On Wed, Aug 13, 2003 at 04:07:24PM -0500, sean peters wrote:
> > Hi all, i've been weighing the pros and cons of running multiple
> > concurr
e, i've tried many syntax variations.
Could someone confirm my suspicions, or prove me wrong.
thanks,
sean peters
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
known (to others)
information, i should be able to gain that same understanding faster, and be
more productive.
So, if anyone could point me at such a book, or online tutorials, that would
be great.
Thanks much,
sean peters
[EMAIL PROTECTED]
Filter info: mysql, query
--
MySQL General Ma
Hi all, I've inadvertently ran across a weird issue with the text client. I
have found that if you press [SHIFT][ENTER] the program seg faults. This is
consistent behaviour as far as i know.
Im running redhat 9 and MySQL 4.0.12-max
Does anyone else see this behaviour?
thanks
--
MySQL Genera
If I do a query on a table which has a column of the 'text' type, I get the
following error: "Positioned request cannot be performed because result
set was generated by a join condition". This is on a simple select with a
join between two tables.
I'm using a wrapper class from codeproject.com to
Got it on a none server machine I had typed my chown without the /P at
the end.
Also used the package from entropy. I may have used it before.
John
On Thursday, July 11, 2002, at 08:43 AM, A. John Peters wrote:
> New error msg, I think I have permissions right
>
> 020711 08:37:5
New error msg, I think I have permissions right
020711 08:37:57 mysqld started
020711 8:37:57 /usr/libexec/mysqld: Can't create/write to file
'/usr/var/e-mac
.pid' (Errcode: 13)
020711 8:37:57 /usr/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno
: 13)
020711 8:37:57 /usr/libe
I have installed mysql on OS X server. I used the pkg install.
Everything appears to have run fine except when I do safe_mysqld the
daed starts and stops. See error log below.
Any ideas?
020701 19:46:50 mysqld started
020701 19:46:50 /Library/mySQL/libexec/mysqld: Table 'mysql.host'
doesn
>Description:
mysqlgui crash caused by infinite loop in
mysql_read_default_options because strcend
never returns 0
>How-To-Repeat:
>Fix:
--- libmysql/libmysql.c.origThu Feb 14 18:30:17 2002
+++ libmysql/libmysql.c Tue Mar 19 15:52:49 2002
@@ -712,7 +712,7 @@ s
I would like to offer my very deepet apologies.
This is what happened-
About a year ago or so (maybe longer) when NuSphere was new I tried their
product and did not want to use my regular e-mail address to register, so
I used my username@host e-mail address on my linux box.
In fact, it was a com
This e-mail address is brand new.
I used it to subscribe to the MySQL list.
I sent one e-mail to the MySQL list.
I used it to send two e-mails to my web hosting provider.
I used it to send one e-mail to [EMAIL PROTECTED]
That's it! No others yet.
I know my web hosting provider did not sell my e
to create the
split-manual myself (unless someone has a script to do it they are willing
to share)
Thanks,
Michael A. Peters
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
We developed a site using PHP and MYSQL on an online shared server. We used
HEAP tables extensively and everything worked fine. When we moved the site
to our dedicated server prior to launching the site, the queries that
should create the HEAP tables return syntax errors (when submitting the
q
We developed a site using PHP and MYSQL on an online shared server. We used
HEAP tables extensively and everything worked fine. When we moved the site
to our dedicated server prior to launching the site, the queries that
should create the HEAP tables return syntax errors (when submitting the
q
st this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Michael A. Peters
Abriasoft Senior Developer
http://www.abria
ike(mickalo)Blezien
> >
> > Thunder Rain Internet Publishing
> > Providing Internet Solutions that work!
> > http://www.thunder-rain.com
> > Tel: 1(225) 686-2002
> > ===
mail client that cannot send a message to
> the above address (Microsoft Outlook), you can use:
> http://lists.mysql.com/php/unsubscribe.php
>
>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Michael A. Peters
Abriasoft Senior Developer
http://www.abriasoft.com/
(510) 623-9726x357
Fax: (5
62 matches
Mail list logo
