How to save data after editing config MySQL

0 like 0 dislike
33 views
Corrected configs of MySQL on VPS. Immediately collapsed all the bases, MySQL swore to incorrect data in the frm files. I read that this is normal, I had to immediately adjust as needed, now only dump and import.
I'd like to ask knowledgeable how to restore database without much fuss? Manual dump 30+ databases and import then back somehow reluctant. Any advice?
by | 33 views

4 Answers

0 like 0 dislike
by
0 like 0 dislike
Well, you can manually and not by script. Because experience shows that REPAIR TABLE does not always work.
by
0 like 0 dislike
mysqlcheck database_name
try.
\r
About handmade... you Need to write a script, no more...
by
0 like 0 dislike
Corrected configs of MySQL on VPS. Immediately collapsed all the bases
\r
A good administrator, before to change something is to first backup.
A good rule — very often helped(!!!)...
by

Related questions

0 like 0 dislike
1 answer
How to make in a MySQL database did not change the date when editing the data?
asked Jun 3, 2019 by yagyar001
0 like 0 dislike
1 answer
How to organize the save options item when editing?
asked May 21, 2019 by alex-1917
0 like 0 dislike
2 answers
How to save html page after editing the chrome Developer tool?
asked Apr 13, 2019 by Paul_Morte
0 like 0 dislike
1 answer
How to fix MYSQL error when adding/editing categories?
asked May 21, 2019 by 97artur97

Most popular tags

javascript php css html jquery wordpress python linux web-development mysql android windows java layout c# computer-networks node.js cpp iron yii vue.js 1C-Bitrix react laravel django nginx system-administration search-engine-optimization api ubuntu the-it-education. ajax sql programming hosting cms design apache google-chrome bootstrap Vkontakte macos google network-administration git laptops algorithms regular-expressions unity-game-engine email angular database network-equipment software wooсommerce debian .net ios information-security video law-in-it browsers books parsing wi-fi game-development career htaccess postgresql telegram mikrotik mobile-development ruby-on-rails the-domain-name-system modx Yandex c json opencart Habr freelance vpn asp.net windows-server symfony bots hard-drives math qt DIY audio frontend payment-system bash electronics gulp.js user-interface docker online-shopping
110,608 questions
257,187 answers
0 comments
40,796 users