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.
AWS CLI Restore Object from S3 Glacier
How to restore an object from Amazon S3 Glacier via the AWS CLI.
aws s3api restore-object \ --bucket awsexamplebucket \ --key dir1/example.obj \ --restore-request '{"Days":25,"GlacierJobParameters":{"Tier":"Standard"}}' |