cd /path/to/backups
mysql -u root -h 127.0.0.1 -p --default-character-set=utf8
# Switch to database USE database_name;
SET names 'utf8';
SET autocommit=0;
SOURCE backup.sql;
COMMIT;- Note:
database_nameshould exists - Source
-
-
Save akhilesh-sirvi92/7b1fd6b2ca8f978cddb920abe344847f to your computer and use it in GitHub Desktop.
MySQL/Postgresql: Import database via command line
mysqldump -u root -h 127.0.0.1 -p --all-databases > all_db.sqlmysql -u root -h 127.0.0.1 -p < all_db.sqlmysqldump --set-gtid-purged=OFF --no-tablespaces -h 127.0.0.1 -u root -p database_name_here > backup_file.sqlmysql -h 127.0.0.1 -u root -p database_name_here < backup_file.sqlCREATE DATABASE my_database;
CREATE USER 'my_user'@'%' IDENTIFIED BY 'my_password';
GRANT ALL PRIVILEGES ON my_database.* TO 'my_user'@'%' IDENTIFIED BY 'my_password' WITH GRANT OPTION;# get the container id
docker container ls
# Specify the container id in next command, for example 95bf1f75af9c
docker exec 95bf1f75af9c pg_dump -U postgres database_name > backup.sqldocker exec -i 95bf1f75af9c psql -U postgres database_name < /full/path/to/backup.sqlAssumptions
- You have postgres installed on your local machine
- You have a database dump
*.sqlfile created withpsqlcommand - You can SSH to EC2 instance
- You have an EC2 instance running and EC2 machine has access to RDS instance
Steps
- Create a tunnel to EC2
# Syntax
ssh -L <local free port>:<RDS instance host>:<RDS port> <ec2-user>@<ec2-ip-address>
# Example command
ssh -L 5433:db-name.c13mzxjj9hpa.us-east-1.rds.amazonaws.com:5432 ubuntu@192.168.1.234- Import the database to RDS (in new terminal window)
psql -U postgres -p 5433 -h 127.0.0.1 -d db_name < ./path/to/db_backup_file.sql- Close both terminal window when done.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment