Mysql not starting

[Fenczu 2]

Hello mysql not starting on vps

 

2023-11-13T00:02:16.6NZ mysqld_safe Logging to '/var/db/mysql/vps14159.awhost.cloud.err'.
2023-11-13T00:02:16.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2023-11-13T00:02:16.855194Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.42-log) starting as process 5996 ...
2023-11-13T00:02:16.881451Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-11-13T00:02:16.881484Z 0 [Note] InnoDB: Uses event mutexes
2023-11-13T00:02:16.881487Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-11-13T00:02:16.881489Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2023-11-13T00:02:16.881689Z 0 [Note] InnoDB: Number of pools: 1
2023-11-13T00:02:16.881744Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2023-11-13T00:02:16.883234Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M
2023-11-13T00:02:16.967538Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-13T00:02:16.994207Z 0 [ERROR] InnoDB: The Auto-extending innodb_system data file '/var/db/mysql/ibdata1' is of a different size 768 pages (rounded down to MB) than specified in the .cnf file: initial 8192 pages, max 0 (relevant if non-zero) pages!
2023-11-13T00:02:16.994234Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-11-13T00:02:17.201381Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-11-13T00:02:17.201416Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-11-13T00:02:17.201423Z 0 [ERROR] Failed to initialize builtin plugins.
2023-11-13T00:02:17.201427Z 0 [ERROR] Aborting

2023-11-13T00:02:17.201433Z 0 [Note] Binlog end
2023-11-13T00:02:17.201490Z 0 [Note] Shutting down plugin 'CSV'
2023-11-13T00:02:17.202848Z 0 [Note] /usr/local/libexec/mysqld: Shutdown complete

2023-11-13T00:02:17.6NZ mysqld_safe mysqld from pid file /var/db/mysql/vps14159.awhost.cloud.pid ended

 

[porexemplo 13]

What server are you using for db?

[Fenczu 2]

MySQL 5.7 

[kamil2321 11]

Why use 5.7? in FreeBSD 13.x still have a mysql56  just repleace FreeBSD.conf from latest to release_2 and pkg update.
And i recommend backup files in .sql or .sql.bz2 or copy all folder using metin2 and 3 files named ibdata ib_logfile1 ib_logfile2 and repleace. Dont replace folder mysql
and use command:
 

chown -R mysql:mysql /var/db/mysql; chgrp -R mysql /var/db/mysql

Dont use chmod 777, tutorial all its very bad. Maye I'll write someday tutorial 100% great and work.
I help you on AnyDesk if you want  

[dainz 1]

On 11/15/2023 at 5:25 PM, kamil2321 said:

Why use 5.7? in FreeBSD 13.x still have a mysql56  just repleace FreeBSD.conf from latest to release_2 and pkg update.
And i recommend backup files in .sql or .sql.bz2 or copy all folder using metin2 and 3 files named ibdata ib_logfile1 ib_logfile2 and repleace. Dont replace folder mysql
and use command:
 

chown -R mysql:mysql /var/db/mysql; chgrp -R mysql /var/db/mysql

Dont use chmod 777, tutorial all its very bad. Maye I'll write someday tutorial 100% great and work.
I help you on AnyDesk if you want  

@kamil2321 i have sam problem can help me

[kamil2321 11]

On 12/19/2023 at 8:53 AM, dainz said:

@kamil2321 i have sam problem can help me

You have mysql 56? yes i can help