How to save data after editing config MySQL


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
7 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 | 7 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
0 like 0 dislike
1 answer
0 like 0 dislike
2 answers
0 like 0 dislike
1 answer
110,608 questions
257,186 answers
0 comments
28,158 users