Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Exporting table from Amazon RDS into a csv file

    @anirudh.rautela
    Recommendations Offline Message

    • 0
    • 3
    • 3
    • 1
    • 0
    • 0
    • 0
    • 0
    • 2.43k
    Comment on it

    A simple command to export tables from Amazon RDS into a csv file

    mysql -uroot -ptest123 --database=test -e "select concat(id,',',login) FROM users" > userdata.csv

    This command will simply connect to mysql from terminal using root as username , test123 as password and will concat data of id and login columns as comma separated values from table users and will export it as a csv format file having name userdata.csv

    Amazon mysql Amazon RDS
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: