ช่วยด้วยครับ DirectAdmin Innodb Start ไม่ขึ้นครับ

ลองดู error แล้ว บอกว่าอย่างนี้ครับ ไม่ทราบพอมีใครเคยเจอปัญหานี้บ้างหรือเปล่าครับ

[FONT=Menlo][root@cs01 ~]# tail -n 50 /var/lib/mysql/xxxxxxxxx.err[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data![/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [ERROR] Plugin ‘InnoDB’ init function returned error.[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [ERROR] Unknown/unsupported storage engine: InnoDB[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [ERROR] Aborting[/FONT]
[FONT=Menlo]
[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Binlog end[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘partition’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘ARCHIVE’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘BLACKHOLE’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_FT_DELETED’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_METRICS’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_CMPMEM’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_CMP_RESET’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_CMP’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_LOCKS’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘INNODB_TRX’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘CSV’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘MEMORY’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘MRG_MYISAM’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘MyISAM’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘sha256_password’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘mysql_old_password’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘mysql_native_password’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] Shutting down plugin ‘binlog’[/FONT]
[FONT=Menlo]2015-09-20 16:48:07 32201 [Note] /usr/sbin/mysqld: Shutdown complete[/FONT]

InnoDB: Could not open or create the system tablespace.

HDD เต็ม

เช็ค hdd แล้วไม่เต็มครับ

แก้ไขได้เรียบร้อยแล้ว ขอบคุณครับ

แก้ไปท่าไหนครับ ใบ้ทีได้มั้ย
เผื่อท่านอื่นเจอเหมือนกัน จะได้เก็บไว้เป็นแนวทางครับ

ขอบคุณล่วงหน้าคร้าบ

อ้าว มาไม่ทัน

ได้ยินชื่อเสียงมา สมคำร่ำรือ ขอบคุณพี่ kke ด้วยครับ

ใช้ innobackupex ทำการ backup ก่อนครับ
จากนั้นลบ ibdata1 ib_logfile0 ib_logfile1
ใน /var/lib/mysql/ ออก แล้ว restart MySQL ใหม่
จากนั้น restore data เดิมกลับเข้าไปใหม่ครับ :slight_smile:

ปัญหาคือ ibdata ib_logfile มันไม่อยู่รอให้ backup น่ะสิครับ

ถ้าหายหมด คงต้องไปเอาใน backup ของ DA มาครับ น่าจะมีอยู่นะ :slight_smile: