Hi there, I have a strange problem. I am using Server version: 5.0.45 SUSE MySQL RPM
I made a backup of a database by copying its directory like so: mv urulu urulu_X then I recreateded the database, played a little with it and then dropped it again. the I moved the old database in place again. now when I want to access the tables of the database I get an error that the tables do not exist, alltough the showtables lists them correctly. what can I do to fix that? to explayin thin a bit better, here a dump of an mysql dialog mysql> use urulu Database changed mysql> show tables; +------------------+ | Tables_in_urulu | +------------------+ | dataccess | | datancestors | | datchildren | | datserialisation | | datstat | | datvariables | | datwidgets | | defchildren | | defdependencies | | defgeneral | | defhandler | | defvariables | | lang | | session | | synaccess | | synconnect | | syncreate | | syndata | | synproperties | | syntoc | | xslcache | +------------------+ 21 rows in set (0.00 sec) mysql> select * from lang; ERROR 1146 (42S02): Table 'urulu.lang' doesn't exist mysql> thanks robert
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
