永恒心锁 发表于 2024-4-27 10:45:02

【已完成】mysql 二进制日志第一次关闭后再开启就报错

mysql 二进制日志第一次关闭后再开启就报错。跟这个帖子一样的问题。
https://www.bt.cn/bbs/forum.php? ... 6%E6%97%A5%E5%BF%97

永恒心锁 发表于 2024-4-27 10:51:07


mysqld: File './mysql-bin.000023' not found (OS errno 13 - Permission denied)
Could not open log file.
Can't init tc log
Aborting

永恒心锁 发表于 2024-4-27 10:53:04

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA08AAAAjCAYAAABM4DGmAAAS+klEQVR4Ae1dyXIcxxEdf4Wu/gIdFDrh6E/gnVf8AO8KEdxJgAAhWSK4YiPOOtG2Fkf4Rh8o2T5QikCEIRAUqIBupCxiG6Wjtu6s6qrqmumeXgYPERPdU11L5stXlZldPY0BBf7uLC/Tzo+7dHxykvz5eO4S/XdnJ9BjheLtJZoZzNDSdoU+sqbbtDQzoMHs06wEJ0AACAABIDA9CPzy6+/To0yZJrX6x7LB4tfPFO5xKDpxtTf2kBwe0FhhWZW2nbBSQ0I8naXBzBLVEkY3JHKXhxmEhFtcukO3F5do4fYi3VpYoJvz83Tj5i26fuMmXb1+g65cu0aXr1yluctX6OKlyyQSp48uXpxI8vR0ts5kB8lTyOYoBwJAAAhMAwK9CRprALte/1hNoLOEezWkmmkNezSDM0Y5ewgEk6cuQLG9NEODwaDmbBnJUxdsCxmAABAAApNC4CwEjZPxj9UschZwr4ZQs61hj2bxxmhnB4FOJ09nxwzQFAgAASAABOpCAEFjXUiO1g9wHw2vSdeGPSaNMPo/qwggeTqrlofeQAAIAIEpRQBBYzuGBe7t4B4aFfYIIYNyIFANgcHzn4nwAQbgADgADoAD08KBb3Z+h19rwbcD926tIbBHt+wxLesr9CCSydMH7w2ko8EROIhJAR6AB+AB5kGf1wERNPZZ/r7OP+DerXUD9uiWPfo6ryF3kUcD42AEOPgAA3AAHAAHwIG+cwB33NvhMHBvB/fQfIU9umWPkJ1Q3j87BR/be/LkCW1ubtL6xgatra3T6uoqPX78mB4+ekQPHj6k+/cf0Mq9e3R3ZYVW19bor//8AckXElBwABwAB8CB1jmAoLGdYAS4t4N7KPiGPbplj5CdUN4/OwV3nkTitP/6NQ2HQ/k5HQ5Jfk6HdCo+wyG9ffuWtra2aGdnhzY2Nukvz1607jRBwv6REDaDzcABcKBODiBobIdPwL0d3ENzB/bolj1CdkJ5/+wU3HkSO077+/t0fHJCx8cndHR8rD5Hx3R4pM7fvHkjk6eDgwOZQK2tr9M/vj9AAoU7z+AAOAAOgAOtcQBBYzvBCHBvB/dQ8A17dMseITuhvH92Cu48iUf1ZPJ0zJInkTR5kqf5+XkSnzvLy/T3/+y15jDHJeDy+QENPlyiL0qCnbrrjSsv2vVvosFmsBk40BwHEDQ2hzXnNXAP4y7jh8EsLZfEGRzPquewR9geVbF9/vM2XfhwQINBymeGLjxjsmzN2jHnsyV633BDnrt9xnkjuHVui/VfG8eUju/PbafH9a5utckyCf3G7zO48yR+42SSJ3fXSew8HR4d0eHhEb3Tn5OTU1pcuoPkyUyohGSsdPIKErKJ6SVwY3We0jkmi5DLJ49yEGbiOwvGlE6iUjtC7/SFF1gBqxo4MFVBozeY8gRLji8YnH9qc0leLwZhX8zNSD9j1nN7DVdrublWttYl4e7I6e27sTrN+jWJbR2xQeIcKbdHmv7PS+2R2E8mt0k8inw0HFO89F0ftW1cNsN/Hmvx83BSouQIXzeBuRjfiYUEnpwHheSJ6y3a8++mX3aU9impk2HP2pWWjZ48CY5753TpWI5cpZxz6rP+pU3d9U9fd+1dbj//OMGdJ/FyiJ9++sl6XM/sOhWTp0MSydPtxSX6BjtPtsNiBjWLQtJREodNOO1ALVI2WKcwITSxuTyClJyIiqRMh3GxQLt6OAUcgeMZ4UB50Oh3iElrc9MYyrW/ZB3V63G2/pqEiwcQso4dYJlAImv3M1EhwPf5ngAGpbg36LNUwM9w8+hRv18zgb25gTjCkQfTAXxH5WeZPVL0rwtHLrvh3SCYFGgcOX81JqO2TdLRg7ecB57xcz1GsXXOw1x+Hzdm6MIW24WSciUkT3re8ngsl7PKWjdi8mTWHedGO09GzXlU1pR1wmOz53x8j+2kTTnn3HXT12egLLjzJN6q90okT/pRvXDidETv3qnkaeH2In3z75e9C1AkoAkLV2q96qT1Lxxy0mVyNlnHP/lK8dBE5o65OjZ+WdAvcAEHwAHDgbKg0dTrxdGT9Lhy+9ZiFaSxZMntJxA4+PqSZZ5gxJUjjnuTPitlLP988elv6Zns14QMedBs9SECMtcegSCt0G6EenF7pOg/ARwlfjN07rzY8WT85HrpOtajbuJ6lbas/zQbR2wn+1LYlMc3Dew8SWy2S396MjqXlI7RRCfD1V9XrENp7Q0fx+Mcj4/965WwQ3HHvpQLmX5GPnUM7jyJ15G/eqWSJ7XTpF4UIR/Xsx7ZO6TfdPJ0a2EhmDwZZdSCrjNunQhYZWwyhZSyyxUgJpstEFk7CHP9/bmn6jlV5gjs/myAONmyenrxNH26j0dk9dgEE3VCevIx5Lnu36+LntBN1gmQx9bTg1tIxkB/BRxQr3c3ImBDzzwAjxvn8ThBY2e5mxBk88DB6FEo4/1E1ubiuu4PZsw4/BjFPTSmlGs6/ZrAMhQ4SpxZHMJxrOs8ao/AumTZP8VmKf1kdfIAW8VD/uTJkqGWtva67O/f1MlljNtBz4uEXZaB77G9QjuNhcY8iy9lPXXNjiF9O1eBsrF5FteRc7uw3mi7iXJeL46pSZCLSY69A6rlyjYTjO3U0Tu3JK6ehJivixnX7P58Mgd3nsT/cdp79Uq+WS9Pno4Kv3USu04mebo5P09fB3aepDL8dzKcIJlhdSJkvvNFNVOKZ4/qnBtmeS5/8YMhGk9CjBw84YlPpBzErC03mNbDksF6AUVOvryOo2emmx4rZGRezs95e17Oz6vU4W3Nuew77BiyH1MaW5p2ODYeSPomPsryeQ0spg+LcYLGrvLA+DEeTHGfpuRWfiYr9639JkgoWbsL/tC0S1i7o7j7ZBJ98nJ+zsfj5fy8Sh3e1pzLvmv0a7I/X4IgYgBPIGfkqOkYtYdvDFf/FKxT+tF1OLcUr0PYFG1Qpa01t10dXflH4LvVr9tP9t1jazFGIY7kyRPHRbTn35tcr9W6kseuobE9Omr9x0uePHPD4uK4yVMxKQvzMKSrKg/uPIl/gLu3Z5InT9IkXhShEyeTPN24eYu+/teuNzjkxDeEk2UOKex6HsNxYutJkDmMjKxCOWHM4gT0BfX2mGHAfPIKXVzw7f78RnbbGEzkUeoYIo82fpN1LFyNs/O9oVDrqu+olE+4MNYWHu74+O6dY8AMfAIHFAdGDhp7tKYo3+EGAcrf8QQrfrc7HIwpP2ffwU5dy6O4N+mzUsZyba7jCSuolXWq+TWBp4uftGEDNxaj9kjRv0Yc3ZjH/Z6tXXJMm59uXfd7rG12TegbtLHxHZ6Y08WJf7cCetWHz96WDKK91NGeY9kjjLJPrn8fkieDX/EobOXyv4AHx3QczvH25nebnvml1jaGreGDk4dE5dNjBXee7q6s0N7ennyjnnirHn+znnzDHkucRPIk/h/U9Rs348mTo4xUhGffJhFhZXKSZN9dYrNFLaujjadBKSZWug2TxZaD9SmTgDyJsesxkjjGtusVxxOGCU7+bGLl42aG5BPVGXOidRgxldy+xInhoeubukUbFOtm8rOxUAacwAFwYBwOjBQ09nDN8foYKwAwfowFCtJniO/6muszNQ5234J/8frcPlHcm/RZKWMxuxtfVUycivPP1E32a9xvizEzOxT75ljWcR61R4r+deHo6UfhyPgp5fHES1XapujI6oxmGzPH3CQo9J3pKnTi809yRF/n51K2SPIk+mGxrOCMmL/J3OS6e8+VjmXJj1wzCo8hhnBg5RwDM77H3nIuuPPI1PccpTwOLmY+2bLO0rIcj9nG059py4/BnafP796ll3t72avIzSvJ3x0eWjtOInH632/vZPJ09foN+iq28+QoI5VwwJMTipdxwPg5V1CWa4OYtrqsSKLi5PTJwUEy58F6jrHtesXxRH/+hUMvpiHZ+ThN1pFY5wtFEdOwE5BYOHY3eOIYxg3YABtwYHwOpAaNfcXY8pMhX+CWW0GC3qky/pL5U9t/aRtw38PquvhFcXflMf3wvpus06RfMzrKN6l5bowaLGo+Ru2Ron+KPUr7yWMHe2eUBdEmRiiMV6WtWT/yPuKxi65nZInaIlxXzJ+yZEMmaXzuSb11AC+5wrBhv3my5pvBao6/KGKbvpAcqyuBUnqW6hPBSqxVI7U3ern/t8rMIf7/sgLjjhJ3WmtpoD8Ld10nuPP02Wef0+5LnjwVkyaTOJnk6cq1a/TVd5HH9hxS+hbpoiK58YrXzOTgC7whjXIORaNpp8Fk8cnhA0vWs+7uqXHd9vZ3/ySTunj6UuPmOnM5bP2brKNfXxuU17EDI6DEgmHN9cF5GDdgA2zAgfE5UB40jt93F+xirauhYMMtl8EHu8Oqr/vuXFt3xcV6nhi4xHFv0meljNWsX1M+PyGwZv6zKtfi9kjRf3I4+mIgO8YJz9FR2sq5khK7uPMlYgc5fuElYG7C43zXcZCSx7mW7drM0gXxf9d4YiV/gsLmrZQrFN9qzHQCFk8Ww/jmvPPbP79e3ofAqhiHx9r5x0zlhpDNWh8jdjS76uPgFNx5+vTPn9Huy5eFXSaRMJmPSJrMRzy2d/nKVfrqux+9v8fwKSPLLJLoHRmnTGXps3TuQ5MYaeCfLdE5/p+PnQVekdS+y6PKBtZWp08OHzl8bZVTseWy+1NEcB2UPfmLCV3BWfkmtqOveZ7XIkItdZR8Vr8FQoo69gRXOtrY+HBFWWwhwTXwAxwYlQNlQeOo/bVZf/m87cPUumqX2T5H8EX7He5LpS+w12jjv7h/SuqrsP4rjpbiXos/8iRzY/nHhvyaSVKlLbSvD74sQl/PbjiWfY+vDXF7pOifgnViPw5n7BhI6KH6SQm009umy1bsM45taE0Q8ydVB1lP8sPMZ1/iIHTg89YfU7ryBNeJjFsp+vnkSWmX1xFypOBhyV+6TnjWN8YvuYZ59LTX0ngfljysb1Me3Hn65NNPaXf3ZZYomYRJHlnSxJOnuctX6MtJJE96UmU/qGOKSJCyrN0QMDecfV2Quvqrypf1f2Q3W9BuUiHHzJyWn+j2RI3Vye9QuOMII6p+JlzHLP4Zzvl41o+SC/X4hM9tYsiHIzABB8CBSXAgHjT2DXPtH7L117+uur6AJ0QSY1/yJHypLM9/x+r6TOnnPIGIz24puLtyTqtfy/X02Iv5SjuwdGOBsu9xLkftwWQwsUx+tGOpXBfl+y2bjdAP54zqk2HjBswszuPtxHly2xFks+O2OK6uPPy76Me2qduXtmkWI5oXWczQhblZz/++4smTSgbtnSm3//y7mssGYzVuXLa8rdJpnDZ2H8JWo42p2kc557s5xPgi9fauWRo/vZaOI5exdXDnafmTT2h3dzdPnjwJk0mcxFHsPF28dJm+/Na/82QGHO/oLiC2cUbrs86+qsiBtqPZDXgBL3AAHEjjQDRoZE4WeKbhmYoTcDePwpUF0DnuKsC1n4ZJxbusXp/sEQ54c6xC+lZpG+ozWm5uOGQ3NPgN5cj5+aeRR8pEbMqSVj6GTgRkQsGTrtK1TMW7KtkViQPr32mb8XAMnWJYjZs8xfrswrXgztOd5WXa+XFXJkUiMUr5fDx3if727Y73sb1Kysq7B2Gjj9Y3kqfR8CpfuNAfMAIHwIEucaBPQWOXcKsqC3Dv1jrQG3voHSJrR8sJ7oPcrNI2dYxpqCeSsZESr25xOWj/lmwT3HlaXLpDtxeXaOH2It1aWCDxD3DF/3ESryMXb9UTL4cQv3ESj+qJHSeROH108eJEkqd67yogeeoaCSEPFilwAByokwO9CRpbcvx1Ys37Au7dmsewR7fswecKzvttm+DOUxcMmz3zWGu2jOSpC7aFDP1eOGA/2K/LHEDQ2A4/gXs7uIfmIuzRLXuE7ITy/tkp23n64L2BfNwOR+AgJjJ4AB6AB5gHfV0H/vTHP8CftbCOA/du+Q3Yo1v26Ot6CrmLPOr0zhOy8f5l47AZbAYOgANtcwB33NvhIHBvB/fQfIM9umWPkJ1Q3j87DQh/QAAIAAEgAASmCIFffv19irTpjyrAvVu2gj26ZQ9IMz0IIHmaHltCEyAABIAAECAiBI3t0AC4t4N7aFTYI4QMyoFANQSQPFXDD62BABAAAkCgYwggaGzHIMC9HdxDo8IeIWRQDgSqIRBMnp48eUKbm5u0vrFBa2vrtLq6So8fP6aHjx7Rg4cP6f79B7Ry7x7dXVmh1bU1+v77H6pJgtZAAAgAASAABGpAAEFjDSCO0QVwHwO0CTaBPSYILro+0wgEkyeROO2/fk3D4VB+TodDkp/TIZ2Kz3BIb9++pa2tLdrZ2aGNjU168eLFmQYTygMBIAAEgED7CCBobMcGwL0d3EOjwh4hZFAOBKohEEyexI7T/v4+HZ+c0PHxCR0dH6vP0TEdHqnzN2/eyOTp4OBAJlBr6+skzvEHBIAAEAACQKAtBBA0toM8cG8H99CosEcIGZQDgWoI/B/OpcYIX/k76wAAAABJRU5ErkJggg==

永恒心锁 发表于 2024-4-27 18:45:28

我已卸载重新安装,恢复数据,自己解决了。但这个问题,希望你们自己跟进修复一下。
页: [1]
查看完整版本: 【已完成】mysql 二进制日志第一次关闭后再开启就报错