{"id":365,"date":"2017-11-03T17:24:28","date_gmt":"2017-11-03T10:24:28","guid":{"rendered":"http:\/\/www.st.ac.th\/krubuncha\/?p=365"},"modified":"2017-11-20T15:49:35","modified_gmt":"2017-11-20T08:49:35","slug":"mysql-table-doesnt-exist","status":"publish","type":"post","link":"https:\/\/www.st.ac.th\/krubuncha\/mysql-table-doesnt-exist\/","title":{"rendered":"mysql table doesn’t exist"},"content":{"rendered":"

STEP #1<\/h1>\n

Make sure you have backups of those\u00a0.frm<\/code>\u00a0and\u00a0.ibd<\/code>\u00a0files in\u00a0\/tmp\/innodb_data<\/code><\/p>\n

STEP #2<\/h1>\n

Get the\u00a0CREATE TABLE tags<\/code>\u00a0statement and execute it as\u00a0CREATE TABLE mydb.tags ...<\/code>. Make sure it is the exact same structure as the original\u00a0tags.frm<\/code><\/p>\n

STEP #3<\/h1>\n

Delete the empty\u00a0tags.ibd<\/code>\u00a0using MySQL<\/p>\n

ALTER TABLE mydb.tags DISCARD TABLESPACE;\r\n<\/code><\/pre>\n
STEP #4<\/h1>\n
Bring in the backup copy of\u00a0tags.ibd<\/code><\/p>\n
cd \/var\/lib\/mysql\/mydb\r\ncp \/tmp\/innodb_data.tags.ibd .\r\nchown mysql:mysql tags.ibd\r\n<\/code><\/pre>\n
STEP #5<\/h1>\n
Add\u00a0tags<\/code>\u00a0table to the InnoDB Data Dictionary<\/p>\n
ALTER TABLE mydb.tags IMPORT TABLESPACE;\r\n<\/code><\/pre>\n
STEP 6<\/h1>\n
Test the table’s accessibility<\/p>\n
SHOW CREATE TABLE mydb.tags\\G\r\nSELECT * FROM mydb.tags LIMIT 10;\r\n<\/code><\/pre>\n
If you get normal results, congratulations you import an InnoDB table.<\/p>\n
STEP 7<\/h1>\n
In the future, please don’t delete ibdata1 and its logs<\/p>\n
Give it a Try !!!<\/h1>\n","protected":false},"excerpt":{"rendered":"
STEP #1 Make sure you have backups of those\u00a0.frm\u00a0and\u00a0.ibd\u00a0files in\u00a0\/tmp\/innodb_data STEP #2 Get the\u00a0CREATE TABLE tags\u00a0statement and execute it as\u00a0CREATE TABLE mydb.tags …. Make sure [\u0e2d\u0e48\u0e32\u0e19\u0e15\u0e48\u0e2d]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":314,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-365","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2013\/09\/phpmysql-e1470191125530.png?fit=200%2C200&ssl=1","blog_post_layout_featured_media_urls":{"thumbnail":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2013\/09\/phpmysql-e1470191125530.png?resize=150%2C150&ssl=1",150,150,true],"full":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2013\/09\/phpmysql-e1470191125530.png?fit=200%2C200&ssl=1",200,200,false]},"categories_names":{"1":{"name":"\u0e1a\u0e17\u0e04\u0e27\u0e32\u0e21\u0e04\u0e2d\u0e21\u0e1e\u0e34\u0e27\u0e40\u0e15\u0e2d\u0e2d\u0e23\u0e4c","link":"https:\/\/www.st.ac.th\/krubuncha\/category\/%e0%b8%9a%e0%b8%97%e0%b8%84%e0%b8%a7%e0%b8%b2%e0%b8%a1%e0%b8%84%e0%b8%ad%e0%b8%a1%e0%b8%9e%e0%b8%b4%e0%b8%a7%e0%b9%80%e0%b8%95%e0%b8%ad%e0%b8%ad%e0%b8%a3%e0%b9%8c\/"}},"tags_names":[],"comments_number":0,"wpmagazine_modules_lite_featured_media_urls":{"thumbnail":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2013\/09\/phpmysql-e1470191125530.png?resize=150%2C150&ssl=1",150,150,true],"cvmm-medium":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2013\/09\/phpmysql-e1470191125530.png?resize=200%2C200&ssl=1",200,200,true],"cvmm-medium-plus":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2013\/09\/phpmysql-e1470191125530.png?resize=200%2C200&ssl=1",200,200,true],"cvmm-portrait":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2013\/09\/phpmysql-e1470191125530.png?resize=200%2C200&ssl=1",200,200,true],"cvmm-medium-square":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2013\/09\/phpmysql-e1470191125530.png?resize=200%2C200&ssl=1",200,200,true],"cvmm-large":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2013\/09\/phpmysql-e1470191125530.png?resize=200%2C200&ssl=1",200,200,true],"cvmm-small":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2013\/09\/phpmysql-e1470191125530.png?resize=130%2C95&ssl=1",130,95,true],"full":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2013\/09\/phpmysql-e1470191125530.png?fit=200%2C200&ssl=1",200,200,false]},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5Mvvj-5T","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/comments?post=365"}],"version-history":[{"count":1,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/365\/revisions"}],"predecessor-version":[{"id":366,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/365\/revisions\/366"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/media\/314"}],"wp:attachment":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/media?parent=365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/categories?post=365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/tags?post=365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}