• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
sharadchhetri

sharadchhetri

Tutorials On Linux, Unix & Open Source

  • Home
  • Linux Commands
  • Resources
    • Learn Linux
  • My WordPress plugins

mysqldump: Got error: 145: Table ‘./DB/table-name’ is marked as crashed

July 1, 2014 by Sharad Chhetri Leave a Comment

It was time to take backup of mysql database of my server. I run the command mysqldump with some options and found the error, ” mysqldump: Got error: 145: Table ‘./DB/table-name’ is marked as crashed and should be repaired when using LOCK TABLES ”

I have seen this error before but not written on this blog.

To solve this issue, simply repair the table which is causing issue. In error, it is clearly stated with database name and table name.

Login into MySQL Database Server

mysql -u root -p

Go to Database Name of concerned table

After login into MySQL Server.Go to database name which table has issue

Write the below given command on mysql prompt

mysql > use database-name;

Check and Repair the table

Run below given command on mysql prompt to check and repair the table

mysql> check table table-name;

mysql> repair table table-name;

mysql > exit;

Exit from mysqlserver and try once again taking backup by using mysqldump command.
I hope the issue is solved.

Share this:

  • Twitter
  • Facebook
  • More
  • Print
  • Email
  • LinkedIn
  • Reddit
  • Tumblr
  • Pinterest
  • Pocket
  • Telegram
  • WhatsApp
  • Mastodon

Related posts:

  1. mysqldump Error Binlogging on server not active
  2. How to copy existing table in mysql
  3. How to rename table in mysql using command line
  4. How to know storage engine of mysql table
  5. fatal error: error writing to /tmp/ccwAjc9Z.s: No space left on device
  6. error: The requested URL returned error: 403 Forbidden while accessing Github repo
  7. dlopen(): error loading libfuse.so.2 – Got Error On Ubuntu
  8. plugins/python/uwsgi_python.h:2:20: fatal error: Python.h: No such file or directory
  9. error command ‘gcc’ failed with exit status 1 in Ubuntu
  10. sshd error could not load host key

Filed Under: Linux, mysql Tagged With: mysql, mysqldump

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Our Social Media Presence

  • Facebook
  • GitHub
  • Twitter

Linux Command

What is Linux Internal And External Command

Linux Basic Commands With Examples For Every Beginner

tr command to convert lines to space , tab and vertical tab

smbpasswd command not found on CentOS 7 and RHEL 7

Solution : semanage command not found

Unix / Linux : How to print duplicate lines from file

More Posts from this Category

You Might Like These Articles!

simplecodesyntax wordpress plugin

SimpleCodeSyntax : My Another WordPress Plugin

Install Nginx

How To Install Nginx On Ubuntu 22.04 LTS

Install Latest Git package in Ubuntu Operating System

How To Always Install Latest Git Package In Ubuntu Operating System

Bash script for installing VirtualBox on Ubuntu 22.04 LTS Desktop

Install VirtualBox On Ubuntu 22.04 LTS Desktop (Bash Script)

libfuse

dlopen(): error loading libfuse.so.2 – Got Error On Ubuntu

Failed to open/create the internal network

VirtualBox Error: Failed to open/create the internal network

Always Useful Tips And Tricks

Yum Error database disk image is malformed

Nagios HTTP WARNING: HTTP/1.1 403 Forbidden

rsync all files,hidden files,symlinks,hardlinks to remotes Linux Server

Learn Linux Date Command With Examples

Install libjpegtran by using yum command in CentOS 6.x

set and unset line number in file with vi editor

How to see line numbers in file through cat command

Explore 90+ Article On "Linux Tips And Tricks"

Copyright © 2023 ยท
The material in this site cannot be republished either online or offline, without our permission.
Proudly Blogging From Bharat.

  • Contact
  • About Me
  • My WordPress plugins
  • Privacy Policy