Re: [Problem solved]cannot start mysql during upgrade
Posted: 02. January 2009 04:05
Indeed i still haave one last question:
The Howto said:
IMPORTANT: MySQL table upgrade to 5.1.30 in 13 steps!
cd <xampp>\mysql\bin
mysql_upgrade
mysql -u root -h localhost
mysql> use mysql;
mysql> REPAIR TABLE `event`;
mysql> REPAIR TABLE `help_category`;
mysql> REPAIR TABLE `help_keyword`;
mysql> REPAIR TABLE `help_topic`;
mysql> REPAIR TABLE `proc`;
mysql> REPAIR TABLE `servers`;
mysql> REPAIR TABLE `time_zone_name`;
mysql> quit;
mysql_upgrade
but :
C:\xampp\mysql\bin>mysql_upgrade.exe -u root -p
Enter password: ***********
Looking for 'mysql.exe' as: C:\xampp\mysql\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\xampp\mysql\bin\mysqlcheck.exe
This installation of MySQL is already upgraded to 5.1.30, use --force if you sti
ll need to run mysql_upgrade
Is this really nesserary to run it again? I haven't use the --force option to do it as i found that it is already working. Will it makes any difference?
The Howto said:
IMPORTANT: MySQL table upgrade to 5.1.30 in 13 steps!
cd <xampp>\mysql\bin
mysql_upgrade
mysql -u root -h localhost
mysql> use mysql;
mysql> REPAIR TABLE `event`;
mysql> REPAIR TABLE `help_category`;
mysql> REPAIR TABLE `help_keyword`;
mysql> REPAIR TABLE `help_topic`;
mysql> REPAIR TABLE `proc`;
mysql> REPAIR TABLE `servers`;
mysql> REPAIR TABLE `time_zone_name`;
mysql> quit;
mysql_upgrade
but :
C:\xampp\mysql\bin>mysql_upgrade.exe -u root -p
Enter password: ***********
Looking for 'mysql.exe' as: C:\xampp\mysql\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\xampp\mysql\bin\mysqlcheck.exe
This installation of MySQL is already upgraded to 5.1.30, use --force if you sti
ll need to run mysql_upgrade
Is this really nesserary to run it again? I haven't use the --force option to do it as i found that it is already working. Will it makes any difference?