tables/ index with NULL data length Post Mysql upgrade from 5.5.28 to 5.7.12

I've recently upgraded mysql version on one of the systems from mysql 5.5.28 to 5.7.12 after upgrading binaries I've also upgraded schema of tables using

$sudo mysql_upgrade  

and

$sudo mysql_upgrade --force  

which executed successfully without any error.

I was trying to check if there are any crashed tables using following query

mysql> select table_schema,table_name from information_schema.tables where index_length is NULL or data_length is NULL; 

(since this is now allowing me to post complete info regarding my query I am going to add link to my post of other forums. Hope I will be able to put data in multiple posts.Kindly follow the link:- http://www.linuxquestions.org/questions/showthread.php?p=5582807#post5582807)

Replay

Category: mysql5.5 Time: 2016-07-29 Views: 0
Tags: mysql5.5

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.236 (s). 12 q(s)