Created
February 24, 2016 19:05
-
-
Save technosailor/d5e63a95538cb4634e80 to your computer and use it in GitHub Desktop.
Updates VVV MySQL 5.5 to 5.6 -- Ubuntu 14.04
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# Usage: ./update-mysql56.sh | |
# Backup of all databases... JUST IN CASE | |
mysqldump --all-databases --single-transaction --events --user=root --password > ~/all_database_backup.sql | |
# Remove MySQL 5.5 | |
sudo apt-get remove mysql-server | |
sudo apt-get autoremove | |
# Install MySQL 5.6 | |
sudo apt-get install mysql-client-5.6 mysql-client-core-5.6 | |
sudo apt-get install mysql-server-5.6 |
@eriktdesign Yes, this is the script for you. I found this gist on the following post that explains the upgrade process: https://crispinbixler.wordpress.com/2016/09/07/vagrantvvv-upgrading-mysql-to-5-6/
Hey, noob question. Where does the ~/all_database_backup.sql actually get saved? Thank you so much.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I'm trying to get a DB exported from WPEngine to import into a VVV box. I'm getting
#1214 - The used table type doesn't support FULLTEXT indexes
From what I understand, I need MySQL 5.6 to have fulltext indexes -- should I run this on my VVV box to upgrade MySQL? Is this the script for me?