Skip to content

Instantly share code, notes, and snippets.

@andersonfreitas
Last active December 17, 2015 14:29
Show Gist options
  • Save andersonfreitas/5624595 to your computer and use it in GitHub Desktop.
Save andersonfreitas/5624595 to your computer and use it in GitHub Desktop.
Move from MySQL to Percona using Homebrew
brew update
mysqldump --all-databases -u root -p > full_backup.sql
mysql.server stop
brew remove mysql
rm -rf /usr/local/var/mysql
brew install percona-server
mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix percona-server)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
mysql.server start
mysql -u root < full_backup.sql
rm full_backup.sql
brew cleanup
@marcalc
Copy link

marcalc commented May 22, 2013

mysqldump -u root -p --all-databases

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment