Make dump file of database using command line

by abhi singh Apr 25 in Amazon 0 Comments 73 Views

Make dump file of database using command line
Here are some simple step to make dump file mysql databse.

If you want to export database from RDS, you can follow below command:

    mysqldump -h rds.host.name (RDS Endpoint) -u remote_user_name (user name) -p remote_db > remote_db.sql

Example:
    mysqldump -h rds.host.name -u remote_user_name -p remote_db > remote_db.sql


If you want to download simple mysql server, you can follow command:
    mysqldump -u root -p your_database_name> database sql file name

Example:
    mysqldump -u root -p test > test.sql