Register for your free account! | Forgot your password?

Go Back   elitepvpers › Popular Games › Metin2 › Metin2 Private Server
mysql upgraden ? mysql upgraden ?
You last visited: Today at 14:16

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

mysql upgraden ?

Discussion on mysql upgraden ? within the Metin2 Private Server forum part of the Metin2 category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 57/0/0
Join Date: Jan 2013
Posts: 1,818
Received Thanks: 336
mysql upgraden ?

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.
Attached Files
File Type: rar petFunctions.rar (1.9 KB, 6 views)
°Ace° is offline  
Old   #2
 
elite*gold: 11
The Black Market: 1/0/0
Join Date: Nov 2010
Posts: 1,709
Received Thanks: 3,828
try

mysql_upgrade -u root -p
.Shōgun is offline  
Old   #3
 
elite*gold: 0
The Black Market: 57/0/0
Join Date: Jan 2013
Posts: 1,818
Received Thanks: 336
Quote:
Originally Posted by .Shōgun View Post
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:~ # 
°Ace° is offline  
Old   #4
 
gerald500's Avatar
 
elite*gold: 150
The Black Market: 0/0/0
Join Date: Sep 2010
Posts: 1,049
Received Thanks: 275
Quote:
Originally Posted by °Ace° View Post
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
gerald500 is offline  
Old   #5
 
elite*gold: 0
The Black Market: 57/0/0
Join Date: Jan 2013
Posts: 1,818
Received Thanks: 336
Quote:
Originally Posted by gerald500 View Post
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.
°Ace° is offline  
Old   #6
 
elite*gold: 11
The Black Market: 1/0/0
Join Date: Nov 2010
Posts: 1,709
Received Thanks: 3,828
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)
.Shōgun is offline  
Old   #7
 
elite*gold: 0
The Black Market: 57/0/0
Join Date: Jan 2013
Posts: 1,818
Received Thanks: 336
Quote:
Originally Posted by .Shōgun View Post
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 
°Ace° is offline  
Old   #8
 
elite*gold: 11
The Black Market: 1/0/0
Join Date: Nov 2010
Posts: 1,709
Received Thanks: 3,828
/usr/local/bin/mysql_upgrade -S /tmp/mysql.sock -u root -p
.Shōgun is offline  
Old   #9
 
elite*gold: 0
The Black Market: 57/0/0
Join Date: Jan 2013
Posts: 1,818
Received Thanks: 336
Quote:
Originally Posted by .Shōgun View Post
/usr/local/bin/mysql_upgrade -S /tmp/mysql.sock -u root -p
Nice, thx it work!
°Ace° is offline  
Reply

« Metin 2 eigene musik-playlist erstellen? | Metin2 Serverkonzept - Bock drauf ?? »

Similar Threads Similar Threads
PC upgraden
10/16/2015 - Hardware Discussions / Questions - 18 Replies
Was sollte ich verbessern? PC wird zum spielen genutzt: Grafikkarte: GTX 760 CPU: AMD FX 6300 RAM: 2x 4 GB Mainboard: Gigabyte GA-970A-DS3P Netzteil: Be quiet! Pure Power CM BQT L8-CM-630W PC Netzteil (630 Watt) Ich hab das Gefühl, dass ich damals eine falsche entscheidung getroffen habe, was mein CPU angeht. Ich will schritt für schritt in mein PC investieren, was würdet ihr mir empfehlen?
Mysql funktioniert nicht.. service mysql status mysql does not exist in /etc/rc.d
07/09/2015 - Metin2 Private Server - 8 Replies
Hey, mein Mysql Server funktíoniert von jetzt auf gleich nicht mehr.. Kam aus dem Freibad und alles war down.. Wenn ich den Mysql Server starten will sagt er mir: " service mysql status mysql does not exist in /etc/rc.d or the local startup directories (/usr/local/etc/rc.d) " Und wenn ich meinen Metin Server starte "cant connect to 127.0.0.1" weil der Mysql Server down ist..
PC Upgraden 500-600€
01/18/2015 - Hardware Discussions / Questions - 11 Replies
Hallo, Ich wollte mir einen neuen PC für Gamingzwecke zulegen. Mein Budget liegt bei 500-600€. Arbeitsspeicher und Prozessor denke ich werde ich locker von meinem aktuellen PC übernehmen. Was ich denke übernehmen zu können: -Prozessor: Intel i7-2600 CPU @ 3.40GHz -Arbeitsspeicher: 12 GB, PC3-10600 MB/sec, DDR3-1333 -Laufwerke: CD Drive, Memory Card Reader
PC Upgraden?
08/19/2014 - Hardware Discussions / Questions - 6 Replies
Graka - Geforce GTX 670 OC Cpu - Intel i5-3570k 4GHZ OC Arbeitsspeicher - 12GB DDR3 Ram Mainboard - Asrock Z77 Extreme 4 Mini Monitor : Acer G225HQV Der PC wird hauptsächlich zum zocken benutzt, ich frage mich jedoch ob ich das Geld für einen neuen Monitor ausgeben soll oder die CPU/Graka/Mainboard updaten soll. :)
PC upgraden!
04/02/2010 - Technical Support - 3 Replies
Tag zusammen. Ich würde gerne meinen alten PC aufmotzen. Möchte aber nicht mehr als 100 Euro ausgeben Maximal 150 Euro. Also momentan habe ich 100-200 W Netzteil



All times are GMT +2. The time now is 14:17.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.