توجه ! این یک نسخه آرشیو شده میباشد و در این حالت شما عکسی را مشاهده نمیکنید برای مشاهده کامل متن و عکسها بر روی لینک مقابل کلیک کنید : مشکل The MySQL server is currently offline
renjo
May 2nd, 2014, 04:43
درود
دیتابیس ها کار میکنن و سایت ها بالا میان ولی کسی نمیتونه دیتابیس جدید بسازه
http://up.iranwebfa.ir/uploads/13989890977277_0Snapshot_2014-05-02_042920.png
http://up.iranwebfa.ir/uploads/13989894393295_0Snapshot_2014-05-02_043959.png
http://up.iranwebfa.ir/uploads/139898909720270_2mysql.png
به phpmyadmin هم نمیشه وصل شد
http://up.iranwebfa.ir/uploads/13989895503031_0Snapshot_2014-05-02_044217.png
یوزر و پسورد رو درست وارد میکنم ولی وارد نمیشه
cat /root/.my.cnf
لطفا راهنمایی کنید
nginxweb
May 2nd, 2014, 05:25
احتمالا سروریس mysql شما آسیب جدید دیده است باید لاگ های سرویس را بررسی کنید که طبق اون بتوان برای حل مشکل اقدام کرد
renjo
May 2nd, 2014, 05:28
اینم لاگ ها :
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2014-05-02 05:25:11 7ff7641cf700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2014-05-02 05:25:11 7ff7641cf700 InnoDB: Error: Fetch of persistent statistics requested for table "delavara_farshad"."gal_news" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2014-05-02 05:25:11 7ff7641cf700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2014-05-02 05:25:11 7ff7641cf700 InnoDB: Error: Fetch of persistent statistics requested for table "delavara_farshad"."tbl_forosh" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2014-05-02 05:25:11 7ff7641cf700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2014-05-02 05:25:11 7ff7641cf700 InnoDB: Error: Fetch of persistent statistics requested for table "delavara_farshad"."tbl_news" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2014-05-02 05:26:05 7ff76410c700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2014-05-02 05:26:05 7ff76410c700 InnoDB: Error: Fetch of persistent statistics requested for table "parpatog_30dbcms"."vbseo_serviceupdate" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2014-05-02 05:26:06 7ff76410c700 InnoDB: Error: page 4 log sequence number 338713869
InnoDB: is in the future! Current system log sequence number 260426482.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2014-05-02 05:26:06 7ff76410c700 InnoDB: Error: page 9 log sequence number 338713869
InnoDB: is in the future! Current system log sequence number 260426482.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2014-05-02 05:26:07 7ff764251700 InnoDB: Error: page 75 log sequence number 360742481
InnoDB: is in the future! Current system log sequence number 260426482.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
nginxweb
May 2nd, 2014, 05:31
اینم لاگ ها :
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2014-05-02 05:25:11 7ff7641cf700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2014-05-02 05:25:11 7ff7641cf700 InnoDB: Error: Fetch of persistent statistics requested for table "delavara_farshad"."gal_news" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2014-05-02 05:25:11 7ff7641cf700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2014-05-02 05:25:11 7ff7641cf700 InnoDB: Error: Fetch of persistent statistics requested for table "delavara_farshad"."tbl_forosh" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2014-05-02 05:25:11 7ff7641cf700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2014-05-02 05:25:11 7ff7641cf700 InnoDB: Error: Fetch of persistent statistics requested for table "delavara_farshad"."tbl_news" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2014-05-02 05:26:05 7ff76410c700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2014-05-02 05:26:05 7ff76410c700 InnoDB: Error: Fetch of persistent statistics requested for table "parpatog_30dbcms"."vbseo_serviceupdate" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2014-05-02 05:26:06 7ff76410c700 InnoDB: Error: page 4 log sequence number 338713869
InnoDB: is in the future! Current system log sequence number 260426482.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2014-05-02 05:26:06 7ff76410c700 InnoDB: Error: page 9 log sequence number 338713869
InnoDB: is in the future! Current system log sequence number 260426482.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2014-05-02 05:26:07 7ff764251700 InnoDB: Error: page 75 log sequence number 360742481
InnoDB: is in the future! Current system log sequence number 260426482.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
تیبل های اصلی innodb سرویس mysql سرورتون آسیب دیده و حذف شده اند این تقریبا بدترین مشکلی هستش که برای mysql میتونه ایجاد بشه...
renjo
May 2nd, 2014, 05:56
با این حل نمیشه ؟ InnoDB: Error: Table "mysql"."innodb_table_stats" not found after upgrade to mysql 5.6 - Database Administrators Stack Exchange (http://dba.stackexchange.com/questions/54608/innodb-error-table-mysql-innodb-table-stats-not-found-after-upgrade-to-mys)
- - - Updated - - -
به کمک آقای سنجری ( Yas-Host (http://www.webhostingtalk.ir/misc.php?do=wrtviewuser&u=61464) ) حل شد
Yas-Host
May 2nd, 2014, 09:30
با این حل نمیشه ؟ InnoDB: Error: Table "mysql"."innodb_table_stats" not found after upgrade to mysql 5.6 - Database Administrators Stack Exchange (http://dba.stackexchange.com/questions/54608/innodb-error-table-mysql-innodb-table-stats-not-found-after-upgrade-to-mys)
- - - Updated - - -
به کمک آقای سنجری ( Yas-Host (http://www.webhostingtalk.ir/misc.php?do=wrtviewuser&u=61464) ) حل شد
دوستانی که شبیه مشکل ایشون دارند از روش زیر برای حل استفاده کنند :