نوشته اصلی توسط
OmidX
از این دستور استفاده کنید :
کد:
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
نتایج به این شکل بود
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
پاسخ : مشکل در بک آپ گرفتن دایرکت ادمین از یوزر ویبولتین
پاسخ با نقل قول