MySQL 5.5 Installation Prob..

08/22/2013 13:11 #Kajo#1
Hey,
Habe ne Frage...
Wie installiere/update ich richtig die MySQL Version von 5.0->5.5 .. ?
Es gibt zwar viele TuT's aber die sind veraltet & funktionieren nicht..
Brauche genaue Befehle um:
Backups von Tables & der Inhalt der Tables der DB etc. zu machen,
MySQL 5.5 zu installieren.
Die Backup's auf die neue db auf zu spielen..

Brauche dringend Hilfe!...
Freue mich um jede Antwort!
08/22/2013 13:33 RandomName42#2
1. Deine Version wählen.
PHP Code:
MySQL 5.0: cd /usr/ports/databases/mysql50-server/
MySQL 5.1: cd /usr/ports/databases/mysql51-server/
MySQL 5.5: cd /usr/ports/databases/mysql55-server/
MySQL 5.6: cd /usr/ports/databases/mysql56-server/ 
2.
PHP Code:
make install WITH_XCHARSET=all clean 
3.
PHP Code:
rehash 
4.
PHP Code:
cat /etc/rc.conf 
5.
PHP Code:
echo mysql_enable="YES" >> /etc/rc.conf 
6.
PHP Code:
/usr/local/etc/rc.d/mysql-server onestart 
Quelle: [Only registered and activated users can see links. Click Here To Register...]
08/22/2013 13:44 xGr33n#3
Und da hast du noch ein Tut zum Backups erstellen + wd einspielen: [Only registered and activated users can see links. Click Here To Register...]
08/22/2013 16:25 Wython#4
Ihr macht das alles viel zu umständlich...

einfach Ports runterladen / aktualisieren,
PHP Code:
portsnap fetch extract 
PHP Code:
portsnap fetch update 
danach ganz easy (so habe ich es gemacht)
PHP Code:
pkg_add -r mysql55-server 
..

Mysql ist installiert.
08/22/2013 16:28 xGr33n#5
Quote:
Originally Posted by Wython View Post
Ihr macht das alles viel zu umständlich...

einfach Ports runterladen / aktualisieren,
PHP Code:
portsnap fetch extract 
PHP Code:
portsnap fetch update 
danach ganz easy (so habe ich es gemacht)
PHP Code:
pkg_add -r mysql55-server 
..

Mysql ist installiert.
Kann ich nicht empfehlen dannach sah meine DB syserr so aus :

Quote:
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'
SYSERR: Aug 22 12:48:24 :: QueryLocaleSet: cannot set locale euckr by 'mysql_set_character_set', errno 1115 Unknown character set: 'euckr'