2007/6/16, mos <[EMAIL PROTECTED]>:
At 09:39 AM 6/16/2007, Stanley wrote:
>Is it possible to undelete a dropped MyISAM table?
Nope, not from within MySQL. Your operating system might allow you to
undelete the file then you might have a chance of importing the data to a
new table.
Mike
If your have a backup of your file system, you have only to restore
those file in the mysql datadir : yourtable.FRM, yourtable.MYD,
yourtable.MYI.
No need to importing data to a new table. MySQL will see it as it were
before dropping it.
This is a notable difference between myisam and innodb for instance.
Regards,
Geoffroy.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
