Jump to content

soxis94

Inactive Member
  • Posts

    2
  • Joined

  • Last visited

  • Feedback

    0%

Posts posted by soxis94

  1. On 7/10/2022 at 10:24 AM, TMP4 said:

    MySQL 8.0 is not supported. You have to do several changes to make it usable. For start, I suggest this topic:

    Any questions please open a topic in q&a.

    Tnx for the reply, i've controlled source file, but in this release ([40250] Reference Serverfile + Client + Src [15 Available Languages] by @ TMP4)

    if i'm not wrong, the file are updated to mysql 8.0 or not ? because in the file game src the password function are not present. 

  2. Hi @ TMP4, i have a problem with the DB, when i start MySQL 8.0 on FreeBSD 13.1 x64:

     

    # service mysql-server start
    Starting mysql.
     # service mysql-server status
    mysql is not running.

     

    in my /var/db/mysql  *.err :

    Spoiler

    2022-05-13T15:58:26.6NZ mysqld_safe Logging to '/var/db/mysql/AwakenII.err'.
    2022-05-13T15:58:26.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
    2022-05-13T15:58:27.503003Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_load_tmpdir' is deprecated and will be removed in a future release. Please use replica_load_tmpdir instead.
    2022-05-13T15:58:27.503113Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
    2022-05-13T15:58:27.503182Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
    2022-05-13T15:58:27.503322Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
    2022-05-13T15:58:27.503703Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
    2022-05-13T15:58:27.503802Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_load_tmpdir' is deprecated and will be removed in a future release. Please use replica_load_tmpdir instead.
    2022-05-13T15:58:27.503891Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
    2022-05-13T15:58:27.503940Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
    2022-05-13T15:58:27.504068Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
    2022-05-13T15:58:27.504387Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
    2022-05-13T15:58:27.512483Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.29) starting as process 28069
    2022-05-13T15:58:27.645031Z 0 [Warning] [MY-000054] [Server] World-writable config file '/var/db/mysql/auto.cnf' is ignored.
    2022-05-13T15:58:27.646034Z 0 [Warning] [MY-010107] [Server] World-writable config file '/var/db/mysql/auto.cnf' has been removed.
    2022-05-13T15:58:27.647228Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 87008867-d2d5-11ec-92c9-dca632fa7384.
    2022-05-13T15:58:27.673038Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
    2022-05-13T15:58:27.673202Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
    2022-05-13T15:58:28.267872Z 1 [ERROR] [MY-012263] [InnoDB] The Auto-extending innodb_system data file '/var/db/mysql/ibdata1' is of a different size 1152 pages (rounded down to MB) than specified in the .cnf file: initial 8192 pages, max 0 (relevant if non-zero) pages!
    2022-05-13T15:58:28.268142Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
    2022-05-13T15:58:28.271297Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
    2022-05-13T15:58:28.272647Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
    2022-05-13T15:58:28.273443Z 0 [ERROR] [MY-010119] [Server] Aborting
    2022-05-13T15:58:28.287337Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.29)  Source distribution.
    2022-05-13T15:58:28.6NZ mysqld_safe mysqld from pid file /var/db/mysql/AwakenII.pid ended
     

     

    i can change the my.conf configuration for reduce the ibdata1 dimension to 18M but if i change this, return the error "Redo log is compatible for MySQL ver 5.7 bla bla bla..."

    Help me pleasee.
     

×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.