O.K MySQL List This one is on me,
a bit funny, a bit strange but with a serious background.
You are allowed to laugh ;-).
Assuming that somebody has the "clever idea" to rename the folder for a InnoDB
database f.e. on the command line base (mv command for Linux). Now the mysqld
server startsup and of course he will not be able to access any table , data
etc. he will get something like below:
mysql> use sam_member_db
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'discountplan'
Didn't find any fields in table 'members'
Didn't find any fields in table 'rank'
Didn't find any fields in table 'relations'
Database changed
Then he would try to access one of the tables f.e. like this:
mysql> describe members
-> ;
ERROR 1016: Can't open file: 'members.InnoDB'. (errno: 1)
1) Is it possible to reconstruct which name the database originally had before
the folder was renamed on the command line ?
2) Is it possible to access or release (delete) the "captured" data related to
the not anymore useable database ?
Of course I could step through the log files trying to find the correct
"CREATE DATABASE dbname" statement, but having seen the innodb log file sizes
I would appreciate another solution ;-)
PS: Didn't happen with serious data, just when fooling around with mysql.
--
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
