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 |
MySQL Restore
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.
GCP Convert Standard to SSD
How to convert Persistent Standard disk to SSD.
First create a snapshot of the disk.
gcloud compute disks snapshot your-server \ --snapshot-names manual-snapshot-disk-1 \ --project your-project \ --zone us-central1-c |
Restore snapshot to SSD format.
gcloud compute disks create disk-1-ssd \ --source-snapshot manual-snapshot-disk-1 \ --project your-project \ --zone us-central1-a \ --type pd-ssd \ --size 10GB |
Swap disks using GCP attach and detach.