adding a column and index to a large table

2007-06-16 Thread Perrin Harkins
I have a large InnoDB table which I want to add a TIMESTAMP column to and a new index. It's actually a few tables and in some cases I only want to index the new column but in others it's a multi-key index with the new column and another column. The problem is that this is taking many, many hours

Re: Can I undelete a dropped MyISAM table?

2007-06-16 Thread mos
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 -- MySQL General Mailing List For list

Can I undelete a dropped MyISAM table?

2007-06-16 Thread Stanley
Is it possible to undelete a dropped MyISAM table?