reapair all mySQL/mariaDB databases

mysqlcheck --repair --all-databases -u root -p<PASSWORD>
while dumping database if you see following error/warning than you have to repair broken tables/rows
Sample Output 
hepsihaber.wp_commentmeta                          OK
hepsihaber.wp_comments                             OK
hepsihaber.wp_frm_fields                           OK
hepsihaber.wp_frm_forms                            OK
hepsihaber.wp_frm_item_metas                       OK
hepsihaber.wp_frm_items                            OK
hepsihaber.wp_hmwp_ms_intrusions                   OK
hepsihaber.wp_links                                OK
hepsihaber.wp_options
info     : Wrong aligned block at 54
info     : Delete link points outside datafile at 54
info     : Found row block followed by deleted block
warning  : Number of rows changed from 209 to 207

4
By: aysadk
2020-10-30 11:52:20
mysql database crash table repair
3
Submit An Alternative

What Others Think

seful when I need to
mikestanley464 · 271 weeks and 1 day ago
nice
JunFritz01 · 270 weeks and 3 days ago
nice
JunFritz01 · 270 weeks and 3 days ago

What do you think?

Any thoughts on this command? Does it work on your machine? Can you do the same thing with only 14 characters?

You must be signed in to comment.

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands

Similar Commands

Backup all MySQL Databases to individual files

Backup all MySQL Databases to individual files

Backup all MySQL Databases to individual files

Backup all MySQL Databases to individual files

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for: