Exporting/Importing MySQL database from/to Remote Server

Export database

mysqldump -u dbuser -p databasename -h rds.amazonaws.com > backup.sql

Import database

mysql -u username -p -h rds.amazon.com databasename < backup.sql

mysql --host=rds.amazonaws.com --user=dbuser --password=password databasename < backup.sql

Share this article

Posted

in

by

Tags: