Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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

This comment has been minimized.

Copy link

@eriktdesign eriktdesign commented Jun 7, 2016

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

This comment has been minimized.

Copy link

@mirceaburdusa mirceaburdusa commented Jan 30, 2017

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

@ghost

This comment has been minimized.

Copy link

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