my database has been crashed since insufficient space, so I get more space and tried to restart MySQL, and I doesn`t start and shows this message
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
So, I typed systemctl status mysql.service and I got following.
â mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: activating (start-post) (Result: exit-code) since Sun 2018-01-28 16:07:57 UTC; 27s ago Process: 14481 ExecStart=/usr/sbin/mysqld (code=exited, status=3) Process: 14471 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 14481 (code=exited, status=3); : 14482 (mysql-systemd-s) Tasks: 2 Memory: 348.0K CPU: 281ms CGroup: /system.slice/mysql.service ââcontrol ââ14482 /bin/bash /usr/share/mysql/mysql-systemd-start post ââ14553 sleep 1 Jan 28 16:07:57 gorgeous-garden systemd[1]: mysql.service: Service hold-off time over, scheduling restart. Jan 28 16:07:57 gorgeous-garden systemd[1]: Stopped MySQL Community Server. Jan 28 16:07:57 gorgeous-garden systemd[1]: Starting MySQL Community Server... Jan 28 16:07:58 gorgeous-garden systemd[1]: mysql.service: Main process exited, code=exited, status=3/NOTIMPLEMENTED
Any suggestion how do I fix it?
Here is my mysql dblog
2018-01-28T16:20:03.878646Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_mailchimp_carts.ibd' with space ID 4478, since the redo log references ./mbateamsport_wp/wp_mailchimp_carts.ibd with space ID 4468. 2018-01-28T16:20:03.878668Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/#sql-ib14167-2600412909.ibd' with space ID 4478. Another data file called ./mbateamsport_wp/wp_mailchimp_carts.ibd exists with the same space ID. 2018-01-28T16:20:03.878695Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_mailchimp_carts.ibd' with space ID 4478, since the redo log references ./mbateamsport_wp/wp_mailchimp_carts.ibd with space ID 4468. 2018-01-28T16:20:03.878716Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/#sql-ib14167-2600412909.ibd' with space ID 4478. Another data file called ./mbateamsport_wp/wp_mailchimp_carts.ibd exists with the same space ID. 2018-01-28T16:20:03.879150Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_masterslider_options.ibd' with space ID 4479, since the redo log references ./mbateamsport_wp/wp_masterslider_options.ibd with space ID 4472. 2018-01-28T16:20:03.879219Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_masterslider_options.ibd' with space ID 4479, since the redo log references ./mbateamsport_wp/wp_masterslider_options.ibd with space ID 4472. 2018-01-28T16:20:03.879242Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/#sql-ib14171-2600412911.ibd' with space ID 4479. Another data file called ./mbateamsport_wp/wp_masterslider_options.ibd exists with the same space ID. 2018-01-28T16:20:03.879269Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_masterslider_options.ibd' with space ID 4479, since the redo log references ./mbateamsport_wp/wp_masterslider_options.ibd with space ID 4472. 2018-01-28T16:20:03.879295Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/#sql-ib14171-2600412911.ibd' with space ID 4479. Another data file called ./mbateamsport_wp/wp_masterslider_options.ibd exists with the same space ID. 2018-01-28T16:20:03.879662Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4408. 2018-01-28T16:20:03.879705Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4481. 2018-01-28T16:20:03.879749Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4481. 2018-01-28T16:20:03.879792Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4481. 2018-01-28T16:20:03.880963Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2234459984327 2018-01-28T16:20:03.881150Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4481. 2018-01-28T16:20:03.881193Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4486. 2018-01-28T16:20:03.881297Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4481. 2018-01-28T16:20:03.881352Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4486. 2018-01-28T16:20:03.881385Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4481. 2018-01-28T16:20:03.881423Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4486. 2018-01-28T16:20:03.882006Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4486. 2018-01-28T16:20:03.882074Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4486. 2018-01-28T16:20:03.882098Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/#sql-ib14185-2600412923.ibd' with space ID 4488. Another data file called ./mbateamsport_wp/wp_popover_ip_cache.ibd exists with the same space ID. 2018-01-28T16:20:03.882124Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/wp_popover_ip_cache.ibd' with space ID 4488, since the redo log references ./mbateamsport_wp/wp_popover_ip_cache.ibd with space ID 4486. 2018-01-28T16:20:03.882146Z 0 [Note] InnoDB: Ignoring data file './mbateamsport_wp/#sql-ib14185-2600412923.ibd' with space ID 4488. Another data file called ./mbateamsport_wp/wp_popover_ip_cache.ibd exists with the same space ID. 2018-01-28T16:20:03.882269Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-01-28T16:20:03.882274Z 0 [Note] InnoDB: Starting crash recovery. 2018-01-28T16:20:03.882698Z 0 [ERROR] InnoDB: Tablespace 4448 was not found at ./mbateamsport_wp/#sql-ib14094-2600412855.ibd. 2018-01-28T16:20:03.882704Z 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace. 2018-01-28T16:20:03.882958Z 0 [ERROR] InnoDB: Cannot continue operation.
Thanks, in advance!!