mysql> alter table lastblock DISCARD TABLESPACE;
Query OK, 0 rows affected (0.26 sec)
mysql> alter table lastblock import TABLESPACE;
ERROR 1808 (HY000): Schema mismatch (Clustered index validation failed. Because the .cfg file is missing, table definition of the IBD file could be different. Or the data file itself is already corrupted.)
8 July 2022
Chetan Kulthemysql> alter table lastblock DISCARD TABLESPACE;
Query OK, 0 rows affected (0.26 sec)
mysql> alter table lastblock import TABLESPACE;
ERROR 1808 (HY000): Schema mismatch (Clustered index validation failed. Because the .cfg file is missing, table definition of the IBD file could be different. Or the
check the .cfg file..
Chetan Kulthethere is no .cfg file
if the configuration file itself not their.. then thing wont works
Chetan Kultheusing commands alter table TBLNAME discard tablespace; copied files ; then again alter table ... import tablespce ..
what is your requirement ?? why AlterTable command was used ?
Chetan Kultheusing commands alter table TBLNAME discard tablespace; copied files ; then again alter table ... import tablespce ..
you mean you wish to move the mysql from "a" machine to "b" machine ?
Immediate requirement for MYSQL DBA+ Cloud
Kindly find the details below :
Role: MySQL DBA+ Cloud
Experience:4 Yrs to 9 Yrs
Location: Pune/Hyderabad
Notice Period: Immediate/30 Days
Job description:
Primary skills: Database, MySQL, more large Cloud deployments AWS OR GCP, or Azure
Secondary Skills: RDS & Aurora
Roles & Responsibilities:
5+ years of hands-on experience
Databases MySQL Mandatory
Cloud deployments
Expertise AWS OR GCP, or Azure
Good Knowledge on RDS, Aurora is a big plus
References are Highly appreciated!!
Do Reach out to me @emailid: [email protected]