To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bruce Martin
The Martin Solution
PO Box 644
Delaware Water Gap, PA
(570) 421-0670
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to include some libs with this client, but which libs and how can
I do that in xCode?
Thank you,
Bruce Martin
The Martin Solution
PO Box 644
Delaware Water Gap, PA
(570) 421-0670
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
=latin1;
update UserTBL set gid='25', usertype='Super Administrator11' where
username='ADmin';
update UserTBL set gid='25', usertype='Super Administrator11' where
username='admin';
'username' = 'admin' in the tabls...
thanks
-bruce
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list
You might try UNION with the 1st statement pulling all products with
groupid = 0 and the 2nd pulling 1 product with groupid 1.
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Monday, October 10, 2005 3:31 PM
To: MySQL List
Subject: [SPAM] - Query help - Bayesian
Hi All,
I'm bulkloading my instance and I'm getting a return message at the end
of the load like this:
mysql \. vm_load.txt
Query OK, 164 rows affected, 113 warnings (0.01 sec)
Records: 164 Duplicates: 0 Warnings: 113
When I load the data line by line, I get no warnings.
How can I see
Paul DuBois wrote:
At 10:11 -0700 10/8/05, Bruce Ferrell wrote:
Hi All,
I'm bulkloading my instance and I'm getting a return message at the
end of the load like this:
mysql \. vm_load.txt
Query OK, 164 rows affected, 113 warnings (0.01 sec)
Records: 164 Duplicates: 0 Warnings: 113
When
IF you are on 5.0.x you can use INFORMATION_SCHEMA
21.1.13. The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
http://dev.mysql.com/doc/mysql/en/key-column-usage-table.html
-Original Message-
From: Operator [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 05, 2005 3:02 PM
To:
.
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it back again at various system updates.
Best Regards, Bruce
On Sep 28, 2005, at 11:52 AM, Jim C. wrote:
I had the same problem with both of these:
mysql-standard-4.1.14-apple-darwin7.9.0-powerpc.dmg
and
mysql-standard-4.0.26-apple-darwin7.9.0-powerpc.dmg
They seem to install OK, but when I set
Try this
mysql select distinct secname, date
- from optresult
- where secname like 'swap%'
-and date like '2005-09-2%'
- order by if(secname like 'swap%',
- (mid(secname,5,20)+0),
- secname);
+--++
| secname | date
hi...
i've got a question/problem that i can't seem to figure out. it should be
simple/straightforward.
i'm creating a test tbl
id int
t1 timestamp
when i do a 'select * from tbl' i get what looks like a default date/time
format in the timestamp column.
i do a, (from mysql)
'insert into tbl
-bruce
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What am I missing
INSERT INTO table1 (column names.)
SELECT VALUES..
FROM table2
WHERE primary id = insert value
You will have to put in your real table name and column names.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23,
that for you on even the
simplest ALTER TABLE commands.
Best Regards, Bruce
On Sep 22, 2005, at 7:59 AM, Jeff wrote:
Hey all,
I've got a production database that made up of all MyISAM tables. I'd
like to change some of the more heavily written to tables to InnoDB to
take advantage of the record level
duplication of the
data directories.
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
' instead of the /.
this is in a php app, and i'd like to be as standard as possible in the
event i need to change dbs..
thanks
-bruce
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
from there rather than having to go back
to yesterdays backup or something.
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
there is some memory for MyISAM.
Final note.. MySQL needs the mysql database to exists and for the
tables it cares about to be MyISAM... these hold your user
permissions and so on... don't try converting this to InnoDB, that
would be bad.
Best Regards, Bruce
On Sep 15, 2005, at 2:31 AM, Scott Haneda
pointers/thoughts/etc...
searching google hasn't led to any solid solutions..
thanks
-bruce
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
' button that would generate/display the next 'N' items
in the list/query results...
if anybody could direct me to sample docs/code that kind of describes/solves
what i've described, i'd appreciate it!!!
thanks
-bruce
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http
more that can be done with specific memory settings and
so on... but I think I've given you a handful of things to get
started on, and you can come back for more when you have made some
headway on this part.
Best Regards, Bruce
On Sep 7, 2005, at 4:28 PM, Scott Haneda wrote:
Unless I am
of memory to get at,
also no problem.
And of course until it is worked out, stay within the limis of 32 bit
and you don't have a problem :-)
Best Regards, Bruce
On Sep 7, 2005, at 8:51 PM, Scott Haneda wrote:
on 9/7/05 8:42 PM, Bruce Dembecki at [EMAIL PROTECTED] wrote:
Yeah, 64 bit isn't
- there is so much to performance than this
one piece of the puzzle, and there are plenty of solutions which
don't mean throwing out your hardware).
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
contacts to get each of them trying to find the problem... but (being
the open minded people we are) we'll also take a look at Yellow Dog
and see what's involved in getting Linux up and making a 64 bit MySQL
Binary to run under Yellow Dog.
Best Regards, Bruce
On Sep 7, 2005, at 4:23 PM
of memory, it's not an issue to start with.
Best Regards, Bruce
On Sep 7, 2005, at 4:23 PM, Scott Haneda wrote:
on 9/7/05 2:40 PM, Bruce Dembecki at [EMAIL PROTECTED] wrote:
We're happy with our Mac based MySQL servers in many respects. We've
got some 64 bit issues that are causing
are trying to use.
Best Regards, Bruce
On Sep 2, 2005, at 7:17 AM, eddie wrote:
Hello kind sirs,
I have a DL380 G4 box, Dual Xeon 3.0Ghz with 6GB of DDR2 Ram,
I'm Linux CentOS 4 with a 2.6.12.5 vanilla kernel, and a remote
storage which I access via iSCSI (linux-iscsi-4.0.2 complied as a
module
If you have the 5.0.x version of MySQL then INFROMATION SCHEMA can give
you what you want. i.e.
SELECT a.*, b.*
FROM INFORMATION_SCHEMA.COLUMNS AS a
INNER JOIN _SCHEMA.COLUMNS AS b
ON (a.column_name = b.column_name)
WHERE a.TABLE_NAME = 'foo_1'
AND b.TABLE_NAME =
It's getting late on Friday, but couldn't you build a table with all of
the parameter combinations and then just join against that table?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 4:25 PM
To: mysql@lists.mysql.com
Subject: Union vs
I think you misunderstand how auto_increment works. Primary keys using
auto_increment are NOT row numbers.
If your table has a primary key that is an auto_increment field then
when you add a row to the table the value of the primary key of the new
row is 1 greater than the max(Value) before the
it is character based. Allowing a full
conversion of data from 4.0 to 4.1 if managed correctly.
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is your downtime is minimal but the
problem is at the end of the day you are still left with your shared
innodb table space, and even though it may be mostly empty, you can't
clean it up and make it smaller.
Best Regards, Bruce
On Aug 23, 2005, at 6:19 AM, Rafal Kedziorski wrote:
Hi,
we have
Do You know about INTERVAL?
Use it in an exprecssion or funtion as
..INTERVAL expr type
where expr is any numerical value
* The INTERVAL keyword and the type specifier are not case
sensitive.
The following table shows how the type
If you want to have all values except the primary key be the same and
say your is foo_ID
You can simply do
INSERT INTO foo
(foo_ID... {rest of columns list})
SELECT new primary key value,
{rest of columns list}
FROM foo
WHERE foo_ID = {primary key value of row you want to copy}
If
You can use INTERVAL i.e.
Lets say you have a table
mysql CREATE TABLE foo (bar int(14), fdate date );
Query OK, 0 rows affected (0.27 sec)
mysql INSERT INTO foo
VALUES (1, now()),
(25,now() - INTERVAL 1 DAY),
(15,now() - INTERVAL 2 DAY);
mysql SELECT f1.bar
Regards, Bruce
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Gary Huntress [mailto:[EMAIL PROTECTED]
Sent: Monday, 15 August 2005 9
that you're not likely to get much of a
response.
Best Regards, Bruce
On Aug 15, 2005, at 7:59 AM, James Sherwood wrote:
I am still having trouble with french characters if anyone has ANY
ideas, please help.
We have installed the newest version of MySql and cannot get it to
play nice
)... be sure to use the new mysql
client and mysqlimport to insert the data into the new version,
making sure to use an appropriate --default-character-set setting
each time you call it.
Best Regards, Bruce
On Aug 12, 2005, at 4:24 AM, James Sherwood wrote:
Hello,
We have installed
If you are on a version prior to 4.1.2 the max index size is 500 bytes
{not sure why the error mentions 1024}
From section 14.1 of documention
The maximum key length is 1000 bytes (500 before MySQL 4.1.2). This can
be changed by recompiling. For the case of a key longer than 250 bytes,
a larger
Multi Table UPDATES are first supported in 4.0.x
-Original Message-
From: Brendan Gogarty [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 09, 2005 12:16 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: JOIN QUERY - UPDATE ... help?!
Brendan Gogarty [EMAIL PROTECTED]
We have a relatively small web site running 4.0.20 on a Dell 2850
running RedHat.
We rarely see any SQL statements visible when we run SHOW PROCESSLIST
and typically use 30 - 40 concurrent connections.
The Number of SQL Queries graph in MySQL Administrator usually is in the
0 to 10 range
This is out of the MySQL class and is called the Max-Concat trick.
What is the biggest country in each continent?
The Rows Holding the Group-wise Maximum of a Certain Field
MySQL Select Continent,
-
Something like this
SELECT CompanyName,
WhatToShip,
SUM(IF(TrackingNumber = '',
IF(SerialNumber = '',
1,
0),
0)
) AS READY,
SUM(IF(TrackingNumber '',
IF(SerialNumber = '',
enrique...
i wasn't looking for away around the behavior... i was simply posting this
as a potential bug.
my version of mySQL (1.4.12) gives me the error that i described.. i'd be
willing to bet other versions act in a similar manner...
-bruce
-Original Message-
From: Enrique Sanchez
that the word 'system' is inside a
comment, it should be ignored!!!
if you place aomething in front of the 'system' in the comment.. it gets
ignored...!!!
hope this clarifies what i stated earlier...
-bruce
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 31, 2005
' is in the comments. when i remove it, the
error/msg goes away...
any thoughts/comments/etc...
thanks
bruce
[EMAIL PROTECTED]
-- MySQL dump 10.9
--
-- Host: localhostDatabase: spyder
-- --
-- Server version 4.1.12-standard
away...
any thoughts/comments/etc...
thanks
bruce
[EMAIL PROTECTED]
-- MySQL dump 10.9
--
-- Host: localhostDatabase: spyder
-- --
-- Server version 4.1.12-standard
/*
mysqldump --no-data --tables -uroot -p dbname colleges_schema.sql
You *COULD* include the information in the my.cnf file under the
[client] area, something like this:
[client]
user=bruce
password=brucesPassword
That would tell the client to use that unless something else is
disabled.
Of course that needs to be saved in plain text in a plain text file
there. At least that's how it's supposed
to work :-)
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. the main problem
here is that once the file reached the OS limit InnoDB thought the
table was full(which technically it was)... so Innodb's autoextending
files don't know how to launch a second file once the File system's
upper limit has been reached.
Best Regards, Bruce
--
MySQL General
isn't important.
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this exact same thing with another server... times don't
change much here, so it doesn;t seem to be specific to this one machine.
This is all on Mac OS X 10.4.2
Best Regards, Bruce
[data-admin:/var/mysql] root# tail -f mysql.err
050722 13:51:08 mysqld started
InnoDB: The first specified data file
solutions.. but the
production server/admin server setup works great regardless of what
your database engine is... if you have a server you can do it on :-)
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
to innodb_file_per_table.
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
enable the bin log in mysql. It doesn't log transactions i.e. what it
was, what it became, but the update will be logged
prathima rao wrote:
hi,
how to create a log file of the updates done on the data in visual basic or
in mysql for a particular record
for example
i have a purchase order
Here is one way.
Some time ago I set up a table named count with one field named count
and built 5000 rows of incrementing values .
I think I originally populated it by originally createing it with a 2nd
field
CREATE TABLE `count` (
`count` int(10) unsigned NOT NULL auto_increment,
A database in MySQL is simply a directory.
So just rename the directory with appropriate tool for your platform.
On my test box this becomes
mysql show databases;
++
| Database
|
++
| information_schema |
|
lois
|
| mailprint |
|
... and our setup wasn't as clean as
yours sounds to be.
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 7/15/05, Bruce Dembecki [EMAIL PROTECTED] wrote:
This process has worked for us taking our latin1 4.0 databases and
turning them into utf8 4.1 databases. UTF8 data we had already
put in
our 4.0 database despite it's latin1 encoding was correctly exported
out of 4.0 and correctly
).
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 7/15/05, Bruce Dembecki [EMAIL PROTECTED] wrote:
This process has worked for us taking our latin1 4.0 databases and
turning them into utf8 4.1 databases. UTF8 data we had already
put in
our 4.0 database despite it's latin1 encoding was correctly exported
out of 4.0 and correctly
been a little helpful :-)
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
two copies of the data live protecting us from
hardware failure. Something like what you describe may or may not be
worth doing for us.
Best Regards, Bruce
Here's a simplified version of our scripts (simplified because our
admin server has multiple instances of mysql it manages):
Crontab
(and not my dept):
#!/bin/sh
#
echo `date` `/usr/local/mysql/bin/mysql -e SHOW SLAVE STATUS\G |
grep Seconds_Behind_Master `
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
by.. well... let's just say it's painful. Took me some
time to figure out why it wasn't accepting my new usernames - very
unpleasant.
Best Regards, Bruce
On Wed, Jul 06, 2005 at 03:46:02PM -0700, Tim Traver wrote:
Is there any reason why I shouldn't increase the size of the
allowable
user
select count(distinct ordr_ID) from store
-Original Message-
From: Gana [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 07, 2005 3:01 PM
To: mysql@lists.mysql.com
Subject: Count(*)
select count(*) from store group by orederId.
For the above sql, I am not getting the count of unique
by a
college_ID, that's unique and assigned to each college, and maintained in a
master_collegeTBL...
thoughts/comments/etc
i'm leaning towards the side that keeps each college information separate,
although this means that i essentially have to deal with 1000s of
tables/files...
-bruce
[EMAIL
even though this might mean i get a table with 5 million records??? as
opposed to say a 1000 different tables, each with 50,000 records?
-bruce
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 07, 2005 5:34 PM
To: [EMAIL PROTECTED]; mysql
a 'temp' master collegeTBL that contains all the information,
and this table is comprised of the smaller separate collegeTBLS, and i could
simply make any changes to the smaller tbls, and rebuild the master table
from time to time...
hmmm
-bruce
-Original Message-
From: Devananda
If you really need more than 20 digits of accuracy and can move to 5.0.3
+
you can use the Decimal data type without losing precision.
This is out of Chapter 23. Precision Math
The maximum value of 64 for M means that calculations on DECIMAL values
are accurate up to 64 digits. This limit of
of life, let's talk!!
but with the right combination of web development skills
(perl/php/c/apache/linux/mysql/html/css) we can do some damage. there are
numerous opportunities for the right 3-5 person team!
regards,
bruce
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http
When I have seen this error it was caused by a field defined in the
MySQL database as NOT NULL in the Create table and the value in Access
is NULL or usually for us an empty field in EXCEL which is appears to be
intreped as NULL when you do a PASTE APPEND.
Ours is often times a datetime field
If you are runing binary log and do a
FLUSH LOGS
mysqldump --opt --skip-lock-tables MyISAM table names
FLUSH LOGS
mysqldump --opt --single-transaction INNODB table names
You have a recoverable state with the combination of the mysqldump file
and the binary log file that was started by the 1st
RTFMs with links.
Gordon Bruce wrote:
If you are runing binary log and do a
FLUSH LOGS
mysqldump --opt --skip-lock-tables MyISAM table names
FLUSH LOGS
mysqldump --opt --single-transaction INNODB table names
You have a recoverable state with the combination of the mysqldump
file
anywhere in /usr/local/mysql-any-version
Any idea how I can get MySQL 5.0 to launch here would be greatly
appreciated :-)
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If you have c values in the table currently you can just do an
ALTER TABLE tablename CHANGE columnname columnname ENUM('a','b','c','x')
DEFAULT a NOT NULL
then
UPDATE tablename SET columname = 'x' WHERE columname = 'c'
Then
ALTER TABLE tablename CHANGE columnname columnname
only a int(11) as unique key and the enum field..
suposing now i have enum(a, b) only, and did a ALTER TABLE
tablename CHANGE columnname columnname ENUM('a','b','c');
thanks,
Gabriel
2005/6/16, Gordon Bruce [EMAIL PROTECTED]:
If you have c values in the table currently you can just do
In some hierarchies I have seen people put the the current id in the
parent_ID Field {basicaly pointing to them self} to represent the top of
the hierarchy.
I don't know how much this would affect the rest of your application but
it would get rid of the null's
-Original Message-
From:
It always helpd me to change MySQL's user to connection in my head
when I begin to think about access control. Then in most database
designs that I have seen, row access control is just as important as
database/table/column. Then the question becomes does the user have
direct access to the
see how to remove the primary key fom username...
thanks
-bruce
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows and they
both seem to look fine {see the SHOW CREATE TABLE's following the CREATE
TABLE statements}
RUN ON 4.0.20
mysql CREATE TABLE ID (
- mat INT UNIQUE PRIMARY KEY,
- ID_firstname CHAR(35) DEFAULT 'filler',
-
If you are on 5.0.n there is an INFORMATION_SCHEMA which you can query
like this. A casual scan of the mysql tables don't show any sizes and I
don't know of a way to get table/database size via SQL.
mysql select table_schema, sum(DATA_LENGTH) from
information_schema.tables group by 1;
You can have any number of timestamp columns, but only one of them can
be set to autoupdate. As of 4.1 you are not limited to this being the
1st one in the table and CURRENT_TIMESTAMP, CURRENT_TIMESTAMP(), or
NOW() can be used in the DEFAULT. Read
You can try
if($queryID = mysql_query(SELECT *
FROM WhInventory
WHERE Booking like ('%15%')
ORDER BY Booking,$dbLink))
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June
,
and where they'd be located? if i knew the files, i could do a search to
find where they're located.
--
./configure --with-apxs2=/usr/sbin/apxs --with-mysql=/usr/bin/mysql_config
--
thanks
-bruce
[EMAIL PROTECTED]
--
MySQL General
hi..
is there a way to run system commands from inside mysql if i'm using
mysql3.23 (linux). in mysql-4, i simply do a 'system'...
this doesn't work in 3.23...
thanks
bruce
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
-passwords to allow my perl/php
apps to communicate with the mysql4.1 db
i can now do the 'show slave status' and access the db from perl...
this seems to have allowed me to get past this hurdle...
-bruce
-Original Message-
From: Kristen G. Thorson [mailto:[EMAIL PROTECTED]
Sent: Wednesday
--with-raid --without-bench
--with-mysql=/usr/local/mysql
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
give me pointers/shed light on what i might need to change. my
gut tells me that there's some mysql table/attribute that needs to be
changed, but i'm not that familiar with mysql...
thanks
bruce
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
to do to resolve this issue!!
i would imagine that this is a function of access/privs but i'm not sure
what has to be set.
thoughts/comments/ideas/etc...
thanks
bruce
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
bruce
Sent: Tuesday
scripts, even if
Apple overwrites your symlinks, you'll still be calling your binaries).
Still, you should get in the habit of checking the files in /usr/bin/my*
each time you install a System update in case Apple has updated versions.
Best Regards, Bruce
--
MySQL General Mailing List
For list
socket
file that is configured in the my.cnf file for each instance.
Hope that helps.
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PROTECTED]
Sent: Tuesday, March 29, 2005 8:40 PM
To: mysql@lists.mysql.com
Subject: Re: upgrading mysql on RH fedora core 3
On Tue, 29 Mar 2005 19:28:56 -0800, bruce [EMAIL PROTECTED] wrote:
we're trying to install mysql/mysql-server (4.1.10a-1.i386) and are
running
into some serious problems. we
the /usr/local/bin dir, and
somehow 'point' the system to the '/usr/bin' dir for the mysql files?
it seems my environment path has both '/usr/local/bin' and '/usr/bin'. also,
how do i change the environment path??
thanks
bruce
-Original Message-
From: Tom Crimmins [mailto:[EMAIL PROTECTED
directions/pointers on what you did, where you
placed the resulting libs/etc...
also, this has to be running with apache/php/perl/etc...
thanks
bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
with no luck. i've lloked through google/mysql
with no luck...
any ideas as to what might be causing the problems... if i can get the
daemon started, i'll (hopefully) be ok...
thanks
bruce
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Looks like it made it through to here
David Smithson wrote:
I have sent a couple of emails to the list, but I don't know if they
are posting or not, because I haven't received them back from the
list, which I assumed I would. Can someone just confirm that this
message is indeed being posted?
--
file exists and
is blank or doesn't include enough information, delete it. If it's there and
looks right, include it's contents in your next mail here (you can blank out
the username/password info).
Best Regards, Bruce
Tierney Thurban [EMAIL PROTECTED] wrote:
Hi all. Sorry if you get this twice
Hannes Rohde [EMAIL PROTECTED] wrote:
innodb_data_file_path=ibdata1:2G:autoextend
innodb_buffer_pool_size=1200M
innodb_additional_mem_pool_size=20M
May not solve the replication issue, but if this is a 4GByte server that is
dedicated to MySQL (ie you aren't using memory for anything
201 - 300 of 586 matches
Mail list logo