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 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 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 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
You can’t perform that action at this time.