How to fix "Cannot load from mysql.proc. The table is probably corrupted"
If MySQL reports "Error: Cannot load from mysql.proc. The table is probably corrupted", its schema may be a different version from the running server.
EXPLORE THE TOPIC
Database.
19 articles on this topic
How to copy a table in MySQL
In MySQL, a table's structure and data can be copied easily. For example, create table_new with the structure and data from table_name as follows.
How to uses mysqldump to get structure or schema data only
mysqldump normally exports both database structure and data. Add -d or --no-data to export only the structure or schema.
How to remove/purge MySQL binary logs
MySQL binary logs consume disk space. Configure their expiry carefully and use MySQL commands to purge them rather than deleting files from the operating system.
How to reset virus database on Zimbra
Zimbra uses ClamAV to scan email for viruses. Its virus database is normally updated regularly, but if updates fail, the database needs to be reset.
Tips for speeding up dump and import data in MySQL
Importing large SQL datasets into MySQL can take a long time. These tips speed it up by adjusting indexes, inserts, autocommit, and constraint checks.
Check MySQL database size using SQL query
SQL queries to check space used by MySQL databases and tables. Check size of all database: run the query below to check each database's size. SELECT TABLE_SCHEMA
How to disable InnoDB storage engine on MySQL
MySQL enables the InnoDB storage engine by default. If you do not need it, disable it to save system resources. To disable InnoDB…
How to transfer the anti-spam database to another Zimbra server
When migrating zimbra to a new system or installing a new zimbra server, you can retain spam detection as effective as the previous system.
A Comparison of Pros and Cons between InnoDB and MyISAM
MySQL has many table storage engines, with InnoDB and MyISAM among the most popular. This article compares their features, performance, advantages, and disadvantages.
NUMA Architecture and MySQL
NUMA is a new architecture for multiprocessor systems. Each physical processor has its own memory, allowing faster memory access than the older architecture. Linux…
How to streaming export and import MySQL database to other server
You can dump a database and simultaneously import it on another machine by using nc (netcat) to stream data to the destination.
How to convert all MyISAM tables to InnoDB in a MySQL Database
To change multiple tables from the MyISAM storage engine to InnoDB, run SELECT CONCAT... to generate the conversion commands, then run the resulting commands…
Fix missing dependency libmysqlclient.so.15 when installing MySQL-python via yum
CentOS 5 machines running a MySQL version newer than the one supplied with the OS may have trouble installing MySQL-python through yum or rpm. Both report that libmysqlclient_r.so.15 is missing…
MySQL server hardware, OS and configuration tuning tips
MySQL server hardware, OS and configuration tuning tips. Hardware and OS: use a 64-bit OS to support more memory. Do not use software RAID. Avoid RAID 5 and use RAID 10 instead. A battery-backed…
Mass killing MySQL connections
Too many MySQL connections or locked tables can slow a server. Mass-killing selected stalled connections can restore service with minimal downtime.
How to find all tables use particular storage engine on MySQL
MySQL supports various table engines, including MyISAM, InnoDB, MEMORY, and NDB. Finding which engine a table uses may seem complicated, but it is straightforward…
MySQL replication: 'show master status' shows 'Empty set (0.00 sec)'
After preparing two servers for MySQL replication with identical data, the next step is setting up replication. This requires running show master status to check…
Installing MySQL Cluster
This setup uses four machines: two storage nodes, mysql-ndb-1 and mysql-ndb-2; one API node, mysql-api-1; and one management node, mgmt.