Deprecated: Function get_magic_quotes_gpc() is deprecated in /home/styllloz/public_html/qa-include/qa-base.php on line 1175

Warning: session_start(): Cannot start session when headers already sent in /home/styllloz/public_html/qa-include/app/users.php on line 162

Warning: Cannot modify header information - headers already sent by (output started at /home/styllloz/public_html/qa-include/qa-base.php:1175) in /home/styllloz/public_html/qa-include/app/users.php on line 1267

Warning: Cannot modify header information - headers already sent by (output started at /home/styllloz/public_html/qa-include/qa-base.php:1175) in /home/styllloz/public_html/qa-include/app/page.php on line 356
How to save data after editing config MySQL - code-flow.club | Q&A

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
10 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 | 10 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
35,181 users