Re[2]: [ADMIN] Multiple tables with same name

[������ �������]

Hi, Terry and others

> What is your system?
FreeBSD 2.2.8

> However, as "apache" owns both the real tables AND the dublicate tables,
> then it is not so simple in your case, for to destroy user apache would
> wipe out every thing.
The most interesting question - how it could happen.

So, how did I overcome this problem:
1. I tried to dump mydb - it failed on one of sequences
2. I made a copy of .../data/base/mydb directory
3. I destroyed mydb
4. Fortunately  I  always keep the SQL code which creates DB
structure, so I created DB mydb and applied this code
5. I copied all files from old copy of mydb directory to new
one, excluding db_* files
6. It worked! Coarse but working :))

Now is the question, how to avoid it in the future.

Andrey Novikov