Always use MySQL 5.0. After a batch of large data tables have been imported recently, the database has become very slow. The reason is that the performance of the InnoDB engine is severely impaired. Then upgrade the database to MariaDB 10.0.2 (personal learning always takes the latest, more versions to see https://downloads.mariadb.org /). MySQLdump export and import. [ERROR] Column count of mysql. proc is wrong. Expected 20, found 16. The table is probably upted. Stored procedures cannot be imported. The reason is that the mysql. proc table of the two versions has different structures.
MySQL 5.0 mysql. proc table structure:
Mysql. proc table structure of Maria10.0.2:
You do not want to upgrade MySQL 5.0. When exported using HeidiSQL, the stored procedure is not exported. After importing the data, copy the CREATE code from the MySQL database to the Maria database.
It is not easy to complete the migration.