Crash on Windows XP SP2 when not run as an administrator

2004-08-31 Thread Todd O'Bryan
I've tested mysql in my high school lab running from an administrator and from a student account, both from within the Cygwin terminal, and at the Windows command prompt. From the administrator account, it runs fine for hours. From the student account, it promptly (within 15 seconds or so) cras

Cygwin and High School Lab

2004-08-31 Thread Todd O'Bryan
A couple of people have wondered why I'm using Cygwin with MySQL and seem to think I'm trying to use the Linux version of MySQL on Windows. I've installed the latest Windows version of MySQL. I'm using Cygwin as the launcher rather than the Windows command prompt, mostly because it's easier for

Problem running MySQL in high school lab

2004-08-30 Thread Todd O'Bryan
I'm trying to teach my students how to use MySQL, and have installed it on all the lab machines along with Cygwin. Originally, I had the permissions set wrong and my students couldn't start the server, but I fixed that, and now mysqld& works fine. Unfortunately, if you then mysql -u root, after a r

Re: select help

2003-07-06 Thread Todd O'Bryan
I'm new, too, so someone correct me if I'm wrong, but... if you make it an ENUM field in a table you can store it using the value in the selection, retrieve it as the same value, and still get all the advantages of numeric storage. Todd On Sunday, July 6, 2003, at 02:38 PM, Dan Cox wrote: He

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

2003-07-02 Thread Todd O'Bryan
ocal/mysql/libexec/mysqld' stored in the system. Can we change this path somewhere in the parameter file? Thanks, song -Original Message- From: Todd O'Bryan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 6:56 PM To: Xu, Song PH/US/EXT Cc: [EMAIL PROTECTED] Subject: Re: The

Re: Can't start MySQL on Mac OS X

2003-07-02 Thread Todd O'Bryan
I figured out what happened, though I don't know when it happened... I had screwed up the permissions for the /tmp/ directory, so the mysql user could not create the socket it needed there. A well-placed chmod and things are back in working order. Thanks to all for the suggestions, Todd -- MySQ

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

2003-07-02 Thread Todd O'Bryan
Do what it says: cd /usr/local/mysql ./bin/mysqld_safe and see if that's any better. Todd On Wednesday, July 2, 2003, at 05:18 PM, [EMAIL PROTECTED] wrote: Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe & [1] 22717 $ The file /usr/local

OS X downloads

2003-07-02 Thread Todd O'Bryan
There are two sets of binary downloads at mysql.com for Mac OS X. They're different sizes, but both say OS 10.2. Is that a typo? Is one of the two for OS 10.1, and could I have downloaded the wrong one and could that be the reason I can't get mysql to start? Todd -- MySQL General Mailing List

Re: Can't start MySQL on Mac OS X

2003-07-02 Thread Todd O'Bryan
OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: "Todd O'Brya

Can't start MySQL on Mac OS X

2003-07-02 Thread Todd O'Bryan
Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I "cd /usr/local/" and "s

Re: cannot connect to mysql server

2003-04-05 Thread Todd O'Bryan
Try the following cd /usr/local/mysql ./bin/mysqld_safe and see if that starts up the server. If it doesn't, check to make sure you don't have a proxy set in your internet configurations. Todd On Saturday, April 5, 2003, at 12:00 PM, Peter Gumbrell wrote: I have installed mysql on Mac OS X.

Re: About JDBC

2003-04-05 Thread Todd O'Bryan
It should be enough to place the .jar file in the jre/lib/ext folder inside your Java installation folder. If you don't want to do that, you could modify your CLASSPATH environment variable to include wherever you decide to place the .jar. Todd On Saturday, April 5, 2003,

Re: JDBC can't connect, but command line can...

2003-04-03 Thread Todd O'Bryan
ly if you forget what all is involved in the switch. Color me stupid, Todd On Wednesday, April 2, 2003, at 10:56 AM, Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Todd O'Bryan wrote: | I've managed to get mysql up and running again (I don't know how) but | JDBC

Re: JDBC can't connect, but command line can...

2003-04-02 Thread Todd O'Bryan
ike it should tell somebody something. Any idea where to go next? Thanks! Todd On Wednesday, April 2, 2003, at 10:56 AM, Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Todd O'Bryan wrote: | I've managed to

JDBC can't connect, but command line can...

2003-04-02 Thread Todd O'Bryan
I've managed to get mysql up and running again (I don't know how) but JDBC won't connect to it. Here's my little simple code: import java.sql.*; import java.io.*; public class MySQLTester { public static void main(String[] args) th

Mac OS X package problems

2003-04-01 Thread Todd O'Bryan
In desperation I have restarted my machine a couple of times, and once I actually watched the start-up routine...this gave me a clue: In accord with the installation instructions, I used Marc Liyanages' startup item installer. Since then, I have removed the every vestige of my MySQL installation

Still Mac OS X problems (4.0.12)

2003-03-31 Thread Todd O'Bryan
OK. Everything was up and running thanks to what Lenz suggested earlier. I was even able to connect to the server using JDBC from the local machine. But then the Java connection, for no apparent reason, stopped working. Java apps would just stall without ever connecting, but I could still conn

OS X errors (using 4.0.12 package installer)

2003-03-30 Thread Todd O'Bryan
After removing every directory I could find related to MySQL, I used the OS X Package Installer to re-install MySQL. But I get the following error when I follow the instructions to start mysql (from the logfile): 030330 16:22:20 mysqld started 030330 16:22:21 InnoDB: Operating system error nu

Can't uninstall, reinstall, or otherwise get 4.0.12 to work on Mac OS X

2003-03-30 Thread Todd O'Bryan
I recently installed MySQL 4.0.12 on Mac OS X (using the package provided in the downloads section) and I must have corrupted something because I can't get the mysql command to work. I thought the easiest thing to do would be to uninstall the whole thing and start over, but I can't figure out h