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

3
By: aysadk
2020-10-30 11:52:20

What Others Think

Great, thanks! Useful when I need to [url=https://123homework.com/do-my-computer-science-homework/]do my computer science homework[/url].
RosieRosie · 4 weeks and 2 days ago
Great, thanks! Useful when I need to do my computer science homework.
RosieRosie · 4 weeks and 2 days ago
Nice Post, I love this post. Keep sharing eft dongle crack
Incracked · 4 weeks and 1 day ago
seful when I need to
mikestanley464 · 3 weeks and 4 days ago
nice
JunFritz01 · 2 weeks and 6 days ago
nice
JunFritz01 · 2 weeks and 6 days ago
guitar lessons san antonio Absolutely fantastic posting! Lots of useful information and inspiration, both of which we all need!Relay appreciate your work. With game, you can give a striking new look.
yeoyeo · 2 weeks and 6 days ago
a hit freelancers swear by exercises — washing your face, putting on real garments and placing smartphone boundaries — and those recommendations increase to ingesting. dietary therapist and longtime paintings-from-homer wilma macdonald told huffpost that snacking right here and there's the largest mistake she sees new far flung workers make. she recommends setting up your day like all everyday working day, with a lunch wreck, a few smaller breaks and a focus at the most important meal: breakfast. https://www.webcontentonline.com
webcontentonline · 2 weeks and 1 day ago
cbd effects
charlly · 1 week and 4 days ago
hooray! it's snowing! it's time to make a snowman.james runs out. he makes a large pile of snow. he places a huge snowball on top. he adds a headband and a hat. he adds an orange for the nostril. he adds coal for the eyes and buttons.within the night, james opens the door. what does he see? the snowman is transferring! james invitations him in. the snowman has by no means been interior a house. he says hey to the cat. he performs with paper towels.a moment later, the snowman takes james's hand and goes out.they move up, up, up into the air! they may be flying! what a terrific night time!the following morning, james jumps off the bed. he runs to the door.he desires to thank the snowman. however he is long past. https://www.businessmenuguide.com
businessmenugui · 1 week and 3 days ago
[url=https://www.businessmenuguide.com/photography]digital camera reviews[/url]
businessmenugui · 1 week and 3 days ago
https://www.bestproblog.com
businessmenugui · 1 week and 3 days ago
The book has a lot of knowledge, but not everyone wants to spend time writing an essay, and for this, I recommend you a wonderful site https://papernow.org/book-reports that will help you write any written work.
Shouressunt · 1 week ago
great book! bathroomremodelingmadisonwi.com
Killersmile · 6 days ago
Best Sharing https://getintopc.app/
untitleone2021 · 3 days ago
Best Sharing getintopc.app
untitleone2021 · 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



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: