I'm using a debian system.I could not start my mysql after the partition went full - I received the messageERROR: The partition with /var/lib/mysql is too full!I found a recommendation to delete some of the data folders I don't need in /var/lib/mysql so I deleted the folder of an old DB i didn't need.Now when I tried to start the mysqld service again, I receive the following error:150218 10:09:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql150218 10:09:03 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full n$150218 10:09:03 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use$150218 10:09:03 [Note] Plugin 'FEDERATED' is disabled.150218 10:09:03 InnoDB: The InnoDB memory heap is disabled150218 10:09:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins150218 10:09:03 InnoDB: Compressed tables use zlib 1.2.7150218 10:09:03 InnoDB: Using Linux native AIO150218 10:09:03 InnoDB: Initializing buffer pool, size = 128.0M150218 10:09:03 InnoDB: Completed initialization of buffer pool150218 10:09:03 InnoDB: highest supported file format is Barracuda.InnoDB: Log scan progressed past the checkpoint lsn 20417554120150218 10:09:03  InnoDB: Database was not shut down normally!InnoDB: Starting crash recovery.InnoDB: Reading tablespace information from the .ibd files...InnoDB: Restoring possible half-written data pages from the doublewriteInnoDB: buffer...InnoDB: Doing recovery: scanned up to log sequence number 20419913007150218 10:09:03  InnoDB: Error: page 24667 log sequence number 20425339296InnoDB: is in the future! Current system log sequence number 20419913007.InnoDB: Your database may be corrupt or you may have copied the InnoDBInnoDB: tablespace but not the InnoDB log files. SeeInnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.htmlInnoDB: for more information.150218 10:09:03  InnoDB: Error: page 530914 log sequence number 20426394124InnoDB: is in the future! Current system log sequence number 20419913007.InnoDB: Your database may be corrupt or you may have copied the InnoDBInnoDB: tablespace but not the InnoDB log files. SeeInnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.htmlInnoDB: for more information.InnoDB: 1 transaction(s) which must be rolled back or cleaned upInnoDB: in total 6135 row operations to undoInnoDB: Trx id counter is 574E00150218 10:09:04  InnoDB: Starting an apply batch of log records to the database...InnoDB: Progress in percents: 150218 10:09:04  InnoDB: Error: page 248000 log sequence number 20425331738InnoDB: is in the future! Current system log sequence number 20419913007.InnoDB: Your database may be corrupt or you may have copied the InnoDBInnoDB: tablespace but not the InnoDB log files. SeeInnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.htmlI saw that I should start mysql while adding to the my.cnf the following commandinnodb_force_recovery = 1/2/3/4/5/6Starting from one, going up.Tried all of those but nothing.Does someone has any idea?
MySQL won't start
debian;mysql