{"id":11445,"date":"2021-12-08T04:01:40","date_gmt":"2021-12-08T04:01:40","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=11445"},"modified":"2021-12-08T04:02:01","modified_gmt":"2021-12-08T04:02:01","slug":"solved-mysql-database-5-0-will-not-start-up","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/dbase\/mysql-database-50-will-not-start-up\/1555.html","title":{"rendered":"Solved MySQL Database (5.0) Will Not Start Up"},"content":{"rendered":"<p>The data is held in a single large file named ibdata1, and the file seems to have grown too large. This database is held on a Windows 2003 Server. I need someone to tell me how to extract the data from the large datafile without starting the database OR extend the allowed size for the file on Windows so that I can start db.<\/p>\n<p>Starting the db from a command window, I get:<\/p>\n<p>&gt;&gt; CMD window &gt;&gt;<br \/>\nC:\\Program Files\\MySQL\\MySQL Server 5.0\\bin&gt;mysql<br \/>\nERROR 2003 (HY000): Can&#8217;t connect to MySQL server on &#8216;localhost&#8217; (10061)<br \/>\n&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;<\/p>\n<p>error file is found at bottom of file<br \/>\nC:\\Program Files\\MySQL\\MySQL Server 5.0\\data\\PARADIGM.err<br \/>\n091024 15:33:24 InnoDB: Operating system error number 23 in a file operation.<br \/>\nInnoDB: Some operating system error numbers are described at<br \/>\nInnoDB: <a href=\"https:\/\/web.archive.org\/web\/20160615015552\/http:\/\/dev.mysql.com\/doc\/mysql\/en\/Operating_System_error_codes.html\" target=\"_blank\" rel=\"nofollow noopener\">http:\/\/dev.mysql.com\/doc\/mysql\/en\/O&#8230;<\/a><br \/>\nInnoDB: File name .\\ibdata1<br \/>\nInnoDB: File operation call: &#8216;Windows aio&#8217;.<br \/>\nInnoDB: Cannot continue operation.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":26},"question-category":[51],"question_tags":[],"class_list":["post-11445","question","type-question","status-publish","hentry","question-category-dbase"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/11445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=11445"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=11445"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=11445"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=11445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}