MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: MySQL 5.6: creating users kills mysql, and mysq_upgrade fails
Posted by: Rick James
Date: November 09, 2014 02:10PM

> mysql dump (10.13)

What version of MySQL (5.x.y or 4.x.y) did it come with?

> it does not contain any reference to mysql.proc

Older versions did not have a mysql.proc. Its absence may lead to "Incorrect definition of table mysql.proc".

If reloading the dump effectively did:
DROP DATABASE mysql;
CREATE DATABASE mysql;
CREATE TABLE ... (without creating `proc`)
then it would probably explain what you are seeing.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL 5.6: creating users kills mysql, and mysq_upgrade fails
Simon Hobbs
November 07, 2014 10:37AM
Re: MySQL 5.6: creating users kills mysql, and mysq_upgrade fails
Rick James
November 08, 2014 10:07AM
Re: MySQL 5.6: creating users kills mysql, and mysq_upgrade fails
Simon Hobbs
November 08, 2014 02:05PM
Re: MySQL 5.6: creating users kills mysql, and mysq_upgrade fails
Rick James
November 09, 2014 02:10PM
Re: MySQL 5.6: creating users kills mysql, and mysq_upgrade fails
Simon Hobbs
November 10, 2014 05:11AM
Re: MySQL 5.6: creating users kills mysql, and mysq_upgrade fails
Rick James
November 11, 2014 12:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.