Skip to content

Instantly share code, notes, and snippets.

@tricker

tricker/gist:1323552

Created October 28, 2011 21:03
Show Gist options
  • Save tricker/1323552 to your computer and use it in GitHub Desktop.
Save tricker/1323552 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. tricker revised this gist Oct 28, 2011. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -2,7 +2,7 @@
    mysqldump -uroot -ppassword hornet > hornet-dump.sql

    # Drop database schema
    mysqladmin –uroot –ppassword –f drop hornet
    mysqladmin -uroot -ppassword –f drop hornet

    # create empty database schema
    mysqladmin –uroot –ppassword create hornet
  2. tricker created this gist Oct 28, 2011.
    11 changes: 11 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,11 @@
    # export data to file
    mysqldump -uroot -ppassword hornet > hornet-dump.sql

    # Drop database schema
    mysqladmin –uroot –ppassword –f drop hornet

    # create empty database schema
    mysqladmin –uroot –ppassword create hornet

    # push dump file into new database schema
    mysql -uroot -ppassword hornet < hornet-dump.sql