Steps to upgrade MySQL in FreeBSD
Steps to upgrade MySQL version 4 to 5 in the FreeBSD :
1. Backup the existing MySQL database.
$ cd /var/db/
$ tar cvfz mysql.tar.gz mysql
$ tar cvfz mysql.tar.gz mysql
2. Stop the MySQL service.
$ /usr/local/etc/rc.d/mysql-server.sh stop
3.Remove the existing MySQL Server .
pkg_delete mysql-server-4.*.*
pkg_delete mysql-client-4.*.*
Replace the ‘*’ with the version that is the server.
pkg_delete mysql-client-4.*.*
Replace the ‘*’ with the version that is the server.
4. For installing the new MySQL Server, execute the following step.
$ cd /usr/ports/databases/mysql50-server && make install clean
5.Start MySQL 5.0 in the server and run the upgrade script.
$ /usr/local/etc/rc.d/mysql-server.sh start
$ /usr/local/bin/mysql_upgrade -u root -p –datadir=/var/db/mysql
$ /usr/local/bin/mysql_upgrade -u root -p –datadir=/var/db/mysql
You will be prompted for the new MySQL password where you can provide it.
One Response to “Steps to upgrade MySQL in FreeBSD”
Leave a Reply
You must be logged in to post a comment.
2instructors…
…