بالا نیامدن mysql در کنترل پنل سی پنل

[mandana32]

سلام

متاسفانه mysql سرور ما تحت هیچ شرایطی بالا نمیاد

چطور میشه اطلاعات دیتابیس سایت ها رو از سرور خارج کرد ؟

در چه مسیری هستند ؟

ممنون میشم یکی کمک کنه

با تشکر

[m2n]

ارور چی نشون داده میشه؟

[mandana32]

داخل سی پنل که ری استارت mysql میزنم اینجوری میشه :


Restarting MySQL Server Waiting for “mysqld” to start ……[2018-11-21 15:10:03 +0330] warn [restartsrv_mysql] The system encountered an error while starting the “mysqld” service with the command “/etc/init.d/mysqld start”: The subprocess reported error number 1 when it ended. at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 1403. Cpanel::ServiceManager::Base::warn(Cpanel::Service Manager::Services::Mysql=HASH(0x1f8c7d8), "The system encountered an error while starting the \x{e2}\x{80}\x{9c}mysqld\x{e2}"...) called at /usr/local/cpanel/Cpanel/ServiceManager/Manager/Initd.pm line 103 Cpanel::ServiceManager::Manager::Initd::start(Cpan el::ServiceManager::Manager::Initd=HASH(0x22fec68) , Cpanel::ServiceManager::Services::Mysql=HASH(0x1f8 c7d8)) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 848 Cpanel::ServiceManager::Base::start(Cpanel::Servic eManager::Services::Mysql=HASH(0x1f8c7d8)) called at /usr/local/cpanel/Cpanel/ServiceManager/Services/Mysql.pm line 60 Cpanel::ServiceManager::Services::Mysql::start(Cpa nel::ServiceManager::Services::Mysql=HASH(0x1f8c7d 8)) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 707 Cpanel::ServiceManager::Base::restart(Cpanel::Serv iceManager::Services::Mysql=HASH(0x1f8c7d8), "graceful", undef) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 540 Cpanel::ServiceManager::Base::run_from_argv(Cpanel ::ServiceManager::Services::Mysql=HASH(0x1f8c7d8), "--verbose", "--html", "--wait", "--verbose") called at bin/restartsrv_base.pl line 96 scripts::restartsrv_base::__ANON__() called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 99 eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 90 Try::Tiny::try(CODE(0x1f8c928), Try::Tiny::Catch=REF(0xb3ea58)) called at bin/restartsrv_base.pl line 130 scripts::restartsrv_base::run("--html", "--wait", "--verbose") called at bin/restartsrv_base.pl line 33 …Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. [2018-11-21 15:10:09 +0330] warn [restartsrv_mysql] The system encountered an error while starting the “mysqld” service with the command “/etc/init.d/mysqld start”: The subprocess reported error number 1 when it ended. at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 1403. Cpanel::ServiceManager::Base::warn(Cpanel::Service Manager::Services::Mysql=HASH(0x1f8c7d8), "The system encountered an error while starting the \x{e2}\x{80}\x{9c}mysqld\x{e2}"...) called at /usr/local/cpanel/Cpanel/ServiceManager/Manager/Initd.pm line 103 Cpanel::ServiceManager::Manager::Initd::start(Cpan el::ServiceManager::Manager::Initd=HASH(0x22fec68) , Cpanel::ServiceManager::Services::Mysql=HASH(0x1f8 c7d8)) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 848 Cpanel::ServiceManager::Base::start(Cpanel::Servic eManager::Services::Mysql=HASH(0x1f8c7d8)) called at /usr/local/cpanel/Cpanel/ServiceManager/Services/Mysql.pm line 60 Cpanel::ServiceManager::Services::Mysql::start(Cpa nel::ServiceManager::Services::Mysql=HASH(0x1f8c7d 8)) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 707 Cpanel::ServiceManager::Base::restart(Cpanel::Serv iceManager::Services::Mysql=HASH(0x1f8c7d8), "graceful", undef) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 540 Cpanel::ServiceManager::Base::run_from_argv(Cpanel ::ServiceManager::Services::Mysql=HASH(0x1f8c7d8), "--verbose", "--html", "--wait", "--verbose") called at bin/restartsrv_base.pl line 96 scripts::restartsrv_base::__ANON__() called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 99 eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 90 Try::Tiny::try(CODE(0x1f8c928), Try::Tiny::Catch=REF(0xb3ea58)) called at bin/restartsrv_base.pl line 130 scripts::restartsrv_base::run("--html", "--wait", "--verbose") called at bin/restartsrv_base.pl line 33 …Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. [2018-11-21 15:10:15 +0330] warn [restartsrv_mysql] The system encountered an error while starting the “mysqld” service with the command “/etc/init.d/mysqld start”: The subprocess reported error number 1 when it ended. at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 1403. Cpanel::ServiceManager::Base::warn(Cpanel::Service Manager::Services::Mysql=HASH(0x1f8c7d8), "The system encountered an error while starting the \x{e2}\x{80}\x{9c}mysqld\x{e2}"...) called at /usr/local/cpanel/Cpanel/ServiceManager/Manager/Initd.pm line 103 Cpanel::ServiceManager::Manager::Initd::start(Cpan el::ServiceManager::Manager::Initd=HASH(0x22fec68) , Cpanel::ServiceManager::Services::Mysql=HASH(0x1f8 c7d8)) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 848 Cpanel::ServiceManager::Base::start(Cpanel::Servic eManager::Services::Mysql=HASH(0x1f8c7d8)) called at /usr/local/cpanel/Cpanel/ServiceManager/Services/Mysql.pm line 60 Cpanel::ServiceManager::Services::Mysql::start(Cpa nel::ServiceManager::Services::Mysql=HASH(0x1f8c7d 8)) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 707 Cpanel::ServiceManager::Base::restart(Cpanel::Serv iceManager::Services::Mysql=HASH(0x1f8c7d8), "graceful", undef) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 540 Cpanel::ServiceManager::Base::run_from_argv(Cpanel ::ServiceManager::Services::Mysql=HASH(0x1f8c7d8), "--verbose", "--html", "--wait", "--verbose") called at bin/restartsrv_base.pl line 96 scripts::restartsrv_base::__ANON__() called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 99 eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 90 Try::Tiny::try(CODE(0x1f8c928), Try::Tiny::Catch=REF(0xb3ea58)) called at bin/restartsrv_base.pl line 130 scripts::restartsrv_base::run("--html", "--wait", "--verbose") called at bin/restartsrv_base.pl line 33 …failed.

Cpanel::Exception::Services::StartError Service Status

Service Error
(XID pdddqz) The “mysqld” service failed to start.

Startup Log
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

Log Messages
2018-11-21T11:40:15.389274Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2018-11-21T11:40:09.246658Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2018-11-21T11:40:03.081451Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2018-11-21T11:36:22.282870Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

mysqld has failed. Contact your system administrator if the service does not automagically recover.

[هاست 97]

احتمالا درون فایل /etc/my.cnf محل ذخیره ارور را تعریف کرده اید
با دستور زیر ۵۰ خط آخر فایل ارور را بگذارید



tail -50 /مسیر فایل ارور

[mandana32]

احتمالا درون فایل /etc/my.cnf محل ذخیره ارور را تعریف کرده اید
با دستور زیر ۵۰ خط آخر فایل ارور را بگذارید



tail -50 /مسیر فایل ارور



سلام

داخل فایل کانفیگ مسیر ذخیره ارور نیست متاسفانه

[هاست 97]

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

[mandana32]

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

داخل خصوصی خدمتتون ارسال می کنم

[هاست 97]

حل شد.

[mandana32]

حل شد.


در عرض چند دقیقه مشکل را کامل حل کردند !

واقعا ازشون خیلی خیلی ممنونم

باعث افتخارمون هست که همشهری ما هستند امیدواریم ان شاالله موفق باشند.