Corrupted Table (?)

All, I have a table which was accessible for the last couple years but is now inaccessible after performing a simple alter table command. There are approx. 10 tables in this database on which the same alter table command was given (alter table table_name add glperiod varchar (3) null

Re: Can't stop mysql

I'm having the same problem. At 12:27 PM 11/12/2001 -0500, [EMAIL PROTECTED] wrote: Howdy, I'm running version 3.23.41 on RH7.2. For the life of me I can't figure out why I can't stop mysqld. Linuxconf was where I first noticed this where mysqld would not respond to the stop request. I then

Storing the mysql data in a different location

Hello everyone!! I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and want the datadir to be /data/mysql/data. In my /etc/my.cnf file I have the directive: [mysqld] datadir=/data/mysql/data The installation completes but the daemon won't start. I do the mysql_install_db

Re: Storing the mysql data in a different location

Thanks Gerald!! That did the trick and everything seems to be running perfectly! At 01:59 PM 8/30/2001 -0500, Gerald Clark wrote: Unfortunately, when you moved the directories, you forgot to make mysql the owner of the new directory. chown -R mysql /data/mysql Philip Daggett wrote: Hello

Problems getting into MySQL.com

Is anybody else not able to get onto mysql.com??? - Before 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

Restoring mysql database from backup and logging

When restoring a backup, the binlog will record all of the backup's commands (create tables and insert into's). Would it therefore be a good idea to flush the logs before a restore and then flush the logs immediately after so that the restoration log can be deleted (or ignored)?

MySQL: my.cnf in Windows 2000

Anybody: I've installed (and got working!) MySQL on my Windows 2000 pc and am trying to use the my.cnf file. 1) The manual says that my.cnf is included in the installation and that I should copy it to c:\my.cnf. (Copy the file `\mysql\my-x.cnf' to `C:\my.cnf' and edit it to suit your

Re: Turning off logging for certain download queries

At 03:01 PM 7/9/2001 -0700, you wrote: On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote: We do a few large daily and monthly downloads from an Oracle database server. Is there a way to exclude these specific queries from the update/binary log?? If the queries only affect

Re: Turning off logging for certain download queries

Jeremy, I did test it and couldn't get it to work one way or the otherHowever, as it turns out, the '--binlog-ignore-db' option will work for me. Thanks for all your help!! Phil At 11:03 AM 7/10/2001 -0700, you wrote: On Tue, Jul 10, 2001 at 09:20:35AM -0700, Philip Daggett wrote

Turning off logging for certain download queries

We do a few large daily and monthly downloads from an Oracle database server. Is there a way to exclude these specific queries from the update/binary log?? - Before posting, please check: http://www.mysql.com/manual.php

Update phone inner join tmpphone....

I tried this query: Update phone inner join tmpphone on phone.empno = tmpphone.empno set phone.lname = tmpphone.lname, phone.fname = tmpphone.fname and it didn't work. This works in MSAccess. Is this syntax (or something like it) supported by MySQL??

Update phone inner join tmpphone....

I tried this query: Update phone inner join tmpphone on phone.empno = tmpphone.empno set phone.lname = tmpphone.lname, phone.fname = tmpphone.fname and it didn't work. This does work in MSSqlServer 7. Is this syntax (or something like it) supported by MySQL??