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 first;). All of these tables are O.K. (and were correctly altered) except 1. What happens is that whenever I try to perform an SQL command against this table (called codeprojects), either MySQL hangs (at the command prompt) or my perl script hangs in the $sth-execute($sql) statement. Like I said, all of these methods, etc. worked on this table in the past and still work on the rest of the tables. I've tried, restarting MySQL (which seemed to work at first but now does not), dropping and rebuilding the table (it hangs on the drop command), copying a working copy of the three table files from a backup database, deleting the three files and starting over again. Nothing has worked so far. Any ideas?? OS: Redhat 7.1 Linux MySQL: 3.23.41 Thanks, Phil P.S. My team members are big fans of MySQL and are using it exclusively for our web systems. Keep up the GREAT work!! - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 tried to reboot the box and watched the shutdown process and noticed that mysqld failed the stop request. The only way to 'stop' mysqld is to use the 'killall mysqld' command. Any ideas on what could be wrong. If there is scripting changes, please give me very specific instructions. Thanks.. - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 command and the requisite tables are installed in my new data directory, the message states that it is starting with the data in the new directory, then the server stops and the error message from the error log is : /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) This file in fact exists in the new data directory as well as the /var/lib/mysql directory. Does anyone know how to do this correctly?? Thanks, Phil - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 command and the requisite tables are installed in my new data directory, the message states that it is starting with the data in the new directory, then the server stops and the error message from the error log is : /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) This file in fact exists in the new data directory as well as the /var/lib/mysql directory. Does anyone know how to do this correctly?? Thanks, Phil - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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)? - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 setup.) However I searched and searched for the suggested file and could not find it (or anything like it...); 2) I created my own c:\my.cnf based on the my.ini file but it didn't work (i.e. the commands I put in to my.cnf had no effect); 3) I then put the same options into my.ini and everything worked just fine. I'm wondering 1) if using my.ini is O.K.; and 2) am I doing something wrong? Thanks, Phil - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 one table or database, use the replication ignore options listed here: http://www.mysql.com/doc/R/e/Replication_Options.html Better yet, check this page: http://www.mysql.com/doc/R/e/Replication_SQL.html And look at SET SQL_LOG_BIN=0 Does this turn off logging for everything (all other connections) or only for the current connection?? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 23 days, processed 177,648,797 queries (87/sec. avg) - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: 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 one table or database, use the replication ignore options listed here: http://www.mysql.com/doc/R/e/Replication_Options.html Better yet, check this page: http://www.mysql.com/doc/R/e/Replication_SQL.html And look at SET SQL_LOG_BIN=0 Does this turn off logging for everything (all other connections) or only for the current connection?? Hmm. Good point. I hadn't thought about that. And the manual doesn't say one way or the other, so I assume it's a global setting. This might not be what you want aferall. But it would be useful to be able to do this on a per connection basis. Perhaps some testing is in order. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 24 days, processed 183,699,039 queries (87/sec. avg) - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 (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
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?? - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.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 does work in MSSqlServer 7. Is this syntax (or something like it) supported by MySQL?? - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php