Best way to convert character set from "latin1 to utf8" for existing database?

Hi All, I have read many blogs suggesting some examples for this. But suggestions from you guys who have ACTUALLY worked on such a scenario would help me out the best. Current Database has: DEFAULT CHARACTER SET - latin1 DEFAULT COLLATION : latin1_swedish_ci We need to convert this to DEFAULT

AW: Recover data without logs

O think not, did you make dumps of your database? If not you have to use bin-log -Ursprüngliche Nachricht- Von: Weitao Liu [mailto:liuwt...@gmail.com] Gesendet: Sonntag, 31. Mai 2009 10:13 An: mysql@lists.mysql.com Betreff: Recover data without logs I had deleted some important data from

Re: Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key?

As I know, IN sometimes invoke unmormal index. On Thu, May 28, 2009 at 1:15 AM, Baron Schwartz wrote: > Simon, > > On Wed, May 27, 2009 at 11:23 AM, Simon J Mudd wrote: > > per...@elem.com (Perrin Harkins) writes: > > > >> On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd wrote: > >> > So is the f

Recover data without logs

I had deleted some important data from my mysql server,who can tell how can I recover my data,I do not open the bin log,is there some other method? thanks a lot !