Hi --

24 hours ago I did a 'mysqlhotcopy' of a working database, then
inadverntently did an 'rsync' copy of that copy, _over_ the working
database tables.

Today, mysql is saying "Can't read dir ./thedatabase/'" when I start up
a conversation. :(

Meanwhile, Perl scripts have been working on that database and giving
the appearance that they've been succeeding -- but it looks to me like
no transaction has been recorded to the tables on disk, in the past 24
hours.

Two questions, then:

 - How (where?) do I address mysql's inability to "read dir" for these
   database tables?  (Looks like it's trying to find them in the 
   place I had mysqlhotcopy place its copies, instead of in the place
   where they really are, /var/lib/mysqld/thedatabase/.)
 
 - Is there (he asked, hopefully) a 'buffer' mysql has been keeping
   during the last 24 hours, that might be holding transactions that
   were not written to the tables on disk, but still could be
   written to those tables now...?

Thanks kindly,

-- 

 -- Jeff --   <http://www.wellnow.com>

 "There's nothing left in the world to prove.  All that's worth doing
  is to love one another, using whatever means are available to serve."

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to