ریستارت Mysql Server :
service mysqld restart
ریستارت 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
از این دستور استفاده کنید :
کد: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
...Zzzz...
نتایج به این شکل بود
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
این دستور رو که زدم الان از قسمت admin فقط از یوزر forum که بک آپ میگیرم باز همون ارر اولی رو میده
منتها داخل یوزر که میرم و از اونجا بک آپ میگیرم بک آپ گرفته میشه
چیز دیگه ای که هست من رو سرور قبلیم آخرین بک آپی که گرفته بودم نزدیک 2.4 گیگ حجم همین یوزر بود ولی الان رو این سرور 1.48 گیگ شده همون یوزر بک آپش
در حال حاضر 1 کاربر در حال مشاهده این موضوع است. (0 کاربران و 1 مهمان ها)