Importing MySQL Database (.sql) in Terminal

Importing MySQL Database (.sql) Via MySQL Terminal on to Remote Database Server on Amazon web services

Advert

Couple of days ago I saw a few amateur developers struggling to importing an .sql file to Remote Database Server in AWS. They were migrating to Amazon Web services from a self hosted server. The database they exported form the old server sized around 125 MB and was too heavy to be uploaded as a whole.

They did get a PhpMyadmin running on a EC2 instance and get it connected to RDS, but the apache limit was a stopper here. An editable value but the Internet connection was not stable due to a scheduled maintenance work of ISP so pushing 100+Mb of a single file was not an option.

I had a few mins to talk with them and joined to solve the issue. I have no idea why one of them showed me a git repo hosted on Bit bucket which had the .sql file online I didn't know how they managed to get it uploaded but it was available.

I cloned the repo to the EC2 and connected to the RDS via after SSH'ing to the server and imported the .sql via terminal. If you happen to be in same situation here is what you can do from start of exporting data from current server to Importing to RDS.

  1. Export Data from MySQL server as .sql file.
  2. Set up your RDS instance and an EC2 Instance to import the data. You can use any EC2 with MySQL installed. Make sure to allow the EC2 with permissions to connect to RDS.
  3. SSH connect to the EC2.
     ssh -i   @  
  4. Get the exported file onto the EC2. You can use git remote repository to upload and clone it or use FTP.
  5. Now CD to the directory where the .sql exist on EC2.
  6. Connect to your MySQL server in RDS.
    $ mysql -h  -port=3306 -u  -p
  7. Create and Select the database where you want the data to be imported.
    $ mysql> create database  ;
    $ mysql> use  
  8. Here comes the magic,
    $ mysql> source  <name_of_file>.sql;
  9. You have your Database on RDS.

Remote connection can also be done from your local machine if you have a strong Internet connection.

Comments

Wow ! you have someting to tell us. That's great! Please keep in mind that comments are moderated, we employ rel="nofollow" for links, avoid using a spammy word or a domain in name field, it might end up as a Spam. Thanks for reading.

Last 5 Articles

All Articles >

  1. Mitigating Risks In Custom Software Development

     
  2. Container Security to Secure Microservices

     
  3. Strategic Messaging

     
  4. URL Shortener in Django

     
  5. MySQL as Database Option

     

News Letter

Subscribe to our email newsletter for useful tips and valuable resources, sent out every new article release.