Mysql upgrade from 4.1 to 5.0 to 5.1
Hi All, I've performed a upgrade from 4.1.22 to 5.0.81, the mysql_upgrade performed well on all tables repairing, however, after upgrade the same db from 5.0.81 to 5.1.33, a few tables got the error as below: Error: Unknown table engine 'InnoDB' error: Corrupt Any ideas? THnaks. -- Best regards, KengHeng. Chan Mobile : +6-016-717-0273 SQL Technology Sdn Bhd http://www.mysql.cc c...@mysql.cc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql upgrade from 4.1 to 5.0 to 5.1
kengheng wrote: Hi All, I've performed a upgrade from 4.1.22 to 5.0.81, the mysql_upgrade performed well on all tables repairing, however, after upgrade the same db from 5.0.81 to 5.1.33, a few tables got the error as below: Error: Unknown table engine 'InnoDB' error: Corrupt Any ideas? THnaks. fixed by --with-plugins=innobase A DB politics between mysql oracle again -- Best regards, KengHeng. Chan Mobile : +6-016-717-0273 SQL Technology Sdn Bhd http://www.mysql.cc c...@mysql.cc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql upgrade from 4.1 to 5.0 to 5.1
A DB politics between mysql oracle again Thats quite ironic given recent events :) -- Linux web infrastructure consulting, cr...@codenation.net Free live poker tournament listings, http://www.g5poker.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
upgrade from 4.1 to 5.0 KO
hi, I'm running mysql-server on a linux debian box with apt package system I upgraded mysql server from 4.1 to 5.0 (apt automatically execute mysql_upgrade) now on my 5.0.32 server almost everything works fine, except for a database containing 4 tables: two of them have been upgraded as I can see from the extension of the files (.frm, .MYD and .MYI) and I can use them without problems, but the other two tables seem not to have been upgraded as they are still with 4.1 extensions (.frm, .ISM and .ISD). if I try to operate with them I obtain the mysql error ERROR 1017 (HY000): Can't find file: 'tablename' (errno: 2) I tried to run mysql_upgrade again with --force option but It seems they are not considered any idea? ciao, ivan http://www.retecivica.milano.it/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade from 4.1 to 5.0 KO
In the last episode (Oct 23), Ivan Longhi said: I'm running mysql-server on a linux debian box with apt package system I upgraded mysql server from 4.1 to 5.0 (apt automatically execute mysql_upgrade) now on my 5.0.32 server almost everything works fine, except for a database containing 4 tables: two of them have been upgraded as I can see from the extension of the files (.frm, .MYD and .MYI) and I can use them without problems, but the other two tables seem not to have been upgraded as they are still with 4.1 extensions (.frm, .ISM and .ISD). if I try to operate with them I obtain the mysql error ERROR 1017 (HY000): Can't find file: 'tablename' (errno: 2) I tried to run mysql_upgrade again with --force option but It seems they are not considered You'll need to downgrade to 4.1 and then convert those ISAM tables to MYISAM, or copy those files to a system that is running 4.1 and do the conversion there. ISAM format was deprecated in 4.0 and support was removed in 5.0. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
upgrade from 4.1 to 5.0
Hello, I'm going to upgrade from 4.1 to 5.0. My question is how do I handle the data from old version. Do I need to recreate tables in the mysql database when I install the new version or can I use the old mysql database from the old version? Data in other database I believe I can dump and import from the old version. Thank you. Claire __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade from 4.1 to 5.0
On 3/3/06, Claire Lee [EMAIL PROTECTED] wrote: Hello, I'm going to upgrade from 4.1 to 5.0. My question is how do I handle the data from old version. Do I need to recreate tables in the mysql database when I install the new version or can I use the old mysql database from the old version? Data in other database I believe I can dump and import from the old version. Thank you. http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html Claire __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]