Re: Bad table conversion

2002-09-05 Thread Heikki Tuuri
Michael, - Original Message - From: ""Michael T. Babcock"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, September 05, 2002 6:37 PM Subject: Re: Bad table conversion > Victoria Reznichenko wrote: > > >Michael,

Re: Bad table conversion

2002-09-05 Thread Michael T. Babcock
Victoria Reznichenko wrote: >Michael, MySQL privilege tables MUST be MyISAM: > http://www.mysql.com/doc/en/InnoDB_restrictions.html > > Yes, thank-you; I must have missed / forgotten that warning at some point -- my next E-mail will be to the phpMyAdmin author suggesting a patch to pr

Re: Bad table conversion

2002-09-05 Thread Heikki Tuuri
Michael, - Original Message - From: "Michael T. Babcock" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Heikki Tuuri" <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 6:03 PM Subject: Re: Bad table conversion > Heikki Tuuri wrote: >

Re: Bad table conversion

2002-09-05 Thread Michael T. Babcock
Heikki Tuuri wrote: >what version you are using? > mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686) >It left the MyISAM user and db tables as they were. > >You have lost the db table? I guess that if you create the same databases in >another server and copy the db table from there, it s

Re: Bad table conversion

2002-09-05 Thread Victoria Reznichenko
Michael, Thursday, September 05, 2002, 5:09:47 PM, you wrote: MTB> I was using phpMyAdmin to do some user management and since it was MTB> fairly slow, decided to try upgrading my mysql.users and mysql.db tables MTB> to InnoDB format. It seems however that this is a "bad thing" as mysql MTB>

Re: Bad table conversion

2002-09-05 Thread Heikki Tuuri
Michael, - Original Message - From: ""Michael T. Babcock"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, September 05, 2002 5:15 PM Subject: Bad table conversion > I was using phpMyAdmin to do some user management and since it was

Bad table conversion

2002-09-05 Thread Michael T. Babcock
I was using phpMyAdmin to do some user management and since it was fairly slow, decided to try upgrading my mysql.users and mysql.db tables to InnoDB format. It seems however that this is a "bad thing" as mysql told me when it refused to restart. I've recovered the users table from a backup