Re: shadow tables?

2001-08-27 Thread Michael Widenius
Pukinskis schrieb am Mittwoch, 22. August 2001, 22:48:26: I've made some progress figuring out my case issue. It seems that somehow I'm ending up with shadow tables. I discovered this after I ran an ALTER command. My db has 4 tables: mysql show tables\g

Re: shadow tables?

2001-08-23 Thread Werner Stürenburg
figuring out my case issue. It seems that somehow I'm ending up with shadow tables. I discovered this after I ran an ALTER command. My db has 4 tables: mysql show tables\g +-+ | Tables_in_hbperfrev | +-+ | employee| | perfassessment

Re: shadow tables?

2001-08-23 Thread Alex Pukinskis
on 8/23/01 12:35 AM, Werner Stürenburg wrote: Is it an option to drop the table and recreate and repopulate it? I would give it a try and think that your problem will be gone. You can easily do that with mysqldump. Ask again if you need more help. Hi, Werner: I tried this, and it didn't

shadow tables?

2001-08-22 Thread Alex Pukinskis
I've made some progress figuring out my case issue. It seems that somehow I'm ending up with shadow tables. I discovered this after I ran an ALTER command. My db has 4 tables: mysql show tables\g +-+ | Tables_in_hbperfrev | +-+ | employee