نمایش نسخه قابل چاپ
سلام
از یوزر انجمن که میخاد بک آپ بگیره این پیام رو میده :
کد:Error while backing up database forum_aaz
mysqldump error output: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `vb_post` at row: 585437
چطور میشه حلش کرد؟
کسی میدونه چطور میشه رفعش کرد؟
درود
وارد phpadmin بشید ببینید اروری مبنی بر سرور نمایان می شود که بعد از چند لحظه از بین برود؟
باسلام و عرض ادب
مورد ۱ و ۲ را تست کنید ببینید جواب میدهد:
https://ottomatik.groovehq.com/knowl...-dumping-table
روز خوش
نقل قول:
نوشته اصلی توسط jahromweb
تو این آدرس:
nano /etc/my.cnf
max-allowed-packet رو کردم 2 گیگ ولی باز همون ارر رو میده
کد:[mysqld]
# GENERAL #
user = mysql
default-storage-engine = InnoDB
# MyISAM #
key-buffer-size = 32M
myisam-recover = FORCE,BACKUP
# SAFETY #
max-allowed-packet = 2G
max-connect-errors = 1000000
# BINARY LOGGING #
expire-logs-days = 14
sync-binlog = 1
# CACHES AND LIMITS #
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 1
query-cache-size = 8M
max-connections = 500
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 10240
# INNODB #
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
#innodb-log-file-size = 128M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 2G
# LOGGING #
log-queries-not-using-indexes = 1
slow-query-log = 1
با سلام و عرض ادب
یکبار دیتابیس مورد نظر را از طریق SSH (دسترسی روت) Repair کنید و مجدد تست فرمایید.
max_allowed_packet
افزایش بدید مجدد تست کنید
نقل قول:
نوشته اصلی توسط a.e
دستوری که باید بزنم رو لطف کنید
10G گذاشتم این مقدار رو ولی باز ارر دادنقل قول:
نوشته اصلی توسط HPxf
کد:# SAFETY #
max-allowed-packet = 10G
max-connect-errors = 1000000
نتایج موجود در لینک مقابل را بررسی نمایید: https://www.google.com/?client=firef...8%AF%D8%B1+ssh
آموزش های زیادی برای این موضوع وجود دارد.
بعد از افزایش max_allowed_packet باید سرویس mysql رو ری استارت کنید.
ریستارت Mysql Server :
service mysqld restart
ریست هم کردم ولی باز نشد
با دستور زیر خواستم ریپیر کنم:
پسورد ازم خواست ولی بعد از اینکه وارد کردم این خطا رو داد:کد:mysqlcheck -u da_admin -p --auto-repair forum_aaz
کد:mysqlcheck: Got error: 1045: Access denied for user 'da_admin'@'localhost' (using password: YES) when trying to connect
خواستم با دستور زیر بک آپ بگیرم از sql با دستور زیر :
کد:mysqldump –opt -Q -u forum_aaz -p forum_aaz > forum_aaz.sql
ولی این خطا رو داد:
کد:mysqldump: Got error: 1044: Access denied for user 'forum_aaz'@'localhost' to database '.opt' when selecting the database
از این دستور استفاده کنید :نقل قول:
نوشته اصلی توسط Amin007
کد:mysqlcheck -u da_admin -p`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --auto-repair --all-databases ; mysqlcheck -uda_admin -p`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --optimize --all-databases
نقل قول:
نوشته اصلی توسط OmidX
نتایج به این شکل بود
table `vb_post` رو پیدا نکردم توش
کد:da_roundcube.cache OK
da_roundcube.cache_index OK
da_roundcube.cache_messages OK
da_roundcube.cache_shared OK
da_roundcube.cache_thread OK
da_roundcube.contactgroupmembers OK
da_roundcube.contactgroups OK
da_roundcube.contacts OK
da_roundcube.dictionary OK
da_roundcube.identities OK
da_roundcube.searches OK
da_roundcube.session OK
da_roundcube.system OK
da_roundcube.users OK
forum_aaz.vb_aaggregate_temp_1459753800
note : The storage engine for the table doesn't support check
forum_aaz.vb_access OK
forum_aaz.vb_action OK
forum_aaz.vb_activitystream OK
forum_aaz.vb_activitystreamtype OK
forum_aaz.vb_ad OK
forum_aaz.vb_adcriteria OK
forum_aaz.vb_adminhelp OK
forum_aaz.vb_administrator OK
forum_aaz.vb_adminlog OK
forum_aaz.vb_adminmessage OK
forum_aaz.vb_adminutil OK
forum_aaz.vb_album OK
forum_aaz.vb_albumupdate OK
forum_aaz.vb_announcement OK
forum_aaz.vb_announcementread OK
forum_aaz.vb_apiclient OK
forum_aaz.vb_apilog OK
forum_aaz.vb_apipost OK
forum_aaz.vb_attachment OK
forum_aaz.vb_attachmentcategory OK
forum_aaz.vb_attachmentcategoryuser OK
forum_aaz.vb_attachmentpermission OK
forum_aaz.vb_attachmenttype OK
forum_aaz.vb_attachmentviews OK
forum_aaz.vb_autosave OK
forum_aaz.vb_avatar OK
forum_aaz.vb_bbcode OK
forum_aaz.vb_bbcode_video OK
forum_aaz.vb_block OK
forum_aaz.vb_blockconfig OK
forum_aaz.vb_blocktype OK
forum_aaz.vb_blog OK
forum_aaz.vb_blog_attachmentlegacy OK
forum_aaz.vb_blog_category OK
forum_aaz.vb_blog_categorypermission OK
forum_aaz.vb_blog_categoryuser OK
forum_aaz.vb_blog_custom_block OK
forum_aaz.vb_blog_custom_block_parsed OK
forum_aaz.vb_blog_deletionlog OK
forum_aaz.vb_blog_editlog OK
forum_aaz.vb_blog_featured OK
forum_aaz.vb_blog_groupmembership OK
forum_aaz.vb_blog_grouppermission OK
forum_aaz.vb_blog_hash OK
forum_aaz.vb_blog_moderation OK
forum_aaz.vb_blog_moderator OK
forum_aaz.vb_blog_pinghistory OK
forum_aaz.vb_blog_rate OK
forum_aaz.vb_blog_read OK
forum_aaz.vb_blog_relationship OK
forum_aaz.vb_blog_search OK
forum_aaz.vb_blog_searchresult OK
forum_aaz.vb_blog_sitemapconf OK
forum_aaz.vb_blog_subscribeentry OK
forum_aaz.vb_blog_subscribeuser OK
forum_aaz.vb_blog_summarystats OK
forum_aaz.vb_blog_tachyentry OK
forum_aaz.vb_blog_text OK
forum_aaz.vb_blog_textparsed OK
forum_aaz.vb_blog_trackback OK
forum_aaz.vb_blog_trackbacklog OK
forum_aaz.vb_blog_user OK
forum_aaz.vb_blog_usercss OK
forum_aaz.vb_blog_usercsscache OK
forum_aaz.vb_blog_userread OK
forum_aaz.vb_blog_userstats OK
forum_aaz.vb_blog_views OK
forum_aaz.vb_blog_visitor OK
forum_aaz.vb_bookmarksite OK
forum_aaz.vb_cache OK
forum_aaz.vb_cacheevent OK
forum_aaz.vb_calendar OK
forum_aaz.vb_calendarcustomfield OK
forum_aaz.vb_calendarmoderator OK
forum_aaz.vb_calendarpermission OK
forum_aaz.vb_cms_article OK
forum_aaz.vb_cms_category OK
forum_aaz.vb_cms_grid OK
forum_aaz.vb_cms_layout OK
forum_aaz.vb_cms_layoutwidget OK
forum_aaz.vb_cms_navigation OK
forum_aaz.vb_cms_node OK
forum_aaz.vb_cms_nodecategory OK
forum_aaz.vb_cms_nodeconfig OK
forum_aaz.vb_cms_nodeinfo OK
forum_aaz.vb_cms_permissions OK
forum_aaz.vb_cms_rate OK
forum_aaz.vb_cms_sectionorder OK
forum_aaz.vb_cms_widget OK
forum_aaz.vb_cms_widgetconfig OK
forum_aaz.vb_cms_widgettype OK
forum_aaz.vb_contentpriority OK
forum_aaz.vb_contentread OK
forum_aaz.vb_contenttype OK
forum_aaz.vb_cpsession
note : The storage engine for the table doesn't support check
forum_aaz.vb_cron OK
forum_aaz.vb_cronlog OK
forum_aaz.vb_customavatar OK
forum_aaz.vb_customprofile OK
forum_aaz.vb_customprofilepic OK
forum_aaz.vb_datastore OK
forum_aaz.vb_dbquery OK
forum_aaz.vb_dbtech_dbseo_adminmessage OK
forum_aaz.vb_dbtech_dbseo_keyword OK
forum_aaz.vb_dbtech_dbseo_resolvedurl OK
forum_aaz.vb_dbtech_dbseo_sitemapbuildlog OK
forum_aaz.vb_dbtech_dbseo_sitemapdata OK
forum_aaz.vb_dbtech_dbseo_sitemaplog OK
forum_aaz.vb_dbtech_dbseo_sitemapurl OK
forum_aaz.vb_dbtech_dbseo_spiderlog OK
forum_aaz.vb_dbtech_dbseo_urlhistory OK
forum_aaz.vb_dbtech_usertag_hash OK
forum_aaz.vb_dbtech_usertag_hashsubscription OK
forum_aaz.vb_dbtech_usertag_mention OK
forum_aaz.vb_dbtech_usertag_quote OK
forum_aaz.vb_dbtech_usertag_settings OK
forum_aaz.vb_dbtech_usertag_tag OK
forum_aaz.vb_deletionlog OK
forum_aaz.vb_discussion OK
forum_aaz.vb_discussionread OK
forum_aaz.vb_editlog OK
forum_aaz.vb_event OK
forum_aaz.vb_externalcache OK
forum_aaz.vb_faq OK
forum_aaz.vb_filedata OK
forum_aaz.vb_force_read_guests OK
forum_aaz.vb_force_read_users OK
forum_aaz.vb_forum OK
forum_aaz.vb_forumpermission OK
forum_aaz.vb_forumprefixset OK
forum_aaz.vb_forumread OK
forum_aaz.vb_forumrunner_push_data OK
forum_aaz.vb_forumrunner_push_users OK
forum_aaz.vb_groupmessage OK
forum_aaz.vb_groupmessage_hash OK
forum_aaz.vb_groupread OK
forum_aaz.vb_holiday OK
forum_aaz.vb_humanverify OK
forum_aaz.vb_hvanswer OK
forum_aaz.vb_hvquestion OK
forum_aaz.vb_icon OK
forum_aaz.vb_imagecategory OK
forum_aaz.vb_imagecategorypermission OK
forum_aaz.vb_inactiveuserlog OK
forum_aaz.vb_indexqueue OK
forum_aaz.vb_infraction OK
forum_aaz.vb_infractionban OK
forum_aaz.vb_infractiongroup OK
forum_aaz.vb_infractionlevel OK
forum_aaz.vb_ipdata OK
forum_aaz.vb_language OK
forum_aaz.vb_mailqueue OK
forum_aaz.vb_moderation OK
forum_aaz.vb_moderator OK
forum_aaz.vb_moderatorlog OK
forum_aaz.vb_navigation OK
forum_aaz.vb_notice OK
forum_aaz.vb_noticecriteria OK
forum_aaz.vb_noticedismissed OK
forum_aaz.vb_package OK
forum_aaz.vb_passwordhistory OK
forum_aaz.vb_paymentapi OK
forum_aaz.vb_paymentinfo OK
forum_aaz.vb_paymenttransaction OK
forum_aaz.vb_phrase OK
forum_aaz.vb_phrasetype OK
forum_aaz.vb_picturecomment OK
forum_aaz.vb_picturecomment_hash OK
forum_aaz.vb_picturelegacy OK
forum_aaz.vb_plugin OK
forum_aaz.vb_pm OK
forum_aaz.vb_pmreceipt OK
forum_aaz.vb_pmtext OK
forum_aaz.vb_pmthrottle OK
forum_aaz.vb_podcast OK
forum_aaz.vb_podcastitem OK
forum_aaz.vb_poll OK
forum_aaz.vb_pollvote OK
mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'CHECK TABLE ... '
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to conn ect
نقل قول:
نوشته اصلی توسط OmidX
این دستور رو که زدم الان از قسمت admin فقط از یوزر forum که بک آپ میگیرم باز همون ارر اولی رو میده
منتها داخل یوزر که میرم و از اونجا بک آپ میگیرم بک آپ گرفته میشه
چیز دیگه ای که هست من رو سرور قبلیم آخرین بک آپی که گرفته بودم نزدیک 2.4 گیگ حجم همین یوزر بود ولی الان رو این سرور 1.48 گیگ شده همون یوزر بک آپش