Skip to content

Instantly share code, notes, and snippets.

@marcalc

marcalc/migrate.sh

Forked from andersonfreitas/migrate.sh
Created May 22, 2013 15:26
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save marcalc/5628468 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save marcalc/5628468 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @andersonfreitas andersonfreitas revised this gist May 22, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion migrate.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    mysqldump -uroot -p > full_backup.sql
    mysqldump --all-databases -u root -p > full_backup.sql

    mysql.server stop

  2. @andersonfreitas andersonfreitas revised this gist May 22, 2013. 1 changed file with 2 additions and 0 deletions.
    2 changes: 2 additions & 0 deletions migrate.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -4,6 +4,8 @@ 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
  3. @andersonfreitas andersonfreitas created this gist May 22, 2013.
    14 changes: 14 additions & 0 deletions migrate.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,14 @@
    mysqldump -uroot -p > full_backup.sql

    mysql.server stop

    brew remove 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