Fix my mysql db
Project detail
We had a power failure and our db crashed
we tried
innodb_force_recovery from 1 to 6 but can still not get into the db
We need someone who can repair the db
Server version: 5.5.68-MariaDB
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=0
max_threads=153
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 466719 K bytes of memory
Hope that’s ok; if not, decrease some variables in the equation.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong…
stack_bottom = 0x0 thread_stack 0x48000
/usr/libexec/mysqld(my_print_stacktrace+0x3d)[0x5609fe233cad]
/usr/libexec/mysqld(handle_fatal_signal+0x515)[0x5609fde47975]
sigaction.c:0(__restore_rt)[0x7febd541c630]
:0(__GI_raise)[0x7febd3b43387]
:0(__GI_abort)[0x7febd3b44a78]
/usr/libexec/mysqld(+0x63845f)[0x5609fdfdc45f]
/usr/libexec/mysqld(+0x638f69)[0x5609fdfdcf69]
/usr/libexec/mysqld(+0x73b504)[0x5609fe0df504]
/usr/libexec/mysqld(+0x730487)[0x5609fe0d4487]
/usr/libexec/mysqld(+0x63b17d)[0x5609fdfdf17d]
/usr/libexec/mysqld(+0x62f0f6)[0x5609fdfd30f6]
pthread_create.c:0(start_thread)[0x7febd5414ea5]
/lib64/libc.so.6(clone+0x6d)[0x7febd3c0bb0d]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
230527 18:29:17 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended