cloud engineer
If you have an existing EFS that’s unencrypted, you can encrypt it be creating a snapshot using AWS Backup, and then restoring the file system to a new EFS with encryption. If you choose to restore in a directory in the same file system, it will not be encrypted. It has to be a new EFS. In addition, you’ll be asked to select which encryption key to use. The default key will work, unless you have your own.
In order to restore a MySQL database to another database, use routines and triggers.
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 |
Here’s how to restore a MySQL database from mysqldump.
mysql -u user -p mysql> drop database databasename; mysql> quit; Bye mysql -u user -p databasename < filename.sql |
Drop database first, then import the SQL file.