Upgrading mysql from 5.5 to 5.6 Tipărire

  • 0

Language English

Make sure you have made backups

 

  1. Stop MySQL: service mysql-server stop
  2. Add to /etc/rc.conf:
    Code:
    mysql_args="--explicit_defaults_for_timestamp=true --skip-grant-tables --skip-slave-start --thread_stack=256K"
    These are needed, it prevents the slave process from starting, skips grant tables (so you always have access), the thread stack seems to be required, I ran out of it a couple of times
  3. Remove MySQL 5.5 server: pkg delete mysql55-server
  4. Install MySQL 5.6: pkg install mysql56-server
  5. Start it: service mysql-server start
    Note, this starts MySQL with the arguments we added above.
  6. Run the upgrade script: mysql_upgrade
  7. Stop MySQL server: service mysql-server stop
  8. Remove the mysql_args line from /etc/rc.conf
  9. Start MySQL server service mysql-server start
  10. Done

 

Language  Română

Asigurați-vă că ați făcut copii de rezervă

pkg info -r mysql55-client

pkg delete -f VERSIUENATAMYSQL

pkg install -f mysql56-server

make install clear


Răspunsul a fost util?

« înapoi

Te muti la noi?

Migrarea catre un nou furnizor de hosting poate fi extrem de complicata .
Fii relaxat si lasa-i expertii nostri sa o faca! Vom muta site-ul existent în 48 de ore, fara intrerupere .
Inclus GRATUIT la achizitionarea oricarui pachet de gazduire .