Uly.me

cloud engineer

  • Home
  • About
  • Archives
Home/Archives for triggers

June 14, 2020

MySQL Restore to another DB

In order to restore a MySQL database to another database, use routines and triggers.

mysqldump -p user -p --routines --triggers db1 > db1.sql

mysqldump -p user -p --routines --triggers db1 > db1.sql

To restore to another database, just use the normal command.

mysql -u user -p db2 < db1.sql

mysql -u user -p db2 < db1.sql

  • Cloud
  • Linux
  • Git

Copyright © 2012–2021