{"id":159549,"date":"2024-01-17T07:13:27","date_gmt":"2024-01-17T07:13:27","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=159549"},"modified":"2024-01-17T08:08:26","modified_gmt":"2024-01-17T08:08:26","slug":"troubleshooting-mysql-error-145-hy000","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/","title":{"rendered":"Troubleshooting MySQL Error 145 (HY000)"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p>You may encounter the &ldquo;error 145: Table &lsquo;\/dbname\/tablename&rsquo; is marked as crashed and should be repaired,&rdquo; while accessing the records in the MySQL database. MySQL Server usually throws this error when it fails to read the tables in the database. It indicates corrupted or damaged data in the database. Due to this error, you may fail to access the tables and other data in the database, leading to downtime and service disruption. Below, we will discuss how to resolve the MySQL error 145 (HY000) on both Windows and Linux operating systems. But before that, let&rsquo;s take a look at the causes behind this MySQL error.<\/p><h2 class=\"wp-block-heading\" id=\"what-causes-mysql-error-145-(hy000)?\"><strong>What Causes MySQL Error 145 (HY000)?<\/strong><\/h2><p><strong>The MySQL error 145 indicates corruption in database tables. The tables can get corrupted due to one of the following reasons:<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Sudden power failure.<\/li>\n\n\n\n<li>Interruption in the data transfer process while migrating from one server to another.<\/li>\n\n\n\n<li>The application is abruptly terminated or killed in the middle of a write operation.&nbsp;<\/li>\n\n\n\n<li>Internet failure on the system hosting the MySQL Server.<\/li>\n\n\n\n<li>Lack of disk space.<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"methods-to-fix-mysql-error-145-(hy000)\"><strong>Methods to Fix MySQL Error 145 (HY000)<\/strong><\/h2><p>You can encounter the MySQL error 145(HY000): Table is marked as crashed and should be repaired, while connecting to the MySQL Server. It can occur due to network issues. If there are network connectivity issues, you can <a href=\"https:\/\/dev.mysql.com\/doc\/mysql-security-excerpt\/8.0\/en\/problems-connecting.html\" target=\"_blank\" rel=\"noreferrer noopener nofollow\"><em>troubleshoot the connection problems<\/em><\/a><em>. <\/em>If this is not the case, then follow the below methods.<\/p><h3 class=\"wp-block-heading\"><strong>Method 1 &ndash; Restore MySQL Database Tables from Backup<\/strong><\/h3><p>The error message itself indicates issues with the MySQL table. If you have created a logical backup of the database using the mysqldump utility, then you can restore the tables from the backup database file.<\/p><p><strong>To identify the crashed table, you can use the below T-SQL query:<\/strong><\/p><pre class=\"wp-block-code command_container\"><code><strong>SHOW TABLE STATUS;<\/strong><\/code><\/pre><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"401\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/running-show-status-command.jpg\" alt=\"running show status command\" class=\"wp-image-159613 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/running-show-status-command.jpg 938w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/running-show-status-command-300x128.jpg 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/running-show-status-command-768x328.jpg 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/running-show-status-command-150x64.jpg 150w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/figure><p>Search for the table with the &ldquo;<strong>Crashed<\/strong>&rdquo; status, under the <strong>Data_free<\/strong> column.<\/p><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"62\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/searching-for-table-with-crashed-status-1024x62.jpg\" alt=\"searching for table with crashed status\" class=\"wp-image-159615 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/searching-for-table-with-crashed-status-1024x62.jpg 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/searching-for-table-with-crashed-status-300x18.jpg 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/searching-for-table-with-crashed-status-768x46.jpg 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/searching-for-table-with-crashed-status-150x9.jpg 150w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/searching-for-table-with-crashed-status.jpg 1193w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><p>Once you identify the affected table, you can restore it.<\/p><p>First, create an empty database by using the following command:<\/p><pre class=\"wp-block-code command_container\"><code>&lsquo;mysql &gt; create db_name&rsquo;<\/code><\/pre><p>Then, use the below command to restore the table from the backup database.<\/p><pre class=\"wp-block-code command_container\"><code>mysql -u root -p db_name &lt; dump.sql --tables table name<\/code><\/pre><p>If multiple tables are corrupted, then you can restore the entire MySQL database from the backup. Here is the command:<\/p><pre class=\"wp-block-code command_container\"><code>mysql -u root -p db_name &lt; dump.sql<\/code><\/pre><p>After restore, it is important to check the restored objects in the database. For this, use this command:<\/p><pre class=\"wp-block-code command_container\"><code>&lsquo;mysql&gt; use db_name;<\/code><\/pre><pre class=\"wp-block-code command_container\"><code>mysql &gt; show tables;&rsquo;<\/code><\/pre><p>If you&rsquo;re running MySQL on Linux system, then execute the below command to <a href=\"https:\/\/www.stellarinfo.com\/article\/how-to-restore-mysql-database-in-linux.php\" target=\"_blank\" rel=\"noreferrer noopener\">restore the database from backup:<\/a><\/p><pre class=\"wp-block-code command_container\"><code>mysql -u [user] -p [database_name] &lt; [filename].sql<\/code><\/pre><h3 class=\"wp-block-heading\"><strong>Method 2 &ndash; Check and Repair the MySQL Database Table using mysqlcheck Command<\/strong><\/h3><p>If you don&rsquo;t have an updated backup or your backup file is obsolete, you can use the mysqlcheck command. This command is used to check the tables and repair them if they&rsquo;re corrupted. It is also used to analyze and optimize the tables. Here&rsquo;s how to use this command:<\/p><ul class=\"wp-block-list\">\n<li>Open the command-line terminal on your system which is hosting MySQL Server.<\/li>\n\n\n\n<li>Run the below command to check a specific table in the database:&nbsp;&nbsp;<\/li>\n<\/ul><pre class=\"wp-block-code command_container\"><code>mysqlcheck -c database_name table_name<\/code><\/pre><ul class=\"wp-block-list\">\n<li>If it shows error for the table, then repair it by using the below command:<\/li>\n<\/ul><pre class=\"wp-block-code command_container\"><code>&nbsp; mysqlcheck --r database_name table_name<\/code><\/pre><h3 class=\"wp-block-heading\"><strong>Method 3 &ndash; Repair MySQL Tables using<\/strong> <strong>myisamchk Command<\/strong><\/h3><p>MySQL supports two types of storage engines &ndash; MyISAM and InnoDB. If you&rsquo;re using MyISAM storage engine, then you can use myisamchk command to recover the corrupted table. Here&rsquo;s how to use this command on the Windows system.<\/p><p><strong>First, you need to stop the MySQL Server. For this, use the below command:<\/strong><\/p><pre class=\"wp-block-code command_container\"><code>mysqld stop<\/code><\/pre><ul class=\"wp-block-list\">\n<li>Then, use the myisamchk command, as given below, to fix the corrupt table:<\/li>\n<\/ul><pre class=\"wp-block-code command_container\"><code>myisamchk &ndash;recover TABLE<\/code><\/pre><ul class=\"wp-block-list\">\n<li>Now, again start the MySQL Server by using this command:<\/li>\n<\/ul><pre class=\"wp-block-code command_container\"><code>mysqld start<\/code><\/pre><p><strong>If you are running MySQL on Linux system, then follow these steps to repair the tables:<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Stop the MySQL server using the below commands:<\/li>\n\n\n\n<li>For CentOS and Fedora<\/li>\n<\/ul><pre class=\"wp-block-code command_container\"><code>service mysqld stop<\/code><\/pre><ul class=\"wp-block-list\">\n<li>For Debian and Ubuntu<\/li>\n<\/ul><pre class=\"wp-block-code command_container\"><code>service mysql stop<\/code><\/pre><ul class=\"wp-block-list\">\n<li>Next, change the directory with the directory where the affected database table is saved.<\/li>\n<\/ul><pre class=\"wp-block-code command_container\"><code>cd \/var\/lib\/mysql<\/code><\/pre><ul class=\"wp-block-list\">\n<li>Use the below command to check the corrupted table in the database.<\/li>\n<\/ul><pre class=\"wp-block-code command_container\"><code>myisamchk table_name<\/code><\/pre><ul class=\"wp-block-list\">\n<li>If you want to check all the tables in the database, use this command:<\/li>\n<\/ul><pre class=\"wp-block-code command_container\"><code>myisamchk *.MYI<\/code><\/pre><ul class=\"wp-block-list\">\n<li>After identifying the damaged table, run the below command to repair it:<\/li>\n<\/ul><pre class=\"wp-block-code command_container\"><code>myisamchk &ndash;recover table<\/code><\/pre><ul class=\"wp-block-list\">\n<li>After this, restart the MySQL Server using the below command:<\/li>\n\n\n\n<li>service mysqld start <strong>For CentOS and Fedora<\/strong><\/li>\n\n\n\n<li>service mysql start <strong>For Debian and Ubuntu<\/strong><\/li>\n<\/ul><p><strong>Note:<\/strong><\/p><p><em>If you&rsquo;re using InnoDB storage engine, you can enable the <a href=\"https:\/\/www.stellarinfo.com\/blog\/mysql-innodb-force-recovery-not-working\/\" target=\"_blank\" rel=\"noreferrer noopener\">Innodb_force_recovery<\/a> option to <a href=\"https:\/\/www.stellarinfo.com\/blog\/repair-innodb-table-corruption-in-mysql\/\" target=\"_blank\" rel=\"noreferrer noopener\">repair the corrupt tables<\/a>. &nbsp;<\/em><\/p><h2 class=\"wp-block-heading\" id=\"what-if-nothing-works?\"><strong>What If Nothing Works?<\/strong><\/h2><p>If the above repair methods fails to repair the MySQL database tables, then you can use &nbsp;an advanced MySQL database repair tool, like Stellar Repair for MySQL. It can repair corrupt MySQL database, including tables and other objects with complete integrity. It can also help recover deleted records from the corrupted database. The tool allows you to save the repaired data in MySQL, MariaDB, SQL Script, HTML, CSV, and XLS formats. It can help you fix corruption issues in MyISAM and InnoDB tables. The tool supports both Linux and Windows operating systems.<\/p><h2 class=\"wp-block-heading\" id=\"closure\"><strong>Closure<\/strong><\/h2><p>The error 145 (HY000) in MySQL usually occurs due to corrupt database tables. You can follow the methods discussed above to repair the tables. One of the easiest methods to repair database tables without data loss is to use a professional MySQL repair tool, like <a href=\"https:\/\/www.stellarinfo.com\/mysql-repair.php\" target=\"_blank\" rel=\"noreferrer noopener\">Stellar Repair for MySQL<\/a>. It can fix corrupt MyISAM and InnoDB tables, and restore them to their original state. The tool can help fix complex corruption-related errors in MySQL database, including the error 145. It supports MySQL Server 8.x, 6.x, 5.x, 4.x, and 3.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You may encounter the &ldquo;error 145: Table &lsquo;\/dbname\/tablename&rsquo; is marked as crashed&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/\">Continue reading <span class=\"screen-reader-text\">Troubleshooting MySQL Error 145 (HY000)<\/span><\/a><\/p>\n","protected":false},"author":82,"featured_media":159876,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1048],"tags":[5670],"class_list":["post-159549","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql-repair","tag-mysql-error-145-hy000","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Troubleshooting MySQL Error 145 (HY000)<\/title>\n<meta name=\"description\" content=\"learn the causes and methods to fix MySQL error 145(HY000): Table is marked as crashed and should be repaired.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Troubleshooting MySQL Error 145 (HY000)\" \/>\n<meta property=\"og:description\" content=\"learn the causes and methods to fix MySQL error 145(HY000): Table is marked as crashed and should be repaired.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-17T07:13:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-17T08:08:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/Troubleshooting-MySQL-Error-145-HY000-1-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Monika Dadool\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Monika Dadool\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/\"},\"author\":{\"name\":\"Monika Dadool\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd\"},\"headline\":\"Troubleshooting MySQL Error 145 (HY000)\",\"datePublished\":\"2024-01-17T07:13:27+00:00\",\"dateModified\":\"2024-01-17T08:08:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/\"},\"wordCount\":898,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/Troubleshooting-MySQL-Error-145-HY000-1-1.jpg\",\"keywords\":[\"Mysql ERROR 145 (HY000)\"],\"articleSection\":[\"MySQL Database Repair\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/\",\"name\":\"Troubleshooting MySQL Error 145 (HY000)\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/Troubleshooting-MySQL-Error-145-HY000-1-1.jpg\",\"datePublished\":\"2024-01-17T07:13:27+00:00\",\"dateModified\":\"2024-01-17T08:08:26+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd\"},\"description\":\"learn the causes and methods to fix MySQL error 145(HY000): Table is marked as crashed and should be repaired.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/Troubleshooting-MySQL-Error-145-HY000-1-1.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/Troubleshooting-MySQL-Error-145-HY000-1-1.jpg\",\"width\":1000,\"height\":600,\"caption\":\"Troubleshooting MySQL Error 145 HY000 1 (1)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Troubleshooting MySQL Error 145 (HY000)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/\",\"name\":\"Stellar Data Recovery Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd\",\"name\":\"Monika Dadool\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7d22d2cc256776033dcf284e9c6b96fcf19473429aa25ea91b3f7561ae5e8b7a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7d22d2cc256776033dcf284e9c6b96fcf19473429aa25ea91b3f7561ae5e8b7a?s=96&d=mm&r=g\",\"caption\":\"Monika Dadool\"},\"description\":\"Monika Dadool is a Senior Content Writer at Stellar with over 5 years of experience in technical writing. She is a tech enthusiast and expert who specializes in writing about SQL Server, MySQL Server, MariaDB Server, Microsoft Access, Active Directory, email recovery, Microsoft 365, pattern recognition, machine learning, data recovery, file repair, and operating systems like Linux, Windows, and Mac. She also writes about accounting software such as QuickBooks and Sage 50, as well as web-scripting languages like HTML, JavaScript, Python, PHP, Visual Basic, ASP.NET, and AJAX. Monika is passionate about researching and exploring new technologies, and she enjoys developing engaging technical blogs that help organizations and database administrators resolve various issues. When she's not creating content, you can find her on social media, watching web series, reading books, or exploring new food recipes.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/monika-dadool-105a87163\/\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/monika\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Troubleshooting MySQL Error 145 (HY000)","description":"learn the causes and methods to fix MySQL error 145(HY000): Table is marked as crashed and should be repaired.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/","og_locale":"en_US","og_type":"article","og_title":"Troubleshooting MySQL Error 145 (HY000)","og_description":"learn the causes and methods to fix MySQL error 145(HY000): Table is marked as crashed and should be repaired.","og_url":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2024-01-17T07:13:27+00:00","article_modified_time":"2024-01-17T08:08:26+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/Troubleshooting-MySQL-Error-145-HY000-1-1.jpg","type":"image\/jpeg"}],"author":"Monika Dadool","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Monika Dadool","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/"},"author":{"name":"Monika Dadool","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd"},"headline":"Troubleshooting MySQL Error 145 (HY000)","datePublished":"2024-01-17T07:13:27+00:00","dateModified":"2024-01-17T08:08:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/"},"wordCount":898,"commentCount":0,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/Troubleshooting-MySQL-Error-145-HY000-1-1.jpg","keywords":["Mysql ERROR 145 (HY000)"],"articleSection":["MySQL Database Repair"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/","url":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/","name":"Troubleshooting MySQL Error 145 (HY000)","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/Troubleshooting-MySQL-Error-145-HY000-1-1.jpg","datePublished":"2024-01-17T07:13:27+00:00","dateModified":"2024-01-17T08:08:26+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd"},"description":"learn the causes and methods to fix MySQL error 145(HY000): Table is marked as crashed and should be repaired.","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/Troubleshooting-MySQL-Error-145-HY000-1-1.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/01\/Troubleshooting-MySQL-Error-145-HY000-1-1.jpg","width":1000,"height":600,"caption":"Troubleshooting MySQL Error 145 HY000 1 (1)"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/troubleshooting-mysql-error-145-hy000\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Troubleshooting MySQL Error 145 (HY000)"}]},{"@type":"WebSite","@id":"https:\/\/www.stellarinfo.com\/blog\/#website","url":"https:\/\/www.stellarinfo.com\/blog\/","name":"Stellar Data Recovery Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd","name":"Monika Dadool","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7d22d2cc256776033dcf284e9c6b96fcf19473429aa25ea91b3f7561ae5e8b7a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7d22d2cc256776033dcf284e9c6b96fcf19473429aa25ea91b3f7561ae5e8b7a?s=96&d=mm&r=g","caption":"Monika Dadool"},"description":"Monika Dadool is a Senior Content Writer at Stellar with over 5 years of experience in technical writing. She is a tech enthusiast and expert who specializes in writing about SQL Server, MySQL Server, MariaDB Server, Microsoft Access, Active Directory, email recovery, Microsoft 365, pattern recognition, machine learning, data recovery, file repair, and operating systems like Linux, Windows, and Mac. She also writes about accounting software such as QuickBooks and Sage 50, as well as web-scripting languages like HTML, JavaScript, Python, PHP, Visual Basic, ASP.NET, and AJAX. Monika is passionate about researching and exploring new technologies, and she enjoys developing engaging technical blogs that help organizations and database administrators resolve various issues. When she's not creating content, you can find her on social media, watching web series, reading books, or exploring new food recipes.","sameAs":["https:\/\/www.linkedin.com\/in\/monika-dadool-105a87163\/"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/monika\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/159549","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/users\/82"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=159549"}],"version-history":[{"count":27,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/159549\/revisions"}],"predecessor-version":[{"id":159921,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/159549\/revisions\/159921"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/159876"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=159549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=159549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=159549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}