From: Martin M. (THALES) <mm...@fi...> - 2002-12-02 16:33:52
|
Dear all, PHP-HelpDesk has been working fine for some months now, but now suddenly it's creating what I believe are parasite tables... Please, look at the following output for 'show tables': --- +-----------------------+ | Tables_in_solicitudes | +-----------------------+ | | | 09 | | 1 | | 25 | | 36 | | 38 | | 42 | | 51 | | 53 | | 69 | | 7 | | 74 | | 78 | | 8 | | 85 | | 90 | | binary_data | | category | | department | | events | | lunes | | parts | | prueba | | security | | ticket | | ticketparts | | tmpeid | | tmpviewtickets | | userdepartments | +-----------------------+ 29 rows in set (0.00 sec) --- The parasite tables are those begining with a number. These tables also produce an error, for example: --- mysql> desc 74 ; ERROR 1064: You have an error in your SQL syntax near '74' at line 1 --- It doesn't matter if I (double)quote the table name... I still get the same error. Furthermore, these tables do have the following associated files: --- ls -l 74.* -rw-rw---- 1 mysql daemon 0 Dec 2 10:48 74.MYD -rw-rw---- 1 mysql daemon 1024 Dec 2 10:48 74.MYI -rw-rw---- 1 mysql daemon 8550 Dec 2 10:48 74.frm --- So, my questions: * where do these tables/files come from? * how can I get rid of them? Thank you very much in advance! Best regards, Martin -- Martin Mielke - mar...@th... THALES Information Systems - http://www.thales-is.com/ [ echo "\$0&\$0">_;chmod +x _;./_ ] |