Skip to content

Instantly share code, notes, and snippets.

@technosailor
Created February 24, 2016 19:05
Show Gist options
  • Star 5 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save technosailor/d5e63a95538cb4634e80 to your computer and use it in GitHub Desktop.
Save technosailor/d5e63a95538cb4634e80 to your computer and use it in GitHub Desktop.
Updates VVV MySQL 5.5 to 5.6 -- Ubuntu 14.04
#!/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
Copy link

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?

@mirceaburdusa
Copy link

@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/

Copy link

ghost commented May 28, 2017

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