مشکل در بک آپ گرفتن دایرکت ادمین از یوزر ویبولتین

[OmidX]

ریست هم کردم ولی باز نشد

با دستور زیر خواستم ریپیر کنم:

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

از این دستور استفاده کنید :

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

[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

نتایج به این شکل بود

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

[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

این دستور رو که زدم الان از قسمت admin فقط از یوزر forum که بک آپ میگیرم باز همون ارر اولی رو میده

منتها داخل یوزر که میرم و از اونجا بک آپ میگیرم بک آپ گرفته میشه

چیز دیگه ای که هست من رو سرور قبلیم آخرین بک آپی که گرفته بودم نزدیک 2.4 گیگ حجم همین یوزر بود ولی الان رو این سرور 1.48 گیگ شده همون یوزر بک آپش