Upgrading to MySQL 5.1

English Install/Boot/Login
1

Unknown system variable ‘have_csv’

I upgraded to mysql 5.1 from 5.0 with openSuse 11.1, but I can’t start Mysql. It gives me this error:


Running 'mysql_fix_privilege_tables'...                                          
ERROR 1193 (HY000) at line 80: Unknown system variable 'have_csv'                
ERROR 1064 (42000) at line 82: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
ERROR 1243 (HY000) at line 83: Unknown prepared statement handler (stmt) given to EXECUTE                                                                                            
ERROR 1243 (HY000) at line 84: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE                                                                                 
ERROR 1193 (HY000) at line 88: Unknown system variable 'have_csv'                                                                                                                    
ERROR 1064 (42000) at line 90: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
ERROR 1243 (HY000) at line 91: Unknown prepared statement handler (stmt) given to EXECUTE                                                                                            
ERROR 1243 (HY000) at line 92: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE                                                                                 
ERROR 1193 (HY000) at line 320: Unknown system variable 'general_log'                                                                                                                
ERROR 1193 (HY000) at line 321: Unknown system variable 'general_log'                                                                                                                
ERROR 1146 (42S02) at line 322: Table 'mysql.general_log' doesn't exist                                                                                                              
ERROR 1193 (HY000) at line 323: Unknown system variable 'general_log'                                                                                                                
ERROR 1193 (HY000) at line 325: Unknown system variable 'slow_query_log'                                                                                                             
ERROR 1193 (HY000) at line 326: Unknown system variable 'slow_query_log'                                                                                                             
ERROR 1146 (42S02) at line 327: Table 'mysql.slow_log' doesn't exist                                                                                                                 
ERROR 1193 (HY000) at line 328: Unknown system variable 'slow_query_log'                                                                                                             
FATAL ERROR: Upgrade failed

Any ideas?

2

rpm -qa | grep -i mysql

Incidentally, 5.1 is mega unstable, buggy and nothing I would ever suggest for even relatively production quality.

3

Go back to 5.0 !!!

There are going to be some major changes in the paths used by MySQL. You installed it from a repo, that has been declared experimental numerous times.

4

**** I was hoping to use its increased fulltext speed. Ah well. The reversion to 5.0 worked fine. **** Sun and Oracle. MySQL used to be so awesome. Thanks!