• Skip to main content

Uly.me

cloud engineer

  • Home
  • About
  • Archives

import

MySQL Restore

April 26, 2020

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

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.

Filed Under: Linux Tagged With: import, mysql, restore, sql

AWS ACM Certificate Import

August 11, 2019

Here’s how to import a SSL certificate into AWS Certificate Manager.

aws acm import-certificate \
--certificate fileb://example.crt \
--private-key fileb://example.key \
--certificate-chain fileb://example-bundle.crt \
--tags Key=Name,Value=mydomain.com_20220107

aws acm import-certificate \ --certificate fileb://example.crt \ --private-key fileb://example.key \ --certificate-chain fileb://example-bundle.crt \ --tags Key=Name,Value=mydomain.com_20220107

Filed Under: Cloud Tagged With: acm, aws, certificate, cli, import, ssl

Certbot AWS Renewals

May 27, 2019

Here are the instructions for renewing Certbot SSL certificates in AWS Certificate Manager. Certbot provides SSL certificates for free for 60 days and are auto-renewed before they expire. If you are using Certbot SSL certificates with CloudFront, you will need to reimport them to AWS Certificate Manager before expiration.

  1. Get the latest SSL certificate by running “certbot certificates.”
  2. Reimport the certificate in 3 parts.
    • Certificate Body – the root or top portion of the full chain
    • Certificate Private key – the private key
    • Certificate chain – the entire full chain containing multiple certificates
  3. Click Save. Check expiration.

You’ll need to update the certificate before the next expiration date.

Filed Under: Cloud Tagged With: aws, certbot, certificate manager, import, renewal, ssl

Subversion Import

November 2, 2012

Typically, you use the Subversion Import command to start or add a new project to a remote repository. Subversion recommends that you setup three directories called trunk, tags and branches under each project in a repository. Trunk will be the current version you are working on. Tags are for releases. Branches are when you fork projects based on one particular release. The following directory format under each project is recommended.

repository/project/trunk
                  /tags
                  /branches

repository/project/trunk /tags /branches

Once the directories are setup, you can then perform the import command to upload a new project to the repository. Just the following command in the Terminal.

svn import project http://repository -m "Place comments here."

svn import project http://repository -m "Place comments here."

Filed Under: SVN Tagged With: import

  • Home
  • About
  • Archives

Copyright © 2023