Fenczu 2 Posted November 13, 2023 Share Posted November 13, 2023 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 Link to comment Share on other sites More sharing options...
porexemplo 13 Posted November 13, 2023 Share Posted November 13, 2023 What server are you using for db? Link to comment Share on other sites More sharing options...
Fenczu 2 Posted November 13, 2023 Author Share Posted November 13, 2023 MySQL 5.7 Link to comment Share on other sites More sharing options...
kamil2321 11 Posted November 15, 2023 Share Posted November 15, 2023 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 Link to comment Share on other sites More sharing options...
dainz 1 Posted December 19, 2023 Share Posted December 19, 2023 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 Link to comment Share on other sites More sharing options...
kamil2321 11 Posted December 21, 2023 Share Posted December 21, 2023 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now