{"id":137003,"date":"2023-05-31T04:01:20","date_gmt":"2023-05-31T04:01:20","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=137003"},"modified":"2024-01-04T05:15:12","modified_gmt":"2024-01-04T05:15:12","slug":"fix-mysql-error-145","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/","title":{"rendered":"How to Fix MySQL Error 145?"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p>MySQL, developed by Oracle, is nowadays one of most popular database management systems (DBMS). It is written in C\/C++ language and is an open-source software. You can access the data stored in the database using the SQL language. In fact, MySQL supports ANSI\/ISO SQL standards.<\/p><p>Like any other DBMS, where software operates by reading and writing data on disk, data may get corrupt or damaged in MySQL.<\/p><p><strong>The common causes that can result in data corruption or damage in MySQL include:<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Sudden system <strong>shutdown <\/strong>due to a power failure.<\/li>\n\n\n\n<li><strong>Virus or malware<\/strong> infection.<\/li>\n\n\n\n<li><strong>Hardware <\/strong>malfunction, such as <strong>disk failure<\/strong> or network failure.<\/li>\n\n\n\n<li>Software malfunction, such as <strong>software bug<\/strong> in the MySQL engine.<\/li>\n<\/ul><p>When the <a href=\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-mysql-database-corruption\/\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL database gets corrupted<\/a>, the data stored in the database becomes inaccessible and you&rsquo;ll encounter the <strong>MySQL error code 145<\/strong>.<\/p><p><strong>Let&rsquo;s discuss how to fix the MySQL error code 145 and recover the data.<\/strong><\/p><h2 class=\"wp-block-heading\" id=\"methods-to-fix-mysql-error-145\"><strong>Methods to Fix MySQL Error 145<\/strong><\/h2><p>It is said that prevention is the best solution. Therefore, it is always recommended to make copies of the data (backup) and verify that these are working fine (test restore). In case of such errors or data corruption, you can rely on the backups to restore the data.<\/p><p>However, if you cannot count on a backup, then follow the given methods.<strong><\/strong><\/p><h2 class=\"wp-block-heading\" id=\"method-1:-use-mysql-tools\"><strong>Method 1: Use MySQL Tools<\/strong><\/h2><p>MySQL provides some commands that allow you to restore the data. However, you must be careful while executing these commands as a small error can make the entire database unreadable. Always remember to make a copy of the data first.<\/p><p>You can use the <strong>myisamchk <\/strong>command, if your database uses MyISAM tables (and not the newer InnoDB tables). This command will get information about the tables.<\/p><p>To use this command, you need to specify an option followed by the table name (see below).<\/p><pre class=\"wp-block-code command_container\"><code><strong>myisamchk [<em>options<\/em>] &lt;tablename&gt;<\/strong><\/code><\/pre><p>Many options are available but by specifying the -recover option, you can perform repair on a single table. You can also type &ldquo;<em>&ndash;r<\/em>&rdquo; instead of &ldquo;<em>&ndash;recover<\/em>&rdquo;.<\/p><p>This will fix any problem, except problems related to unique keys that are not unique due to a problem.<\/p><p>You can type:<\/p><pre class=\"wp-block-code command_container\"><code><strong>Myisamchk &ndash;r &lt;<\/strong><strong> tablename<\/strong><strong> &gt;<\/strong><\/code><\/pre><p><strong><em>Note:<\/em><\/strong><em> Stop the MySQL service before recovering a table.<\/em><\/p><p>After the recovery process, you can check if the table is fine. To perform this operation, you can use the <strong>check table<\/strong> command as given below.<\/p><pre class=\"wp-block-code command_container\"><code><strong>Check table &lt;tablename&gt; [, <em>tablename2, etc. etc.<\/em>] ... [<em>option<\/em>]<\/strong><\/code><\/pre><p>The parameter option may have the following values: FOR UPGRADE, QUICK, FAST, MEDIUM, EXTENDED, or CHANGED.<\/p><p>For example, you can type:<\/p><pre class=\"wp-block-code command_container\"><code><strong>Check table &lt;<\/strong><strong>mytable&gt;<\/strong><strong> FAST QUICK;<\/strong><\/code><\/pre><h2 class=\"wp-block-heading\" id=\"method-2:-use-a-mysql-database-repair-software\"><strong>Method 2: Use a MySQL Database Repair Software<\/strong><\/h2><p>If the recovery is not possible with the above MySQL tools, then you can use a powerful MySQL database repair software, such as <strong>Stellar Repair for MySQL,<\/strong> especially developed to recover data from <a href=\"https:\/\/www.stellarinfo.com\/mysql-repair.php\" target=\"_blank\" rel=\"noreferrer noopener\">corrupt MySQL databases<\/a>. Here are its key features:<\/p><ul class=\"wp-block-list\">\n<li>Fixes corrupt MySQL database and restores all its objects.<\/li>\n\n\n\n<li>Recovers and saves tables, primary keys, views, triggers, etc. without modifying or deleting the original database.<\/li>\n\n\n\n<li>Supports MySQL 8.0.30 and lower versions, including MariaDB up to 10.8.<\/li>\n\n\n\n<li>Repairs InnoDB and MyISAM tables of MySQL database.<\/li>\n\n\n\n<li>Repairs MySQL and MariaDB databases created on Windows or Linux.<\/li>\n\n\n\n<li>Saves repaired files in MySQL, MariaDB, SQL Script, CSV, HTML, and XLS formats.<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"steps-to-use-the-stellar-repair-for-mysql\"><strong>Steps to use the Stellar Repair for MySQL<\/strong><\/h2><ul class=\"wp-block-list\">\n<li>Download the application directly from Stellar&rsquo;s website.<\/li>\n\n\n\n<li>When the executable, named StellarRepairforMySQL.exe, is in your download folder, double-click on it. Then, follow the wizard to install the application. It will take only a few minutes.<\/li>\n\n\n\n<li>Then, launch the software.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"716\" height=\"454\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image011.jpg\" alt=\"Stellar Repair for MySQL interface\" class=\"wp-image-137011 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image011.jpg 716w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image011-300x190.jpg 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image011-150x95.jpg 150w\" sizes=\"auto, (max-width: 716px) 100vw, 716px\" \/><\/figure><p>On the main window, you need to enter the path of the folder which contains database files. After that, press the OK button.<\/p><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"713\" height=\"380\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image012.jpg\" alt=\"path for Database files\" class=\"wp-image-137012 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image012.jpg 713w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image012-300x160.jpg 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image012-150x80.jpg 150w\" sizes=\"auto, (max-width: 713px) 100vw, 713px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>If data files are in use, you&rsquo;ll get a warning message saying, MySQL service must be stopped before proceeding with the recovery process.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"460\" height=\"186\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image013.png\" alt=\"MYSQL service\" class=\"wp-image-137013 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image013.png 460w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image013-300x121.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image013-150x61.png 150w\" sizes=\"auto, (max-width: 460px) 100vw, 460px\" \/><\/figure><p>A list of databases is shown. Press the Repair button.<\/p><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"298\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image014.png\" alt=\"Database List\" class=\"wp-image-137014 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image014.png 555w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image014-300x161.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image014-150x81.png 150w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>When the databases are repaired, you&rsquo;ll get the repair complete message.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"560\" height=\"296\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image016.png\" alt=\"Preview of Repair Database\" class=\"wp-image-137015 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image016.png 560w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image016-300x159.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image016-150x79.png 150w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Press the Save button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"616\" height=\"232\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image017.png\" alt=\"Saving Database\" class=\"wp-image-137016 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image017.png 616w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image017-300x113.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image017-150x56.png 150w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Choose in which format you want to save your recovered data. By default, the format selected is MySQL. Other formats such as MariaDB, HTML, SQL Script, CSV, and XLS are also available.<\/li>\n\n\n\n<li>Enter Host Name, Username, and Password, and press the Save button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"415\" height=\"283\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image018.png\" alt=\"Saving Database type\" class=\"wp-image-137017 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image018.png 415w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image018-300x205.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image018-150x102.png 150w\" sizes=\"auto, (max-width: 415px) 100vw, 415px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>At the end of the procedure, the following message will appear.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"385\" height=\"145\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image019.png\" alt=\"Completion of Database\" class=\"wp-image-137018 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image019.png 385w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image019-300x113.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/image019-150x56.png 150w\" sizes=\"auto, (max-width: 385px) 100vw, 385px\" \/><\/figure><h2 class=\"wp-block-heading\" id=\"to-conclude\"><strong>To Conclude<\/strong><\/h2><p>Error 145 in MySQL may occur due to corruption in the database. You can use the native MySQL utilities to repair the database and fix the error. Alternatively, you can use the <a href=\"https:\/\/www.stellarinfo.com\/mysql-repair.php\" target=\"_blank\" rel=\"noreferrer noopener\">Stellar Repair for MySQL<\/a> software, to repair the corrupt database. This application is quite powerful and extremely easy to use.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL, developed by Oracle, is nowadays one of most popular database management&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/\">Continue reading <span class=\"screen-reader-text\">How to Fix MySQL Error 145?<\/span><\/a><\/p>\n","protected":false},"author":85,"featured_media":137021,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1048],"tags":[1248,5094],"class_list":["post-137003","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql-repair","tag-corrupt-mysql-database","tag-mysql-error-145","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Fix MySQL Error 145 - Complete Troubleshooting Guide<\/title>\n<meta name=\"description\" content=\"Discover effective solutions to resolve MySQL Error 145 and prevent database issues. Follow our step-by-step troubleshooting guide for quick and reliable fixes.\" \/>\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\/fix-mysql-error-145\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fix MySQL Error 145 - Complete Troubleshooting Guide\" \/>\n<meta property=\"og:description\" content=\"Discover effective solutions to resolve MySQL Error 145 and prevent database issues. Follow our step-by-step troubleshooting guide for quick and reliable fixes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-31T04:01:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-04T05:15:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-fix-MYSQL-error-145.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=\"Bharat Bhushan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bharat Bhushan\" \/>\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\/fix-mysql-error-145\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/\"},\"author\":{\"name\":\"Bharat Bhushan\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a\"},\"headline\":\"How to Fix MySQL Error 145?\",\"datePublished\":\"2023-05-31T04:01:20+00:00\",\"dateModified\":\"2024-01-04T05:15:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/\"},\"wordCount\":754,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-fix-MYSQL-error-145.jpg\",\"keywords\":[\"Corrupt MySQL database\",\"mysql error 145\"],\"articleSection\":[\"MySQL Database Repair\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/\",\"name\":\"Fix MySQL Error 145 - Complete Troubleshooting Guide\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-fix-MYSQL-error-145.jpg\",\"datePublished\":\"2023-05-31T04:01:20+00:00\",\"dateModified\":\"2024-01-04T05:15:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a\"},\"description\":\"Discover effective solutions to resolve MySQL Error 145 and prevent database issues. Follow our step-by-step troubleshooting guide for quick and reliable fixes.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-fix-MYSQL-error-145.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-fix-MYSQL-error-145.jpg\",\"width\":1000,\"height\":600,\"caption\":\"Fix MYSQL error 145\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Fix MySQL Error 145?\"}]},{\"@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\/c2edd14c25759638c6a69f5aececf07a\",\"name\":\"Bharat Bhushan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8371107c793354293acf244b899d7bf7f4209ee58e4305f3b195241bd426ef12?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8371107c793354293acf244b899d7bf7f4209ee58e4305f3b195241bd426ef12?s=96&d=mm&r=g\",\"caption\":\"Bharat Bhushan\"},\"description\":\"Bharat Bhushan is an experienced technical Marketer working at Stellar Data Recovery - expertise in data care. He is skilled in Microsoft Exchange Database, MSSQL Database troubleshooting &amp; data warehousing. He is a Management Post Graduate having a strong grip in Technology &amp; certified in SAP-SD, Oracle 10g &amp; Informatica Powercenter 9.1.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/bharat-bhushan-311956144\/\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/bharat\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fix MySQL Error 145 - Complete Troubleshooting Guide","description":"Discover effective solutions to resolve MySQL Error 145 and prevent database issues. Follow our step-by-step troubleshooting guide for quick and reliable fixes.","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\/fix-mysql-error-145\/","og_locale":"en_US","og_type":"article","og_title":"Fix MySQL Error 145 - Complete Troubleshooting Guide","og_description":"Discover effective solutions to resolve MySQL Error 145 and prevent database issues. Follow our step-by-step troubleshooting guide for quick and reliable fixes.","og_url":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2023-05-31T04:01:20+00:00","article_modified_time":"2024-01-04T05:15:12+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-fix-MYSQL-error-145.jpg","type":"image\/jpeg"}],"author":"Bharat Bhushan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bharat Bhushan","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/"},"author":{"name":"Bharat Bhushan","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a"},"headline":"How to Fix MySQL Error 145?","datePublished":"2023-05-31T04:01:20+00:00","dateModified":"2024-01-04T05:15:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/"},"wordCount":754,"commentCount":0,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-fix-MYSQL-error-145.jpg","keywords":["Corrupt MySQL database","mysql error 145"],"articleSection":["MySQL Database Repair"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/","url":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/","name":"Fix MySQL Error 145 - Complete Troubleshooting Guide","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-fix-MYSQL-error-145.jpg","datePublished":"2023-05-31T04:01:20+00:00","dateModified":"2024-01-04T05:15:12+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a"},"description":"Discover effective solutions to resolve MySQL Error 145 and prevent database issues. Follow our step-by-step troubleshooting guide for quick and reliable fixes.","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-fix-MYSQL-error-145.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-fix-MYSQL-error-145.jpg","width":1000,"height":600,"caption":"Fix MYSQL error 145"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/fix-mysql-error-145\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Fix MySQL Error 145?"}]},{"@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\/c2edd14c25759638c6a69f5aececf07a","name":"Bharat Bhushan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8371107c793354293acf244b899d7bf7f4209ee58e4305f3b195241bd426ef12?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8371107c793354293acf244b899d7bf7f4209ee58e4305f3b195241bd426ef12?s=96&d=mm&r=g","caption":"Bharat Bhushan"},"description":"Bharat Bhushan is an experienced technical Marketer working at Stellar Data Recovery - expertise in data care. He is skilled in Microsoft Exchange Database, MSSQL Database troubleshooting &amp; data warehousing. He is a Management Post Graduate having a strong grip in Technology &amp; certified in SAP-SD, Oracle 10g &amp; Informatica Powercenter 9.1.","sameAs":["https:\/\/www.linkedin.com\/in\/bharat-bhushan-311956144\/"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/bharat\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/137003","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\/85"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=137003"}],"version-history":[{"count":12,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/137003\/revisions"}],"predecessor-version":[{"id":158623,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/137003\/revisions\/158623"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/137021"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=137003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=137003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=137003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}