cd /var/lib/mysql/ваша бд/
TABLE=$(ls -la | grep ibd | grep -Eo b_.+[^.]) && echo "$TABLE" | cut -d '.' -f 1mkdir /tmp/111
mysqldump -uroot dbhikvisionpro b_vote > /tmp/111/b_vote.sql 2>&1 || echo "b_vote $?"
mysqldump -uroot dbhikvisionpro b_vote_question > /tmp/111/b_vote_question.sql 2>&1 || echo "b_vote_question $?"
mysqldump -uroot dbhikvisionpro b_vote_user > /tmp/111/b_vote_user.sql 2>&1 || echo "b_vote_user $?"ps aux | grep mysqlkill -9 номер пидаmysqldump -uroot dbhikvisionpro b_abtest >> /tmp/alltables.sql
mysqldump -uroot dbhikvisionpro b_admin_notify >> /tmp/alltables.sql
mysqldump -uroot dbhikvisionpro b_admin_notify_lang >> /tmp/alltables.sql
mysqldump -uroot dbhikvisionpro b_adv_banner_2_country >> /tmp/alltables.sql
....mysql> use dbhikvisionpro
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
^[[ADatabase changed
mysql> drop tables b_xml_tree_import_1c;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 3
Current database: dbhikvisionpro
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysqld/mysqld.sock' (111)
ERROR:
Can't connect to the serverTABLE=$(ls -la | grep ibd | grep -Eo b_.+[^.ibd]) && echo "$TABLE"mysqldump -uroot dbhikvisionpro b_adv_banner_2_group > /tmp/111/b_adv_banner_2_group.sql || echo "b_adv_banner_2_group $?"
mysqldump -uroot dbhikvisionpro b_adv_banner_2_page > /tmp/111/b_adv_banner_2_page.sql || echo "b_adv_banner_2_page $?"
mysqldump -uroot dbhikvisionpro b_adv_banner_2_site > /tmp/111/b_adv_banner_2_site.sql || echo "b_adv_banner_2_site $?"
.......b_app_passwor 6
b_catalog_discount_con 6
b_catalog_loa 6
b_clouds_file_uploa 6
b_consent_fiel 6
b_form_crm_fiel 6
b_form_fiel 6
b_im_comman 6
b_lists_fiel 6
b_mail_filter_con 6
b_mail_message_u 6
b_report_visual_report_dashboar 6
b_rest_stat_metho 6
b_sale_basket_archive_packe 6
b_sale_loc_search_wor 6
b_sale_order_archive_packe 6
b_sale_order_roun 6
b_sender_message_fiel 6
b_sender_posting_rea 6
b_sender_posting_unsu 6
b_short_ur 6
b_user_fiel 6
b_user_profile_recor 6
b_xml_tree_import_1c 2