Cannot load from mysql.proc. The table is probably corrupted 问题解决
来源:互联网 发布:数据库接口怎么开发 编辑:程序博客网 时间:2024/04/30 19:29
MySQL will sometimes return the error message “Cannot load from mysql.proc. The table is probably corrupted”. This happens due to schema changes required for different MySQL server versions. The simple fix to this problem is to run the mysql_upgrade command from the command line.
About mysql_upgrade
mysql_upgrade examines all tables across all databases for incompatibilities with the current version of MySQL Server. mysql_upgrade also upgrades the system tables so that you can take advantage of new privileges or capabilities that might have been added.
mysql_upgrade should be executed each time you upgrade MySQL. It supersedes the older mysql_fix_privilege_tables script, which should no longer be used.
mysql_upgrade executes the following commands to check and repair tables and to upgrade the system tables:
mysqlcheck --all-databases --check-upgrade --auto-repair
mysql < fix_priv_tables
Run mysql_upgrade From Command Line
To use mysql_upgrade, make sure your MySQL server is running and then invoke mysql_upgrade from the command line tool:
mysql_upgrade -uroot -p --force
You should then be prompted to enter the MySQL root's password and mysql_upgrade will check all the databases and tables and fix them where appropriate. You may need to specify the full path to the above command if it's not in the shell's search path.
On Debian 6 it should be loacted at:
/usr/bin/mysql_upgrade -uroot -p --force
On Mac's MAMP the default path is:
/Applications/MAMP/Library/bin/mysql_upgrade -uroot -p --force
On Windows it'll be where MySQL is installed and contained in the bin subdirectory. By default it should be located at:
"C:\Program Files\MySQL\MySQL Server\[*CHANGE TO MySQL SERVER*]\bin\mysqladmin" -u root shutdown
- Cannot load from mysql.proc. The table is probably corrupted
- Cannot load from mysql.proc. The table is probably corrupted
- Cannot load from mysql.proc. The table is probably corrupted
- Cannot load from mysql.proc. The table is probably corrupted 问题解决
- 1548 cannot load mysql.proc.the table is probably corrupted
- 解决MySQL中【Cannot load from mysql.proc. The table is probably corrupted。】的问题
- MySQL 1548 Cannot load from mysql.proc. The table is probably corrupted的解决办法
- Mysql报Cannot load from mysql.proc. The table is probably corrupted
- Mysql报Cannot load from mysql.proc. The table is probably corrupted
- Mysql报错:Cannot load from mysql.proc. The table is probably corrupted
- Mysql报Cannot load from mysql.proc. The table is probably corrupted
- BUG: Cannot load from mysql.proc. The table is probably corrupted
- ERROR 1548 (HY000): Cannot load from mysql.proc. The table is probably corrupted
- BUG: Cannot load from mysql.proc. The table is probably corrupted
- 1548-Cannot load from mysql.proc. The table is probably corrupted
- create stored procs Cannot load from mysql.proc. The table is probably corrupted
- Error code:1728 Cannot load from mysql.proc. The table is probably corrupted
- 1548-Cannot load from mysql.proc. The table is probably corrupted
- CGAL 编译指南
- Find number of subsets with equal sum
- #149 Best Time to Buy and Sell Stock
- Android使用fitsSystemWindows属性实现–状态栏【status_bar】各版本适配方案
- JAVA 数据类型转换
- Cannot load from mysql.proc. The table is probably corrupted 问题解决
- Android intent-fileter简介
- Java IO小结
- ROM、RAM、DRAM、SRAM和FLASH的区别
- GB28181开流SDP各个字段汇总整理
- 【机器学习】推导支持向量机SVM二分类
- 理解Linux中 modify time、change time、access time
- 使用CocoaPods(一)为项目配置第三方类库
- 4Sum