Re: Primary key ID gets messed up after deleting/adding

2001-04-08 Thread John Jensen
[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php

Re: MyODBC for Windows ME

2001-03-01 Thread John Jensen
archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858

Re: Re: more Youch

2001-02-28 Thread John Jensen
ommunicate with the rest of the world. This option is also documented in the New Riders (Paul DuBois) MySQL book, which I have found very useful. Sean On Tue, 27 Feb 2001, John Jensen wrote: There must be a bug here somewhere. I have just made three attempts to reinstall mysql, one from rpm,

Re: Re: more Youch (thank you)

2001-02-28 Thread John Jensen
ean Conley On Wed, 28 Feb 2001, John Jensen wrote: BUG: Telling me I "shouldn't have done" something, not even mentioned in the manual, does not help me fix the problem. BUG: Having to completely reinstall the operating system (Linux) in order to repair problems with a mysql inst

Re: MySQL as spider database.

2001-02-27 Thread John Jensen
PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: more Youch

2001-02-27 Thread John Jensen
with the rest of the world. This option is also documented in the New Riders (Paul DuBois) MySQL book, which I have found very useful. Sean On Tue, 27 Feb 2001, John Jensen wrote: There must be a bug here somewhere. I have just made three attempts to reinstall mysql, one from rpm, two from

Re: MySql Install problems

2001-02-27 Thread John Jensen
this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before

Re: Help with Create Table

2001-02-27 Thread John Jensen
' not null auto_increment,primary key (MeetScoresId)); Query OK, 0 rows affected (0.08 sec) -- http://it97.dyn.dhs.org -- IrmundThum +49 179 6998564 +49 6374 992541 John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858

Re: Re: Re: Youch!

2001-02-27 Thread John Jensen
at /usr/sbin/mysqld? Is there anything else I need to know about before I start over? Do I need to start over? On 23 Feb 2001, at 14:02, John Jensen wrote: I do believe I have a mess on my hands. Lacking any other guidance, I tried upgrading my mysql to 3.23 with an rpm on a Redhat

Re: ORDER BY optimisation

2001-02-27 Thread John Jensen
://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: XML support under mySQL

2001-02-27 Thread John Jensen
[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php

Re: XML support under mySQL

2001-02-23 Thread John Jensen
] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Re: Youch!

2001-02-23 Thread John Jensen
/ -name "mysqld"' to attempt to find your binary. I always like to install stuff by source, cuz then I can always specify where things go :) RPM usually should work fine, but sometimes it can be tricky. Atle On Fri, 23 Feb 2001, John Jensen wrote: I do believe I have a mess o

Re: web based admin?

2001-02-22 Thread John Jensen
) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 66

Re: Youch!

2001-02-22 Thread John Jensen
rep mysqld' to find out ;) Did that. All that turned up was the ps call. Atle On Wed, 21 Feb 2001, John Jensen wrote: I had shut down the mysql daemon using: bin/mysql -u root -p[password] shutdown Now when I attempt to restart it using: bin/safe_mysql it gives me the message

Youch!

2001-02-22 Thread John Jensen
now I am left wondering: "Why is it trying to look in a non-existent direcory?" and "What went wrong?" Any ideas? John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, p

Re: error 35 with my.cnf

2001-02-21 Thread John Jensen
archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858

Re: web based admin?

2001-02-21 Thread John Jensen
to make ssh work. On 21 Feb 2001, at 18:18, Ed Carp wrote: John Jensen ([EMAIL PROTECTED]) writes: Do you have a remote server? Do you have a lot of data to enter into your database? Ask yourself: Would you rather preface each and every insert with "INSERT

mysqlimport puzzle

2001-02-20 Thread John Jensen
exist. Do I have to manually add those lines to transfer a dump file to a new machine? John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php (

mysqldump

2001-02-19 Thread John Jensen
. I am not finding the manual at all helpful to get around this problem. I have even tried telneting in as user "mysql", but that doesn't work either. Any ideas? John Jensen 520 Goshawk Court Bakersfield, CA 93309 66

Re: mysqldump

2001-02-19 Thread John Jensen
to find), or the instructions I am finding are seriously incomplete. What am I doing wrong? On 19 Feb 2001, at 11:39, John Jensen wrote: I have an existing mysql database I am trying to back up before upgrading to 3.23 from 3.22. Both the mysqldump and mysqladmin commands tell me I am accessing

Re: mysqldump

2001-02-19 Thread John Jensen
Thank you Fred, that helps On 19 Feb 2001, at 21:23, Fred van Engen wrote: On Mon, Feb 19, 2001 at 11:39:07AM -0800, John Jensen wrote: I have an existing mysql database I am trying to back up before upgrading to 3.23 from 3.22. Both the mysqldump and mysqladmin commands tell me I am

Re: Setting up Access 2000 to work using a mySQL db...

2001-02-16 Thread John Jensen
/lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: MyODBC Prompt on connect

2001-02-16 Thread John Jensen
) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 66

Re: myODBC question

2001-02-01 Thread John Jensen
, (Mr) Pekka Gaiser wrote: Hi there, A DB newbie question - can I use MS Access for remote mySQL databases using myODBC?? Thanks. John Jensen 520 Goshawk Court Bakersfield, CA 93309 - Before posting, please check: http

Re: RE:mySQL is winning

2001-02-01 Thread John Jensen
L PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

Re: ERROR 1170: BLOB column 'Url' used in key specification without a key length

2001-01-30 Thread John Jensen
hread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 - Before posting, please

Re: Very slow to connect

2001-01-29 Thread John Jensen
: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: Index text without Match/against

2001-01-28 Thread John Jensen
://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Search engine database structure

2001-01-26 Thread John Jensen
the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court B

Re: Error 2002: can't connect to mysql.sock

2001-01-26 Thread John Jensen
/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen Jensen's Directories www.college-without-classes.com

Re: OT - Cron

2001-01-25 Thread John Jensen
] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen Jensen's Directories www.college-without-classes.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: write problems via MS Access 97 in table with timestamp and primary key

2001-01-24 Thread John Jensen
re posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php J