Yes, it is connecting to the same server each time, it is very strange. I have tried moving the entire database to a different server, and I seem to encounter the same problem as well. It is almost as if the tables themselves have an issue which is causing the problem.....
-----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 11:49 PM To: Chris Stark; [EMAIL PROTECTED] Subject: Re: Disappearing of New Inserts to MyISAM table At 23:05 -0500 3/14/02, Chris Stark wrote: >Hi Everyone, > >I am in kind of a jam, and I could use some help. Hopefully someone out >there has encountered something similar to this. I have a MySQL database, >and I am using Java to make the connection to the database. At one point in >the execution of my app, I need to issue an ALTER TABLE command to add a >column to one of my tables. The command issues successfully, however, if I >login to the Server itself, and issue a DESCRIBE TABLE command, the newly >added column is not among the list of columns. When I use WINMYSQLADMIN to >monitor the database, it to shows the addition of the new column. Only when >I login to the server itself does the column not show. It is strange because >the command issues flawlessly, and I get no SQL or Java Errors...I have >checked my permissions on the tables, as well as on the server itself, and I >have full rights to do anything I please on the database. Please help me >out with any advice you may have on this issue, anything would be a huge >help. Bizarre. Perhaps this is a silly question, but are you sure you're actually connecting to the same server each time? > >Thanks, >Chris --------------------------------------------------------------------- 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
