MySQL table type and storage engine version inconsistency resolution

Source: Internet
Author: User
Tags mysql client mysql version table name

Using the old version of the MySQL client navicate 8, the MySQL server with the mysql5.6 version, in the revision of the engine version of the version is not correct;

MySQL error ' Type=myisam '

Solution:

Replace

Type=myisam

With

Engine=myisam

The problem was "Type=myisam" which should is "Engine=myisam" as per MySQL version updates–a simple Search/replace has Fix it.

Attached modify table Engine Sql:alter table Db.user engine =myisam;

Supplementary MySQL table type and storage engine view

Look at your MySQL now what storage engine is available:
Mysql> show engines;

Look at your MySQL. Current default storage Engine:
Mysql> Show variables like '%storage_engine% ';

You want to see what engine a table is using (after the parameter engine in the display result indicates the storage engine that the table is currently using):
Mysql> Show create table name;

CREATE TABLE Discuz.cdb_user engine = InnoDB;
This allows the Discuz.cdb_user engine of the table to be changed to the InnoDB engine.

You can also change the following statement after you create the table:
ALTER TABLE Discuz.cdb_user engine =INNODB;

If you want to view the type of a table, you can use:
Show table status form Discuz;
Represents information for viewing all tables in the database Discuz, where engine: the corresponding column is the storage engine used by the table

If you want to view information for a single table, you can use:
Show CREATE TABLE Discuz.cdb_user;
You can see engine=***** at the end of the output information, which is where the storage engine used for the table

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.