Skip to main content

How to move sql file into RDS

In this post, we are going to see how to bring data from mysql to RDS.
The first thing you gonna need to do is a dump of your db to a sql file so we can than bring it into the RDS. So, here we go.
If you have not done it already go to the RDS console and create or launch a new mysql db instance. Take note of the following infos: db name, db user, db passwd and the db endpoint. We gonna use all that with mysql command to bring all tables of our mysql into the RDS.
So, next we need to create our dump file. Log into your instance to get access to mysql cli. You can login like this: 
ssh -i file.pem user@IP
To get inside mysql cli: 
mysql -u root
Create a dump of your database: 
mysqldump -u root db_name > file.sql
This will create a dump of your db on your user location. Exit the mysql cli to check if the file was created. We can take advantage of the mysql cli of our previously db to run our last command to bring the file into our new RDS instance. 
mysql -h your-rds.endpoint.region.rds.amazonaws.com -u db_user -P 3306 -p db_name < file.sql
Note the use of all infos from RDS and the dump file at the end of the command to bring it into the RDS.
Labels:

Comments

Post a Comment

Popular posts from this blog

Understanding RabbitMQ

Introduction RabbitMQ is a centralized message broker based on the AMQP (Advanced Message Queuing Protocol) protocol, acting as a Middleware between Producers and Consumers of different systems. In a message system, Publishers sends a message to a message broker where messages are consumed some time later by one or more Subscribers. By introducing a message brokeer between systems we are decoupling the sender application from the receiver. In this case the service that is responsible for sending or publishing the message does not need to know about any other service. All it needs to care about is the message and its format. With a message system you send a message to a message broker first and when the consumers or listeners of it become online they can start consuming from the message queue. This means you can keep sending messages without even care if the other application is online or if they had any failures. RabbitMQ Architecture Exchange, queue and bindings are the ...
Post a Comment
Read more

A Retrospective board to call your own made with React, GraphQL and MongoDB

Introduction I have been working in a project to enable anyone to fork and run a retrospective board in its own server. I have created 2 (two) projects: one for the UI with React and GraphQL using Apollo client and one for the GraphQL server also using Apollo (Server) and MongoDB for the database. In the following sections I am going to walk you through the steps and explain how to run both projects. Main features The board main features: - History of your past iteractions saved in the Mongo database - Easy url link format to quick access any past iteractions - Automatically add action items as last action items in the new board - Quick move items to Action Items Coming next You can fork the React UI from the following GitHub repo: - Support for multiple teams - Authentication - Subscriptions (pub/sub) Code Repo You can fork the React UI from the following GitHub repo: React Retrospective UI You can fork the GraphQL Server from the following GitHub rep...
Post a Comment
Read more

How to become a Blockchain developer and write your first Smart Contract - Part II

Introduction Now that you've already learned the basic concepts needed to become a Blockchain developer, in our introductory article , and are more familiar with the entire ecosystem of tools needed, in this article we will see how to write and deploy our first Smart Contract using Solidity. According to Solidity website: Solidity is an object-oriented, high-level language for implementing smart contracts. Smart contracts are programs that govern the behavior of accounts within the Ethereum state. Getting Started with the Solidity language The easiest way to start writing your first Solidity Smart Contrat is using Remix an online Ethereum IDE. To start creating your first Smart Contract you need to create a file with the .sol extension. So if you see a file with the .sol extension, that's a Smart Contract. In Solidity we make use of a preprocessor directive to tell the compiler how to compile our code. Being a statically typed language, all types in our code ...
Post a Comment
Read more