Question mysql problem please help

[yamcell]

i have this error a lot and need to restore all database its possible any one guide me how fix without restore
thanks in advance

-- Unit mysql.service has begun starting up.
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.398977Z 0 [Warning] Could not increase number of max_open_file
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.399513Z 0 [Warning] Changed limits: max_connections: 4190 (req
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.399528Z 0 [Warning] Changed limits: table_open_cache: 400 (req
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.519766Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is d
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.519826Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.520172Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.34-0ubuntu0.18.0
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.555189Z 0 [Warning] option 'innodb-lock-wait-timeout': unsigne
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556037Z 0 [Warning] InnoDB: innodb_open_files should not be gr
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556136Z 0 [Note] InnoDB: PUNCH HOLE support available
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556163Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic b
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556184Z 0 [Note] InnoDB: Uses event mutexes
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556203Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() i
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556222Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556251Z 0 [Note] InnoDB: Using Linux native AIO
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.560811Z 0 [Note] InnoDB: Number of pools: 1
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.561143Z 0 [Note] InnoDB: Using CPU crc32 instructions
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.585025Z 0 [Note] InnoDB: Initializing buffer pool, total size
lines 1060-1082/1082 (END)

 

[Ian]

i have this error a lot and need to restore all database its possible any one guide me how fix without restore
thanks in advance

-- Unit mysql.service has begun starting up.
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.398977Z 0 [Warning] Could not increase number of max_open_file
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.399513Z 0 [Warning] Changed limits: max_connections: 4190 (req
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.399528Z 0 [Warning] Changed limits: table_open_cache: 400 (req
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.519766Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is d
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.519826Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.520172Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.34-0ubuntu0.18.0
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.555189Z 0 [Warning] option 'innodb-lock-wait-timeout': unsigne
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556037Z 0 [Warning] InnoDB: innodb_open_files should not be gr
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556136Z 0 [Note] InnoDB: PUNCH HOLE support available
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556163Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic b
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556184Z 0 [Note] InnoDB: Uses event mutexes
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556203Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() i
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556222Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.556251Z 0 [Note] InnoDB: Using Linux native AIO
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.560811Z 0 [Note] InnoDB: Number of pools: 1
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.561143Z 0 [Note] InnoDB: Using CPU crc32 instructions
Aug 11 21:07:07 PAR-261707 mysqld[13219]: 2021-08-11T19:07:07.585025Z 0 [Note] InnoDB: Initializing buffer pool, total size
lines 1060-1082/1082 (END)

I use a tool called Mysql administrator which is a very powerful tool try to use it to restore your backup.

When I didn't know I used navcat until I lost everything one day and started from scratch with this wonderful tool.

 

[urgodfather]

What did you do to cause this error?

 

[yamcell]

What did you do to cause this error?

InnoDB: innodb_open_files should not be greater than the open_files_limit