{"id":16499,"date":"2019-12-09T22:42:17","date_gmt":"2019-12-10T03:42:17","guid":{"rendered":"https:\/\/bangla.salearningschool.com\/recent-posts\/mysql-repair-database-and-or-tables\/"},"modified":"2020-02-08T09:27:45","modified_gmt":"2020-02-08T14:27:45","slug":"mysql-repair-database-and-or-tables","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=16499","title":{"rendered":"Mysql: Repair database and\/or tables"},"content":{"rendered":"

"
\nmysqldump db_name<\/em> t1 > dump.sql mysql db_name<\/em> < dump.sql<\/p>\n

mysqldump db_name<\/em> > dump.sql mysql db_name<\/em> < dump.sql<\/p>\n

mysqldump –all-databases > dump.sql mysql < dump.sql<\/p>\n

ALTER TABLE t1 ENGINE = InnoDB;<\/p>\n

REPAIR TABLE t1;<\/p>\n

mysqlcheck –repair –databases db_name<\/em> … mysqlcheck –repair –all-databases<\/p>\n

"<\/p>\n

Reference: https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/rebuilding-tables.html<\/a>
\n—<\/p>\n

Sayed Ahmed<\/strong>
\n<\/em><\/p>\n

BSc. Eng. in Comp. Sc. & Eng. (BUET)<\/strong><\/em>
\nMSc. in Comp. Sc. (U of Manitoba, Canada)<\/strong><\/em>
\nMSc. in Data Science and Analytics (Ryerson University, Canada)<\/strong><\/em>
\nLinkedin<\/strong>: https:\/\/ca.linkedin.com\/in\/sayedjustetc<\/a>
\n<\/em><\/p>\n

Blog<\/strong>: http:\/\/Bangla.SaLearningSchool.com<\/a>, http:\/\/SitesTree.com<\/a> <\/em>
\nOnline and Offline Training<\/strong>: http:\/\/Training.SitesTree.com<\/a> <\/em><\/p>\n

Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others to earn a revenue.<\/em>
\nhttp:\/\/sitestree.com\/training\/<\/a><\/p>\n

I<\/strong>f you want to contribute to the operation of this site (Bangla.SaLearn) including occasional free and\/or low cost online training (using Zoom.us): http:\/\/Training.SitesTree.com<\/a> (or charitable\/non-profit work in the education\/health\/social service sector), you can financially contribute to: safoundation at salearningschool.com<\/a> using Paypal or Credit Card (on <\/em>http:\/\/sitestree.com\/training\/enrol\/index.php?id=114<\/a> ).<\/em>
\n<\/strong>
\nAffiliate Links: Deals on Amazon :<\/em><\/strong>
\nHottest Deals on Amazon USA: http:\/\/tiny.cc\/38lddz<\/a>
\n<\/em>
\nHottest Deals on Amazon CA: http:\/\/tiny.cc\/bgnddz<\/a>
\n<\/em>
\nHottest Deals on Amazon Europe: http:\/\/tiny.cc\/w4nddz<\/a><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

" mysqldump db_name t1 > dump.sql mysql db_name < dump.sql mysqldump db_name > dump.sql mysql db_name < dump.sql mysqldump –all-databases > dump.sql mysql < dump.sql ALTER TABLE t1 ENGINE = InnoDB; REPAIR TABLE t1; mysqlcheck –repair –databases db_name … mysqlcheck –repair –all-databases " Reference: https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/rebuilding-tables.html — Sayed Ahmed BSc. Eng. in Comp. Sc. & Eng. … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1910,182],"tags":[],"class_list":["post-16499","post","type-post","status-publish","format-standard","hentry","category-ai-ml-ds-rl-dl-nn-nlp-data-mining-optimization","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69091,"url":"http:\/\/bangla.sitestree.com\/?p=69091","url_meta":{"origin":16499,"position":0},"title":"MySql Administration SQL Commands #5","author":"Author-Check- Article-or-Video","date":"August 12, 2021","format":false,"excerpt":"Using MySQL, AdministrationWorkshop RequirementsYou should have access to the MySQL command line client software.Various different PRIVILEGES on the MySQL ServerIntroductionIn the other MySQL Virtual Workshops we have used commands that are pretty much applicable to anyone. This part of the MySQL series is aimed at giving a rudimentary understanding of\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":67600,"url":"http:\/\/bangla.sitestree.com\/?p=67600","url_meta":{"origin":16499,"position":1},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS #DevOps #RHCE","author":"Author-Check- Article-or-Video","date":"July 25, 2021","format":false,"excerpt":"RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda There are\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":20401,"url":"http:\/\/bangla.sitestree.com\/?p=20401","url_meta":{"origin":16499,"position":2},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS","author":"Author-Check- Article-or-Video","date":"February 20, 2021","format":false,"excerpt":"RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda There are\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":20403,"url":"http:\/\/bangla.sitestree.com\/?p=20403","url_meta":{"origin":16499,"position":3},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS","author":"Author-Check- Article-or-Video","date":"February 20, 2021","format":false,"excerpt":"The author is: the_authornRHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":20405,"url":"http:\/\/bangla.sitestree.com\/?p=20405","url_meta":{"origin":16499,"position":4},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS","author":"Author-Check- Article-or-Video","date":"February 20, 2021","format":false,"excerpt":"The author is: the_authornRHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":20409,"url":"http:\/\/bangla.sitestree.com\/?p=20409","url_meta":{"origin":16499,"position":5},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS","author":"Author-Check- Article-or-Video","date":"February 20, 2021","format":false,"excerpt":"The author is: the_authornRHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/16499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16499"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/16499\/revisions"}],"predecessor-version":[{"id":16777,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/16499\/revisions\/16777"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16499"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}