mysql upgraden ?

[°Ace°]

Guten Tag Epvp,

ich habe eine neue Lua in meinem Server eingefügt, jedoch kommt beim starten folgendes raus:



und in Navicat:



Wie upgrade ich mein Mysql mit der selben DB Files?

Sobald in root "mysql_upgrade" eingebe, kommt Folgendes:



Die Fehlermeldung kommt, wenn ich die petFunctions.lua benutze.

[.Shōgun]

try

mysql_upgrade -u root -p

[°Ace°]

Originally Posted by .Shōgun

try

mysql_upgrade -u root -p

PHP Code:

root@dqv:~ # mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed
root@dqv:~ # 


[gerald500]

Originally Posted by °Ace°

PHP Code:

root@dqv:~ # mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed
root@dqv:~ # 


deinstallier doch einfach die alte mysql version und installier 5.6 ist auch nicht viel mehr aufwand

[°Ace°]

Originally Posted by gerald500

deinstallier doch einfach die alte mysql version und installier 5.6 ist auch nicht viel mehr aufwand

Ich habe die Version 5.6.
Nachdem ich mein Root hatte, habe ich mysql 5.6 mit "pkg install mysql56-server" installiert.

[.Shōgun]

Post the contents of /var/db/mysql/"hostname".err

Where "hostname" is the name of your machine (you can find it out using the command "hostname" in the shell)

[°Ace°]

Originally Posted by .Shōgun

Post the contents of /var/db/mysql/"hostname".err

Where "hostname" is the name of your machine (you can find it out using the command "hostname" in the shell)

PHP Code:

160310 17:47:50 mysqld_safe mysqld from pid file /var/db/mysql/dqv.pid ended
160310 17:48:26 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2016-03-10 17:48:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-03-10 17:48:27 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.27) starting as process 713 ...
2016-03-10 17:48:27 713 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/libexec/mysqld: Table 'mysql.plugin' doesn't exist
2016-03-10 17:48:27 713 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-03-10 17:48:27 713 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-10 17:48:27 713 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-10 17:48:27 713 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-03-10 17:48:27 713 [Note] InnoDB: Memory barrier is not used
2016-03-10 17:48:27 713 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-10 17:48:27 713 [Note] InnoDB: Using CPU crc32 instructions
2016-03-10 17:48:27 713 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-10 17:48:27 713 [Note] InnoDB: Completed initialization of buffer pool
2016-03-10 17:48:27 713 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2016-03-10 17:48:27 713 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2016-03-10 17:48:27 713 [Note] InnoDB: Database physically writes the file full: wait...
2016-03-10 17:48:27 713 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2016-03-10 17:48:27 713 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2016-03-10 17:48:28 713 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2016-03-10 17:48:28 713 [Warning] InnoDB: New log files created, LSN=45781
2016-03-10 17:48:28 713 [Note] InnoDB: Doublewrite buffer not found: creating new
2016-03-10 17:48:28 713 [Note] InnoDB: Doublewrite buffer created
2016-03-10 17:48:28 713 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-10 17:48:28 713 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-03-10 17:48:28 713 [Note] InnoDB: Foreign key constraint system tables created
2016-03-10 17:48:28 713 [Note] InnoDB: Creating tablespace and datafile system tables.
2016-03-10 17:48:28 713 [Note] InnoDB: Tablespace and datafile system tables created.
2016-03-10 17:48:28 713 [Note] InnoDB: Waiting for purge to start
2016-03-10 17:48:28 713 [Note] InnoDB: 5.6.27 started; log sequence number 0
/usr/local/libexec/mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or directory)
2016-03-10 17:48:28 713 [Warning] World-writable config file './auto.cnf' has been removed.

2016-03-10 17:48:28 713 [Warning] 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: e9eb86d3-e6df-11e5-af05-005056002303.
2016-03-10 17:48:28 713 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-10 17:48:28 713 [Note] IPv6 is available.
2016-03-10 17:48:28 713 [Note]   - '::' resolves to '::';
2016-03-10 17:48:28 713 [Note] Server socket created on IP: '::'.
2016-03-10 17:48:28 713 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
2016-03-10 17:48:28 713 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2016-03-10 17:48:28 713 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50092, now running 50627. Please use mysql_upgrade to fix this error.
2016-03-10 17:48:28 713 [ERROR] Cannot open mysql.event
2016-03-10 17:48:28 713 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2016-03-10 17:48:28 713 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.27'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution 


[.Shōgun]

/usr/local/bin/mysql_upgrade -S /tmp/mysql.sock -u root -p

[°Ace°]

Originally Posted by .Shōgun

/usr/local/bin/mysql_upgrade -S /tmp/mysql.sock -u root -p

Nice, thx it work!