Monday, November 11, 2013

Commands

MY SQL
mysql -u<username> -p<password> <DB> -h<hostname> < <sqlfilename>

 copying schema from one location to another location:desitnation

time mysqldump -h<source_hostname> -u<source_username> -p<source_password> -P<source_port> -R <source_db_schema>| mysql -h<desitnation_hostname> -u<desitnation_username>  -p <desitnation_password> -P<desitnation_port>  <desitnation_db_schema>.



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Security Certificates

  1. Cryptography Basics Understand Key Concepts : Encryption, decryption, hashing, and digital signatures. Key terms: confidentiality, inte...

  • MicroServices
     Micro Service 12 Factor The Twelve-Factor App is a methodology for building software-as-a-service apps Codebase : One codebase tracked in v...
  • Authentication & Authorization
    Key words   Knowledge Factor Possession Factor Inherence Factor All individual factors are not secure, because if any factor comprimise. So,...
  • AWS
      What is IAM rules. Lambda Pros / Cons [ColdStart Latency]. How many ways we can invoke a lambda SQS VS SNS S3 usage and different types of...