.
Then I don't know what to say about the MyISAM error, though I'd
watch InnoDB pretty carefully as I think MyISAM is pretty robust on
OS X too. We did also see these when a disk is failing, but I assume
you've run disk utility. I guess it could be failing and not showing
up in disk utility
On Jul 23, 2005, at 12:49 PM, Ware Adams wrote:
Then I don't know what to say about the MyISAM error, though I'd
watch InnoDB pretty carefully as I think MyISAM is pretty robust on
OS X too. We did also see these when a disk is failing, but I
assume you've run disk utility. I guess
So I've been poking around my system and I found
/usr/lib/mysql/
/usr/share/mysql/
The mod dates on these are really old. Can I delete these safely?
I'm guessing the are from the Apple install.
These files seem to be in the /usr/local/mysql/ path also. Hmmm... I
looked at my old Mac OS
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
[EMAIL PROTECTED] wrote:
Michael, here are some snippets from the error log that look relevant,
from three times I tried to start:
050719 20:29:41 mysqld started
050719 20:29:46 [Warning] Setting lower_case_table_names=2 because file
system for /usr/local/mysql/data/ is case insensitive
Hi all,
After deleting and reinstalling mysql on my Powebook G4 12, it
starts and then quits immediate. I had
to reinstall because my users seemed to not be working on.
These are the steps I am taking after reinstalling and the errors I get:
cd /usr/local/mysql
sudo echo
sudo
[EMAIL PROTECTED] wrote:
Hi all,
After deleting and reinstalling mysql on my Powebook G4 12, it starts
and then quits immediate. I had
to reinstall because my users seemed to not be working on.
These are the steps I am taking after reinstalling and the errors I get:
cd /usr/local/mysql
Michael, here are some snippets from the error log that look
relevant, from three times I tried to start:
050719 20:29:41 mysqld started
050719 20:29:46 [Warning] Setting lower_case_table_names=2 because
file system for /usr/local/mysql/data/ is case insensitive
050719 20:29:58 InnoDB:
I am running into repeatable table corruption with MySQL 4.x on Mac
OS X 10.x.
I previously had a MySQL install on 10.2 Client under 3.x and never
had an issue or any major problems at all. I upgraded to MySQL 4.x
and have subsequently installed MySQL 4.x (from the supplied pkg's)
on my
I had someone on the mac-osx server admin list point this out to me:
http://docs.info.apple.com/article.html?artnum=107852#sql
which is regarding a byte-ordering issue resolved in an upgrade from
OS X 10.3.2 to 10.3.3. Now in my case I could have upgraded with out
performing this procedure
Dan Tappin [EMAIL PROTECTED] wrote on 07/06/2005 11:26:13 AM:
I am running into repeatable table corruption with MySQL 4.x on Mac
OS X 10.x.
I previously had a MySQL install on 10.2 Client under 3.x and never
had an issue or any major problems at all. I upgraded to MySQL 4.x
and have
On Jul 6, 2005, at 10:26 AM, [EMAIL PROTECTED] wrote:
I'm not a Mac guru but what you describe sounds like file system
corruption. Can you do a diagnostic scan of your hard drives
looking for bad sectors? You can move your data to another portion
of the disk if you run an ALTER TABLE to
Michael,
You are very correct - I renamed those fields and boom
- it started working like magic, thank you so much.
I have another question - the database in question
that got crashed had mysql root password but the guys
I took over from forgot the password and didn't do any
mysql dump. So, I
Alla-amin wrote:
Michael,
You are very correct - I renamed those fields and boom
- it started working like magic, thank you so much.
I have another question - the database in question
that got crashed had mysql root password but the guys
I took over from forgot the password and didn't do any
So far this was what I did,
Took all files i.e frm, MYI and MYD files from the new
server. Created a database like on another box running
the version of mysql the old server was running and
pasted them in the data folder of the database I
created and viola - they all showed up, so i think it
was
Alla-amin wrote:
So far this was what I did,
Took all files i.e frm, MYI and MYD files from the new
server. Created a database like on another box running
the version of mysql the old server was running and
pasted them in the data folder of the database I
created and viola - they all showed up,
I have to ask, are you using the same version of MySQL? I think 10.1
came with v3 and 10.3 come with v4.0.
You may need to setup 10.1.5 on an old machine to dump the database for
importing.
On Jun 23, 2005, at 4:53 PM, Alla-amin wrote:
Hi everyone,
I just subscribed to the list and some
Yes, 10.1.5 runs mysqk version 3, it was actually
running 3.23.51 and 10.3 runs 4.0.14 I think. Ok - the
database in question have been backedup with files
such as
table1.frm.gz
table1.MYD.gz
table1.MYI.gz
and so on.gz
When I create a new database on the new server and
copy these files to the the
Alla-amin wrote:
Yes, 10.1.5 runs mysqk version 3, it was actually
running 3.23.51 and 10.3 runs 4.0.14 I think. Ok - the
database in question have been backedup with files
such as
table1.frm.gz
table1.MYD.gz
table1.MYI.gz
and so on.gz
When I create a new database on the new server and
copy
You can't transfer database files directly between versions. The file
format is different. You need to dump the data to a text file and
import it.
This isn't like FileMaker, Word or Excel where it will realize it's an
older version and convert it.
On Jun 24, 2005, at 9:42 AM, Alla-amin
Hello.
What is in MySQL error log? Did you use InnoDB tables?
Alla-amin [EMAIL PROTECTED] wrote:
Hi everyone,
I just subscribed to the list and some of the articles
are very helpful. I'm facing some problem on my mysql
database server.
One of our Raid drives crashed and
Hi everyone,
I just subscribed to the list and some of the articles
are very helpful. I'm facing some problem on my mysql
database server.
One of our Raid drives crashed and we had to backup
the whole data to another drive (only files), we did
no mysqldump. Now I want to restore a certain
So I am attempting a 5.0 upgrade from 4.1 on one of our OS X servers...
When attempting to launch mysqld it quits, with this error (showing
two from the log files, happens with our build or the MySQL binary):
050617 14:03:46 mysqld started
/usr/local/mysql-standard-5.0.7-beta-osx10.3
Dear all,
I have a MySQL 4.0.23 server running on an OpenBSD machine. When I try
to connect to it with MySQL Administrator 1.0.21 from my Mac OS X
machine, I get this error:
Connection error
Could not connect to MySQL instance at hostname.
Error: unknown system variable 'sql_mode' (code 1193)
I
Just feedback to the MySQL team...
Query Browser will not launch on OS X 10.3.7
Here is console log output...
console.log
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query
Browser can't open library: /usr/lib/libstdc++.6.dylib (No such file
or directory
2005/5/22, Dan [EMAIL PROTECTED]:
I just installed the 5.0.4 binary for OS X.
Where's the client?
Most likely in /usr/local/mysql/bin/. Just add that to your $PATH.
JP
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
I just installed the 5.0.4 binary for OS X.
Where's the client? It's not in my PATH. Surely I don't have to now
download the source and compile the client myself?
Dan
BEGIN-ANTISPAM-VOTING-LINKS
--
If you are not the CanIt administrator
Hi! Can anyone help me with a 64 Bit OS X 10.4 binary? I've tried to compile
it myself but get errors in the make process that I have no idea what to
do with.
Apple ships a MySQL 4.1.10a binary with Tiger, but it's not 64 bit. MySQL
doesn't have a 64 Bit OS X 10.4 binary yet.
Maybe my question
We have a large OS X MySQL deployment on multiple servers and we have
experienced a range of weirdness with table corruption that I was never able
to fully determine the cause for.
Moving to G5 Xserves (from G5 Towers and G4 Xserves) has seen all the
problems go away as if a switch were thrown. I
to be configured... Let's look at those... What version of OS X are you
working on? Mine is running on 10.3.8, has been running on the previous
versions of 10.3 also. The major difference I see is the test on if to start
or not... This will be important. You have:
if [ ${MYSQL:=-YES-} = -YES
is caused by Apple using different strings both
internally and externally: 'uname -sr' yields Darwin 7.8.0 whereas
customers call it Mac OS X 10.3.
I fear such events will happen again as long as internal ('uname -a')
and external (customer / marketing use) names are different:
We use 'uname
Greetings,
I have successfully configured mysqld_multi to have mysql 4.1.11 and
5.0.3 beta running on the same machine:
# mysqld_multi start
# exit
% mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld4 is running
MySQL server from group: mysqld5 is running
%
However, I
Greetings,
Is there a problem with MySQL 4.1.11 and 5.0.3 on Mac OS X 10.3? The
10.3 versions on the download pages are still at 4.1.10a and 5.0.2.
Thanks,
Jan Pieter Kunst
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
I haven't used Maestro, but I like SQL Grinder. It gives you a
reasonable GUI.
www.advenio.com/sqlgrinder
The WebObjects EOF package has better Entity modelling, but you have to
buy it! : }
--s
On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote:
I am looking for a nice OS X GUI client, can
Vic Cekvenich schrieb:
I am looking for a nice OS X GUI client, can be java for osx that works
w/ mysql 5.x.
(these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but
I want a bit more, like Maestro for OS X).
AFAIK is the stuff from Navicat available for OS X.
Regards
Franks wrote:
I haven't used Maestro, but I like SQL Grinder. It gives you a
reasonable GUI.
www.advenio.com/sqlgrinder
The WebObjects EOF package has better Entity modelling, but you have
to buy it! : }
--s
On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote:
I am looking for a nice OS X GUI client
If you are looking for a GUI admin, MySQL has released a beta of MySQL
Administrator for OSX. MySQL Query Browser is not available on OSX yet.
Not sure which you may be looking for.
On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote:
I am looking for a nice OS X GUI client, can be java for osx
Query Browser is not available on OSX
yet. Not sure which you may be looking for.
On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote:
I am looking for a nice OS X GUI client, can be java for osx that
works w/ mysql 5.x.
(these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work,
but I want
Jeff Justice wrote:
Yes, there is a MySQL beta version of the administrator, but be warned,
it has many bugs that I personally believe makes it unusable.
I would have to agree. I just tried it out and within a few seconds had
it crash on me. Hopefully they'll get it fixed up.
--
== Eric Gorr
Hi Jan Pieter!
Am Do, den 07.04.2005 schrieb Jan Pieter Kunst um 9:03:
Greetings,
Is there a problem with MySQL 4.1.11 and 5.0.3 on Mac OS X 10.3? The
10.3 versions on the download pages are still at 4.1.10a and 5.0.2.
The problem is with the HTML generation, as the binaries for MySQL
I am looking for a nice OS X GUI client, can be java for osx that works
w/ mysql 5.x.
(these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but
I want a bit more, like Maestro for OS X).
what should I use?
tia,
.V
--
MySQL General Mailing List
For list archives: http
I am looking for a nice OS X GUI client, can be java for osx that works
w/ mysql 5.x.
(these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but
I want a bit more, like Maestro for OS X).
what should I use?
tia,
.V
--
MySQL General Mailing List
For list archives: http
I have been running into issues with MySQL table corruption issues on a
couple of OS X systems. I end up with tables that need repair every
day and some times multiples times per day. It's so bad now that I
have a script that runs the mysql 'REPAIR TABLE...' command and then
the myisamck
I've been running on OS X for a while, although I haven't had any
really heavy usage sites. I also haven't had a single corruption
problem on a live database in the 2+ years I've been running MySQL.
Now, I say on a live database. For the first time I tried upgrading the
MySQL that comes
Ave,
I run MySQL 4.x on my Power Mac G5 with Mac OS X 10.3.8 with PHP5. I have
been running Apache Web Server and my websites on this machine for almost 6
months now. And twice I have faced table corruption which I had to fix using
REPAIR TABLE. Twice in 6 months isn't bad at all, yet, I wonder
Hello,
We have been running MySQL (about 50 databases, some medium-sized,
some small, mix of MyISAM and InnoDB) on Mac OS X Client for more than
a year (currently 10.3.8 with MySQL 4.1.10) and I have never seen any
corrupt tables. We use only the MySQL-provided packages for our
binaries.
Maybe
Does anyone know where I can find in-depth, precise instructions to
install MySQL on Mac OS X Panther client?
- Asad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in-depth, precise instructions to
install MySQL on Mac OS X Panther client?
- Asad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search Advisory
Does anyone know where I can find in-depth, precise instructions to
install MySQL on Mac OS X Panther client?
- Asad
Just get the binary for OSX and follow the readme its simple.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hi Brent, thanks for your comments! An unbiased outside pov always helps!
On Thu, 6 Jan 2005 14:32:16 -0500, Brent Baisley [EMAIL PROTECTED] wrote:
While part of the problem may be OS X, Apple is still optimizing parts
of the OS, I would say the problem is that you are comparing
!
scott
On Thu, 06 Jan 2005 17:45:52 -0800, Bruce Dembecki [EMAIL PROTECTED] wrote:
Hi Scott! We use MySQL on 9 Mac OS X machines. While we are looking at
moving some of that back to big Sun boxes, that's a memory access/64 bit
issue, not (directly) a performance issue.
Looking at the live
Hello,
I'm interested to hear peoples' experiences running mysql on OS X.
I've moved the database for a fairly heaily used website (~ 2M queries
a day) over to a new dual 2GHz XServe running OS X Server 10.3.7.
This database has run smoothly on an aging dual PIII machine running
freebsd
While part of the problem may be OS X, Apple is still optimizing parts
of the OS, I would say the problem is that you are comparing it to an
aging PIII. Some people have gotten better performance from a PIII than
a P4. The reason is cache. The PIII has a larger cache, MySQL loves
cache. The G5
Hi Scott! We use MySQL on 9 Mac OS X machines. While we are looking at
moving some of that back to big Sun boxes, that's a memory access/64 bit
issue, not (directly) a performance issue.
Looking at the live stats one of the machines has an uptime of 55 days and
has averaged 405.78 queries per
Hi List,
I installed the MySQL 4.1.7 on my Windows XP and for that I have used the
my.ini to set the startup configuration for using a different language and
to use the old_password.
Now I am installing on my Mac and I am wondering if there is any my.ini
or my.cnf on Mac OS X.
Does anyone knows
Mac OS X is Unix, so you follow the directions for Unix, which means you use
my.cnf. See the manual for details
http://dev.mysql.com/doc/mysql/en/Option_files.html.
Michael
Andre Matos wrote:
Hi List,
I installed the MySQL 4.1.7 on my Windows XP and for that I have used the
my.ini to set
On 11/29/04 1:55 PM, Michael Stassen [EMAIL PROTECTED] wrote:
Mac OS X is Unix, so you follow the directions for Unix, which means you use
my.cnf. See the manual for details
http://dev.mysql.com/doc/mysql/en/Option_files.html.
Michael
Andre Matos wrote:
Hi List,
I installed the MySQL
is suppose to do the job?
You create it according to the configuration you want.
Thanks.
Andre
On 11/29/04 1:55 PM, Michael Stassen [EMAIL PROTECTED] wrote:
Mac OS X is Unix, so you follow the directions for Unix, which means you use
my.cnf. See the manual for details
http://dev.mysql.com/doc/mysql
below and I couldn't find the file my.cnf as described
on the like that you gave me:
/etc/my.cnf
DATADIR/my.cnf
~/.my.cnf
Do I need to create it or MySQL is suppose to do the job?
Thanks.
Andre
On 11/29/04 1:55 PM, Michael Stassen [EMAIL PROTECTED] wrote:
Mac OS X is Unix, so you follow
--enable-thread-safe-client \
--enable-local-infile --enable-shared
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!
Michael Stassen wrote:
MySQL does not come in pieces for Mac OS X. The whole thing comes in
one Mac OS X binary package in PKG format
That's right, it's a precompiled binary. If you want a different
configuration, you have to download the source and build your own
http://dev.mysql.com/downloads/. I haven't tried --enable-shared on Mac
OS X, so I can't promise it will work, but I'm not aware of any reason it
wouldn't
OK using the source and adding '--enable-shared' to the configure line
works on OS X. I then had to create 3 links in order for our app to find
the client library:
ln -s /usr/local/mysql/lib/mysql/libmysqlclient.12.0.0.dylib
/usr/lib/libmysqlclient.12.0.0.dylib
ln -s /usr/lib/libmysqlclient
Where is there an OS X equivalent of:
MySQL-client-VERSION.i386.rpm
The standard MySQL client programs. You probably always want to install
this package. which is referred to here:
http://dev.mysql.com/doc/mysql/en/Linux-RPM.html
Specifically, I am looking for libmysqlclient.so.12 since you
MySQL does not come in pieces for Mac OS X. The whole thing comes in one
Mac OS X binary package in PKG format, downloaded as a disk image (.dmg)
file http://dev.mysql.com/doc/mysql/en/Mac_OS_X_installation.html. The
installer puts everything in /usr/local/mysql-VERSION, with a symbolic link
I have some queries that return around 75,000 rows, and I've been trying
to figure out how to speed them up a little. In the course of looking for
the bottleneck, I discovered that simply getting a large result was
considerably slower on OS X.
I tested on a number of machines, with MySQL versions
Michael Winston [EMAIL PROTECTED] wrote:
Okay, so the first thing to try is obviously enlarge the
max_connections.
Have you tried this?
Yes. It's set to 400 (a number we will never reach unless there's some
sort of logjam). max_connect_errors is set to 200.
Is it a webserver backend
At 10:57 -0700 8/16/04, John Mistler wrote:
I have written an application for MAC OS X.3 that interfaces with MySQL
through the Client/Server approach. I would like to simplify the
installation process of the application by using the embedded MySQL server
instead. However, I am having trouble
Michael Winston [EMAIL PROTECTED] wrote:
Okay, so the first thing to try is obviously enlarge the max_connections.
Have you tried this?
Is it a webserver backend database?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
On Sep 2, 2004, at 6:04 AM, Egor Egorov wrote:
Michael Winston [EMAIL PROTECTED] wrote:
Okay, so the first thing to try is obviously enlarge the
max_connections.
Have you tried this?
Yes. It's set to 400 (a number we will never reach unless there's some
sort of logjam). max_connect_errors is
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server). Every
once in a while we wake up to find the too many connections error
coming up. There really aren't too many connections (we have our max
set to 99
(os x)
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server). Every
once in a while we wake up to find the too many connections error
coming up. There really aren't too many connections (we have our max
set
Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server). Every
once in a while we wake up to find the too many connections error
coming up. There really aren't too many connections (we
for the past
several versions of mysql 4.0 running on OS X (both client and
server). Every once in a while we wake up to find the too many
connections error coming up. There really aren't too many
connections (we have our max set to 99) - it's the type of message
that appears when a wrong password
On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote:
Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server).
Every once in a while we wake up to find the too many connections
error coming up
Michael Winston said:
On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote:
Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server).
Every once in a while we wake up to find the too many
Michael Winston wrote:
On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote:
Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server).
Every once in a while we wake up to find the too many
Not if the host that is blocked is `localhost`.
-Original Message-
From: Michael Winston
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 9/1/04 11:24 AM
Subject: Re: bad too many connections error (os x)
This would make sense since they all the connections are coming from
the same
or Host blocked because of many connection
erros? If it is the later you have reached max_connect_errors and need
to
issue flush-hosts.
-Original Message-
From: Michael Winston
To: [EMAIL PROTECTED]
Sent: 9/1/04 11:02 AM
Subject: bad too many connections error (os x)
Hi-
We've been running
PROTECTED] - Directly to my notebook
Alex Greg wrote:
Michael Winston wrote:
On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote:
Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past
several versions of mysql 4.0 running on OS X (both client and
server). Every once
I've installed mysql-max-4.1.3-beta-apple-darwin7.4.0-powerpc to my PowerBook
and have executed the MySQLStartupItem.pkg. The /Library/StartupItems/MySQLCOM
exists and the /etc/hostconfig file includes the string MYSQLCOM=-YES-.
However, the only way I can get MySQL to start after boot up is to
I have written an application for MAC OS X.3 that interfaces with MySQL
through the Client/Server approach. I would like to simplify the
installation process of the application by using the embedded MySQL server
instead. However, I am having trouble figuring out how to:
1. Include the MySQL
I now have mysql running on my Mac OS X 10.3.4 box.
The socket file is now being created correctly in my
/usr/local/mysql/run directory.
Thank you for all your help.
Regards,
Ron Phelps
--- Ron Phelps [EMAIL PROTECTED] wrote:
1. I re-examined the error messages in config.log. I
couldn't
this far.
Ron
--- Ron Phelps [EMAIL PROTECTED] wrote:
I executed the following preparation work:
1. Upgraded Mac OS X 10.3.1 to 10.3.4
2. Installed two additional security updates
3. Examined the status of the Xcode packages
pre-installed on the box Documentation states it is
Xcode 1.0
I executed the following preparation work:
1. Upgraded Mac OS X 10.3.1 to 10.3.4
2. Installed two additional security updates
3. Examined the status of the Xcode packages
pre-installed on the box Documentation states it is
Xcode 1.0 for Mac OS 10.3 Panther
4. I ran all installers except, CHUD
Environment:
OS: Mac OS X 10.3.1, client
mysql: 4.0.20
compiler: gcc version 3.3 20030304 (Apple Computer,
Inc. build 1495)
Symptom:
Small section of configure log showing first errors
shown below. There is a lot more of this, too much to
post here. I've chopped the beginning and the end. I'm
First, I should point out that the simplest course would be to download the
precompiled binary from mysql. That said, I admit I like to build from
source, largely because whenever things go wrong, I always learn something.
On first glance, I see a few problems:
1) You are running OS X 10.3.1
I am trying to figure out the best innodb paramaters in the my.cnf
file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with
2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am
running on default params.
Does anyone out there have a suggested innodb parameters
Kieran Kelleher wrote:
Does anyone out there have a suggested innodb parameters or even a
working set of params that I could start with.
The InnoDB manual gives good suggestion. Some minor comments (none
particularly OS X specific, but InnoDB works fine on it)
innodb_buffer_pool_size is very
: InnoDB my.cnf settings on OS X 10.3 Server?
I am trying to figure out the best innodb paramaters in the my.cnf
file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with
2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am
running on default params.
Does anyone out
I'm attempting to follow instructions at the MySQL AB site:
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
...in order to reset a lost root password. I am using the Complete MySQL
package from Server Logistics (www.serverlogistics.com) for Mac OS X
Panther.
I've read
I've heard some recent rumblings that MySQL before 4.1 wasn't
multithreaded on OS X. However, in actual usage I see every
indication that is IS.
Does anyone have a definitive answer either way? Thanks!
- John
--
---
John
I am having the same problem that someone else posted about back in
December and I didn't see any responses for:
http://lists.mysql.com/mysql/156346
Specifically, I am trying to link with libmysqld.a on Mac OS X and am
getting 16 undefined link errors such as fixsfdi, floatdisf, udivdi3,
moddi3
This was New 4.1.2 Startup Trouble. The new title seemed more
appropriate given my testing.
Having installation problems with 4.1.2 on OS X 10.3.4.
From previous thread:
I've installed mysql 3 4 a dozen times or more, but I'm having
trouble with 4.1.2 on OS X Server (10.3.4).
Maybe it's
On Jun 1, 2004, at 5:04 PM, Greg Willits wrote:
So,
- G4/OS X Server: 4.0.20 installs fine, but 4.2.1 does not on 10.3.4
- G3/OS X Standard: 4.2.1 installs fine on 10.3.2, but after 10.3.4
Standard was installed, 4.2.1 did not work, yet 4.0.20 continues to
install fine
The fact that 4.0.20
Hi,
I've just downloaded the latest version of MySQL (4.0.20) for OS X.
They seem to have omitted the installer - there's no .dmg file to
download. The manual only covers installing from the .dmg for OS X.
Can anyone help me on how to install without the installer.
best regards
On May 23, 2004, at 3:30 PM, Chris Curnow wrote:
I've just downloaded the latest version of MySQL (4.0.20) for OS X.
They seem to have omitted the installer - there's no .dmg file to
download. The manual only covers installing from the .dmg for OS X.
I think you must have just missed it. There's
At 08:30 +1000 on 05/24/2004, Chris Curnow wrote about Installing on
OS X without installer:
Hi,
I've just downloaded the latest version of MySQL (4.0.20) for OS X.
They seem to have omitted the installer - there's no .dmg file to
download. The manual only covers installing from the .dmg for OS
I start MySQL and it seems to start the server normally
TrentCioran:/usr/local/mysql TrentCioran$ sudo ./bin/mysqld_safe
Starting mysqld daemon with databases from /usr/local/mysql/data
040512 21:27:05 mysqld ended
but when i try to open the mysql console it sends me the message:
to start and then died.
It seems like lots of people starting mysqld on OS X for the first time
have a permission error on the data directory. It should be owned by
mysql (the user already exists in both 10.2 and 10.3) and the group
should be mysql.
This problem is error number 13, but other error
iH
doesn't look as tho mysqld is running
-- mysqld ended
did you install the standard database files?
what about the permissions? can mysqld read those files
check the error log in the data directory
- hcir
On May 12, 2004, at 6:53 PM, Jose Manuel Islas Romero wrote:
I start MySQL and it
101 - 200 of 643 matches
Mail list logo